Exam 12: Distributed Database Management Systems

The inherently complex distributed data environment increases the urgency for standard protocols governing transaction management.

The DO-UNDO-REDO protocol defines three types of operations.What are they?

The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.

____ transparency allows a distributed database to be treated as a single logical database.

Distributed processing does not require a distributed database,and a distributed database does not require distributed processing.

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

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

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

____ transparency allows the integration of several different local DBMSs under a common,or global,schema.

A DDBMS governs the storage and processing of logically related data over interconnected computer systems.

A(n)____ database stores each database fragment at a single site.

____________________ management ensures that data move from one consistent state to another,including synchronization of local and remote transactions.

____ transparency allows the system to perform as if it were a centralized database management system.

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

A transaction processor is the software component residing on each computer that stores and retrieves data located at the site.

The ____ processor is the software component found in each computer that requests data.It receives and processes the application's data requests.

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

A fully distributed database management system must perform all of the functions of a centralized DBMS.What are these functions?

The TP is the software component found in each computer that requests data.

The ____________________ commit protocol guarantees that if a portion of a transaction operation cannot be committed,all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.