RANGE PREDICATE CANONIZATION FOR TRANSLATING A QUERY
First Claim
Patent Images
1. A query system comprising:
- a database comprising a base table, the base table comprising a set of data;
a materialized view associated with a portion of the set of data; and
a materialized view query rewrite (MVQR) component to translate each of a range predicate of the materialized view and a range predicate of a query into a canonical range representation (CRR) format to generate a materialized view metadata and a query metadata, respectively, to enable the query to search the materialized view.
2 Assignments
0 Petitions
Accused Products
Abstract
A system and methods for implementing a materialized view for a query are provided. The query system includes a database that includes a base table. The base table can include a set of data. The query system also includes a materialized view associated with a portion of the set of data, and a MVQR component to translate each of a range predicate of the materialized view and a range predicate of a query into a canonical range representation (CRR) format in materialized view metadata and query metadata, respectively, to enable the query to search the materialized view.
-
Citations
15 Claims
-
1. A query system comprising:
-
a database comprising a base table, the base table comprising a set of data; a materialized view associated with a portion of the set of data; and a materialized view query rewrite (MVQR) component to translate each of a range predicate of the materialized view and a range predicate of a query into a canonical range representation (CRR) format to generate a materialized view metadata and a query metadata, respectively, to enable the query to search the materialized view. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A non-transitory computer readable medium having computer readable instructions comprising:
-
a catalogue manager to create a materialized view associated with a portion of a set of data represented by a base table; a compiler to receive a query programmed to search the base table; and an MVQR component to translate a range predicate of the materialized view into a canonical range representation (CRR) format in materialized view metadata, to translate a range predicate of the query into a CRR format in query metadata, to compare the materialized view metadata and the query metadata, and to enable a search of the materialized view by the query if the query metadata is subsumed by the materialized view metadata. - View Dependent Claims (10, 11, 12)
-
-
13. A method comprising:
-
generating a materialized view associated with a portion of a set of data represented by a base table; translating a range predicate of the materialized view into a canonical range representation (CRR) format in materialized view metadata; receiving a query programmed to search the base table; translating a plurality of range predicates of the query that are connected by a Boolean operator into a single range-oriented predicate in a CRR format in query metadata; comparing the materialized view metadata and the query metadata; enabling a search of the materialized view by the query if the query metadata is subsumed by the materialized view metadata; and searching the materialized view via the query in response to enabling the search. - View Dependent Claims (14, 15)
-
Specification