REAL-TIME DATABASE OBJECT STATISTICS COLLECTION

摘要

A system for collecting database object statistics by a database management system selects one or more objects and corresponding one or more object fields (200) and then creates a base set of statistics for the selected object fields (220). The system further reads active log records (230) and updates the base set of statistics when a change is read in the active log records (240). Finally, the system begins extracting log records (260) when an end-of-file of the active log records is reached (25), and updates the updated statistics based on the extracted log records (298).