US 11,907,220 B2
Optimizing query processing and routing in a hybrid workload optimized database system
Al Chakra, Apex, NC (US); Ruiping Li, San Jose, CA (US); Terence P. Purcell, Springfield, IL (US); and Lily Zhou, Sunnyvale, CA (US)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Dec. 18, 2020, as Appl. No. 17/126,427.
Application 17/126,427 is a continuation of application No. 15/899,694, filed on Feb. 20, 2018, granted, now 10,909,116.
Prior Publication US 2021/0191943 A1, Jun. 24, 2021
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/2453 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/24545 (2019.01) [G06F 16/2379 (2019.01); G06F 16/24537 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A computer-implemented method for processing queries in a hybrid database system, the method comprising:
receiving a query to be processed;
estimating an execution time of said query by an online transaction processing engine, wherein said online transaction processing engine comprises a database engine that functions to process online transaction processing workloads;
estimating an execution time of said query by a database accelerator, wherein said database accelerator comprises a database engine that functions to process analytical workloads;
determining a wait time for said database accelerator to process said query via heartbeat messages between said online transaction processing engine and said database accelerator, wherein said wait time corresponds to a delay in processing said query by said database accelerator, wherein said wait time for said database accelerator to process said query is retrieved every time a fixed period of time elapses through said heartbeat messages between said online transaction processing engine and said database accelerator; and
determining whether said online transaction processing engine or said database accelerator will process said query using said estimated execution time of said query by said online transaction processing engine, said estimated execution time of said query by said database accelerator and said wait time for said database accelerator to process said query.