Lecture 9 & 10: Distributed Database Management Systems

Advantages: Improved performance, increased availability, and enhanced reliability. Disadvantages: Complexity, security risks, and potential data inconsistency.

The characteristics include distribution transparency, fragmentation, replication, and data allocation.

Components include local DBMS, global transaction manager, distributed transaction manager, and data communication.

<p>Distribution transparency refers to the ability of users and applications to access and manipulate data without being aware of its distribution across multiple locations.</p> Signup and view all the answers

<p>The types include horizontal, vertical, and mixed fragmentation.</p> Signup and view all the answers

<p>Replication involves creating and maintaining multiple copies of data at different locations to improve data availability and fault tolerance.</p> Signup and view all the answers

<p>DDBMS stands for distributed database management system. It treats the database as single logical data.</p> Signup and view all the answers

<p>Performance degradation, high maintenance cost, reliability problems, and data availability issues.</p> Signup and view all the answers

<p>Structured information needs were not efficiently met.</p> Signup and view all the answers

<p>The user issues a query without needing to know the location of the data being sought.</p> Signup and view all the answers

<p>DDBMS copes with technological advancement through the acceptance of the Internet as a business platform, the mobile wireless revolution, and the usage of applications.</p> Signup and view all the answers

<p>Performance degradation, high maintenance cost, reliability problems, data availability issues, and bottleneck at the site with the database.</p> Signup and view all the answers

<p>During the 1970s, corporations implemented centralized database management systems to meet their structured information needs. However, the structured information needs were not efficiently met by centralized systems, leading to the evolution of DDBMS.</p> Signup and view all the answers

<p>The main concept is to spread the data out among various cities on the distributed network, each with its own computer and data storage facilities, while still considering all distributed data as a single logical database.</p> Signup and view all the answers

<p>A distributed database (DDB) is a collection of multiple, logically interrelated databases distributed over a computer network. A distributed database management system (DDBMS) is the software that manages the DDB and provides an access mechanism that makes this distribution transparent to the users.</p> Signup and view all the answers

<p>Acceptance of Internet as a platform for business, mobile wireless revolution, and usage of applications.</p> Signup and view all the answers