Invention Grant
- Patent Title: Runtime optimization for multi-index access
-
Application No.: US15259462Application Date: 2016-09-08
-
Publication No.: US09720968B2Publication Date: 2017-08-01
- Inventor: Shuo Li , Ping Liang , Ke Wei Wei , Xin Ying Yang , Chen Xin Yu
- 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 Isaac J. Gooshaw
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Optimization of a multi-index database access at runtime. A processor receives a query. A processor determines a plan and a record identifier (RID) results threshold for the plan, wherein the plan includes an access to the index. A processor determines a static risk threshold, a static risk for the access, and whether the static risk exceeds the static risk threshold. Responsive to the static risk exceeding the static risk threshold, a processor determines a risk bound for the access, and links the access to the risk bound. A processor accesses the index with the key. Responsive to the access being linked to a risk bound, a processor determines a dynamic risk for the access. A processor receives one or more RID results during the execution of the plan. A processor aborts the execution of the plan if a quantity of the RID results is less than the RID results threshold.
Public/Granted literature
- US20170177669A1 RUNTIME OPTIMIZATION FOR MULTI-INDEX ACCESS Public/Granted day:2017-06-22
Information query