Exam 12: Distributed Database Management Systems

A distributed _____ contains the description of the entire database as seen by the database administrator.

_____ fragmentation refers to the division of a relation into attribute subsets.

_____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

_____ management ensures that data move from one consistent state to another.

In theory, a(n) _____ can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

One of the advantages of a distributed database management system (DDBMS) is less danger of a single-_____ failure.

In a distributed database management system (DDBMS), query _____ is used to find the best access strategy.

Typically, the _____ scenario requires a network file server running conventional applications that are accessed through a network.

Data _____ describes the process of deciding where to locate data.

One of the advantages of a distributed database management system (DDBMS) is that the data is located near the site with the least demand.

Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.

Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.

A database management system needs _____ to prepare the data for presentation to the end user or to an application program.

After an update, the originating DP node sends the changes to the replica nodes to ensure that data is immediately updated, during _____replication.

A disadvantage of a distributed database management system (DDBMS) is:

During _____replication, after an update, the originating DP node sends "messages" to the replica nodes to notify them of the update.

_____ transparency allows a physically dispersed database to be managed as though it were centralized.

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

Explain the difference between homogeneous and heterogeneous distributed database management systems (DDBMS).