×

Recommending materialized views for queries with multiple instances of same table

  • US 20070083489A1
  • Filed: 03/02/2006
  • Published: 04/12/2007
  • Est. Priority Date: 10/07/2005
  • Status: Active Grant
First Claim
Patent Images

1. A computer system, comprising:

  • a query analysis logic configured to analyze a database query and identify multiple instances of a table where an instance of a table includes the table being part of a join operation; and

    an instance numbering logic configured to assign an instance number to each of the multiple instances of the table in the query based on a structure of the join operation such that equivalent join operations from different queries that do not match syntactically will be assigned the same instance numbers such that a common materialized view can be recommended for both of the different queries.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×