Matching and compensation tests for optimizing correlated subqueries within query using automatic summary tables
US7167853B2 · kind B2 · utility
13Cited by
41References
21Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Nov 5, 2002 |
| Grant date | Jan 23, 2007 |
| Priority date | — |
| Expiry date | Mar 12, 2024 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99935
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.