Global checkpoint SCN

Details Global checkpoint SCN Global checkpoint SCN

2011-08-02

2011-08-02

Corrielus, Jean M (Department: 2162)

Data processing: database and file management or data structures

Database and file access

Preparing data for information retrieval

C707S741000, C707S750000, C707S999003, C707S999005, C704S009000, C715S231000

Reexamination Certificate

active

07991775

ABSTRACT:
Described herein are techniques for generating a global checkpoint system change number and computing a snapshot query using the global checkpoint system change number without a need to acquire global locks. In many cases, the need to acquire global locks is eliminated, thereby saving the overhead attendant to processing global locks.

REFERENCES:
patent: 5333265 (1994-07-01), Orimo et al.
patent: 5423037 (1995-06-01), Hvasshovd
patent: 5454102 (1995-09-01), Tang et al.
patent: 5555404 (1996-09-01), Torbjørnsen et al.
patent: 5574906 (1996-11-01), Morris
patent: 5581753 (1996-12-01), Terry et al.
patent: 5806076 (1998-09-01), Ngai et al.
patent: 5870758 (1999-02-01), Bamford et al.
patent: 5924096 (1999-07-01), Draper et al.
patent: 5956731 (1999-09-01), Bamford et al.
patent: 5974427 (1999-10-01), Reiter
patent: 5983277 (1999-11-01), Heile et al.
patent: 5991771 (1999-11-01), Falls et al.
patent: 6014669 (2000-01-01), Slaughter et al.
patent: 6192377 (2001-02-01), Ganesh et al.
patent: 6298319 (2001-10-01), Heile et al.
patent: 6353835 (2002-03-01), Lieuwen
patent: 6393485 (2002-05-01), Chao et al.
patent: 6516327 (2003-02-01), Zondervan et al.
patent: 6574717 (2003-06-01), Ngai et al.
patent: 6691139 (2004-02-01), Ganesh et al.
patent: 6839751 (2005-01-01), Dietz et al.
patent: 7024656 (2006-04-01), Ahad
patent: 7076508 (2006-07-01), Brourbonnais et al.
patent: 7200623 (2007-04-01), Chandrasekaran et al.
patent: 7222136 (2007-05-01), Brown et al.
patent: 7287034 (2007-10-01), Wong et al.
patent: 7290017 (2007-10-01), Wang et al.
patent: 7296039 (2007-11-01), Chandrasekaran et al.
patent: 7334004 (2008-02-01), Ganesh et al.
patent: 7464113 (2008-12-01), Girkar et al.
patent: 7577690 (2009-08-01), Chandrasekaran et al.
patent: 7644084 (2010-01-01), Rapp
patent: 7734580 (2010-06-01), Lahiri et al.
patent: 2002/0133508 (2002-09-01), Larue et al.
patent: 2002/0165724 (2002-11-01), Blankesteijn
patent: 2010/0036843 (2010-02-01), MacNaughton et al.
patent: 0 501 180 (1992-09-01), None
Bober, Paul M., et al., “On Mixing Queries and Transactions via Multiversion Locking”, Computer Sciences Department, University of Wisconsin, 1992, pp. 535-545.
Mohan, C., et al., “Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions”, XP000393583, IBM Almaden Research Center, publication date Feb. 6, 1992, pp. 124-133.
European Patent Office, “Communication—European Search Report”, Application No. 07003358.4-2201, dated May 18, 2007, 8 pages.
Teschke et al., “Concurrent Warehouse Maintenance Without Comprising Session Consistency”, University of Erlangen-Nuremberg., Pub 1998, 10 pages.
Vassilakis et al., “Implementation of Transaction and Concurrency Control Support in a Temporal DBMS”, Department of Information Systems, University of Athens, vol. 23 No. 5. Pub 1998, 16 pages.

Affiliated with

Also associated with

Rating

Global checkpoint SCN does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Global checkpoint SCN, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Global checkpoint SCN will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2661146