Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-12-05
2006-12-05
Alam, Shahid (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C709S217000, C715S252000
Reexamination Certificate
active
07146386
ABSTRACT:
A method of performing a snapshot query in a database undergoing recovery allows access to the database during rollback or undo operations. The method includes allowing the query to detect whether a redo lock is present on a data item and if so, waiting until subsequent rollback operations release the lock. If another user has placed an exclusive lock on a data item of the database, the query may continue by reading a version of the data item form the version store. In an embodiment where a mirror database is used for recovery, the constant redo operations have an associated version store. Upon failover to the mirror database, queries may begin during the undo phase of recovery by allowing a query to read the version store of redo operations.
REFERENCES:
patent: 5327556 (1994-07-01), Mohan et al.
patent: 5701480 (1997-12-01), Raz
patent: 5752026 (1998-05-01), Fortier
patent: 6247023 (2001-06-01), Hsiao et al.
patent: 6564215 (2003-05-01), Hsiao et al.
patent: 7076508 (2006-07-01), Bourbonnais et al.
patent: WO 2005/103880 (2005-11-01), None
Mohan, C. et al., “Transaction Management in the R* Distributed Database Management System”, ACM Transactions on Database Systems, vol. 11, No. 4, Dec. 1986, pp. 378-396.
Ng, Pui, “A Commit Protocol for Checkpointing Transactions”, Proceedings of the Seventh Symposium on Reliable Distributed Systems, Oct. 10-12, 1988, pp. 22-31.
Rahm, Erhard, “Recovery Concepts for Data Sharing Systems”, Digest of Papers of the Twenty-First International Symposium on Fault-Tolerant Computing, 1991 FTCS-21., Jun. 25-27, 1991, pp. 368-375.
Lahiri, T. et al., “Fast-Start:Quick Fault Recovery in Oracle”,Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data, 2001, 593-598.
Lomet, D. et al., “Efficient Transparent Application Recovery in Client-Server Information Systems”,Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data, 1998, 460-471.
Mohan, C. et a.l., “ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging”,ACM Transactions on Database Systems, 1992, 17(1), 94-162.
LandOfFree
System and method for a snapshot query during database recovery 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 a snapshot query during database recovery, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for a snapshot query during database recovery will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3685185