Lesson 1.3: Overview of a DBMS Flashcards

1
Q

The two distinct sources of command to the DBMS

A
  1. conventional users and application programs that ask/modify data
  2. database administrator
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

it is a person or persons responsible for the structure or schema of the database

A

database administrator

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

DDL commands are parsed by a DDL processor and passed to the execution engine, which then goes to the what?

A

Index/file/record manager

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

this initiates some action made by a user or an application program

A

data-manipulation language (DML)

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

DML statements are handled by two separate subsystems, namely:

A
  1. answering the query

2. transaction processing

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

in answering the query, the query is optimized and parsed by a?

A

query compiler

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

in answering the query, the resulting query plan is passed to the what?

A

execution engine

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

in answering the query, this issues a sequence of requests for small pieces of data

A

execution engine

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

in answering the query, the requests made by the execution are passed to what?

A

buffer manager

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

in answering the query, this brings appropriate portions of the data from secondary storage to main-memory buffers

A

buffer manager

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

this subsystem communicates with a storage manager to get data from disk

A

buffer manager

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

what is storage manager’s job

A

control the placement of data on disk and its movement between disk and main memory

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

do the storage manager keeps track of the location of files on the disk?

A

Yes. It even obtains the block or blocks containing a file on request from the buffer manager.

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

This is responsible for partitioning the available main memory into buffers

A

buffer manager

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

the contents of the database itself

A

data

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

the database schema that describes the structure of, and contraints on the database

A

metadata

17
Q

information about recent changes to the database; these support durability

A

log records

18
Q

info gatherd and stored by the DBMS about data properties such as the sizes of, and values in, various relations or other components of the database

A

statistics

19
Q

data structures that support efficient access to the data

A

indexes

20
Q

This accepts transaction commands from an application

A

transaction manager

21
Q

The transaction processor performs what?

A
  1. logging
  2. concurrency control
  3. deadlock resolution
22
Q

Does the buffer manager has the responsibility to intervene and cancel transactions to let others proceed?

A

No. This responsibility is for the Transaction Manager.

23
Q

As transactions compete for resources through the locks that the scheduler grants, they can get into a situation where none can proceed because each needs something another transaction has. What is this?

A

Deadlock resolution

24
Q

This does its work by maintaining locks on certain pieces of the databases which are generally stored in a main-memory lock table.

A

scheduler

25
Q

this writes the log in buffers and negotiates with the buffer manager to make sure that buffers are written to disk

A

log manager

26
Q

What ACID stands for the properties of transactions?

A

atomicity
consistency
isolation
durability

27
Q

this translates the query into an internal form

A

query compiler

28
Q

an internal form translated by the query compiler

A

query plan

29
Q

the query compiler consists of three major units

A

query parser
query preprocessor
query optimizer

30
Q

which has the responsibility for executing each of the steps in the chosen query plan

A

execution engine

31
Q

this transforms the initial query plan into the best available sequence of operations on the actual data

A

query optimizer

32
Q

this performs semantic checks on the query (e.g., making sure all relations mentioned by the query actually exist), and performing some tree transformations to turn the parse tree into a tree of algebraic operators representing the initial query plan

A

query preprocessor

33
Q

this builds a tree structure from the textual form of the query

A

query parser