Injibara University
College of Natural and Computational Science
Information Technology Program
Program Information Technology
Course Code ITec3071
Course Title: Advanced Database Management
Degree Program Information Technology
Module Name Database systems
Module Number 07
CP Credits (CP) 5
Contact Hours Lecture Tutorial Lab/Practical Home Study Total
(per week) 2 0 3 5 10
Target Group: 2nd year Information Technology Students
Year /Semester Year: III, Semester: I
Pre-requisites ITec2071
Status of the Core
Course
Course This course covers file organizations, storage management, query optimization,
Description transaction management, recovery, and concurrency control, database
authorization and security. Additional topics include distributed databases, mobile
databases, and integration may also be covered. A major component of the course
is a database implementation project using current database languages and
systems.
Course Objectives At the end of this course the students will be able to:
Understand the database query processing and optimization
Know the basics of transaction management
Understand database security
Use different recovery methods when there is a database failure
Design a distributed database system in homogenous and heterogeneous
environments
Page | 53
Course outline Brief introduction about the course
Chapter 1: Query processing and Optimization
Translating SQL Queries into Relational Algebra
Basic Algorithms for Executing Query Operations
Using Heuristic in Query Optimization
Using Selectivity and Cost Estimates in Query Optimization
Semantic Query Optimization
Chapter 2: Database Security and
Authorization
Introduction to DB Security Issues
Discretionary Access Control Based on Granting /Revoking of Privileges
Mandatory Access Control for Multilevel Security
Statistical DB Security
Chapter 3: Transaction Processing Concepts
Introduction
Transaction and System Concepts
Properties of Transaction
Schedules and Recoverability Serializability of Schedules
Transaction Support in SQL
Chapter 4: Concurrency Control Techniques
Locking Techniques for Concurrency Control
Concurrency Control Based ON Timestamp Ordering
Multiversion Concurrency Control Techniques
Validation (Optimistic) Concurrency Control Technique
Granularity of Data Items and Multiple Granularity Locking
Using Locks for Concurrency Control in Indexes
Chapter 5: Database Recovery Techniques
Recovery Concepts
Recovery Concepts Based on Deferred Update
Recovery Concepts Based on Immediate Update
Shadow Paging
The ARIES Recovery Algorithm
Recovery in Multidatabase Systems
Chapter 6: Distributed Database System
Distributed Database Concepts
Data Fragmentation, Replication, and Allocation Techniques for
Distributed
database Design
Types of Distributed Database Systems
Query Processing in Distributed Databases
An over view of Client- Server Architecture and its Relationship to Distributed
database
Assessment
As per University Legislative
Page | 54
Reference Text Book
Elmasri et al (2011). Fundamentals of Database Systems, 6thed, Pearson education
References
7 Thomas M. Connolly and Carolyn E.Begg. (2004). A step by step approach to
building databases, 2nded.Pearson Education Limited.
8 Ramon A ,etal. Shaum‘s outlines, fundamentals of relational databases
9 David M. Kroenke. (1998). Database processing, 6th ed. Prentice Hall
10 Van der Lans (2006). Introduction to SQL, Mastering the relational database
language. 3rd ed. London, Addis Wesley
11 Silbershatz A. Korth H andSundarshan (2006). Database System concepts, 5th ed.
Boston, McGraw Hill
12 RamaKrishman(1998). Database Management Systems. Boston McGraw Hill
13 Namdagopalan (2003). Database Management Systems with oracle and
vb.Gandhinagar, Appa Book house.
14 Date, .J (1981). An Introduction to Database systems. 3rd ed. Vol. 1. New Delhi.
Narosa publishing House
Page | 55
