Maintaining and reconstructing the history of database...

Details Maintaining and reconstructing the history of database... Maintaining and reconstructing the history of database...

2005-10-25

2005-10-25

Wassum, Luke S (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

06959301

ABSTRACT:
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.

REFERENCES:
patent: 5170464 (1992-12-01), Hayes et al.
patent: 5222235 (1993-06-01), Hintz et al.
patent: 5758355 (1998-05-01), Buchanan
patent: 5806075 (1998-09-01), Jain et al.
patent: 5812840 (1998-09-01), Shwartz
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6115704 (2000-09-01), Olson et al.
patent: 6122640 (2000-09-01), Pereira
patent: 6144970 (2000-11-01), Bonner et al.
patent: 6185555 (2001-02-01), Sprenger et al.
patent: 6212529 (2001-04-01), Boothby et al.
patent: 6226710 (2001-05-01), Melchoir
patent: 6330568 (2001-12-01), Boothby et al.
patent: 6363387 (2002-03-01), Ponnekanti et al.
patent: 6381644 (2002-04-01), Munguia et al.
patent: 6457021 (2002-09-01), Berkowitz et al.
patent: 6502133 (2002-12-01), Baulier et al.
patent: 6519613 (2003-02-01), Friske et al.
patent: 6529921 (2003-03-01), Berkowitz et al.
patent: 6647510 (2003-11-01), Ganesh et al.
patent: 2001/0000536 (2001-04-01), Tarin
patent: 2002/0007363 (2002-01-01), Vaitzbilt
patent: 503768 (1992-09-01), None
Grey et al. , “The Recovery Manager of the System R Database Manager”, ACM, 1981, pp. 223-242.

Affiliated with

Also associated with

Rating

Maintaining and reconstructing the history of database... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Maintaining and reconstructing the history of database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Maintaining and reconstructing the history of database... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3440341