Invention Grant
- Patent Title: Optimizing query processing and routing in a hybrid workload optimized database system
-
Application No.: US15899694Application Date: 2018-02-20
-
Publication No.: US10909116B2Publication Date: 2021-02-02
- Inventor: Al Chakra , Ruiping Li , Terence P. Purcell , Lily Zhou
- 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
- Agency: Winstead PC
- Agent Robert A. Voigt, Jr.
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453 ; G06F16/23

Abstract:
A method, system and computer program product for processing queries in a hybrid database system. A database management system of the hybrid database system obtains an estimated execution time of a query by an online transaction processing engine. The database management system further obtains an estimated execution time of the query by a database accelerator. Furthermore, the database management system determines a wait time (which could be zero) for the database accelerator to process the query. The database management system then determines whether the online transaction processing engine or the database accelerator will process the query using the estimated execution time of the query by the online transaction processing engine, the estimated execution time of the query by the database accelerator and the wait time (which could be zero) for the database accelerator to process the query. In this manner, the processing of queries in hybrid database systems is optimized.
Public/Granted literature
- US20190258732A1 OPTIMIZING QUERY PROCESSING AND ROUTING IN A HYBRID WORKLOAD OPTIMIZED DATABASE SYSTEM Public/Granted day:2019-08-22
Information query