Intoduction

Question 1

Database System

Answer 1

System for providing efficient, convenient, and safe, multi-user storage of and access to massive amounts of persistent data

Question 2

DBMS

Answer 2

A DBMS is software that stores, manages, and
facilitates access to data.

Question 3

Database

Answer 3

a large, organized collection of data

Question 4

Index

Answer 4

An index helps the DBMS find data quickly based on the value of a given field.

Question 5

DBMS software

Answer 5

allows you to access the datanase

Question 6

DBMS components

Answer 6

has functions to retrieve and manage the db

Question 7

Storage manager

Answer 7

gets or modifies information from data storage based on requests from levels above it

Question 8

File manager

Answer 8

knows the location of files on disk and how to get these blocks

Question 9

Buffer Manager

Answer 9

gets blocks of data from the file manager and stores it in main memory. It is held until another block is requested and replaces the present block.

Question 10

Query Manager

Answer 10

takes a query or data manipulation command and converts it into a series of requests for stored data (via the storage manager)

Question 11

Query optimization

Answer 11

involves obtaining the best query plan or series of requests which answers the query.

Question 12

Transaction Manager

Answer 12

Maintains the integrity of the DBMS

Question 13

OLTP

Answer 13

Online Transaction Processing

Question 14

Centralized DBS

Answer 14

physically resides on one or cluster of servers

Question 15

Distributed DBS

Answer 15

partitions the data and stores it across different geographic locations

Question 16

Data Warehouse

Answer 16

supports complex queries on historical data. Emphasis is on query processing and supporting decision support systems

Question 17

DBMS Functions

Answer 17

1) Data dictionary mgmt. -stores definitions of data elements and metadata. Records changes in db structure. Performs validation

2) Data storage management- Manages physical storage of data, Creates and maintains indexes/

3) Query processing- Users query db for data, Data definition language defines structure, Data manipulation language allows data to be extracted.

4) Multi-user control- DBMS must ensure that concurrent user transaction do NOT interfere with each other

5) Backup and recovery management- Maintains various types of log files to return db to original state after transaction or system failure