Database execution cost and system performance estimator

Claim 2

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, from user input, 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.

Claim 3

The tool of claim 1 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 and wherein the tool provides for a possibility of user input for an estimate of a number of rows resulting in an execution of the query statement, an estimate of a number of pages touched and an estimate of a number of pages read.

Claim 4

The tool of claim 1 wherein the cost of executing includes CPU time, I/O time, and minimum elapsed time.

Claim 5

The computer program on the computer usable medium of claim 1 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 and wherein the computer program provides for a possibility of user input for an estimate of a number of rows resulting in an execution of the query statement, an estimate of a number of pages touched and an estimate of a number of pages read.

Claim 6

The computer program on the computer readable medium of claim 1 wherein the cost of executing includes CPU time, I/O time, and minimum elapsed time.

Claim 7

A tool, for use in a computer system, for estimating execution costs of a transaction having at least one query statement for accessing a database; said tool comprising: a user interface for generating, from user input, a simplified transaction definition including at least one predefined simplified query statement definition for said at least one query statement, said simplified query statement definition having a place-holder for each expression detail within said at least one query statement, and a frequency of execution of said query statement in said transaction; means for including in the transaction definition information necessary to define transaction overhead costs; and means for determining an estimation of a cost of said at least one transaction based on said costs of said at least one simplified query statement within said transaction, said frequency of execution, and said overhead costs.

Claim 8

A tool, for use in a computer system, for estimating execution costs of a transaction having at least one query statement for accessing a database; said tool comprising: a user interface for generating, from user input, a simplified transaction definition including at least one predefined simplified query statement definition for said at least one query statement, said simplified query statement definition having a place-holder for each expression detail within said at least one query statement, and a frequency of execution of said query statement in said transaction; means for including in the transaction definition information necessary to define transaction overhead costs; and means for determining an estimation of a cost of said at least one transaction based on said costs of said at least one simplified query statement within said transaction, said frequency of execution, and said overhead costs.

Claim 9

A tool, for use in a computer system, for estimating system performance of at least one application having at least one transaction for accessing a database; said tool comprising: a user interface for generating, from user input, a simplified application definition including at least one predefined simplified transaction definition having at least one simplified query statement for each of said at least one transaction and a frequency of execution of said simplified transaction in said computer system; means for including in the application definition information necessary to define a system load from external sources; and means for computing the system performance of said at least one application based on said costs of said at least one simplified transaction definition having at least one simplified query statement definition, said frequency of execution of said transaction, and said system load from external sources.

Claim 10

A tool, for use in a computer system, for estimating system performance of at least one application having at least one transaction for accessing a database; said tool comprising: a user interface for generating, from user input, a simplified application definition including at least one predefined simplified transaction definition having at least one simplified query statement for each of said at least one transaction and a frequency of execution of said simplified transaction in said computer system; means for including in the application definition information necessary to define a system load from external sources; and means for computing the system performance of said at least one application based on said costs of said at least one simplified transaction definition having at least one simplified query statement definition, said frequency of execution of said transaction, and said system load from external sources.

Claim 11

The tool of claim 7, wherein the system performance includes CPU utilization, I/O device utilization, and elapsed time including service and queuing time for CPU and I/O devices.

Claim 12

A tool, for use in a computer system, for estimating execution costs 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 simplified definition of at least one table in said database and a simplified definition of at least one utility command; means for building, from user input, at least one simplified query statement, said simplified query statement having a place-holder instead of expression details within said at least one query statement, using at least one of said at least one tables; means, through said user interface, for generating a simplified transaction definition including at least one predefined simplified query statement definition and a frequency of execution of said simplified query statement in a transaction; means for including in the transaction definition information necessary to define transaction overhead costs; means for determining an estimation of a cost of said at least one utility based on said simplified definitions of said at least one table and said utility command; means, based on said at least one simplified query statement, for estimating a cost of executing said at least one query statement against said database; means for determining an estimation of a cost of said at least one transaction based on costs of said simplified query statements within said transaction, said frequency of execution, and said overhead costs; and means for determining an estimation of the execution costs of an application based upon said means for determining the estimation of the cost of the at least one utility and said means for estimating the cost of executing said at least one query statement and means for determining the estimation of the cost of said at least one transaction.

