Woldia university
Woldia Institute of Technology
Information Technology Program
Course outline
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) 6
Contact Hours Home
Lecture Tutorial Lab/Practical Total
(per week) Study
2 0 3 5 10
Target Group: 3rd year Information Technology Students
Year /Semester Year: III, Semester: I
Pre-requisites ITec3071
Status of the
Core
Course
Lecturer Gashaw
This course covers file organizations, storage management, query
optimization, transaction management, recovery, and concurrency control,
Course database authorization and security. Additional topics include distributed
Description 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.
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
Course
➢ Understand database security
Objectives
➢ Use different recovery methods when there is a database failure
➢ Design a distributed database system in homogenous and heterogeneous
environments
Brief introduction about the course
Chapter 1: Query processing and Optimization
▪ Translating SQL Queries into Relational Algebra
▪ Basic Algorithms for Executing Query Operations
Course outline ▪ Using Heuristic in Query Optimization
▪ Using Selectivity and Cost Estimates in Query Optimization
▪ Semantic Query Optimization
1|Page
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
▪ Multi version 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 Multi database 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 wdu Legislative
Text Book
Reference
Elmasri et al (2011). Fundamentals of Database Systems, 6thed, Pearson
education
2|Page
References
1. Thomas M. Connolly and Carolyn E.Begg. (2004). A step by step
approach to building databases, 2nd ed.Pearson Education Limited.
2. Ramon A ,etal. Shaum’s outlines, fundamentals of relational databases
3. David M. Kroenke. (1998). Database processing, 6th ed. Prentice Hall
4. Van der Lans (2006). Introduction to SQL, Mastering the relational
database language. 3rd ed. London, Addis Wesley
5. Silbershatz A. Korth H andSundarshan (2006). Database System concepts,5th
ed. Boston, McGraw Hill
6. RamaKrishman(1998). Database Management
7. Systems. Boston McGraw Hill
8. Namdagopalan (2003). Database Management Systems with oracle and
vb.Gandhinagar, Appa Book house.
9. Date, .J (1981). An Introduction to Database systems. 3rd ed. Vol. 1. New Delhi.
Narosa publishing House
Approved by:
Name signature Date
Instructor: Gashaw E. _____________ ____________
Quality Assurance: Sead A. _______________ _____________
Dep’t Head: Kenaw A. ________________ ______________
3|Page
