System and method for retrieving data from a database system
First Claim
1. A method for retrieving data from a database system by an external process, said external process issuing data queries in a first query language, said database system accepting and processing data requests in a second query language, which method comprises the steps of:
- a. providing an interface module operatively coupled to the external process and the database system, said interface module generating an equivalent data request in the second query language when receiving a data query in the first query language;
b. sending a data query in the first query language from the external process to the interface module;
c. generating in the interface module at least one data request in the second query language, said data request being equivalent to the data query sent by the external process;
d. sending the generated data request from the interface module to the database system for processing and data retrieval;
e. transferring the retrieved data from the database system to the interface module; and
f. returning the transferred data from the interface module to the external process, wherein the retrieval of data from the database system is carried out concurrently with the transfer of the retrieved data from the database system to the interface module.
4 Assignments
0 Petitions
Accused Products
Abstract
A fast and efficient system and method for retrieving data from a database system by a process external to the database system is provided, in which the database system accepts and processes data requests in a second query language in response to data queries issued in a first query language by the external process. The system comprises an interface module operatively coupled to the external process and the database system. Upon receiving a data query in the first query language from the external process, the interface module generates an equivalent data request in the second query language and sends the data request to the database system for processing and data retrieval. The interface module then transfers the retrieved data from the database system to the module and returns the 4data to the external process. The interface module operates as a plurality of independent co-operating processes handling at least in part concurrently various steps of the data query processing. In particular, data retrieval and transfer is carried out concurrently in the system by two separate processes.
93 Citations
26 Claims
-
1. A method for retrieving data from a database system by an external process, said external process issuing data queries in a first query language, said database system accepting and processing data requests in a second query language, which method comprises the steps of:
-
a. providing an interface module operatively coupled to the external process and the database system, said interface module generating an equivalent data request in the second query language when receiving a data query in the first query language;
b. sending a data query in the first query language from the external process to the interface module;
c. generating in the interface module at least one data request in the second query language, said data request being equivalent to the data query sent by the external process;
d. sending the generated data request from the interface module to the database system for processing and data retrieval;
e. transferring the retrieved data from the database system to the interface module; and
f. returning the transferred data from the interface module to the external process, wherein the retrieval of data from the database system is carried out concurrently with the transfer of the retrieved data from the database system to the interface module. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A system for retrieving data from a database system by an external process, said system comprising:
-
a. means for running the external process, said external process issuing data queries in a first query language;
b. means for hosting the database system, said database system accepting and processing data requests in a second query language;
c. means for running an interface module, said interface module operatively coupled to the external process and the database system, said interface module capable of;
i. generating an equivalent data request in the second query language when receiving from the external process a data query in the first query language;
ii. sending the generated data request to the database system for processing and data retrieval;
iii. transferring the retrieved data from the database system to the interface module; and
iv. returning the retrieved data to the external process, wherein the retrieval of data from the database system is carried out concurrently with the transfer of the retrieved data from the database system to the interface module. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
Specification