Contents

1. Relational Database Design

1. Introduction

2. Controlling Program Flow

3. Views

4. Stored Functions in PL/pgSQL

5. Handling Errors and Exceptions

6. Cursors and Triggers

7. Triggers

2. Transaction Concepts

1. Introduction

2. Transaction Concepts   

3. Concurrent Execution of Transaction and Conflicting Operations

4. Schedules of Transaction 

3. Concurrency Control

1. Introduction

2. Ensuring Serializability by Locks

3. Basic Timestamp Method for Concurrency

4. Multiple Granularity Locking

5. Dynamic Database Concurrency (Phantom Problem)

6. Timestamp versus Locking

7. Optimistic Concurrency Control Algorithm and Multi Version Concurrency Control

8. Deadlock Handling Methods 

4. Crash Recovery

1. Introduction

2. Transaction Failure Classification

3. Recovery Concepts

4. Checkpoints

5. Recovery with Concurrent Transactions (Rollback, Checkpoints, Commit)

6. Log Based Recovery Techniques (Deferred and Immediate Update)    

7. Buffer Management

8. Relationship between Recovery Management and Buffer Management   

9. Database Backup and Recovery from Catastrophic Failures

10.Shadow Paging

Solved Examples 

5. Database Security

1. Introduction

2. Database Security Concepts

3. Methods of Database Security

4. Discretionary Access Control Method

5. Mandatory Access Control Method

6. Uses of Views in Security Enforcement

7. Overview of Encryption Technique for Database

8. Statistical Database Security 

6. Database System Architectures

1. Introduction

2. Centralized and Client-Server Architecture

3. Server System Architecture

4. Introduction to Parallel Database Systems

5. Introduction to Distributed Database Systems

6. Introduction to Object Based Databases