System and method of fetching data from an external program
OwnerRavishankar Narayanan Nairinventor
Life of this patent
Estimating the term…
Abstract
A system and method for fetching data using an SQL query from the execution of an external code that may be in any language and executed in any environment. The system includes a query engine that can receive a query from a SQL interface and parses the query to the desired format. The system also includes a protocol server that can trigger a code executor to execute an external code based on the query and transmits the data returned by the external code to the query engine. The query engine can process the data to an SQL understandable format and present the processed data on the SQL interface.
Claims13
A computer-implemented method for fetching data from an external source in response to an SQL query, the method comprising the steps of:
- receiving, by a query engine, from an SQL interface, a query having one or more unique identifiers, the one or more unique identifiers refers to one or more external codes;
- parsing, by the query engine, the query to a desired format;
- receiving, by a protocol server, from the query engine, the parsed query;
- triggering, by the protocol server, a code executor which executes at least one of the one or more external codes to obtain data in a first format;
- transmitting, in near real-time, by the protocol server, the data in the first format to the query engine;
- and
- processing, by the query engine, the data in the first format to a data in the second format, wherein the data in the first format is incompatible with the SQL interface and the data in the second format is compatible with the SQL interface.
Dependencies are inferred from the claim text.