Optimization of SQL queries using filtering predicates
US6571233B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Dec 6, 2000 |
| Grant date | May 27, 2003 |
| Priority date | — |
| Expiry date | Jun 21, 2021 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99935
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A technique for optimizing execution of a query that accesses data stored on a data store connected to a computer. Query predicates involving different data types are identified. A second query predicate is generated which includes matching data types, and if necessary, converted operators. The second query predicate with the matching data types and/or converted operators is executed to obtain a subset of records using an index manager or data manager. The subset of records is converted to the data types of the remaining query predicates. The first query predicate is applied against the subset of records to obtain a result, and the remaining query predicates of the original query are applied to the result of the first query predicate and any other additional converted query predicates to obtain a final result.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.