Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-09-12
2006-09-12
Alam, Shahid (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C714S016000
Reexamination Certificate
active
07107294
ABSTRACT:
A method and system for suspending log-based updates to a database in a manner that permits resumption of log-based updating without reinitializing the database. The method and system thereby permit efficient alternation between a log-based update mode and a database access mode. Unplayed log records are protected as revisions of database pages at the time that the log-based update was suspended. This approach permits log-based updating to resume at the same point at which log-based updating was suspended. In order to ensure consistent data for access while in database access mode, a roll-back procedure creates consistent data pages that are used for access and discarded when log-based update resumes.
REFERENCES:
patent: 5287501 (1994-02-01), Lomet
patent: 5317731 (1994-05-01), Dias et al.
patent: 5327556 (1994-07-01), Mohan et al.
patent: 5455944 (1995-10-01), Haderle et al.
patent: 5455946 (1995-10-01), Mohan et al.
patent: 5485608 (1996-01-01), Lomet et al.
patent: 5495601 (1996-02-01), Narang et al.
patent: 5524205 (1996-06-01), Lomet et al.
patent: 5845292 (1998-12-01), Bohannon et al.
patent: 5850507 (1998-12-01), Ngai et al.
patent: 6092066 (2000-07-01), Ofek
patent: 6182241 (2001-01-01), Ngai et al.
patent: 6205449 (2001-03-01), Rastogi et al.
patent: 6226651 (2001-05-01), Masuda et al.
patent: 6295610 (2001-09-01), Ganesh et al.
patent: 6493826 (2002-12-01), Schofield et al.
patent: 6567928 (2003-05-01), Lyle et al.
patent: 6651073 (2003-11-01), Lyle et al.
patent: 6950834 (2005-09-01), Huras et al.
patent: 6976022 (2005-12-01), Vemuri et al.
patent: 6981004 (2005-12-01), Ganesh et al.
patent: 7031974 (2006-04-01), Subramaniam
patent: 7065537 (2006-06-01), Cha et al.
patent: 2004/0054643 (2004-03-01), Vemuri et al.
patent: 2004/0054644 (2004-03-01), Ganesh et al.
Bayer, R. et al., “Parallelism and Recovery in Database Systems”, ACM Transactions on Database Systems, vol. 5, No. 2, Jun. 1980, pp. 139-156.
Mohan, C. et al., “ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging”, ACM Transactions on Database Systems, vol. 17, No. 1, Mar. 1992, pp. 94-162.
Spector, Alfred et al., “Distributed Transactions for Reliable Systems”, ACM 1985, pp. 127-146.
Goss Jeffrey J.
Huras Matthew A.
McArthur Catherine S.
McInnis Dale M.
Romanufa Keriley K.
Alam Shahid
Gibbs Andre
LandOfFree
Method and apparatus for interrupting updates to a 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 Method and apparatus for interrupting updates to a database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for interrupting updates to a database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3604971