Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database Design & Administration > 04_12 DDBMS > Flashcards

04_12 DDBMS Flashcards

1
Q

In a DDBMS

The software component on each computer that requests data.

A

transaction processor (TP) OR transaction manager (TM) OR application processor (AP)

The TP is responsible for the execution and coordination of all database requests issued by a local application that accesses data on any DP.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A data consistency model in which data changes are not immediate but propagate slowly through the system until all replicas are eventually consistent.

A

basically available, soft state, eventually consistent (BASE)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A data allocation strategy in which the entire database is stored at one site.

A

centralized data allocation (centralized database)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

A hardware and software system composed of clients, servers, and middleware.

Features a user of resources and a provider of resources.

A

client/server architecture

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

The TP node that coordinates the execution of a two-phase COMMIT in a DDBMS.

A

coordinator

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

In a DDBMS

The process of deciding where to locate data fragments.

A

data allocation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

A characteristic of a DDBMS that allows a single object to be broken into two or more segments or fragments.

The object might be a user’s database, a system database, or a table.

A

data fragmentation

Each fragment can be stored at any site on a computer network.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

The resident software component that stores and retrieves data through a DDBMS.

A

data processor (DP) OR data manager (DM)

The DP is responsible for managing the local data in the computer and coordinating access to that data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

The storage of duplicated database fragments at multiple sites on a DDBMS.

Duplication of the fragments is transparent to the end user.

A

data replication

Data replication provides fault tolerance and performance enhancements.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

A subset of a distributed database.

A

database fragment

Although the fragments may be stored at different sites within a computer network, the set of all fragments is treated as a single database. See also horizontal fragmentation and vertical fragmentation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A logically related database that is stored in two or more physically indepent sites.

A

distributed database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A DBMS that supports a database distributed across several different sites.

A

distributed database management system (DDBMS)

A DDBMS 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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

A data dictionary that contains the descriptions (fragment names and locations) of a distributed database.

A

distributed data catalog (DDC) OR distributed data dictionary (DDD)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

The database schema description of a distributed database as seen by the database administrator.

A

distributed global schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Sharing the logical processing of a database over two or more sites connected by a network.

A

distributed processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A database request that allows a single SQL statement to access data in several remote DPs in a distributed database.

A

distributed request

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

A database transaction that accesses data in several remote DPs in a distributed database.

A

distributed transaction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

A DDBMS feature that allows a distributed database to look like a single logical database to an end user.

A

distribution transparency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

A protocol used by a DP to roll back or roll foward transactions with the help of a system’s transaction log entries.

A

DO-UNDO-REDO protocol

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

A feature that allows continuous operation of a DDBMS, even if a network node fails.

A

failure transparency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

A DDBMS feature that allows a system to treat a distributed database as a single database even though it is divided into two or more fragments.

A

fragmentation transparency

22
Q

A system that integrates different types of DBMS over a network.

It supports different DBMS that may even support different data models running under different computer systems.

A

fully heterogeneous distributed database system (fully heterogeneous DDBMS)

See also heterogeneous DDBMS and homogeneous DDBMS.

23
Q

In a DDBMS

The distributed database that stores multiple copies of each database fragment at multiple sites.

A

fully replicated database

24
Q

A feature that allows a system to integrate several centralized DBMSs into one logical DDBMS.

A

heterogeneity transparency

25
Q

A system that integrates different types of centralized DBMS over a network.

A

heterogeneous DDBMS

26
Q

A system that integrates only one type of centralized DBMS over a network.

A

homogeneous DDBMS

27
Q

The distributed database design process that breaks a table into subsets of unique rows.

A

horizontal fragmentation

28
Q

A property of a DDBMS in which database access requires the user to know both the name and location of the fragments.

A

local mapping transparency

29
Q

A property of a DDBMS in which database access requires the user to know only the name of the database fragments.

Fragment locations need not be known.

A

location transparency

30
Q

A combination of horizontal and vertical strategies for data fragmentation, in which a table may be divided into several rows and each row has a subset of the attributes (columns).

A

mixed fragmentation

31
Q

A scenario describing a fully DDBMS with support for multiple data processors and transaction processors at multiple sites.

A

multiple-site processing, multiple-site data (MPMD)

32
Q

A scenario in which multiple processes run on different computers sharing a single data repository.

A

multiple-site processing, single-site data (MPSD)

33
Q

A data replication rule that requires all copies of data fragments to be identical.

A

mutual consistency rule

34
Q

The delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.

A

network latency

35
Q

The delay that occurs when nodes become suddenly unavailable due to a network failure.

In distributed databases, the system must account for the possibility of this condition.

A

network partitioning

36
Q

A database model that attempts to provide ACID-compliant transactions across a highly distributed infrastructure.

A

NewSQL

37
Q

A distributed database in which copies of only some database fragments are stored at multiple sites.

A

partially replicated database

38
Q

A data allocation strategy of dividing a database into two or more fragments that are stored at two or more sites.

A

partitioned data allocation

39
Q

In partitioned databases

One or more attributes in a table that determine the fragment in which a row will be stored.

A

partition key

40
Q

A DDBMS feature that allows a system to perform as though it were a centralized DBMS.

A

performance transparency

41
Q

A DDBMS feature that allows a single SQL statement to access data in a single remote DP.

A

remote request

42
Q

A DDBMS feature that allows a transaction (formed by several requests) to access data in a single remote DP.

A

remote transaction

43
Q

The DDBMS’s ability to hide the existence of multiple copies of data from the user.

A

replica transparency

44
Q

A data allocation strategy in which copies of one or more database fragments are stored at several sites.

A

replicated data allocation

45
Q

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.

A

single-site processing, single-site data (SPSD)

46
Q

In a DDBMS

A DP node that participates in a distributed transaction using the two-phase COMMIT protocol.

A

subordinate

47
Q

A DDBMS property that ensures database transaction will maintain the distributed database’s integrity and consistency, and that a transaction will be completed only when all database sites involved complete their part of the transaction.

A

transaction transparency

48
Q

In a DDBMS

An algorithm used to ensure atomicity of transactions and database consistency as well as integrity in distributed transactions.

A

two-phase commit protocol (2PC)

49
Q

In a DDBMS

A condition in which each row is unique, regardless of which fragment it is located in.

A

unique fragment

50
Q

A distributed database in which each database fragment is stored at a single site.

A

unreplicated database

51
Q

In distributed database design

The process that breaks a table into a subset of columns from the original table.

A

vertical fragmentation

Fragments must share a common primary key.

52
Q

A protocol that ensures transaction logs are written to permanent storage before any database data is actually updated.

A

write-ahead protocol

Database Design & Administration (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions