A homogenous distributed database system is a network of two or more Oracle Databases that reside on one or more machines. ... For example, a single query from a Manufacturing client on local database mfg can retrieve joined data from the products table on the local database and the dept table on the remote hq database.

What is the heterogeneous distributed database?

Heterogeneous Database

In a heterogeneous distributed database, different sites have different operating systems, DBMS products and data models. Different sites use dissimilar schemas and software. The system may be composed of a variety of DBMSs like relational, network, hierarchical or object oriented.

What is homogeneous and heterogeneous distributed databases?

Homogeneous and Heterogeneous databases are the two main classifications of DDBMS. In Homogenous distributed database system, the data is distributed but all servers run the same Database Management System (DBMS) software. In Heterogeneous distributed databases dissimilar sites run under the control of different DBMSs.