Invention Grant
- Patent Title: Index selection for database query
-
Application No.: US16998053Application Date: 2020-08-20
-
Publication No.: US11645279B2Publication Date: 2023-05-09
- Inventor: Peng Hui Jiang , Sheng Yan Sun , Shuo Li , Xiaobo Wang
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Randy Tejeda
- Main IPC: G06F16/30
- IPC: G06F16/30 ; G06F16/2453 ; G06F16/22

Abstract:
One or more computer processors match a query pattern to a received query; context information related to the received query; retrieve a set of query records including the same context information as the obtained context information from an index knowledge base, wherein each query record in the set of query records include context information related to a respective history query, the query pattern, an index type associated with the query pattern, and performance information relating to the query pattern and the index type; determine that a subset of the retrieved query records includes one or more query patterns equivalent to the matched query pattern; select a query pattern and an associated index type from the subset of query records based on associated performance information in the set of query records; and perform the received query by applying the selected query pattern and the associated index type.
Public/Granted literature
- US20220058195A1 INDEX SELECTION FOR DATABASE QUERY Public/Granted day:2022-02-24
Information query