PARALLEL TRANSACTIONAL-STATISTICS COLLECTION FOR IMPROVING OPERATION OF A DBMS OPTIMIZER MODULE

摘要

A method and associated system for improving the operation of an optimizer module of a database-management system. A processor of a computer system captures and stores information about the database's recent transactions, where the captured information describes how each transaction altered the logical description of the database or revised data stored in the database. The processor uses this captured information to update stored metadata that identifies the database's logical structure, and to further update stored database statistics that describe characteristics of the data stored in the database. These updated statistics are then returned to the production database's optimizer module, which uses them to determine how to efficiently respond to database-access requests.

主权项

1. A method for optimizing the collection of transactional statistics of a database, the method comprising:
a processor of a computerized database-optimization system capturing transaction information of a production database system, where the production database system comprises an optimizer module and stores data on a production hardware storage medium, where the captured transaction information describes a characteristic of a data-access transaction associated with a data element and a logical element stored on the production hardware storage medium, and where the database-optimization system is distinct from the optimizer module and from the production hardware storage medium,
where the capturing comprises reading database-transaction data stored on the production hardware storage medium; the processor storing the captured information in a transaction-log repository located on a first computer-readable hardware storage medium that is distinct from the production hardware storage medium; the processor updating a repository of cumulative statistical data associated with the production database as a function of the captured transaction information,
where the cumulative statistical data is capable of being used by the optimizer module to increase the efficiency of the data-access operation, andwhere the updating comprises the processor inferring from the captured transaction information metadata that identifies a characteristic of the logical element; the processor further updating a metadata repository as a function of the inferred metadata, where the metadata repository is stored on a second computer-readable hardware storage medium that is distinct from the production hardware storage medium, and where the metadata repository stores information that identifies characteristics of a plurality of logical elements associated with the production database; and the processor making the cumulative statistical data available to the optimizer module.