- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
What is a distributed database?
A distributed database is the one where all the storage devices are not attached to a common CPU (central processing unit). It may be distributed over a network of interconnected computers, or it may be stored in multiple computers located in the same physical location.
Distributed Database Management System
A distributed database management system (DDBMS) manages the database as in if it is stored in the same computer.
The DDBMS synchronizes all the data in a periodical manner and in situations when multiple users are accessing the same data and ensures that updation and deletion performed on the data at one location shall be automatically updated in the data stored elsewhere.
The users and administrators of the distributed system, with proper implementation, interact with the system as if the system is centralized.
This transparency allows the functionality desired for a structured system without specially programmed requirements allowing for any number of local or remote tables to be accessed at a given time across the network.
The different types of transparency of DDBMS are data distribution transparency, heterogeneity transparency, transaction transparency, and performance transparency.
Data distribution transparency, requires that the user of the database must not know how the data is fragmented, know the location of data, or be aware of whether multiple copies of the data exist.
In heterogeneity transparency, the user shall not be aware of the fact that they are using a different DBMS if they access data from a remote site. The user is able to use the same language that they would normally use at a regular access point and the DDBMS should handle query language translation if needed.
In transaction transparency, the DDBMS guarantees that concurrent transactions do not interfere and that it must also handle database recovery.
Performance transparency mandates the DDBMS that has a comparable level of performance to a centralized DBMS. Query optimizers are used to speed up response time.
The advantages of distributed database management system over centralized system are explained below −
It shows organizational structure.
Ability to share is increased.
Availability is improved.
Performance is increased.
Workstations are located nearest to the greatest demand site so that migration cost is reduced.
Data Access for users is faster.
Reliability is improved.
Here, data is processed at several different sites. So, faster data processing is possible.
In DBMS local sites are smaller and closer to customers therefore it improves the communication.
Operating cost is reduced.
Easy-to-use graphical user interface (GUI) which imparts user friendly interface.
Less chances of single-point failure because data and workload are distributed among other workstations.
The end user here is able to access any available copy of data.
- Related Articles
- Distributed database
- Distributed Database Management System
- Explain parallel and distributed database management system
- What is a distributed Operating System?
- MOSS Concurrency Control Protocol (Distributed Locking in Database)
- What is a Distributed File System (DFS)?
- What is a Distributed Component Object Model (DCOM)?
- What is Distributed memory MIMD Architecture?
- What is a database(dbms)?
- What is a multimedia database?
- What is a multimedia database (DBMS)?
- What is a time-series database?
- What is Distributed-Memory Multicomputer in Computer Architecture?
- What is a database and what are the advantages of using MySQL database?
- What is Database Marketing?