×

Method and system for using materialized views to evaluate queries involving aggregation

  • US 5,897,632 A
  • Filed: 07/16/1997
  • Issued: 04/27/1999
  • Est. Priority Date: 08/27/1996
  • Status: Expired due to Term
First Claim
Patent Images

1. A method of evaluating a query in a database system including a materialized view, the method comprising the steps of:

  • receiving an input query;

    semantically analyzing the materialized view to determine whether the materialized view is usable in evaluating the input query;

    if the view is usable, rewriting the input query to produce an output query that is multi-set equivalent to the input query, the output query including at least one reference to the materialized view as a source of information to be returned by the output query that was not included in the input query; and

    evaluating the output query.

View all claims
  • 4 Assignments
Timeline View
Assignment View
    ×
    ×