Matching and compensation tests for optimizing correlated subqueries within query using automatic summary tables
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Jan 23, 2007
Grant Date -
May 8, 2003
app pub date -
Nov 5, 2002
filing date -
May 20, 1999
priority date (Note) -
Expired
status (Latency Note)
Importance
Abstract
A method, apparatus, and article of manufacture for optimizing database queries using an automatic summary table. A query is analyzed 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. If so, the query is rewritten so that the automatic summary table is used.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully