Describe different database management systems (Parallel, distribution)

Distributed database systems spread data across multiple locations connected via a network. Each location operates independently while sharing information with other sites to ensure data consistency across the entire system. This architecture provides high availability, fault tolerance, and improved access speed for geographically dispersed users.

Key Characteristics

• Data Distribution: Data is stored across multiple physical locations
• Network Connectivity: Locations are connected through communication networks
• Local Autonomy: Each site can operate independently
• Global Coordination: All sites work together to maintain data consistency

How It Works

In a distributed database, data is partitioned and stored on different servers at various locations. When a user at one location requests data, the system determines where the data resides and retrieves it, possibly gathering pieces from multiple locations. The DBMS ensures that updates made at any location are automatically propagated to all other relevant locations, maintaining data consistency throughout the system.

Real-World Example

The National Identification Authority (NIDA) in Tanzania uses a distributed database to manage National ID data from different locations across the country. If a citizen updates their information at a local NIDA office in Mbeya, the changes are immediately synchronized with the central system, making the updated information available for verification at any office in Dar es Salaam, Arusha, or elsewhere in Tanzania.

Benefits

• Scalability: Both systems can grow by adding more processors or locations
• Performance: Faster query processing through parallel or distributed execution
• Reliability: Distributed systems provide redundancy; if one site fails, others continue operating
• Local Autonomy: Distributed systems allow local control over data

Challenges

• Complexity: More difficult to design, implement, and manage
• Data Consistency: Ensuring all copies of data remain synchronized
• Network Dependency: Distributed systems rely heavily on network performance
• Security: More entry points require enhanced security measures

In Tanzania, parallel and distributed database systems are essential for mobile banking services like M-Pesa. When thousands of customers transfer money or check balances simultaneously, parallel processing ensures fast transaction handling. Additionally, when a customer in Dar es Salaam performs a transaction, distributed databases ensure the data is accessible at regional servers across the country, allowing real-time updates and preventing service interruption even during network issues.