Browse Prior Art Database

Distributing SQL Statements Among Multiple Accelerators To Ensure Complete Utilization

IP.com Disclosure Number: IPCOM000239373D
Publication Date: 2014-Nov-03
Document File: 3 page(s) / 49K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system is disclosed for distributing Structured Query Language (SQL) statements among multiple accelerators to ensure complete utilization of the accelerators.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 51% of the total text.

Page 01 of 3

Distributing SQL Statements Among Multiple Accelerators To Ensure Complete Utilization

Some database systems perform extremely well on Online Transaction Processing (OLTP) workloads, but are very processor and resource intensive on analytic

workloads. Some database systems are analytic workload optimized, so that they perform well on analytic workloads but not on OLTP. Some in-memory databases perform well on both OLTP and analytic workloads. However, in such cases, the usage is limited to small data warehouses due to high cost of memory.

A hybrid workload optimized database system combines the strengths of both the OLTP optimized system and the analytic optimized system in a way that is transparent to a user. For the hybrid system, the analytic workload optimized database system (the "accelerator") is configured like an internal component, and an OLTP database system serves as the accelerator of the OLTP system. Analytic workloads are automatically routed to the accelerator. This integrated hybrid system performs extremely well on both OLTP and analytic workloads.

Disclosed is a method and system for distributing SQL statements among two or more active accelerators, providing high availability and scalability for a hybrid workload optimized database system. In accordance with the method and system, a database receives utilization information from all active accelerators and automatically routes the SQL statements to respective accelerators based on utilization and queue length information. A single workload can be scaled out beyond one accelerator. The

database ensures that the SQL statements qualify the criteria in order to be processed by the accelerator responsive to the database sending the SQL statements to the accelerator. The database identifies all the accelerators that are active and contains all the tables referenced by the SQL statements. Further, the database applies an accelerator selection algorithm to select the best accelerator among the qualified accelerators.

In one or more embodiments of the present invention, the database uses round robin to choose an appropriate accelerator based on two parameters that are returned through heartbeat from the accelerator, which is in order to provide fair,...