Method of maintaining consistency of cached data in a database s

Details Method of maintaining consistency of cached data in a database s Method of maintaining consistency of cached data in a database s

1990-08-13

1993-11-09

Rudolph, Rebecca L.

Boots, shoes, and leggings

395600, 364DIG2, 364974, 364969, 3649692, 364964, 3649642, G06F 100

Patent

active

052610691

ABSTRACT:
A method of maintaining the consistency of cached data in a client-server database system. Three new locks--a cache lock, a pending lock and an out-of-date lock--are added to a two-lock concurrency control system. A new long-running envelope transaction holds a cache lock on each object cached by a given client. A working transaction of the client works only with the cached object until commit time. If a second client's working transaction acquires an "X" lock on the object the cache lock is changed to a pending lock; if the transaction thereafter commits the pending lock is changed to an out-of-date lock. If the first client's working transaction thereafter attempts to commit, it waits for a pending lock to change; it aborts if it encounters an out-of-date lock; and otherwise it commits.

REFERENCES:
patent: 4755930 (1988-07-01), Wilson, Jr. et al.
patent: 4775955 (1988-10-01), Liu
patent: 4897782 (1990-01-01), Bennett et al.
patent: 4965719 (1990-10-01), Shoens et al.
patent: 5029169 (1991-07-01), Smyk
patent: 5055999 (1991-10-01), Frank et al.
patent: 5077658 (1991-12-01), Bendert et al.
patent: 5091846 (1992-02-01), Sachs et al.
patent: 5113514 (1992-05-01), Albonesi et al.
patent: 5140685 (1992-08-01), Sipple et al.
patent: 5161227 (1992-11-01), Dias et al.
"VAXclusters: A Closely-Coupled Distributed System", by Kronenberg, N. P., Levy, H. M., Strecker, W. D.; ACM Transactions on Computer Systems, vol. 4, No. 2, May 1986, pp. 130-146.
"Integrated Concurrency-Coherency Controls for Multisystem Data Sharing", by Dias, D. M., Balakrishna, R. I., Robinson, J. T. and Yu, P. S.; IEEE Transactions on Software Eng., vol. 15, No. 4, Apr. 1989, pp. 437-448.

Affiliated with

Also associated with

Rating

Method of maintaining consistency of cached data in a database s 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 of maintaining consistency of cached data in a database s, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of maintaining consistency of cached data in a database s will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1149771