Optimizing query processing and routing in a hybrid workload optimized database system

A computer program product for processing queries in a hybrid database system, the computer program product comprising one or more computer readable storage mediums having program code embodied therewith, the program code comprising programming instructions for:

• 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.

A system, comprising:

• a memory for storing a computer program for processing queries in a hybrid database system;
• and
• a processor connected to said memory, wherein said processor is configured to execute program instructions of the computer program 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.