Exam 12: Distributed Database Management Systems

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

A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

The _____ 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.

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

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

One of the advantages of a distributed database management system (DDBMS) is processor _____.

Which propertyof the CAP theorem assumes that all transaction operations take place at the same time in all nodes, as if they were executing in a single-node database?

Distributed processing does not require:

In a distributed database management system (DDBMS), _____ control is used to manage simultaneous data access and ensure data consistency across database fragments.

The _____ rule requires that all copies of data fragments be identical.

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

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

A user-friendly _____ is one advantage of a distributed database management system (DDBMS) .

The _____ fragment condition indicates that no row has a duplicate, regardless of the fragment in which it is located.

The level of transparency supported by the distributed database management system remains the same for all systems.

A transaction processor is also known as the _____ processor.

_____ distributed database management systems (DDBMS) integrate multiple instances of the same DBMS over a network.

In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.

In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

A _____ request lets a single SQL statement reference data located at several different local or remote DP sites.