Improving performance of database queries
US7895191B2 · kind B2 · utility
102Cited by
109References
57Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Apr 9, 2003 |
| Grant date | Feb 22, 2011 |
| Priority date | — |
| Expiry date | Dec 31, 2023 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system, method, and program for improving the performance for SQL queries. Multidimensional metadata associated with a cube model metadata object is obtained. One or more summary tables to be built are automatically identified based on the obtained multidimensional metadata. One or more indexes to create are automatically identified based on the obtained multidimensional metadata.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.