Method, system, and program for optimistic concurrency control for scrollable cursors in a database

A system for performing a cursor operation, comprising:

• means for generating a result table 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;
• means for receiving a command to perform a cursor operation with respect to a subject row in the result table;
• means for obtaining a lock on a row in the base table corresponding to the subject row in the result table as part of performing the operation specified in the received command;
• means for performing the operation specified in the received command with respect to the subject row after obtaining the lock;
• and
• means for releasing the lock on the row in the base table after performing the operation.

A program for performing a cursor operation, wherein the program comprises code implemented in a computer readable medium that is capable of causing a processor to perform:

• generating a result table 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;
• receiving a command to perform a cursor operation with respect to a subject row in the result table;
• obtaining a lock on a row in the base table corresponding to the subject row in the result table as part of performing the operation specified in the received command;
• performing the operation specified in the received command with respect to the subject row after obtaining the lock;
• and
• releasing the lock on the row in the base table after performing the operation.