Browse Prior Art Database

Elimination of Lock Contention in Relational Databases Accessed by Read-Only Queries and On-Line Update Transactions

IP.com Disclosure Number: IPCOM000057634D
Original Publication Date: 1988-Jun-01
Included in the Prior Art Database: 2005-Feb-15

Publishing Venue

IBM

Related People

Authors:
Robinson, J Thomasian, A Yu, PS [+details]

Abstract

A technique is described whereby a concurrency control concept allows the processing of on-line update transactions, which require consistent access to relational databases. The concurrency control utilizes on- demand versioning to eliminate lock contention in the event an update transaction needs to lock a record in a page required by a query. The result is a reduction in on-line transaction delays, enabling a mixture of short update transactions and ad hoc queries to be processed concurrently in a relational database. In an integrated computer processing environment where on-line transactions are processed concurrently with ad hoc read-only queries on a relational database, queries will scan a large number of pages in the database.