5th Components and Levels of Data and Process Distribution

function of the transaction processor (TP) in a DDBMS

• manage user accounts

• store data permanently

• request and process data requests

• perform backup operations

What does the data processor (DP) do in a DDBMS

• Converts data formats

• Interfaces with end users directly

• Manages network security

• Stores and retrieves data located at the site

example of single-site processing

• All processing done on a single host computer with local storage

• A fully distributed DBMS with remote access capabilities

• Cloud-based data processing

• Multiple users accessing a shared network drive

In the (MPSD) scenario, what role does the TP play

• manages all database transactions

• stores all data locally

• routes all network data requests to the file server

• performs all processing tasks

What characterizes the multiple-site processing, multiple-site data (MPMD) scenario

• Supports multiple TPs and DPs at different sites

• All processing occurs on a single computer

• Only one data processor is used

• Limited to one type of database system

What distinguishes homogeneous DDBMS from heterogeneous DDBMS

• Homogeneous is more complex than heterogeneous

• Homogeneous requires more hardware resources than heterogeneous

• Homogeneous supports multiple platforms; heterogeneous does not

• Homogeneous uses only one type of DBMS; heterogeneous integrates different types

How do TPs and DPs interact within a distributed database system

• By using centralized control mechanisms only

• Through specific communication protocols

• Only when initiated by an end user request

• Directly without any protocols

What does MPSD stand for

• Mainframe Processing, Single-Site Data

• Multi-Server Processing, Single-Site Data

• Multiple-Site Processing, Single-Site Data

• Multi-User Processing, Single-Site Data

integrate multiple instances of the same DBMS over a network

• Homogeneous DDBMS

• heterogeneous DDBMS

• fully heterogeneous

• MPMD

support different DBMSs, each one supporting a different data model, running under different computer systems

• Homogeneous DDBMS

• heterogeneous DDBMS

• fully heterogeneous

• MPMD