System and process for evaluating the performance of a database system
AssigneeInternational Business Machines Corporation
InventorsJOHN F. HORNIBROOK, JOHN E. LUMBY
Life of this patent
Estimating the term…
Abstract
A system and process for evaluating the performance of an operational database system without interfering with the normal operation of the operational database system is described. The process involves the creation of a test database which contains the system catalogs of the operational database system as user tables. The test database is used to compile queries using these simulated system catalogs. The access plan generated by the compilation in the test database can then be used to evaluate the performance of the queries.
Claims13
A system for enabling analysis of the performance of an operational database management system using a test database management system, said test database management system including:
- means for storing a copy of system catalog tables from said operational database management system in user tables in said test database management system;
- means for accepting test queries in said test database management system;
- means for compiling said test queries in said test database management system, said means for compiling being substantially identical to means for compiling queries in said operational database management system;
- and
- means for generating an access plan for each test query whereby the ability of said operational database management system may be evaluated.
A method for enabling analysis of the performance of an operational database management system, said method comprising the following steps:
- creating a test database management system;
- storing a copy of system catalog tables stored in said operational database management system in said test database management system, said catalog tables being stored as simulated system catalogs in user data tables in said test database management system;
- compiling a query on said test database management system using said simulated system catalogs;
- and
- generating an access plan for said query whereby the access plan can be analyzed.
A method for evaluating performance of an operational database system comprising the steps of:
- creating a test database system having the compilation characteristics of said operational database system including user tables, catalog tables, a computer, and a catalog ID table;
- storing a copy of system catalog tables stored in said operational database as simulated system catalog tables in user tables in said test database system;
- compiling a query on said test database, said query addressing said simulated system catalog tables through said catalog ID table;
- and
- generating an access plan for said query whereby said performance can be evaluated by analyzing said access plan generated by said test database.
A method for enabling the studying of the various phases of a compiler during development of an SQL compiler of a database management system based on information used by the compiler within an operational database system, said method including creating a replica of said operational database system on a test database system, said replica excluding data from said operational database system, and running said test database system so as to simulate compilation of said operational database system.
A computer program product tangibly embodying a program of instructions executable by a computer to perform a method for enabling analysis of the performance of an operational database management system, said method comprising the following steps:
- creating a test database management system;
- storing a copy of system catalog tables stored in said operational database management system in said test database management system, said catalog tables being stored as simulated system catalogs in user data tables in said test database management system;
- compiling a query on said test database management system using said simulated system catalogs;
- and
- generating an access plan for said query whereby the access plan can be analyzed.
A computer program product tangibly embodying a program of instructions executable by a computer to perform a method for evaluating performance of an operational database system comprising the steps of:
- creating a test database system having the compilation characteristics of said operational database system including user tables, catalog tables, a computer, and a catalog ID table;
- storing a copy of system catalog tables stored in said operational database as simulated system catalog tables in user tables in said test database system;
- compiling a query on said test database, said query addressing said simulated system catalog tables through said catalog ID table;
- and
- generating an access plan for said query whereby said performance can be evaluated by analyzing said access plan generated by said test database.
A computer program product tangibly embodying a program of instructions executable by a computer to perform a method for enabling the studying of the various phases of a compiler during development of an SQL compiler of a database management system based on information used by the compiler within an operational database system, said process including creating a replica of said operational database system on a test database system, said replica excluding data from said operational database system, and running said test database system so as to simulate compilation of said operational database system.
Dependencies are inferred from the claim text.