Maintaining and reconstructing the history of database content modified by a series of events

摘要

A method and a system for maintaining the history of database content when the database is modified by a sequence of events, where each event may be one of a load or a load retraction, is provided. The inventive system and method can reconstruct the state of a database as it existed at a discrete time between two successive historical events without repeating each event in the historical event sequence. A table containing deleted row information and a table containing historical information are maintained as the target table is updated to more quickly recreate historical states of the target table.