Method, system, and program for optimistic concurrency control for scrollable cursors in a database
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Dec 16, 2003
Grant Date -
Jul 4, 2002
app pub date -
Dec 28, 2000
filing date -
Sep 7, 2000
priority date (Note) -
Expired
status (Latency Note)
Importance
Abstract
Provided is a method, system, and program for performing a cursor operation. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. A command is received to perform a cursor operation with respect to a subject row in the result table. A lock is obtained on a row in the base table corresponding to the subject row in the result table. An operation specified in the received command is performed with respect to the subject row after obtaining the lock. The lock on the row in the base table is released after performing the operation.
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