Home BCA/BTech JEE RAS RSCIT Blogs
Switch Language हिन्दी
BCA / B.Tech 13 min read

Distributed Database System

Quick Summary & Key Takeaways

  • • Subject Focus: DBMS Notes in English (BCA / B.Tech Syllabus)
  • • Core Topic: Distributed Database System - General Topics
  • • Overview: What is a Distributed Database in DBMS? A distributed database is a database where data is physically stored across multiple computers in different loc...
  • • Key Concepts: Distributed database system, Advantages transparency Hindi, Query processing distributed,

What is a Distributed Database in DBMS?

A distributed database is a database where data is physically stored across multiple computers in different locations. While the data is spread out, it is logically managed as a single database. The different nodes or servers are connected via a network. This type of system is capable of managing large volumes of data and providing fast access from various locations. The primary goal is to increase data availability, reliability, and distribute processing across a network.

Types of Distributed Databases:
  • Homogeneous: All sites use identical DBMS software and hardware. They are easier to design and manage because the systems are uniform.
  • Heterogeneous: Different sites can use different DBMS software, hardware, and data models. This provides more flexibility but makes management and query processing more complex.

Data Distribution Strategies (Fragmentation):
  • Horizontal Fragmentation: The table is split by rows. Each fragment has a subset of the rows and is stored on a different site. This is useful when different locations need access to different sets of records (e.g., storing customer data for a specific region on a local server).
  • Vertical Fragmentation: The table is split by columns. Each fragment has a subset of the columns and is stored on a different site. This is useful when different applications need access to different attributes of a record. The primary key is usually repeated in all fragments to allow for reconstruction of the original table.
  • Hybrid Fragmentation: A combination of horizontal and vertical fragmentation. The table is first divided horizontally, and then each of those fragments is divided vertically.

Frequently Asked Questions (FAQs)

What is a Distributed Database in DBMS?.
Understanding Distributed Database System is fundamental to mastering DBMS Notes in English. It covers crucial concepts, solved problems, and revision points essential for academic and entrance exam success.
You can read free solved examples, detailed explanations, and key formulas for Distributed Database System directly on the NotesMedia website or by downloading the NotesMedia App.

In this Chapter

Distributed Database System
What is DBMS in English
What is a Database in English
Advantages and Disadvantages of DBMS in English
Data Independence in English – What is Data Independence?
BCA || DBMS(Database Management System) 2025 (Supplementary) Paper || MDSU Exam Paper
What is an Entity in DBMS?
Database Languages
What is an Entity Set?
Entity-Relationship (ER) Model
Data Models & Their Types
JOINs and Their Types
Tuples and Their Types
What is a Database Instance?
What is a Domain in DBMS?
Database Interfaces and Their Types
Data Abstraction in DBMS
Data Integrity in DBMS
What is a Database Schema?
Database Constraints
Keys in DBMS and Their Types
What is a Data Dictionary?
What is a Relationship Set?
What is a Distributed File System?
Difference Between DBMS & Filesystem
DBMS Security
Relational Algebra
Database Recovery
Inference Rules
Dependencies and Their Types
File Organization
Normalization
BCA | DBMS 2022 Paper | MDSU Exam Paper