Patent №
US 11,222,015
Granted
2022-01-11
Filed 2019
Owner
INTERNATIONAL BUSINESS MACHINES CORPORATION
Lab
AI components
1
planning
Assignment
Recorded
Dataset
AIPD
2023_r1 edition
Application
16403952
A method, system and computer program product are provided. A first index scan of records of a database table is performed. A first index used by the first index scan is specified in a DBMS query statement as being ordered by one or more field values of one or more fields of the first index. A second scan of the database table is performed to determine whether each respective record of the second scan is qualified based on one or more fields of the each respective record of the second scan and a predicate. A lookup data structure is built indicating whether each of the respective records of the second scan is qualified. The lookup data structure is used to determine whether a record of the first index scan is qualified when the lookup data structure becomes available.
AI classification
Ownership
INTERNATIONAL BUSINESS MACHINES CORPORATION
assignment · 490910827
Assignors
BAGGETT, BRIAN L., BEAVIN, THOMAS A., DRAESE, OLIVER, GUO, SHUANGLIN, LURIE, ANDREI F., PURCELL, TERENCE P., SUO, SHENGXI
On an employer assignment, the assignors are typically the inventors.