Database system providing methodology for enhancing concurrency using row update bit and deferred locking
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Mar 26, 2002
Grant Date -
N/A
app pub date -
Jul 31, 1999
filing date -
Oct 20, 1998
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A Client/Server Database System with improved methods for enhancing concurrency using a 'row update' bit and deferred locking is described. Data rows in the system are designed to include ROW_DELETE and ROW_UPDATE status bits. When a transaction updates a row, it sets the ROW_UPDATE bit. When a transaction inserts a row, neither the ROW_UPDATE nor the ROW_DELETE status bits are set. When a transaction deletes a row, it sets the ROW_DELETE bit but the contents of the data row are left intact. Methods are described for processing database transactions (e.g., in response to SQL queries) using these status bits or flags, together with deferred locking techniques, in a manner that reduces locking overhead and increase concurrency. The approach provides a particular performance advantage over systems that employ row-level locking.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully