Systems and methods for a high speed query infrastructure

摘要

In an analytics system, an analyst can analyze data by submitting queries, e.g., through an interface to a database. The analytics system can implement multiple query systems that are each configured to query the database. Query systems can be optimized for handling particular types of queries or for querying particular data. As such, some query systems can process certain queries more quickly and/or more efficiently than other query systems. To take advantage of this, when a query is received, query classification rules can be applied to the query. Based on the query classification, a query system can be selected to process the query, and the query can be sent to the selected query system for processing.

主权项

1. A computer implemented method comprising:
receiving a query at an interface to a database; applying one or more query classification rules to the query to determine a query classification; selecting a query system from a plurality of available query systems based on the query classification, wherein each of the available query systems is configured to process queries against the database in a different manner; wherein the different manner comprises at least one of a) different database data sources that each of the available query systems is optimized to process queries against, b) different numbers of database data sources that each of the available query systems is optimized to process queries against, or c) different query operations that each of the available query systems is optimized to process; wherein the query classification reflects at least one of a) a database data source the query is to be executed against, b) a number of database data sources the query is to be executed against, or c) an operation of the query to be performed on a database data source when the query is executed; wherein the different manner of the selected query system for processing queries against the database, relative to the different manners of the other query systems of the plurality of query systems for processing queries against the database, is optimized to process queries having the query classification according to the one or more query classification rules; and sending the query to the selected query system for processing.