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.