Method of querying relational database management systems
AssigneeInternational Business Machines Corporation
InventorsPaul Reuben Day, Thomas Owen McKinley, Brian Robert Muras
Life of this patent
Estimating the term…
Abstract
Database management systems and methods for searching a database are disclosed. In one embodiment, an inspector examines a plan cache or a program containing embedded queries. A plurality of similar queries is identified, and an alias is generated that satisfies the plurality of queries. The alias may be executed on a database to output a result set. Queries belonging to the alias may be executed on the result set of the alias, rather than on the database. Accordingly, efficiency is improved and runtime costs are reduced as compared to conventional database management systems.
Claims20
A method of searching a database, comprising:
- choosing a plurality of queries being executed on a database table;
- creating a data set that is smaller-than the database table and satisfies the plurality of executed queries;
- choosing a target query, other than one of the executed plurality of queries, that is satisfied by the data set;
- and
- executing the target query on the data set, wherein the executing is performed on a computer.
A computer program product including computer usable program code embodied on a non-transitory computer usable medium for searching a database, the computer program product including:
- computer usable program code for choosing a plurality of queries being executed on a database table;
- computer usable program code for creating a data set that is smaller than the database table and satisfies the chosen plurality of queries;
- computer usable program code for choosing a target query, other than one of the executed plurality of queries, that is satisfied by the data set;
- and
- computer usable program code for executing the target query on the data set.
Dependencies are inferred from the claim text.