The sites use identical DBMS or DBMS from the same vendor. • Each s. In a heterogeneous distributed database, different sites have different. In a heterogeneous distributed database, different sites have different operating systems, DBMS products and data models. Its properties are −. Types of Distributed Database System Homogeneous Heterogeneous DDBMS Homogenous Heterogeneous; 5. Homogenous Distributed.

Author: Tygokinos Mauran
Country: Mali
Language: English (Spanish)
Genre: Relationship
Published (Last): 3 February 2015
Pages: 297
PDF File Size: 10.3 Mb
ePub File Size: 16.52 Mb
ISBN: 142-4-51693-493-8
Downloads: 91984
Price: Free* [*Free Regsitration Required]
Uploader: Goltirg

Heterogeneous database system – Wikipedia

In a homogeneous system, all sites use the same DBMS product. In a heterogeneous system, sites may run different DBMS products, which need not be based on the same underlying data model, and so the system may be composed of relational, network, hierarchical and object-oriented DBMSs. Homogeneous systems are much easier to design and manage.

This approach provides incremental growth, making the addition of a new site to the DDBMS easy, and allows increased performance by exploiting the parallel processing capability of multiple heterogeneoous.


Heterogeneous system usually result when individual sites have implemented their own database and integration is considered at a later stage. In a heterogeneous system, translations are required to allow communication between different DBMSs. The system then has the task of locating the data and performing any necessary translation.

Data may be required from another site that may have: If the DBMS products are different, the translation is complicated, involving the mapping of the data structure in one data model to the equivalent data structures in another data model. For example, relations in the relational data model are mapped to records and sets in the network model. If both the hardware and software are different, then these two types of translation are required.

This makes the processing extremely complex. The typical solution use by some relational systems that are part of a heterogeneous DDBMS is to use gateways, which convert the language and model of each different DBMS into the language and model of the relational system. Dinesh authors the hugely popular Computer Notes blog.


Where he writes how-to guides around Computer fundamentalcomputer software, Computer programming, and web apps.

For any type of query or something that you think is missing, please feel free to Contact us. Related Articles on Database.

Distributed DBMS – Database Environments

What is Data Warehouse? What is Data Replication? What is Distributed Database? Characteristics of Distributed Database Management System.

What is Object-Relational Database Systems? What is Data Mining?

Compare between Data Mining and Data Warehousing. What are the Causes for Database Failure?

What are the Homogeneous and Heterogeneous Distributed DBMS

How we are Protecting the Data within the Database. What is Flat-File Database? Mail Me At Computer Notes.