Real-time database object statistics collection
AssigneeComputer Associates Think, Inc.
InventorChristopher F. Parker
Life of this patent
Estimating the term…
Abstract
A system for collecting database object statistics by a database management system selects one or more objects and corresponding one or more object fields and then creates a base set of statistics for the selected object fields. The system further reads active log records and updates the base set of statistics when a change is read in the active log records. Finally, the system begins extracting log records when an end-of-file of the active log records is reached, and updates the updated statistics based on the extracted log records.
Claims14
A method of collecting database object statistics by a database management system (DBMS), said method comprising:
- (a) selecting one or more objects and corresponding one or more object fields;
- (b) creating a base set of statistics for the selected object fields;
- (c) reading active log records;
- (d) updating the base set of statistics when a first change is read in the active log records;
- (e) when an end-of-file of the active log records is reached, begin extracting log records;
- and
- (f) updating the updated statistics based on the extracted log records.
A system for collecting database object statistics by a database management system (DBMS), said system comprising:
- means for selecting one or more objects and corresponding one or more object fields;
- means for creating a base set of statistics for the selected object fields;
- means for reading active log records;
- means for updating the base set of statistics when a first change is read in the active log records;
- means for begin extracting log records when an end-of-file of the active log records is reached;
- and
- means for updating the updated statistics based on the extracted log records.
Dependencies are inferred from the claim text.