Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-07-31
2007-07-31
Mofiz, Apu (Department: 2161)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
10403618
ABSTRACT:
A committed version of a data table is stored in a base table that includes a timestamp column that indicates when the most recent change to each row was committed. Changes to the base table are stored in three versioned tables: a version add table, a version modify table, and a version delete table. A version view table reconstructs the data stored in the base table and the versioned tables to provide an external view of each version. When a change is made, the change is stored in the appropriate versioned table with the corresponding timestamp from the base table. When the change is submitted, the “stored” timestamp in the versioned table is compared with the “current” timestamp in the base table. If the stored timestamp is equal to the current timestamp, then there is no conflict and the change is committed. If the stored timestamp is not equal to the current timestamp, then there is a conflict. A user may choose to merge and commit a conflict or to rollback and not commit the conflicting.
REFERENCES:
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4714996 (1987-12-01), Gladney et al.
patent: 5280612 (1994-01-01), Lorie et al.
patent: 6393437 (2002-05-01), Zinda et al.
patent: 6615223 (2003-09-01), Shih et al.
patent: 7013315 (2006-03-01), Boothby
Cohen, D. “Compiling Complex Database Transition Triggers”,ACM, 1989, 225-234.
Conradi, R. et al., “Version Models for Software Configuration Management”,ACM Computing Surveys, Jun. 1998, 30(2), 232-282.
Dayal, U. et al., “Organizing Long-Running Activities with Triggers and Transactions”,ACM, 1990, 204-214.
Eswaran, K.P. “Aspects of a Trigger Subsystem in an Integrated Database System”,IBM Research Laboratory, San Jose, 243-250.
Katz, R.H. “Toward a Unified Framework for Version Modeling in Engineering Databases”,ACM Computing Surveys, Dec. 1990, 22(4), 375-408.
Raschid, L., et al. “Semantics for Update Rule Programs and Implementation in a Relational Database Management System”,ACM Transactions on Database Systems, Dec. 1996, 22(4), 526-271.
Sciore, E. “Using Annotations to Support Multiple Kinds of Versioning in an Object-Oriented Database System”,ACM Transactions on Database Systems, Sep. 1991, 16(3), 417-438.
Mofiz Apu
Pyo Monica
Woodcock & Washburn LLP
LandOfFree
System and method for database versioning does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for database versioning, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for database versioning will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3756006