Database Management System Chapter 12(100% Correct
answers)
distributed database management system (DDBMS) correct answers a DBMS that supports a
database distributed across several different sites; governs the storage and processing of logically
related data over interconnected computer systems in which both data and processing functions
are distributed among several sites
distributed processing correct answers sharing the logical processing of a database over two or
more sites connected by a network
distributed database correct answers a logically related database that is stored in two or more
physically independent sites
database fragment correct answers a subset of a distributed database. although may be stored at
different sites within a computer network, the set of all is treated as a single database
transaction processor (TP) correct answers in a DDBMS, the software component on each
computer that requests data. responsible for the execution and coordination of all database
requests issued by a local application that accesses data on any DP
data processor (DP) correct answers the resident software component that stores and retrieves
data through a DDBMS. responsible for managing the local data in the computer and
coordinating access to that data
single-site processing, single-site data (SPSD) correct answers a scenario in which all processing
is done on a single host computer and all data is stored on the host computer's local disk
multiple-site processing, single-site data (MPSD) correct answers a scenario in which multiple
processes run on different computers sharing a single data repository
client/server architecture correct answers a hardware and software system composed of clients,
servers, and middleware. features a user of resources (client) and a provider of resources (server)
multiple-site processing, multiple-site data (MPMD) correct answers a scenario describing a
fully distributed database management system with support for multiple data processors and
transaction processors at multiple sites
homogeneous DDBMS correct answers a system that integrates only one type of centralized
database management system over a network
heterogeneous DDBMS correct answers a system that integrates different types of centralized
database management systems over a network
answers)
distributed database management system (DDBMS) correct answers a DBMS that supports a
database distributed across several different sites; governs the storage and processing of logically
related data over interconnected computer systems in which both data and processing functions
are distributed among several sites
distributed processing correct answers sharing the logical processing of a database over two or
more sites connected by a network
distributed database correct answers a logically related database that is stored in two or more
physically independent sites
database fragment correct answers a subset of a distributed database. although may be stored at
different sites within a computer network, the set of all is treated as a single database
transaction processor (TP) correct answers in a DDBMS, the software component on each
computer that requests data. responsible for the execution and coordination of all database
requests issued by a local application that accesses data on any DP
data processor (DP) correct answers the resident software component that stores and retrieves
data through a DDBMS. responsible for managing the local data in the computer and
coordinating access to that data
single-site processing, single-site data (SPSD) correct answers a scenario in which all processing
is done on a single host computer and all data is stored on the host computer's local disk
multiple-site processing, single-site data (MPSD) correct answers a scenario in which multiple
processes run on different computers sharing a single data repository
client/server architecture correct answers a hardware and software system composed of clients,
servers, and middleware. features a user of resources (client) and a provider of resources (server)
multiple-site processing, multiple-site data (MPMD) correct answers a scenario describing a
fully distributed database management system with support for multiple data processors and
transaction processors at multiple sites
homogeneous DDBMS correct answers a system that integrates only one type of centralized
database management system over a network
heterogeneous DDBMS correct answers a system that integrates different types of centralized
database management systems over a network
