Advance Database Management Systems


Module Supervisors: Fawaz Alarfaj

     fkarfaj at imamu . edu . sa

This course is intended to give students a solid background in database management systems and database maintenance. Such systems will be examined from two perspectives: 1. as a database system user, and 2. as a database system administrator. First, we will look at the basic structure and capabilities of a database system, and we will examine the process of designing a database and using a database system. Second, we will look inside a database system to see how it is implemented.

The students will be familiar with centralized systems, client–server systems, parallel and distributed architectures, and network types. Its main attention is towards the fundamentals of a transaction-processing system, including transaction atomicity, consistency, isolation, and durability, as well as the notion of serializability.

Students will also be exposed to the concurrency control mechanism and presents several techniques for ensuring serializability, including locking, time stamping, and optimistic (validation) techniques. It also covers deadlock issues like deadlock detection and deadlock recovery. At the end of the course, students are expected to be familiar with Database Administration, Creating and Configuring an Oracle Database. Particular attention will be paid towards managing users and securing the Database and monitoring database operations, Database maintenance is also another main focus of the course.
  • Describe fundamental data and database concepts
  • Compare and contrast the different database models
  • Knowing the different database system architectures and their advantages and disadvantages
  • Understand transaction processing and the manner in which database systems support atomicity, concurrency, isolation and durability
  • Understand the various concurrency control protocols
  • Familiar with different recovery management techniques
  • Understand the basics of database management and administration
  • Understand the functionality provided by typical database management systems, to an extent sufficient to select and utilize a DBMS to support real world applications.
  • Topic 1

    Introduction, Centralized Architectures; Client-Server Architectures; Parallel Systems; Distributed Systems; Network Types.

  • Topic 2

    Transaction Concept, Transaction State, Implementation of Atomicity and Durability, Concurrent Executions, Serializability, Recoverability, Implementation of Isolation, Transaction Definition in SQL, Testing for Serializability.

  • Topic 3

    Lock-Based Protocols, Timestamp-Based Protocols, Validation-Based Protocols, Multiple Granularity, Deadlock Handling, Insert and Delete Operations

  • Topic 4

    Failure Classification, Storage Structure, Recovery and Atomicity, Log-Based Recovery, Shadow Paging, Recovery With Concurrent Transactions, Buffer Management, Failure with Loss of Nonvolatile Storage, Remote Backup Systems

  • Topic 5

    Getting Started with Database Administration, Creating and Configuring an Oracle Database, Starting Up and Shutting Down, Managing Processes, Managing Memory, Managing Users and Securing the Database, Monitoring Database Operations, Managing Diagnostic Data

Final grades will be determined based on the following components:

Semester Work60%
Final Exam40%
Week Topics Slides Lab Reading/Quizzes
1 Introduction, Course Logistics Survey
2 Database History
3 Databases and Database Users Quiz
4 Database System Concepts and Architecture Quiz
5 Basic SQL SQlite Quiz 1   Quiz 2
6 Basic SQL II Exam Review
7 Basic SQL III   Java
8 Transaction Processing Quiz 1 Quiz 2
9 Concurrency control protocols Quiz 1 Quiz 2
10 Recovery approaches Exam
11 Database Administration and security

Deliverables marks

Please select your student ID and the assignment...

The penalty for late submission without sufficient cause is 5% points per working day up to the seventh day in which 0% will be awarded.
  • 1. Fundementals of Database Systems, 6/E, Ramez Elmasri and Shamkant Navathe, Addison-Wesley Pub. Company, 2011. ISBN-10: 0136086209.
  • 2. Expert Oracle Database 11g Administration, 1/E, Sam R. Alapati, Apress, 2008. ISBN- 13: 978-1430210153.