Reason-based database changes

Details Reason-based database changes Reason-based database changes

2005-11-10

2009-06-23

Mahmoudi, Tony (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07552150

ABSTRACT:
A method, apparatus, system, and signal-bearing medium that in an embodiment, store a reason identifier in rows in a database. The reason identifier identifies the most recent change to the rows. The content of the rows that existed prior to the change are stored in journal records. In response to an undo command, the most-recent instance of each record identifier in the records associated with the reason identifier are found in the journal and moved to the database in reverse time sequence order. In an embodiment, a promote operation requests moving the change upwards in a sequence, from a source version to a target version of the database. In response to the promote operation, a determination is made whether rows with the same row identifiers but a different reason identifier exist in a target version of the database, but the different reason identifier is complete.

REFERENCES:
patent: 5553279 (1996-09-01), Goldring
patent: 6081799 (2000-06-01), Beavin et al.
patent: 6189016 (2001-02-01), Cabrera et al.
patent: 6839724 (2005-01-01), Manchanda et al.
patent: 6981114 (2005-12-01), Wu et al.
patent: 7251669 (2007-07-01), Arora
patent: 2006/0212492 (2006-09-01), Jacobs et al.

Affiliated with

Also associated with

Rating

Reason-based database changes does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Reason-based database changes, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Reason-based database changes will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4068370