Unique key lookup with additional filter
US11163766B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Apr 4, 2019 |
| Grant date | Nov 2, 2021 |
| Priority date | — |
| Expiry date | Oct 21, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24542
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method, a system, and a computer program product for executing a query. The query requiring access to one or more tables stored in a database system is executed. The query includes one or more filter predicates. Using a unique key value corresponding to a first predicate, at most one row in the tables including a portion of data matching the unique key value is identified. Using filter values corresponding to the filter predicates, another portion of data in the identified row is compared to the filter values to determine whether that portion of data matches the filter values. Based on the comparison, a result of the execution of the query is outputted. The result includes data stored in the identified row upon determination that the data matches the unique key value corresponding to the first filter predicate and the filter values corresponding to remaining filter predicates. Otherwise, the result is empty.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.