Please enable JavaScript.
Coggle requires JavaScript to display documents.
Parallel Databases and Distributed Databases - Coggle Diagram
Parallel Databases and Distributed Databases
Parallel Database Architectures
Multiprocessor Architectures
SMP (Symmetric Multiprocessor) Architecture
NUMA (Non-Uniform Memory Access) Architecture
MPP (Massively Parallel Processor) Architecture
Cluster Architectures
Database Cluster Architecture
Storage Cluster Architecture
Parallel Database Design
Data Fragmentation
Horizontal Fragmentation
Vertical Fragmentation
Fragment Assignment to Nodes
Data Replication
Parallel Query Processing Algorithms
Query Partitioning Methods
Range Partitioning
Hash Partitioning
Parallel Join Algorithms
Multiway Join
Hash Join
Parallel Sorting Algorithms
Multiway Sort
Hash Sort
Concurrency Control in Parallel Databases
Locking Protocols
Timestamp Protocols
Wait-for Protocols
Homogeneous and Heterogeneous Databases
Definition and characteristics
Advantages and disadvantages
Distributed Data Storage
Data distribution techniques
Replication and fragmentation
Distributed hash table (DHT)
Distributed Transactions
Definition and characteristics
ACID properties
Commit Protocols
Two-phase commit protocol (2PC)
Three-phase commit protocol (3PC)
Optimistic commit protocol
Concurrency Control in Distributed Databases
Distributed locking
Timestamp ordering
Multi-version concurrency control (MVCC)
Availability
Definition and characteristics
Replication techniques
Fault-tolerant techniques
Distributed Query Processing
Query optimization and decomposition
Distributed query execution
Distributed query languages
Heterogeneous Distributed Databases
Definition and characteristics
Integration techniques
Cloud-Based Databases
Definition and characteristics
Cloud database models
Cloud database providers
Directory Systems
Definition and characteristics
Directory service protocols
Directory service implementations