Distributed database system of the database management system

dbms

1. TAKSHASHILA UNIVERSITY SCHOOL OF COMPUTER SCIENCE DISTRIBUTED DATABASE SYSTEM SUBMITTED BY: SUBMITTED TO: R.ABIGAIL KALYANI MRS.R.SARANYA(MCA,M.PHIL,B.ED…,) S.ABINESH ASSISTANT PROFESSOR MCA(DS)-YEAR 1 TAKSHASHILA UNIVERSITY TAKSHASHILA UNIVERSITY

2. AGENDA

3. INTRODUCTION A DISTRIBUTED DATABASE IS A DATABASE THAT CONSIST OF DATA STORED STORED AT MULTIPLE PHYSICAL LOCATIONS. EVERY SINGLE DATABASE STORED IN ONE NETWORK. USER CAN ACCESS FROM ANYWHERE.

4. IMPORTANCE:

5. TYPES: HOMOGENEOUS : SAME STRUCTURE AND DBMS ACROSS ALL NODES. EASIER MANAGEMENT AND UNIFORMITY. HETEROGENEOUS : DIFFERENT DBMS, STRUCTURES OR MODELS.ALLOWS INTEGRATION OF DIVERSE SYSTEMS BUT REQUIRES MORE COMPLEX MANAGEMENT.

6. ARCHITECTURE MODELS: CLIENT SERVER ARCHITECTURE: CLIENT SEND REQUEST TO A CENTRALIZED SERVER , WHICH PROCESSES AND RESPONDS. PEER-TO-PEER: EACH PARTICIPANT NODE ACT AS BOTH CLIENT AND SERVER , SHARING RESOURCES EQUALLY.

7. KEY COMPONENTS :

8. Data distribution techniques: HORIZONTAL PARTITIONING: ROWS OF A DATASET ARE DISTRIBUTED ACROSS NODES. VERTICAL PARTITIONING:DIFFERENT COLUMNS ARE STORED IN DIFFERENT NODES. HYBRID PARTITIONING: A COMBINATION OF THE TWO METHODS ABOVE FOR OPTIMIZED PERFORMANCE.

9. CHALLENGES: NETWORK LATENCY: KEEPING DATA SYNCHRONIZED CAN BE COMPLEX. NETWORK CONSISTENCY: KEEPING DATA SYNCHRONIZED CAN BE COMPLEX. INCREASED COMPLEXITY: MORE COMPONENTS CAN LEAD TO MANAGEMENT AND MAINTAINANCE CHALLENGES.

10. CONCLUSION: DISTRIBUTED DATABASE ARCHITECTURE ENABLES EFFICIENT DATA MANAGEMENT ACROSS MULTIPLE LOCATIONS , OFFERING BENEFITS SUCH AS SCALABILITY , BUT IT ALSO INVOLVES CHALLENGES THAT REQUIRE CAREFUL PLANNING AND EXECUTION.