Distributed Database Systems

  1. Distributed Database Architecture
    1. Architectural Models
      1. Client-Server Architecture
        1. Two-Tier Architecture
          1. Three-Tier Architecture
            1. Multi-Tier Architecture
            2. Peer-to-Peer Architecture
              1. Fully Connected Networks
                1. Overlay Networks
                  1. Structured P2P Systems
                    1. Unstructured P2P Systems
                    2. Multi-Database Systems
                      1. Loosely Coupled Systems
                        1. Tightly Coupled Systems
                        2. Cloud-Based Architectures
                        3. System Classification
                          1. Homogeneous Systems
                            1. Uniform DBMS Software
                              1. Schema Integration
                                1. Advantages and Limitations
                                2. Heterogeneous Systems
                                  1. Different DBMS Software
                                    1. Schema Translation
                                      1. Data Model Differences
                                        1. Integration Challenges
                                      2. Schemas in a DDBMS
                                        1. Global Schema
                                          1. Definition and Role
                                            1. Schema Integration
                                              1. Global Conceptual Schema
                                              2. Fragmentation Schema
                                                1. Fragment Definitions
                                                  1. Mapping to Global Schema
                                                  2. Allocation Schema
                                                    1. Data Placement
                                                      1. Site Assignment
                                                      2. Local Schemas
                                                        1. Local Database Definitions
                                                          1. Local Autonomy
                                                            1. Local Conceptual Schema
                                                          2. Levels of Transparency
                                                            1. Distribution Transparency
                                                              1. Location Transparency
                                                                1. Fragmentation Transparency
                                                                  1. Replication Transparency
                                                                  2. Transaction Transparency
                                                                    1. Global Transactions
                                                                      1. Local Transactions
                                                                      2. Performance Transparency
                                                                        1. Load Balancing
                                                                          1. Response Time Hiding
                                                                          2. DBMS Transparency
                                                                            1. Heterogeneity Hiding
                                                                              1. Interface Uniformity
                                                                              2. Failure Transparency