Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-07-07
2002-05-14
Alam, Hosain T. (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06389430
ABSTRACT:
FIELD OF THE INVENTION
The present invention is directed to computer databases. More particularly, the present invention is directed to the collection of computer database object statistics.
BACKGROUND OF THE INVENTION
The performance of databases and database management systems (“DBMS”s) is critical to many corporations to meet the need of their customers. Customers desire timely and accurate information, and this information is frequently retrieved by an application program interfacing with a database. Poor performance of a database is usually due to inefficient structured query language (“SQL”) by the application program, or inefficient access path selection by the database and DBMS.
Most DBMSs, such as the DB
2
relational DBMS from IBM Corp., use database object statistics to determine access paths. The access paths may be determined at plan bind time, or at execution time in the case of dynamic SQL. In either case, if the statistics are not up to date the access path selected may not be optimal.
Products are available for collecting statistics of database objects. Examples of these prior art products are “RUNSTATS” from IBM Corp., and the “Database Analyzer” from Platinum technology inc. However, one drawback with these products is that they must be run in batch mode, which is time consuming. A further drawback is that if the highest accuracy is desired, the database objects must be in a read-only state during statistics collection.
Based on the foregoing, there is a need for a system and method for collecting and maintaining database object statistics on a real-time basis without limiting the database objects to read-only status during collection.
SUMMARY OF THE INVENTION
One embodiment of the present invention is a system for collecting database object statistics by a database management system. The 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.
REFERENCES:
patent: 5043866 (1991-08-01), Myre, Jr. et al.
patent: 5430871 (1995-07-01), Jamoussi et al.
patent: 5701471 (1997-12-01), Subramanyam
patent: 5721915 (1998-02-01), Sockut et al.
patent: 5758355 (1998-05-01), Buchanan
patent: 5778350 (1998-07-01), Adams et al.
patent: 5852818 (1998-12-01), Guay et al.
patent: 6115722 (1998-12-01), Isip, Jr. et al.
patent: 5907844 (1999-05-01), Guay et al.
patent: 5946486 (1999-08-01), Pekowski
patent: 6002753 (1999-12-01), Morrison et al.
patent: 6078918 (2000-06-01), Allen et al.
patent: 6119128 (2000-09-01), Courter et al.
patent: 6178427 (2001-01-01), Parker
patent: 6192365 (2001-02-01), Draper et al.
Alam Hosain T.
Baker & McKenzie
Computer Associates Think Inc.
Ly Anh
LandOfFree
Real-time database object statistics collection does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Real-time database object statistics collection, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Real-time database object statistics collection will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2855762