Database execution cost and system performance estimator

• US 5,758,144 A
• Filed: 06/24/1994
• Issued: 05/26/1998
• Est. Priority Date: 06/24/1994
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hall, Harold, Eberhard, Rainer, Lakshmi, Seetha
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Choules, Jack M.
• Application Number:
  US08/265,595
• Time in Patent Office: 1,432 Days
• Field of Search: 395/600, 395/425, 395/650, 395/601, 395/602, 395/616
• US Class Current: 1/1
• CPC Class Codes: G06F 11/34 Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
• CPC Class Codes: G06F 11/3452 Performance evaluation by statistical analysis
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 2201/87 Monitoring of transactions
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing

Abstract

The software tool of this invention estimates the costs of an application program accessing a database. These costs may be execution costs of the application or of a transaction, SQL statement, and/or a utility. Execution costs include CPU time, I/O time and minimum elapsed time. For estimating the execution costs, the tool receives simplified and partial definitions of tables, utilities, SQL statements, transactions, and applications. The estimator tool requires only a minimal amount of information to calculate the various execution costs.

Claims

1. A tool, for use in a computer system, for estimating execution costs of at least a portion of an application having at least one query statement for accessing a database;

said tool comprising;

a user interface for receiving input from a user corresponding to a partial definition of at least one table in said database;

means for building a simplified query statement, said simplified query statement having a place-holder for each expression detail within said at least one query statement, using at least one of said at least one table; and

means, based on said simplified query statement for estimating a cost of executing said at least one query statement against said database;

wherein the simplified query statement comprises only those portions of the query statement that are essential in determining the execution costs of the application accessing the database with said query statement taking into consideration a first input by the user of an estimate of a number of rows resulting in an execution of the query statement, and a second input by the user of an estimate of a number of pages touched and an estimate of a number of pages read.