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.
|Published (Last):||23 July 2012|
|PDF File Size:||14.73 Mb|
|ePub File Size:||4.62 Mb|
|Price:||Free* [*Free Regsitration Required]|
In a homogeneous system, all sites use the same DBMS product.
Distributed DBMS – Database Environments
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 sites. Heterogeneous system usually result when individual sites have implemented their own database and integration heterogejeous 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 heterogeeneous 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 edbms 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.
Heterogeneous database system – Wikipedia
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.
Heterogeneous database system
What are the Causes for Database Failure? How we are Protecting the Data within the Database. What is Flat-File Database?
Mail Me At Computer Notes.