System of database concurrency control based on transaction type

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

364DIG1, 3642821, G06F 1730

Patent

active

055510230

ABSTRACT:
A priority scheme is used to control concurrent access to a database. The priority scheme takes advantage of the usual delay in a process after a first full set of data is accessed in order to improve the overall impression of the speed of the system. Access to the database is granted on the basis of priority. In the disclosed exemplary embodiment of the invent ion, three priorities are established: a first priority for fast-response type transactions which have not yet accessed a set of data, a second priority for fast-response transactions which have accessed a set of data, and a third priority for batch transactions. When a fast-response transaction is initiated, it is given the first priority. Once a predefined number of data values have been obtained from the database, enough to produce a full screen display, the transaction receives the second priority. A transaction may be assigned the first priority periodically, when it needs to access a further set of data. A first priority transaction can block a second priority transaction and can kill a third priority transaction. A first priority transaction can only block a second priority transaction. A second priority transaction is not necessarily given priority over a third priority transaction, however.

REFERENCES:
patent: 4956772 (1990-09-01), Neches
patent: 5084816 (1992-01-01), Boese et al.
patent: 5095421 (1992-03-01), Freund
patent: 5233533 (1993-08-01), Edstrom et al.
patent: 5291397 (1994-03-01), Powell
patent: 5369570 (1994-11-01), Parad
patent: 5406476 (1995-04-01), Deziel, Jr. et al.
K. P. Eswaran, J. N. Gray, R. A. Lorie, and I. L. Traiger, "The Notions of Consistency and Predicate Locks in a Database System", Comm. of the ACM, vol. 19, No. 11, (Nov. 1976) pp. 624-633.
David P. Reed, "Implementing Atomic Actions on Decentralized Data", ACM Transactions on Computer Systems, vol. 1, No. 1, (Feb. 1983) pp. 3-23.
Daniel J. Rosenkrantz, Richard E. Stearns, and Philip M. Lewis, II, "System Level Concurrency Control for Distributed Database Systems", ACM Transactions on Database Systems, vol. 3, No. 2, (Jun. 1978) pp. 178-198.
Robert Abbott & Hector Garcia-Molina, "Scheduling Real-Time Transactions: A Performance Evaluation", Proceedings of 14th VLDB Conf., (1988), pp. 1-12.
Sha et al, "A Real-Time Locking Protocol", IEEE Transactions on Computers, vol. 40, No. 7, Jul. 1991, pp. 793-800.
Song et al, "How Well Can Data Temporal Consistency be Maintained?", IEEE Symposium on Computer-Aided Control System Design, 17-19 Mar. 1992, pp. 275-284.

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

System of database concurrency control based on transaction type 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 of database concurrency control based on transaction type, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System of database concurrency control based on transaction type will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-1063532

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