Exam 12: Distributed Database Management Systems

____ transparency ensures that the system will continue to operate in the event of a node failure.

In a DDBMS,____________________ control is used to manage simultaneous data access and ensure data consistency across database fragments.

One of the advantages of a DDBMS is that the data is located near the site with the least demand.

A user-friendly ____________________ is one advantage of a DDBMS.

A fully distributed DBMS must perform all the functions of a centralized DBMS,and it must handle all necessary functions imposed by the distribution of data and processing.

A remote transaction,composed of several requests,may access data at multiple sites.

Both distributed processing and distributed databases require a network to connect all components.

Current DDBMSs are subject to some problems,such as the complexity of management and control.

A distributed database system requires functional characteristics that can be grouped and described as transparency features.

A distributed database is composed of several parts known as database ____.

What is transaction transparency? What are some of the basic concepts that you should know to understand how transactions are managed in a DDBMS?

The ____________________ fragment condition indicates that each row is unique,regardless of the fragment in which it is located.

In a DDBMS,____________________ occurs to determine the data location of local and remote fragments.

Describe performance transparency and heterogeneity transparency.

____ is a disadvantage of a DDBMS.

The database description,known as the distributed ____________________ schema,is the common database schema used by local TPs to translate user requests into subqueries (remote requests)that will be processed by different DPs.

____ query optimization means that the DDBMS finds the most cost-effective access path without user intervention.

____ transparency allows a transaction to update data at several network sites.

One of the advantages of a DDBMS is less danger of a single-____________________ failure.

____ is the highest level of transparency.The end user or programmer does not need to know that a database is partitioned.