Finish DBMS Overview




CS157a

Chris Pollett

Aug 29, 2018

Outline

Introduction

Storage and Buffer Management

DBMS Info Stored on Disk

The following DBMS info is persisted on disk and hence would involve requests through the buffer and storage manager for to access and manipulate:

  1. Data: the contents of the database itself.
  2. Metadata: the database schema that describes the structure of and constraints on the database.
  3. Log Records: information about recent changes to the database; these are used to make ensure the durability of data stored in the database.
  4. Statistics: information gathered and stored by the DBMS such as sizes of various relations, etc.
  5. Indexes: data structures used to help speed up access to data in the database.

Transaction Processing

ACID Properties of a Transaction

Properly implemented transactions are often said to meet the "ACID" test where:

Tasks of the Transaction Processor

In-Class Exercise

Come up with a situation involving two transactions in which a deadlock occurs. Write a few sentences describing this situation.

Post your solution to the Aug. 29 In-Class Exercise Thread.

Query Processor