Defining and characterizing an analysis space for precomputed views

A method of processing precomputed views for answering user queries on a database, comprising:

• imposing a structure on an analysis space consisting of a subset of all possible views for the database based upon the capabilities of a query rewriting facility;
• and
• characterizing the views in the analysis space.

A method of processing precomputed views for answering user queries on a database, comprising:

• defining an analysis space consisting of a subset of all possible views for the database;
• and
• applying a cost formula to the analysis space based upon a user-defined subset of the data contained in the database.

A method of processing precomputed views for answering user queries on a database, comprising:

• defining an analysis space that includes a candidate view composed of a combination of two or more constituent views;
• and
• characterizing the views in the analysis space.

An apparatus for processing precomputed views for answering user queries on a database, comprising:

• a query processor;
• and
• an advisor configured to respond to a user database query on precomputation strategy effectiveness by defining, based upon user database query history, an analysis space consisting of a subset of all possible views for the database and by characterizing the views in the analysis space.

An apparatus for processing precomputed views for answering user queries on a database, comprising:

• a query processor;
• and
• an advisor configured to impose a structure on an analysis space consisting of a subset of all possible views for the database based upon the capabilities of a query rewriting facility, and to characterize the views in the analysis space.

An apparatus for processing precomputed views for answering user queries on a database, comprising:

• a query processor;
• and
• an advisor configured to define an analysis space consisting of a subset of all possible views for the database, and to apply a cost formula to the analysis space based upon a user-defined subset of the data contained in the database.

An apparatus for processing precomputed views for answering user queries on a database, comprising:

• a query processor;
• and
• an advisor configured to define an analysis space that includes a candidate view composed of a combination of two or more constituent views, and to characterize the views in the analysis space.