Claim 13

A tool, for use in a computer system, for estimating execution costs 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 simplified definition of at least one table in said database and a simplified definition of at least one utility command; means for building, from user input, at least one simplified query statement, said simplified query statement having a place-holder instead of expression details within said at least one query statement, using at least one of said at least one tables; means, through said user interface, for generating a simplified transaction definition including at least one predefined simplified query statement definition and a frequency of execution of said simplified query statement in a transaction; means for including in the transaction definition information necessary to define transaction overhead costs; means for determining an estimation of a cost of said at least one utility based on said simplified definitions of said at least one table and said utility command; means, based on said at least one simplified query statement, for estimating a cost of executing said at least one query statement against said database; means for determining an estimation of a cost of said at least one transaction based on costs of said simplified query statements within said transaction, said frequency of execution, and said overhead costs; and means for determining an estimation of the execution costs of an application based upon said means for determining the estimation of the cost of the at least one utility and said means for estimating the cost of executing said at least one query statement and means for determining the estimation of the cost of said at least one transaction.

Claim 14

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 system comprising: a user front end for receiving input from a user corresponding to a partial definition of at least one table in said database; means for building, from user input, 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.

Claim 15

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 system comprising: a user front end for receiving input from a user corresponding to a partial definition of at least one table in said database; means for building, from user input, 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.

Claim 16

A computer system for estimating execution costs of a transaction having at least one query statement for accessing a database; said system comprising: a user interface for generating, from user input, a simplified transaction definition including at least one predefined simplified query statement definition for said at least one query statement, said simplified query statement definition having a place-holder for each expression detail within said at least one query statement, and a frequency of execution of said query statement in said transaction; means for including in the transaction definition information necessary to define transaction overhead costs; and means for determining an estimation of a cost of said at least one transaction based on costs of said at least one simplified query statement within said transaction, said frequency of execution, and said overhead costs.

Claim 17

A computer system for estimating execution costs of a transaction having at least one query statement for accessing a database; said system comprising: a user interface for generating, from user input, a simplified transaction definition including at least one predefined simplified query statement definition for said at least one query statement, said simplified query statement definition having a place-holder for each expression detail within said at least one query statement, and a frequency of execution of said query statement in said transaction; means for including in the transaction definition information necessary to define transaction overhead costs; and means for determining an estimation of a cost of said at least one transaction based on costs of said at least one simplified query statement within said transaction, said frequency of execution, and said overhead costs.

Claim 18

A computer system, for estimating system performance of at least one application having at least one transaction for accessing a database; said system comprising: a user interface for generating, from user input, a simplified application definition including at least one predefined simplified transaction definition having at least one simplified query statement for each of said at least one transaction and a frequency of execution of said transaction in said computer system; means for including in the application definition information necessary to define a system load from external sources; and means for determining an estimation of system performance of said at least one application based on costs of said at least one simplified transaction definition having at least one simplified query statement, said frequency of execution of said transaction, and said system load from external sources.

Claim 19

A computer system, for estimating system performance of at least one application having at least one transaction for accessing a database; said system comprising: a user interface for generating, from user input, a simplified application definition including at least one predefined simplified transaction definition having at least one simplified query statement for each of said at least one transaction and a frequency of execution of said transaction in said computer system; means for including in the application definition information necessary to define a system load from external sources; and means for determining an estimation of system performance of said at least one application based on costs of said at least one simplified transaction definition having at least one simplified query statement, said frequency of execution of said transaction, and said system load from external sources.

Claim 28

A computer program, on a computer usable medium, for estimating execution costs of at least a portion of an application having at least one query statement for accessing a database, comprising: first program code for providing a user interface for receiving input from a user corresponding to a partial definition of at least one table in said database; second program code for causing a building, from user input, of 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, third program code for causing an estimation of a cost of executing said at least one query statement against said database.

Claim 29

