SQL interface for services
AssigneeBEA Systems, Inc.
InventorNaveen Gupta
Life of this patent
Estimating the term…
Abstract
In accordance with embodiments of the present invention, there are provided mechanisms and methods for providing an SQL interface for a service. These mechanisms and methods for providing an SQL interface for a service make it possible for data from a plurality of services to be provided to a requester so that the data appears to the requestor as having been organized into a single virtual SQL table. This ability of embodiments to provide data from a plurality of services to a requestor so that the data appears to the requestor as having been organized into a single virtual SQL table enables an SQL application making the SQL query to interface with the at least one of a plurality of services to obtain information using SQL format.
Claims20
A method for providing an SQL interface for a service, the method comprising:
- receiving an SQL query;
- preparing a request to access at least one of a plurality of services based upon the SQL query, wherein the request is prepared in a format that a service is able to understand;
- accessing the at least one of a plurality of services using the request to obtain a result set;
- and
- preparing a virtual SQL table comprising data selected from the result set responsive to the SQL query.
A method for receiving data from a service via an SQL interface, comprising:
- sending an SQL query to a server;
- and
- receiving a result set from the server;
- wherein the server has prepared a portion of the result set data from at least one of a plurality of services so that the data appears to the requestor as having been organized into a single virtual SQL table.
A computer-readable medium carrying one or more sequences of instructions for providing an SQL interface for a service, which instructions, when executed by one or more processors, cause the one or more processors to carry out the steps of:
- receiving an SQL query;
- preparing a request to access at least one of a plurality of services based upon the SQL query, wherein the request is prepared in a format that a service is able to understand;
- accessing the at least one of a plurality of services using the request to obtain a result set;
- and
- preparing a virtual SQL table comprising data selected from the result set responsive to the SQL query.
An apparatus for providing an SQL interface for a service, the apparatus comprising:
- a processor;
- and
- one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of:
- receiving an SQL query;
- preparing a request to access at least one of a plurality of services based upon the SQL query, wherein the request is prepared in a format that a service is able to understand;
- accessing the at least one of a plurality of services using the request to obtain a result set;
- and
- preparing a virtual SQL table comprising data selected from the result set responsive to the SQL query.
Dependencies are inferred from the claim text.