Answer to Question #185652 in Databases | SQL | Oracle | MS Access for Garima

Question

Differentiate Homogenous Databases with Heterogenous databases with the help of a case study.

Answer 1

Homogeneous database:

In this kind of database, we use the similar software or the sites use the identical software from the same vendor. In this, each site is aware of all other and it will be accessed thorough the single interface.

Heterogeneous databases:

It is a distributed database system, which is an automated system for the integration of heterogeneous disparate database, which represents a user with single, and unified query interface.

It have at least one different vendors by using the different paradigms.