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. Unknown29 April 2015 at 11:43

    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

Image
                                          Data binding Data binding   in the context of .Net,is the method by which controls on a user interface(UI) of   a client application are configured to fetch from,or update data into,a data source,such as a database or XML document. Prior to .NET,access to data binding models were limited to database.thus,many database management system(DBM) could   indirectly access the data source through their application programming interface (API) without any flexibility in controlling the data binding process. This problem is addressed in .NET by providing fine control of how the data bound and behavior f UI with windows form and ADO.NET classes in the framework. the development of web application is simplifying by providing data binding capa...
Read more

Difference Between Data Warehousing and Data Lake

Image
   Difference Between Data warehousing and Data Lake   The difference between the two most popular options for storing big data but according to the nature of data both have some important differences also so first understand it individually after that we will also know the differences.   Data Warehouse: - A  data warehouse is a repository for structured, filtered data that                                     has already been processed for a specific purpose .   Data Lake :- The data  lake is a vast pool of raw data, the purpose for which is not yet defined.  Difference:-   Data lakes store data from a wide variety of sources like IoT devices, real-time social media streams, users, and web application transactions. Sometimes this data is structured, but often, it’s quite messy because data is being ingested straight from the data source. Dat...
Read more

Operating system

Operating system If you have a computer then you have heard about OS .any desktop or laptop PC that you but normally comes pre-loaded with windows XP. Many corporate server use Linux or Unix OS, without OS a computer is useless we cannot   do perform any task. More recently, operating systems have started to pop up in smaller computers as well. If you like to tinker with electronic devices, you are probably pleased that operating systems can now be found on many of the devices we use every day, from cell phones to wireless access points.  The computers used in these little devices have gotten so powerful that they can now actually run an operating system and applications.  The computer in a typical modern cell phone is now more powerful than a desktop computer from 20 years ago, so this progression makes sense and is a natural development. In any device that has an operating system, there's usually a way to make changes to how the device works....
Read more