US 12,229,095 B2
Hybrid query and index for high performance in a cloud
Sheng Yan Sun, Beijing (CN); Peng Hui Jiang, Beijing (CN); Xiao Xiao Chen, Beijing (CN); and Ying Zhang, Beijing (CN)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Dec. 30, 2022, as Appl. No. 18/091,570.
Prior Publication US 2024/0220465 A1, Jul. 4, 2024
Int. Cl. G06F 16/00 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01); G06F 16/2457 (2019.01); G06F 18/2323 (2023.01)
CPC G06F 16/22 (2019.01) [G06F 16/2425 (2019.01); G06F 16/24578 (2019.01); G06F 18/2323 (2023.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method, comprising:
receiving, by a processor set, a query including a query string for a system catalog;
identifying, by the processor set, a default index structure of the system catalog;
executing, by the processor set, the query based on the default index structure of each index in the system catalog;
ranking, by the processor set, a performance of each execution of the query by each index;
mapping, by the processor set, a query pattern to a corresponding index of the system catalog;
selecting, by the processor set, the index to perform the query using a machine learning (ML) model trained with a knowledge base that includes the ranking and the mapping;
executing, by the processor set, the query on the selected index;
in response to executing the query on the selected index, returning, by the processor set, a result of the query; and
receiving, by the processor set, a new query;
analyzing, by the processor set, the new query to determine a new query pattern; and
building, by, the processor set, a new invisible index based on the determined new query pattern and determining whether the new invisible index performs better than the system catalog.