Lazier timestamping in a transaction time database

Details Lazier timestamping in a transaction time database Lazier timestamping in a transaction time database

2011-03-08

2011-03-08

Boccio, Vincent (Department: 2159)

Data processing: database and file management or data structures

File or database maintenance

Database recovery

Reexamination Certificate

active

07904427

ABSTRACT:
Systems and methods for facilitating more efficient timestamping in a lazy timestamping transaction time database environment are described herein. A recovery log component can store timestamp information of a transaction in a commit record of the transaction, wherein the commit record of the transaction is included in a recovery log. A volatile reference count component can update reference count data of the transaction in a volatile timestamp table to reflect a number of records of the transaction that do not persistently include timestamp information. Further, a checkpoint component can update timestamp information for a batch of transactions, wherein the timestamp information is updated in a record of the persistent timestamp table to ensure that the timestamp information persists in the record of the persistent timestamp table before the commit record of the transaction that contains the transaction's timestamp information is deleted from the recovery log.

REFERENCES:
patent: 5701480 (1997-12-01), Raz
patent: 5864849 (1999-01-01), Bohannon et al.
patent: 6502095 (2002-12-01), Breitbart et al.
patent: 6754657 (2004-06-01), Lomet
patent: 7158991 (2007-01-01), Kekre et al.
patent: 7243088 (2007-07-01), Verma et al.
patent: 7281023 (2007-10-01), Lou
patent: 7403945 (2008-07-01), Lin et al.
patent: 2006/0167960 (2006-07-01), Lomet
David Lomet, et al. “Transaction Time Support Inside a Database Engine” http://www-users.cs.umn.edu/˜mokbel/ImmortalDB-ICDE6.pdf. 12 pages.
Kjetil Norvag, et al. “The Vagabond Approach to Logging and Recovering in Transaction-Time Temporal Object Database Systems”. Department of Computer and Information Science, Norwigian University of Science and Technonogy. 7494 Trondheim, Norway. 22 pages.
Kristian Torp, et al. “Correct and Efficent Timestamping of Temporal Data”. Mar. 11, 1997. 22 pages.
David Lomet, et al. “Immortal DB: Transaction Time Support for SQL Server”. http://www-users.cs.umn.edu/˜mokbel/Immortal/DBDemo.pdf. 3 pages.

Affiliated with

Also associated with

Rating

Lazier timestamping in a transaction time 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 Lazier timestamping in a transaction time database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Lazier timestamping in a transaction time database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2757841