Combination of mass storage sizer, comparator, OLTP user defined workload sizer, and design

• US 6,654,756 B1
• Filed: 02/29/2000
• Issued: 11/25/2003
• Est. Priority Date: 02/29/2000
• Status: Expired due to Term

• Current Assignee: Unisys Corporation
• Original Assignee: Unisys Corporation
• Inventors: Hazzard, Mark G., Quernemoen, John M.
• Primary Examiner(s): Rones, Charles
• Application Number:
  US09/514,801
• Time in Patent Office: 1,365 Days
• Field of Search: 707/1, 707/10, 707/100, 707/205, 705/10, 709/201, 702/186
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A computerized method enabling a user to specify and select a server for a database management system. The computerized method can include software modules for specifying the hardware required to handle the database and the transaction processing. The hardware required to handle the database such as the mass storage and memory can be estimated using either estimated or detailed inputs. When using the detailed inputs, the database composition of each table can be described in great detail, including details about the columns and rows. The hardware required to handle the transaction processing such as the number of processors and the LAN speed can be estimated using either the required transactions per second or the detailed SQL composition for each transaction. A comparator function can allow comparison between two systems in terms of performance ratios and price to performance ratios.

Claims

1. A computer system for operation by a human user for determining a required size for a database management system server comprising:

means for inputting database storage input parameters and transaction input parameters to said computer;

means for displaying results to said user;

first means for determining database mass storage requirements as a function of said database storage input parameters and displaying said mass storage requirements to said user; and

second means for determining transaction processing workload requirements as a function of said transaction input parameters for said database management system and displaying said transaction processing workload requirements; and

wherein said first means for determining database mass storage requirements utilizes as said database storage input parameters estimates of table row size, table column size, and table fill factor, and generates a table size as a function of said database storage input parameters.

2. A computer system for operation by a human user for determining requirements for a proposed database management system server comprising:

means for inputting database storage input parameters and transaction input parameters to said computer;

means for displaying results to said user;

first means for determining database mass storage requirements as a function of said database storage input parameters and displaying said mass storage requirements to said user; and

second means for determining transaction processing workload requirements as a function of said transaction input parameters for said database management system and displaying said transaction processing workload requirements; and

wherein said first means for determining database mass storage requirements utilizes as said database storage input parameters estimates of table row size, table column size, and table fill factor, and generates a table size as a function of said database storage input parameters.

3. A method for assisting a human user in determining needed requirements of a proposed database server comprising:

selecting a database management system from among at least two presented choices;

specifying at least one database input parameter;

calculating a required database storage size as a function of said at least one database input parameter;

specifying a transaction workload; and

identifying a database server having said required database storage size, having sufficient capacity to handle said transaction workload, and being able to run said database management system; and

wherein said required transaction workload is specified at least in part by specifying a composition for a plurality of transactions.

4. A method according to claim 3, wherein said transaction composition includes specifying a plurality of SQL statements for each of said transactions.

5. A computerized method for selecting a database server as recited in claim 4, wherein said SQL statements each have at least one SQL parameter specified to determine a workload requirement for each SQL statement.

6. A method for assisting a human user in determining needed requirements of a proposed database server comprising:

selecting a database management system from among at least two presented choices;

specifying at least one database input parameter;

calculating a required database storage size as a function of said at least one database input parameter;

specifying a transaction workload; and

identifying a database server having said required database storage size, having sufficient capacity to handle said transaction workload, and being able to run said database management system; and

wherein said required transaction workload is specified at least in part by a required transaction per minute value.

7. A method for assisting a human user in determining needed requirements of a database server comprising:

selecting a database management system from among at least two presented choices;

specifying at least one database input parameter;

calculating a required database storage size as a function of said at least one database input parameter;

specifying a transaction workload; and

identifying a database server having said required database storage size, having sufficient capacity to handle said transaction workload, and being able to run said database management system; and

wherein said required transaction workload is specified at least in part by a required transaction per unit time value.

8. A method for assisting a human user in determining needed requirements of a proposed database server comprising:

selecting a database management system from among at least two presented choices;

specifying at least one database input parameter;

calculating a required database storage size as a function of said at least one database input parameter;

specifying a transaction workload; and

identifying a database server having said required database storage size, having sufficient capacity to handle said transaction workload, and being able to run said database management system; and

wherein said database input parameters include a database management system block size, an amount of page padding, statistical summarization estimates of indexes per table and fields per index.

9. A method for assisting a human user in determining needed requirements of a proposed database server comprising:

selecting a database management system from among at least two presented choices;

specifying at least one database input parameter;

calculating a required database storage size as a function of said at least one database input parameter;

specifying a transaction workload; and

identifying a database server having said required database storage size, having sufficient capacity to handle said transaction workload, and being able to run said database management system; and

wherein said database input parameters include estimates for a number of tables, a total amount of data, an average number of columns per row, an average row size, a percent variable length columns, and an average size of variable length columns per table.

10. A method for assisting a human user in determining needed requirements of a proposed database server comprising:

selecting a database management system from among at least two presented choices;

specifying at least one database input parameter;

calculating a required database storage size as a function of said at least one database input parameter;

specifying a transaction workload; and

identifying a database server having said required database storage size, having sufficient capacity to handle said transaction workload, and being able to run said database management system; and

wherein said database input parameters include estimates including a page size, a fill factor, an average number of non-clustered indexes per table, an average number of fixed length fields per non clustered index, an average number of clustered indexes per table, and a number of variable length fields per cluster index.

11. A method for assisting a human user in selecting a database server comprising the steps of:

selecting a database management system from among at least two presented choices;

specifying at least one database input parameters;

calculating a required database storage size as a function of said database input parameters;

specifying a transaction workload; and

identifying a database server having said required database storage size, having sufficient capacity to handle said transaction workload, and being able to run said database management system; and

wherein said database input parameters include estimates including a page size, a fill factor, an average number of non-clustered indexes per table, an average number of fixed length fields per non-clustered index, an average number of clustered indexes per table, and a number of variable length fields per cluster index.

12. A method according to claim 11, wherein said required transaction workload is specified at least in part by a required transaction per minute value.

13. A method according to claim 11, wherein said required transaction workload is specified at least in part by specifying a composition for a plurality of transactions.

14. A method according to claim 13, wherein said transaction composition includes specifying a plurality of SQL statements for each of said transactions.

15. A computerized method for selecting a database server as recited in claim 14, wherein said SQL statements each have at least one SQL parameter specified to determine a workload requirement for each SQL statement.