System and method for determining and generating candidate views for a database
AssigneeInternational Business Machines Corporation
InventorsLatha S. Colby, Richard L. Cole, Edward P. Haslam, Nasi Jazayeri, Galt Johnson, William J. McKenna, David G. Wilhite, Jr.
Life of this patent
Estimating the term…
Abstract
The invention features methods and apparatus for processing precomputed views for answering user queries on a database. In accordance with one aspect, a user query on the database is analyzed, and a candidate view based upon the user query is generated.
Claims42
A method for determining and generating a candidate view for, use in answering subsequent queries on a database, comprising:
- analyzing a query on the database that may or may not reference any views;
- and
- based upon the analyzed query, determining and generating the candidate view that can be used to create a precomputed view containing precomputed results of the generated candidate view, wherein the precomputed view can be used to answer a set of queries that are subsequently submitted to the database and wherein the set of queries that can be answered using the precomputed view includes the analyzed query and wherein the analyzed query and the candidate view can be different.
An apparatus for determining and generating a candidate view for use in answering subsequent queries on a database, comprising:
- a query processor;
- and
- a precomputed view processor configured to analyze a query on the database, and based upon the analyzed query, to determine and generate the candidate view that can be used to create precomputed view containing precomputed results of the generated candidate view, wherein the precomputed view can be used to answer a set of queries that are subsequently submitted to the database and wherein the set of queries that can be answered using the precomputed view includes the analyzed query and wherein the analyzed query and the candidate view can be different.
Dependencies are inferred from the claim text.