DDBMS




                       
Distributed Database:-

Distributed database  is a database  in which storage device are not all attach to a common CPU it may be stored in multiple computer located in the same physical location Or may be dispersed over a network of interconnected computer.


Distributed Database Management System: -

A centralized, distributed database management system(DDBMS) manages the database as if it were all stored on the same computer.

The DDBMS synchronize all the data periodically and in case where multiple user must access the same data insures that update and delete performed on the data at one location will be automatically reflected in the data stored elsewhere.

The user and administrators of a distributed, system,Should with proper implementations interact with the system as if the system was centralized.

This transparency allows for the functionality desired in such a structured system without special programming requirement, allowing for any number local and/or remote table to be accessed at a given time across the network.


Architecture of DDBMS:-
In 19 Centuries-
 






In 20th Centuries-




 

 


                   








In 21th Centuries-







       



Types of Distributed Database design:-

Some distributed database designers are given like this

1-non-partitioned non-Replicated
2-Partitioned non-replicated
3-non-partitioned, replicated
4-Partitioned, replicated



DDBMS Advantage and Disadvantage:-

Distributed database management system delivers  several advantages over traditional systems.That being said that they are subject to some problems.



Advantage Of DDBMS:-

1-reflect organization structure
2-improve share ability,Reliability and performance

3-data have located nearest the greatest demand site and are dispersed to match business requirements

4-faster data access because the user only works with a locally subject of the data

5-faster data processing because the data is processed at several different sites.

6-improve communication because local sites are similar and closer to the customer
7-user friendly interface equipped with an easy-to -use GUI

Disadvantage of DDBMS:-

1-increase cost and integrity control more difficult ,lack of standards

2-database design more complex,Complexity of management and
Control,applications must recognize data location and they must  be able to stitch together data from various sites

3-technologically difficult-data integrity,transaction management,concurrency control,security,query optimization are all issues that must addressed

4-security lapses have increased instances when data are  in multiple locations.
5-increase cost due to higher complexity of training






Comments

  1. Good One! Would love to see more and more in future. :)

    ReplyDelete

Post a Comment

Popular posts from this blog

Data Binding in asp.net

The Psychology of Money (Vitamin "M")

JQuery