Page refreshing procedure using two locking granularities to ens

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

395650, 39518314, 364134, 364DIG1, 36424341, 36493543, 364DIG2, G06F 13364

Patent

active

055465790

ABSTRACT:
A method for ensuring data coherence while detecting whether the locally cached copy of a data page is invalid and responsively refreshing the locally cached page from a Shared Electronic Store (SES) in a multisystem shared disk environment. Locally cached data pages may become invalid in a multisystem shared disk environment because of transactions executed by other systems for the common database. Thus, whenever a transaction in a database management system (DBMS) instance desires to read or update a record in a locally cached data page, the DBMS must first verify validity for the locally cached copy and, for stale or invalid copies, must re-read and re-register the latest version in the SES. This invention provides a procedure for the necessary verification and refreshing steps that relies on page latching to serialize the combination of local multiuser and global multisystem activities. The procedure of this invention supports both record and page locking granularities.

REFERENCES:
patent: 4096561 (1978-06-01), Trinchieri
patent: 4965719 (1990-10-01), Shoens et al.
patent: 5247672 (1993-09-01), Mohan
patent: 5276835 (1994-01-01), Mohan et al.
patent: 5276872 (1994-01-01), Lomet et al.
patent: 5280611 (1994-01-01), Mohan et al.
patent: 5287473 (1994-02-01), Mohan et al.
patent: 5287521 (1994-02-01), Nitta et al.
patent: 5333303 (1994-07-01), Mohan
C. Mohan, "Aries: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging", Research Report RJ 6649, Rev. Nov. 2, 1990, International Business Machines Corporation.
C. Mohan & I. Narang, "Recovery and Coherency-Control Protocols for Fast Intersystem Page Transfer and Fine-Granularity Locking in a Shared Disks Transaction Environment", Research Report RJ 8017, Mar. 15, 1991, International Business Machines Corp.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Page refreshing procedure using two locking granularities to ens does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Page refreshing procedure using two locking granularities to ens, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Page refreshing procedure using two locking granularities to ens will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-1056804

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.