The Community for Technology Leaders
Green Image
<p>A method for concurrency control in distributed database management systems that increases the level of concurrent execution of transactions, called ordering by serialization numbers (OSN), is proposed. The OSN method works in the certifier model and uses time-interval techniques in conjunction with short-term locks to provide serializability and prevent deadlocks. The scheduler is distributed, and the standard transaction execution policy is assumed, that is, the read and write operations are issued continuously during transaction execution. However, the write operations are copied into the database only when the transaction commits. The amount of concurrency provided by the OSN method is demonstrated by log classification. It is shown that the OSN method provides more concurrency than basic timestamp ordering and two-phase locking methods and handles successfully some logs which cannot be handled by any of the past methods. The complexity analysis of the algorithm indicates that the method works in a reasonable amount of time.</p>
concurrent transaction execution; distributed scheduler; distributed databases; concurrency control; distributed database management systems; ordering by serialization numbers; OSN method; certifier model; time-interval techniques; short-term locks; serializability; deadlocks; standard transaction execution policy; concurrency; log classification; timestamp ordering; two-phase locking; complexity analysis; concurrency control; distributed databases
U. Halici, A. Dogac, "Concurrency Control in Distributed Databases Through Time Intervals and Short-Term Locks", IEEE Transactions on Software Engineering, vol. 15, no. , pp. 994-1003, August 1989, doi:10.1109/32.31355
88 ms
(Ver 3.3 (11022016))