Distributed Database System
It represents multiple interconnected databases
Spread out across several sites connected by a network appear as a single database to the users
Distributed databases utilize multiple nodes
They scale horizontally and develop a distributed system
More nodes in the system provide more computing power, offer greater availability, and resolve the single point of failure issue.
Distributed Database Features
Location independency - Data is physically stored at multiple sites and managed by an independent DDBMS.
Seamless integration - Databases in a collection usually represent a single logical database, and they are interconnected.
Network linking - All databases in a collection are linked by a network and communicate with each other.
Transaction processing and management - Distributed databases incorporate transaction processing, an atomic process that is either entirely executed or not at all which is a program including a collection of one or more database operations.
With the increase in traffic from the users, we can easily scale our database by adding more nodes to the system.
Since these nodes are commodity hardware, they are relatively cheaper than adding more resources to each of the nodes individually.
Horizontal scaling is cheaper than vertical scaling.
This horizontal scaling makes replication of data cheaper and easier. This means that now the system can easily handle more user traffic by appropriately distributing the traffic amongst the replicated nodes that.
Types of Distributed Databases
Homogenous
Network of identical databases stored on multiple sites with same operating system, DDBMS, and data structure, making them easily manageable.
It allows users to access data from each of the databases seamlessly.
Heterogeneous
Different sites have different operating systems, DBMS products and data models.
Diverse sites use dissimilar schemas and software.
The system may be composed of a variety of DBMSs like relational, network, hierarchical or object oriented.
Query processing is complex due to different schemas.
Transaction processing is complex due to dissimilar software.
Distributed Database Storage Management
Distributed database storage is managed in two ways:
Replication
Fragmentation
Replication
The systems store copies of data on different sites.
If an entire database is available on multiple sites, it is a fully redundant database.
Advantage of database replication is increases data availability on different sites and allows for parallel query requests to be processed.
However, replication means that data requires constant updates and synchronization with other sites to maintain an exact database copy.
Any changes made on one site must be recorded on other sites, or else inconsistencies occur.
Constant updates cause a lot of server overhead and complicate concurrency control.
Fragmentation
Split into smaller parts
Each of the fragments is stored on a different site, where it is required.
Prerequisite for fragmentation is to make sure that the fragments can later be reconstructed into the original relation without losing data.
Advantage of fragmentation is that there are no data copies, which prevents data inconsistency.
Two types of fragmentation
Horizontal fragmentation - The relation schema is fragmented into groups of rows, and each group (tuple) is assigned to one fragment.
Vertical fragmentation
The relation schema is fragmented into smaller schemas, and each fragment contains a common candidate key to guarantee a lossless join.
Fragment 1
customer_id | Name | Area | Sex
1 | Bob | London | Male
2 | Mike | Manchester | Male
3 | Ruby | London |Female
Fragment 2
customer_id | Payment Type
1 | Credit card
2 | Cash
3 | Cash
Note: In some cases, a mix of fragmentation and replication is possible.
Distributed Database Advantages
Modular Development: a system can be expanded to new locations by adding new servers and data to the existing setup and connecting them to the distributed system without interruption. This type of expansion causes no interruptions.
Reliability: offer greater reliability in contrast to centralized databases. In a distributed database, the system functions even when failures occur, only delivering reduced performance until the issue is resolved.
Lower Communication Cost: Locally storing data reduces communication costs for data manipulation in distributed databases.
Better Response: Efficient data distribution in a distributed database system provides a faster response when user requests are met locally.
Hire expert to get help in distributed database assignment, project and homework help with an reasonable price.
We are group of top rated experts and professionals that can help you do complete your projects which is related to distributed database system as per your given requirement instructions.
Order Now and get 10 percent discount on your first order.
For more details:
Contact us: +91 8267813869
Email: realcode4you@gmail.com
Visit here: www.realcode4you.com
Comments