A computer program, on a computer usable medium, for estimating execution costs of at least a portion of an application having at least one query statement for accessing a database, comprising: first program code for providing a user interface for receiving input from a user corresponding to a partial definition of at least one table in said database; second program code for causing a building, from user input, of 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, third program code for causing an estimation of a cost of executing said at least one query statement against said database.

Claim 30

A computer program, on a computer usable medium, for estimating execution costs of a transaction having at least one query statement for accessing a database, comprising: first program code for providing a user interface for generating a simplified transaction definition including at least one predefined simplified query statement definition for said at least one query statement, said simplified query statement definition having a place-holder for each expression detail within said at least one query statement, and a frequency of execution of said query statement in said transaction; second program code for including in the transaction definition information necessary to define transaction overhead costs; and third program code for determining an estimation of a cost of said at least one transaction based on said costs of said at least one simplified query statement within said transaction, said frequency of execution, and said overhead costs.

Claim 31

A computer program, on a computer usable medium, for estimating execution costs of a transaction having at least one query statement for accessing a database, comprising: first program code for providing a user interface for generating a simplified transaction definition including at least one predefined simplified query statement definition for said at least one query statement, said simplified query statement definition having a place-holder for each expression detail within said at least one query statement, and a frequency of execution of said query statement in said transaction; second program code for including in the transaction definition information necessary to define transaction overhead costs; and third program code for determining an estimation of a cost of said at least one transaction based on said costs of said at least one simplified query statement within said transaction, said frequency of execution, and said overhead costs.

Claim 32

A computer program on a computer usable medium, for estimating system performance of at least one application having at least one transaction for accessing a database, comprising: first program code for providing a user interface for generating, from user input, a simplified application definition including at least one predefined simplified transaction definition having at least one simplified query statement for each of said at least one transaction and a frequency of execution of said simplified transaction in said computer system; second program code for including in the application definition information necessary to define a system load from external sources; and third program code for computing the system performance of said at least one application based on said costs of said at least one simplified transaction definition having at least one simplified query statement definition, said frequency of execution of said transaction, and said system load from external sources.

Claim 33

A computer program on a computer usable medium, for estimating system performance of at least one application having at least one transaction for accessing a database, comprising: first program code for providing a user interface for generating, from user input, a simplified application definition including at least one predefined simplified transaction definition having at least one simplified query statement for each of said at least one transaction and a frequency of execution of said simplified transaction in said computer system; second program code for including in the application definition information necessary to define a system load from external sources; and third program code for computing the system performance of said at least one application based on said costs of said at least one simplified transaction definition having at least one simplified query statement definition, said frequency of execution of said transaction, and said system load from external sources.

Claim 34

The computer program on a computer usable medium of claim 19, wherein the system performance includes CPU utilization, I/O device utilization, and elapsed time including service and queuing time for CPU and I/O devices.

Claim 35

A computer program on a computer usable medium, for estimating execution costs of an application having at least one query statement for accessing a database, comprising: first program code for providing a user interface for receiving input from a user corresponding to a simplified definition of at least one table in said database and a simplified definition of at least one utility command; second program code for building, from user input, at least one simplified query statement, said simplified query statement having a place-holder instead of expression details within said at least one query statement, using at least one of said at least one table; third program code, through said user interface, for generating a simplified transaction definition including at least one predefined simplified query statement definition and a frequency of execution of said simplified query statement in a transaction; fourth program code for including in the transaction definition information necessary to define transaction overhead costs; fifth program code for determining an estimation of a cost of said at least one utility based on said simplified definitions of said at least one table and said utility command; sixth program code, based on said at least one simplified query statement, for estimating a cost of executing said at least one query statement against said database; seventh program code for determining an estimation of a cost of said at least one transaction based on costs of said simplified query statements within said transaction, said frequency of execution, and said overhead costs; and eighth program code for determining an estimation of the execution costs of an application based upon said means for determining the estimation of the cost of the at least one utility and said means for estimating the cost of executing said at least one query statement and means for determining the estimation of the cost of said at least one transaction.

Claim 36

