Please download the dossier by clicking on the dossier button x
×

Optimizing correlated queries using automatic summary tables

  • US 20030088558A1
  • Filed: 11/05/2002
  • Published: 05/08/2003
  • Est. Priority Date: 05/20/1999
  • Status: Active Grant
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) generating an automatic summary table;

    (b) analyzing the query using matching and compensation tests between the query, at least one correlated subquery within the query and the automatic summary table to determine whether expressions occurring in the query, but not in the automatic summary table, can be derived using the automatic summary table;

    (c) rewriting the query so that the automatic summary table is used.

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