Advanced Database Management System - Tutorials and Notes: What is homogeneous distributed DBMS

Thursday, 4 May 2017

What is homogeneous distributed DBMS

What is homogeneous distributed DBMS? Homogeneous distributed database example, why homogeneous distributed DBMS


Homogeneous Distributed DBMS


Distributed database is logically interrelated databases that are spread over multiple sites (servers usually at different geographic locations). Distributed DBMS is the software that handles or controls distributed databases efficiently.
In distributed database, each site has the following properties;

  • It runs on local DBMS software.
  • The database stored locally has a schema (structure).
  • A degree of autonomy on the data those are stored locally and partial autonomy on other sites etc.

A distributed DBMS is a homogeneous DBMS if one or few or all of the following are true;

  • All sites use same/identical DBMS software. 
    • For example, all sites in that distributed database network may use Oracle as the DBMS.
  • Databases that are stored locally at each server will have same structure. 
    • For example, a student table with the schema STUDENT(Regno, Name, Phone) will be stored at all sites with the same schema.
  • If the DBMS software, the schema, and the application software that uses the data are same at all sites, then every site know about other sites well (at least partially)

****************










No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents