Proxying open database connectivity (odbc) calls
AssigneeInternational Business Machines Corporation
InventorsHenrique Andrade, Bugra Gedik, Martin J. Hirzel, Robert J. Soule, Huayong Wang, Kun-Lung Wu, Qiong Zou
Life of this patent
Estimating the term…
Abstract
An Open Database Connectivity (ODBC) proxy infrastructure to transparently route incoming queries to one or more selected query engines. The ODBC proxy receives a query from an application, and determines based on the characteristics of the query and the capabilities of the query engines which one or more query engines are to perform the query. The proxy then routes the query to the one or more query engines, which perform the query. The results are then returned to the proxy, which provides the results to the application.
Claims21
A method of proxying one or more Open Database Connectivity (ODBC) calls from an application to one or more query engines of a plurality of query engines, said method comprising:
- receiving from the application at an ODBC proxy executing on a processor an ODBC call, the ODBC call including a query;
- determining by the ODBC proxy which one or more query engines of the plurality of query engines should be used to satisfy the query, the determining being based on one or more characteristics of the query and on one or more capabilities of the plurality of query engines to compute query results;
- routing the query to one or more selected query engines based on the determining;
- receiving by the ODBC proxy results from the one or more selected query engines;
- and
- returning the results received from the one or more selected query engines to the application.
A system for proxying one or more Open Database Connectivity (ODBC) calls from an application to one or more query engines of a plurality of query engines, said system comprising:
- a processor executing an ODBC proxy, the ODBC proxy configured to:
- receive from the application an ODBC call, the ODBC call including a query;
- determine which one or more query engines of the plurality of query engines should be used to satisfy the query, the determining being based on one or more characteristics of the query and on one or more capabilities of the plurality of query engines to compute query results;
- route the query to one or more selected query engines based on the determining;
- receive results from the one or more selected query engines;
- and
- return the results received from the one or more selected query engines to the application.
A computer program product for proxying one or more Open Database Connectivity (ODBC) calls from an application to one or more query engines of a plurality of query engines, the computer program product comprising:
- a computer readable storage medium readable by a processing circuit and storing instructions for execution by the processing circuit for performing a method comprising:
- receiving from the application at an ODBC proxy an ODBC call, the ODBC call including a query;
- determining by the ODBC proxy which one or more query engines of the plurality of query engines should be used to satisfy the query, the determining being based on one or more characteristics of the query and on one or more capabilities of the plurality of query engines to compute query results;
- routing the query to one or more selected query engines based on the determining;
- receiving by the ODBC proxy results from the one or more selected query engines;
- and
- returning the results received from the one or more selected query engines to the application.
Dependencies are inferred from the claim text.