Query optimization by transparently altering properties of relational tables using materialized views

  • US 6,339,769 B1
  • Filed: 09/14/1998
  • Issued: 01/15/2002
  • Est. Priority Date: 09/14/1998
  • Status: Expired due to Term
First Claim
Patent Images

1. A method of optimizing a query in a computer system, the query being performed by the computer system to retrieve data from a database stored on the computer system, the method comprising the steps of:

  • (a) accepting the query into the computer system;

    (b) determining whether there exists one or more materialized views for one or more tables referenced in the query, wherein the materialized view has different partitioning or replication properties than the tables referenced in the query;

    (c) analyzing whether at least a portion of the query can be evaluated using one or more of the materialized views in a local fashion, so that no data movement is required for the evaluation;

    (d) rewriting the query to use one or more materialized views rather than an original table or tables referenced in the query; and

    (e) executing the rewritten query using one or more materialized views.

View all claims

    Thank you for your feedback