https://drive.google.com/file/d/10NcaXDH1vd1fnmOI3bJ-q6oufeugwJQK/view?usp=sharing
The document introduces and contrasts Centralized Databases (CDBs) with Distributed Databases (DDBs). A CDB is stored, located, and maintained at a single location, offering easier access and lower cost, but it is vulnerable to complete system failure and high data traffic.
A DDB, on the other hand, consists of multiple interconnected databases spread across different physical locations, which offers advantages like easier expansion, better reliability, improved response time, and lower communication costs. The document details various advantages of DDBs, including the management of data with different levels of transparency (network, replication, and fragmentation) and improved performance. It also covers the disadvantages of DDBs, such as complexity, cost, and difficulties in maintaining integrity and security. The architectures of Distributed Database Management Systems (DDBMS) are explored, including client-server, collaborating server, and middleware architectures, as well as peer-to-peer and Multi-DBMS models. Key design strategies for DDBMS, such as data replication (full, partial, no replication) and data fragmentation (horizontal, vertical, hybrid), are also discussed.
Five key topics covered in the document are:
A DDB, on the other hand, consists of multiple interconnected databases spread across different physical locations, which offers advantages like easier expansion, better reliability, improved response time, and lower communication costs. The document details various advantages of DDBs, including the management of data with different levels of transparency (network, replication, and fragmentation) and improved performance. It also covers the disadvantages of DDBs, such as complexity, cost, and difficulties in maintaining integrity and security. The architectures of Distributed Database Management Systems (DDBMS) are explored, including client-server, collaborating server, and middleware architectures, as well as peer-to-peer and Multi-DBMS models. Key design strategies for DDBMS, such as data replication (full, partial, no replication) and data fragmentation (horizontal, vertical, hybrid), are also discussed.
Five key topics covered in the document are:
- Centralized Database: A database stored, located, and maintained at a single location.
- Distributed Database: A database that consists of multiple interconnected databases spread across different physical locations.
- Fragmentation: The process of dividing the database into smaller multiple parts called fragments, which may be stored at different locations.
- Data Replication: The process of copying data at multiple locations to improve the availability of data.
- Distributed Database Management System (DDBMS): A centralized software system that manages a distributed database as if it were all stored in a single location.
Comments