Patent ID: 6473776
Filing Date: 2002-10-29
Classification: G06F,Y10S

Abstract:
A computer-implemented method for automatic pruning of a log used in a log-based replication of at least one database table within a relationable database management system, comprising:(a) re-assembling at least one data row of the database table in at least one database structure from the log records; (b) marking a first log record for the data row being re-assembled; (c) removing the data row from the data structure when it is re-assembled; (d) identifying the marked first log record as an optional point at which to prune the log when the data row is removed from the data structure, in order to provide a minimum amount of storage space form the log, and yet ensures that all updates to the data table can be properly replicated from the log; and (e) automatically pruning the log of selected records prior to the optimal point.