Techniques for ordering predicates in column partitioned databases for query optimization
US11693883B2 · kind B2 · utility
0Cited by
2References
2Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Dec 27, 2012 |
| Grant date | Jul 4, 2023 |
| Priority date | — |
| Expiry date | Dec 27, 2032 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques for ordering predicates in column partitioned databases for query optimization. Predicates on a single CP table within a query are organized to predicate-CP nodes with various sets of column partitions. The predicates within each predicate-CP node and the predicate-CP nodes as a whole are ordered in ascending order of cost which is determined by CPU/IO cost and predicate selectivity. The reorganized query is then executed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.