Heterogeneous distributed database management : RIM-Oracle interface

This thesis develops a database interface between two relational database management systems such that they can be viewed as a heterogeneous distributed database management system. The RIM-Oracle interface system allows a user to transparently access the Oracle DBMS through the RIM DBMS, where the two DBMS are located in different computers connected by a computer network. The RIM-Oracle interface system allows a user to setup a data dictionary with information about existing relations stored in RIM and Oracle, and then perform RIM database retrieval and relational algebra queries on the relations. An interface program is build on top of each DBMS, and the two programs communicate over the network to perform their tasks. The host DBMS, RIM, is independent of the remote DBMS, Oracle, whereas the remote DBMS is dependent on the host DBMS, although the dependence is limited. Since the host DBMS is independent of the remote DBMS, the interface system can be extended to allow queries involving other DBMSs, located in other nodes of the network, using the methods developed in this thesis.