Method, system, and program for using control data structures when performing operations with respect to a database
AssigneeInternational Business Machines Corporation
InventorsSan Yu Phoenix, Kalpana Shyam, James Zu-Chia Teng, Stephen Walter Turnbaugh, Julie Ann Watts
Life of this patent
Estimating the term…
Abstract
Provided is a method, system, program, and data structures for making data available to an application program. 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. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.
Claims42
A method for performing operations with respect to a database, comprising:
- generating a result table for an open scrollable cursor including data from a subset of entries in a base table having data in one or more columns that satisfy a query predicate clause;
- generating at least one control data structure associated with a plurality of base table entries and at least one scrollable cursor, wherein the result table for each scrollable cursor associated with the control data structure includes data from at least one of the base table entries associated with the control data structure;
- receiving a request to delete one base table entry;
- and
- if the base table entry to be deleted is associated with one control data structure, then indicating in the associated control data structure tat the base table entry was deleted.
The method of claim wherein the data is inserted at the target base table entry if there is no open scrollable cursor associated with one determined control structure associated with the target base table entry and if one control data structure indicates that the target base table entry is deleted.
A system for performing operations with respect to a database, comprising:
- a storage device including a base table;
- a computer readable medium;
- means for generating a result table in the computer readable medium for an open scrollable cursor including data from a subset of entries in a base table having data in one or more columns tat satisfy a query predicate clause;
- means for generating at least one control data structure in the computer readable medium associated with a plurality of base table entries and at least on scrollable cursor, wherein the result table for each scrollable cursor associated with the control data structure includes data from at least one of the base table entries associated with the control data structure;
- means for receiving a request to delete one base table entry;
- and means for indicating in the associated control data structure that the base table entry was deleted if the base table entry to be deleted is associated with one control data structure.
An article of manufacture for performing operations with respect to a database by:
- generating a result table for an open scrollable cursor including data from a subset of entries in a base table having data in one or more columns that satisfy a query predicate clause;
- generating at least on control data structure associated with a plurality of base table entries and at least on scrollable cursor, wherein the result table for each scrollable cursor associated with the control data structure includes data from at least one of the base table entries associated with the control data structure;
- receiving a request to delete one base table entry;
- and
- if the base table entry to be deleted is associated with one control data structure, then indicating in the associated control data structure that the base table entry was deleted.
Dependencies are inferred from the claim text.