Database

Front 1

The data in a distributed database system is dispersed to match business requirements.

Back 1

Data is located near the site of greatest demand.

Front 2

End users often work with only the nearest stored subset of the data

Back 2

Faster data access

Front 3

A distributed database system spreads out the system’s workload by processing data at several sites.

Back 3

Faster data processing

Front 4

New sites can be added to the network without affecting the operations of other sites.

Back 4

Growth facilitation

Front 5

Local sites foster better communication among departments and between customers and company staff

Back 5

Improved communications

Front 6

Development work is done more cheaply and quickly on low-cost PCs and laptops than on mainframes.

Back 6

Reduced operating costs

Front 7

Client devices are usually equipped with an easy-to-use graphical user interface (GUI).

Back 7

User-friendly interface

Front 8

When one of the computers fails, the workload is picked up by other workstations

Back 8

Less danger of a single-point failure

Front 9

The end user can access any available copy of the data, and an end user’s request is processed by any processor at the data location

Back 9

Processor independence

Front 10

Applications must recognize data location, and they must be able to stitch together data from various sites

Back 10

Complexity of management and control

Front 11

Data integrity, transaction management, concurrency control, security, backup, recovery, and query optimization must all be addressed and resolved

Back 11

Technological difficulty

Front 12

The probability of ----- lapses increases when data is located at multiple sites.

Back 12

Security

Front 13

There are no standard communication protocols at the database level.

Back 13

Lack of standards

Front 14

Multiple copies of data are required at different sites, thus requiring additional storage space.

Back 14

Increased storage and infrastructure requirements

Front 15

------- are generally higher in a distributed model than they would be in a centralized model, sometimes even to the extent of offsetting operational and hardware savings.

Back 15

Increased training costs

Front 16

Distributed databases require duplicated infrastructure to operate, such as physical location, environment, personnel, software, and licensing

Back 16

Higher costs

Front 17

------ that form the network system. The distributed database system must be independent of the computer system hardware.

Back 17

Computer workstations or remote devices (sites or nodes)

Front 18

------ that reside in each workstation or device. The ------------ allow all sites to interact and exchange data.

Back 18

Network hardware and software components

Front 19

------ is the software component residing on each computer or device that stores and retrieves data located at the site

Back 19

The data processor (DP)

Front 20

----- that carry the data from one node to another. The DDBMS must be ---------- independent; that is, it must be able to support several types of -------------

Back 20

Communications media

Front 21

--------- Is the software component found in each computer or device that requests data. --------- receives and processes the application’s remote and local data requests.

Back 21

The transaction processor (TP)

Front 22

governs the storage and processing of logically related data over interconnected computer systems in which both data and processing are distributed among several sites.

Back 22

Distributed Database Management Systems