System and methodology for performing read-only transactions...

Details System and methodology for performing read-only transactions... System and methodology for performing read-only transactions...

2004-07-02

2010-10-26

Vo, Tim T. (Department: 2168)

Data processing: database and file management or data structures

Data integrity

Transactional processing

Reexamination Certificate

active

07822727

ABSTRACT:
A database system providing high performance database versioning is described. In a database system employing a transaction log, a method for restoring databases to a consistent version comprises steps of: providing a shared cache storing database blocks for use by multiple databases; for a read-only transaction of a given database, creating a cache view of the shared cache using the given database's transaction log, the cache view comprising particular database blocks of the shared cache that record a view of a particular version of the database at a given point in time; creating a shadow cache for storing any database blocks that overflow the cache view; and in conjunction with the cache view and the shadow cache, preserving a logical undo operation for the read-only transaction of the given database, so as to allow the given database to be restored to a transactionally consistent version.

REFERENCES:
patent: 5701480 (1997-12-01), Raz
patent: 5706510 (1998-01-01), Burgoon
patent: 5715447 (1998-02-01), Hayashi et al.
patent: 6192376 (2001-02-01), Kincaid et al.
patent: 6192377 (2001-02-01), Ganesh et al.
patent: 6457021 (2002-09-01), Berkowitz et al.
patent: 6618822 (2003-09-01), Loaiza et al.
patent: 6631374 (2003-10-01), Klein et al.
patent: 6990503 (2006-01-01), Luo et al.
patent: 7093081 (2006-08-01), DeWitt et al.
The Authoritative Dictionary of IEEE Standards Terms, Seventh Edition, IEEE Press, 2000.
Weems, “Shadow Cache,” University of Massachusetts, May 2004 <http://www.cs.umass.edu/˜weems/CmpSci635A/Lecture10/L10.23.html>.
Natarajan et al., “Log Sequence Numbers,” University of Wisconsin, May 2003 <http://www.cs.wisc.edu/coral/mini—doc/logMgr/report
ode5.html>.
Weems, “Shadow Cache,” University of Massachusetts, May 2004.
Natarajan et al., “Log Sequence Numbers,” University of Wisconsin, May 2003.

Affiliated with

Also associated with

Rating

System and methodology for performing read-only transactions... 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 methodology for performing read-only transactions..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and methodology for performing read-only transactions... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4199638