CST(44)-The Distributed Database Model

Standard off-the-shelf commercial distributed database packages will provide, when they fully blossom, transparent access to data on a netwo...

Standard off-the-shelf commercial distributed database packages will provide, when they fully blossom, transparent access to data on a network. The distributed database keeps track of the location of data on the network, and it will route your requests to the right database nodes, making their location transparent. To be fully distributed, a database server must support multisite updates using a transactional two-phase commit discipline. It should allow you to join data from tables that reside on several machines. It should also automatically update data in tables that reside on several machines.

Distributed databases make it easy to write distributed applications without having to first decompose your applications. With true distributed databases, the location of the data is completely transparent to the application. The chief advantage of distributed databases is that they allow access to remote data transparently while keeping most of the data local to the applications that actually use it.

  •  They currently do not work in heterogeneous database environments. As a result, you’re locked into a single vendor solution.
  •  They poorly encapsulate data and services. You cannot change a local database table if other sites are using it.
  •  They require too many low-level message exchanges to get work done. Distributed databases exchange messages at the SQL level.
  •  They are very slow over long wide-area networks. Two-phase commits are very expensive in terms of messages sent, and it is difficult to join tables located on different computers and achieve good performance.

Best Online Tutorials | Source codes | Programming Languages: CST(44)-The Distributed Database Model
CST(44)-The Distributed Database Model
Best Online Tutorials | Source codes | Programming Languages
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content