초록 ▼

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 underlyin

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.

대표청구항 ▼

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 proto

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.