Apparatus and method for providing users with transparent integrated access to heterogeneous database management systems
First Claim
1. In a computer data network having a communications medium commonly connecting a plurality of local site databases containing data with a plurality of users each capable of generating of global data query for accessing and retrieving data from said databases in accord with a single global query protocol, a method for controlling and directing a transmission of the user generated global data query to individual ones of the plurality of databases and for receiving and integrating the requested data received from the databases into a single response and for transmitting the integrated single response to the requesting user, said method comprising the following steps:
- creating a smart data dictionary local site database profile containing data representing schema, data distribution, local site configuration and inter-site relationships of data among the local site databases in the network, for each local site database in the network;
communicating with said smart data dictionary local site database profile to retrieve data therefrom for decomposing the global data query into a local-site execution plan for retrieval of data from each local site database having data responsive to the global data query in accord with the data contained in said smart data dictionary local site database profile;
decomposing the global data query into a local-site execution plan for retrieval of data from each local site database having data responsive to the global data query in accord with the data contained in said smart data dictionary local site database profile;
transmitting that portion of said local-site execution plan to be executed to an appropriate said local site database for execution,receiving data from each local site database responsive to said local-site execution plan and creating a global response database containing such responsive data received from each local site database;
providing the user access to the global response database in accord with the single global query protocol.
2 Assignments
0 Petitions
Accused Products
Abstract
Disclosed is a federated architecture and system which are extensible and flexible for integrated access to heterogeneous DataBase Management Systems (DBMS) dispersed over a long haul network, allowing transparent access to a wide variety of DBMS while maintaining the local autonomy of the underlying DBMS. In addition the system can run on top of different hardware, operating systems, network communications, and DBMS. The system can include new target DBMS with minimum changes and is not limited to integrate relational DBMS, but also to integrate legacy DBMS such as hierarchial or network DBMS, spatial information or text retrieval systems.
-
Citations
22 Claims
-
1. In a computer data network having a communications medium commonly connecting a plurality of local site databases containing data with a plurality of users each capable of generating of global data query for accessing and retrieving data from said databases in accord with a single global query protocol, a method for controlling and directing a transmission of the user generated global data query to individual ones of the plurality of databases and for receiving and integrating the requested data received from the databases into a single response and for transmitting the integrated single response to the requesting user, said method comprising the following steps:
-
creating a smart data dictionary local site database profile containing data representing schema, data distribution, local site configuration and inter-site relationships of data among the local site databases in the network, for each local site database in the network; communicating with said smart data dictionary local site database profile to retrieve data therefrom for decomposing the global data query into a local-site execution plan for retrieval of data from each local site database having data responsive to the global data query in accord with the data contained in said smart data dictionary local site database profile; decomposing the global data query into a local-site execution plan for retrieval of data from each local site database having data responsive to the global data query in accord with the data contained in said smart data dictionary local site database profile; transmitting that portion of said local-site execution plan to be executed to an appropriate said local site database for execution, receiving data from each local site database responsive to said local-site execution plan and creating a global response database containing such responsive data received from each local site database; providing the user access to the global response database in accord with the single global query protocol. - View Dependent Claims (2, 3)
-
-
4. In a computer data network having a communications medium commonly connecting a plurality of databases containing data with a plurality of users each capable of generating a global data query for accessing and retrieving data from said databases in accord with a single query protocol, a globally integrated data retrieval controller architecture for controlling and directing a transmission of the user generated global data query to individual ones of the plurality of databases and for receiving and integrating the requested data received from the databases into a single response and for transmitting the integrated single response to the requesting user, said globally integrated data retrieval controller architecture comprising:
-
a smart data dictionary means containing a database of data representing schema, data distribution, local site configuration and inter-site relationships of data among the databases in the network, for each database in the network; a data information manager means communicating both with said smart data dictionary means to retrieve data therefrom, and with said user to receive said global data query therefrom and to transmit responsive data thereto, for decomposing the global data query into a local-site execution plan for retrieval of data from each database having data responsive to the global data query in accord with the data contained in said smart data dictionary means, and for transmitting that portion of said local-site execution plan to be executed to an appropriate said database for execution, and receiving data therefrom responsive to said local-site execution plan; a plurality of local information manager means, each communicating with said data information manager means and said smart data dictionary means, for controlling data flow to and from a specified database in the network in response to that portion of said local-site execution plan received from said data information manager means and for transmitting retrieved data responsive to that portion of said local-site execution plan to said data information manager means, each said local information manager means further adapted for generating, in accord with the data contained in said smart data dictionary means, a data retrieval request for execution by another local information manager means and for receiving data therefrom in response thereto, in order to complete that portion of said local-site execution plan received by it for execution. - View Dependent Claims (5, 6, 7, 8, 9, 10, 11)
-
-
12. In a computer data network having a communications medium commonly connecting a plurality of databases containing data with a plurality of users each capable of generating a global data query for accessing and retrieving data from said databases in accord with a single query protocol, a globally integrated data retrieval controller architecture for controlling and directing a transmission of the user generated global data query to individual ones of the plurality of databases and for receiving and integrating the requested data received from the databases into a single response and for transmitting the integrated single response to the requesting user, said globally integrated data retrieval controller architecture comprising:
-
a smart data dictionary means containing a database of data representing schema, data distribution, local site configuration and inter-site relationships of data among the databases in the network, for each database in the network; a data information manager means communicating both with said smart data dictionary means to retrieve data therefrom, and with said user to receive said global data query therefrom and to transmit responsive data thereto, for decomposing the global data query into a local-site execution plan for retrieval of data from each database having data responsive to the global data query in accord with the data contained in said smart data dictionary means, and for transmitting that portion of said local-site execution plan to be executed to an appropriate said database for execution, and receiving data therefrom responsive to said local-site execution plan, said data information manager means including syntactic and semantic parser means interfacing with said smart data dictionary means for retrieving data representing local schema information and the interrelationships among data, and for parsing and validating the syntax of the global data request using such data retrieved from said smart data dictionary means, said data information manager means further including optimizer means interfacing with said smart data dictionary means for retrieving data representing local schema information and the inter-relationships among data, and for minimizing the amount of data needed to be transferred among local site databases and for choosing an appropriate said local site database for processing each portion of the local-site execution plan, said data information manager means also including local-site execution plan control means interfacing with each of said local site databases to send each local site database that portion of said local-site execution plan necessary to extract responsive data from each said local site database; a plurality of local information manager means, each communicating with said data information manager means and said smart data dictionary means, for controlling data flow to and from a specified database in the network in response to that portion of said local-site execution plan received from said data information manager means and for transmitting retrieved data responsive to that portion of said local-site execution plan to said data information manager means, each said local information manager means further adapted for generating, in accord with the data contained in said smart data dictionary means, a data retrieval request for execution by another local information manager means and for receiving data therefrom in response thereto, in order to complete that portion of said local-site execution plan received by it for execution, at least one local information manager means controlling data flow to and from at least two local databases and adapted to decompose that portion of said local-site execution plan received from said data information manager means into a sub-local-site execution plan for retrieval of data responsive to that portion of said local-site execution plan received from said data information manager means from each of said controlled local databases, said local information manager means further includes local controller means for controlling the execution of that portion of the local-site execution plan sent by the data information manager means by coordinating all internal operations. - View Dependent Claims (13, 14)
-
-
15. A computer data network controlling and directing transmission of a user generated global data query to individual ones of a plurality of nodes and associated databases and for receiving and integrating the requested data received from the databases through the nodes into a single response and for transmitting the integrated single response to the requesting user, comprising:
-
a communication medium connecting the nodes with a plurality of users, each capable of generating a global data request for accessing and retrieving data from the databases through their associated nodes in accord with a single query protocol; a smart data dictionary node connected to the computer data network and controlling input/output access to a database of data representing schema, data distribution, local site configuration and inter-site relationships of data among the nodes and their associated databases in the network, for each node and associated database in the network; a data information manager controller communicating both with said smart data dictionary node to retrieve data therefrom, and with said user to receive said global data query therefrom and to transmit responsive data thereto, for decomposing the global data query into a local-site execution plan for retrieval of data from each database through its associated node, said database having data responsive to the global data query in accord with the data contained in said database associated with said smart data dictionary node, and for transmitting that portion of said local-site execution plan to be executed to an appropriate node and associated database for execution, and receiving data therefrom responsive to said local-site execution plan; a plurality of local information manager controllers, each communicating with said data information manager controller and said smart data dictionary node, for controlling data flow to and from a specified database in the network in response to that portion of said local-site execution plan received from said data information manager controller and for transmitting retrieved data responsive to that portion of said local-site execution plan to said data information manager controller, each said local information manager controller further adapted for generating, in accord with the data contained in said database associated with said smart data dictionary node, a data retrieval request for execution by another local information manager controller and for receiving data therefrom in response thereto, in order to complete that portion of said local-site execution plan received by it for execution. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22)
-
Specification