Back to results
US 7,925,679 B2Granted
System and program for result set management
AssigneeInternational Business Machines Corporation
InventorsMichael Stephen Schwartz, Naga A. Ayachitula, Shu-Ping Chang, Lenisha V. Gandhi
Life of this patent
Estimating the term…
Abstract
Disclosed is a technique for result set management. One or more result sets are stored. Each result set was generated by executing a query. When at least one of a number of result sets that may be stored and a number of bucket tables that may hold result sets is modified, it is determined whether any of the one or more result sets are to be removed. When it is determined that one or more of the result sets are to be removed, those result sets are removed.
Claims22
A system for result set management, comprising:
- a processor;
- means for receiving input from a system administrator of a number of result sets that are to be stored and a number of bucket tables that are to hold the result sets, wherein the number of result sets represents how many result sets are to be stored, and wherein the number of bucket tables represents how many bucket tables are to be stored in a database;
- means for initializing a result sets table of contents that includes a row for each existing result set, a bucket table column, and a set identifier that identifies a result set, wherein the bucket table column identifies a bucket table in which a result set is stored, wherein the result sets table of contents comprises a table in the database that is separate from the bucket tables;
- means for storing one or more result sets in the bucket tables, wherein each result set was generated by executing a query;
- means for receiving input from the system administrator indicating changes to the number of result sets that are to be stored in the bucket tables and changes to the number of bucket tables that are to be stored in the database;
- and
- means for, in response to receiving the input from the system administrator indicating the changes,
- means for, in response to determining that the input received from the system administrator indicates that the number of result sets has increased and the number of bucket tables has decreased, recalculating values in the bucket table column of the result sets table of contents for existing set identifiers to determine which bucket table is to store which result set and to determine one or more bucket tables to be dropped, dropping one or more empty bucket tables, and inserting additional rows into the result sets table of contents for the increased number of result sets;
- and
- means for, in response to determining that the input received from the system administrator indicates that the number of result sets has decreased and the number of bucket tables has increased, deleting rows in the result sets table of contents for existing set identifiers, recalculating values in the bucket table column of the result sets table of contents for remaining set identifiers to determine which bucket table is to store which result set, and creating one or more bucket tables.
7 more elements
An article of manufacture comprising a computer readable medium including a program for result set management, wherein the program causes operations to be performed, the operations comprising:
- receiving input from a system administrator of a number of result sets that are to be stored and a number of bucket tables that are to hold the result sets, wherein the number of result sets represents how many result sets are to be stored, and wherein the number of bucket tables represents how many bucket tables are to be stored in a database;
- initializing a result sets table of contents that includes a row for each existing result set, a bucket table column, and a set identifier that identifies a result set, wherein the bucket table column identifies a bucket table in which a result set is stored, wherein the result sets table of contents comprises a table in the database that is separate from the bucket tables;
- storing one or more result sets in the bucket tables, wherein each result set was generated by executing a query;
- receiving input from the system administrator indicating changes to the number of result sets that are to be stored in the bucket tables and changes to the number of bucket tables that are to be stored in the database;
- and
- in response to receiving the input from the system administrator indicating the changes,
- in response to determining that the input received from the system administrator indicates that the number of result sets has increased and the number of bucket tables has decreased, recalculating values in the bucket table column of the result sets table of contents for existing set identifiers to determine which bucket table is to store which result set and to determine one or more bucket tables to be dropped, dropping one or more empty bucket tables, and inserting additional rows into the result sets table of contents for the increased number of result sets;
- and
- in response to determining that the input received from the system administrator indicates that the number of result sets has decreased and the number of bucket tables has increased, deleting rows in the result sets table of contents for existing set identifiers, recalculating values in the bucket table column of the result sets table of contents for remaining set identifiers to determine which bucket table is to store which result set, and creating one or more bucket tables.
6 more elements
Dependencies are inferred from the claim text.