Patent ID: 7246115
Filing Date: 2007-07-17
Classification: G06F,Y10S

Abstract:
1. A method for efficiently identifying materialized view candidates for queries in a database system, the database system including a plurality of base tables, a plurality of materialized views, and a plurality of materialized view signatures corresponding to the materialized views, comprising the steps of: (a) receiving a query on the base tables; (b) obtaining the materialized view signatures, wherein each materialized view signature comprises information concerning a content of the corresponding materialized view and wherein each of the plurality of signatures comprises: (c) filtering the materialized views based on the materialized view signatures to identify materialized view candidates for the query, wherein the filtering step (c) comprises: (d) performing a query rewrite matching algorithm on each materialized view candidate to identify materialized views from the materialized view candidates that provide a result for the query.