A computer program on a computer usable medium, for estimating execution costs of an application having at least one query statement for accessing a database, comprising: first program code for providing a user interface for receiving input from a user corresponding to a simplified definition of at least one table in said database and a simplified definition of at least one utility command; second program code for building, from user input, at least one simplified query statement, said simplified query statement having a place-holder instead of expression details within said at least one query statement, using at least one of said at least one table; third program code, through said user interface, for generating a simplified transaction definition including at least one predefined simplified query statement definition and a frequency of execution of said simplified query statement in a transaction; fourth program code for including in the transaction definition information necessary to define transaction overhead costs; fifth program code for determining an estimation of a cost of said at least one utility based on said simplified definitions of said at least one table and said utility command; sixth program code, based on said at least one simplified query statement, for estimating a cost of executing said at least one query statement against said database; seventh program code for determining an estimation of a cost of said at least one transaction based on costs of said simplified query statements within said transaction, said frequency of execution, and said overhead costs; and eighth program code for determining an estimation of the execution costs of an application based upon said means for determining the estimation of the cost of the at least one utility and said means for estimating the cost of executing said at least one query statement and means for determining the estimation of the cost of said at least one transaction.

Claim 37

A computer program, on a computer usable medium, for estimating execution costs of at least a portion of an application having at least one query statement for accessing a database, comprising: means for providing a user interface for receiving input from a user for defining columns of a table by data type and quantity and for defining indexes by specifying a defined column as an index; means for generating a partial table definition from the defined columns and defined indexes and from a user specifiable DASD type; means for providing a user interface for receiving input from a user specifying a cpu and DASD type; means for providing a user interface for receiving input from a user specifying a partial definition of a SQL statement, the specification including an identifier for the partial definition of the SQL statement, and a type of the SQL statement; means for generating a simplified SQL statement from user input received through an interface providing selectable options, based upon the type of the SQL statement specified, the interface including i) a list of selectable statement clause types, selectable defined columns, selectable operators, and selectable values where a selectable value is selected as being a host variable, a constant, or an expression, if the specified type is SELECT, ii) a list of types of insert including columns or sub-select clauses, if the specified type is INSERT, iii) a list of selectable defined columns and selectable values where a selectable value is selected as being null, a host variable, a constant, or an expression, if the specified type is UPDATE or DELETE; and means, based on said generated simplified query statement, for causing an estimation of a cost of executing said at least one query statement against said database.

Claim 38

A computer program, on a computer usable medium, for estimating execution costs of at least a portion of an application having at least one query statement for accessing a database, comprising: means for providing a user interface for receiving input from a user for defining columns of a table by data type and quantity and for defining indexes by specifying a defined column as an index; means for generating a partial table definition from the defined columns and defined indexes and from a user specifiable DASD type; means for providing a user interface for receiving input from a user specifying a cpu and DASD type; means for providing a user interface for receiving input from a user specifying a partial definition of a SQL statement, the specification including an identifier for the partial definition of the SQL statement, and a type of the SQL statement; means for generating a simplified SQL statement from user input received through an interface providing selectable options, based upon the type of the SQL statement specified, the interface including i) a list of selectable statement clause types, selectable defined columns, selectable operators, and selectable values where a selectable value is selected as being a host variable, a constant, or an expression, if the specified type is SELECT, ii) a list of types of insert including columns or sub-select clauses, if the specified type is INSERT, iii) a list of selectable defined columns and selectable values where a selectable value is selected as being null, a host variable, a constant, or an expression, if the specified type is UPDATE or DELETE; and means, based on said generated simplified query statement, for causing an estimation of a cost of executing said at least one query statement against said database.

Claim 39

The program of claim 22 further comprising means for adding, deleting and modifying entries in the partial table definition.

Claim 40

The program of claim 22 wherein the generated table definition comprises scrollable column names with a corresponding data type for each column name and a list of index names and a list of index columns.

Claim 41

The program of claim 22 further comprising means for displaying table and index space requirements.

Claim 42

The program of claim 22 wherein a cpu and DASD type is specified from a list of default cpu and DASD types.

Claim 43

The program of claim 22 wherein a cpu or DASD type is specified by configuring a new cpu or DASD type.

Claim 44

The program of claim 22 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.