Course outline
Hawassa University
Institute of Technology/Faculty of Informatics/Department of computer science
2025 Academic Year, Semester II
Advanced Database Systems (InSy3042)
Course outline/plan
Instructor: Mebrhit G/gewergs (Lecturer), Office number, mebrhitg@hu.edu.et, +251945082183
ECTS: 5 (Lec: 48, Lab: 48, Tuto: 0)
Course description- This course includes Query processing and optimization; data base administration,
performance tuning, recovery and back up; object oriented database, design techniques, and implementation
issues; advanced and emerging database systems concepts - data warehousing, data mining…
Course objective: Students completing this subject should:
Explain database query processing and optimization
Explain the basics of transaction management
Describe database security
Use different recovery methods when there is a database failure
Design a distributed database system in homogenous and heterogeneous environments
Schedule (
Week Topics to be covered Major teaching-learning activities
& Assessment of learning
I Chapter 1: Object Oriented DBMS
o Object Oriented Concepts (Abstraction, 2 hrs lecture
Encapsulation, and Information hiding) Reading assignment (Home take)
o Drawbacks of relational DBMS
o OODBMS definitions
o OO Database Design and Implementation
o OO Data modeling and E-R diagramming
o Objects and Attributes
o Object Identity
o Storing objects in relational database systems
Oracle installation
User management (CRUD)
Table Management (CRUD)
II, III and Chapter 2: Query Processing and Optimization 9 hrs lecture
IV Overview
Query Processing steps 1 hr discussion
Query Decomposition
Optimization Process
Approaches to Query Optimization
Transformation Rules
Implementing relational Operators
Pipelining
- Object Identity 6 hrs practical
- Object Query Language (OQL)
- Query Execution Plan
- Query Optimization
1
Course outline
FIRST EXAMINATION (Test I)
V and VI 3 hrs lecture
Chapter 3: Transaction Management and
Concurrency Control 1 hr discussion
o Transaction
o Transaction Support Reading assignment (Home take)
o Concurrency Control
Problems of Concurrent Sharing
Concept of Serializability
Concurrency Control Mechanism
Database Recovery
Transaction and Recovery
Recovery techniques and facilities
- Transaction Management 6 hrs practical
- Basic Syntax of Transactions
- What are Transactions
- Beginning Transaction
- Committing or Rolling Back
- Creating Named Transactions
VII Chapter 4: Distributed Database Systems 1 hr lecture
Concepts of Distributed Databases
Distributed Database Design 1 hr discussion
Distributed Query Processing and Reading assignment (Home take)
Distributed Transaction Management and
Recovery
Locking
Timestamping
SECOND EXAMINATION (Test II)
VIII and Chapter 5: Database Integrity, Security and Recovery 1 hr lecture
IX Integrity
Integrity Concept & Subsystem 1 hr discussion
Integrity Constraints Reading assignment (Home take)
Types of constraints
Security
Database threats
Identification and Authentication
Categories of control
Implementation of security
subsystems
Data encryption
- Automatic Rollback 3 hrs practical
- Nested Transactions
- Using Save points
- Transactions in Stored Procedures
- Backup and Recovery Concepts
2
Course outline
- Backup
- Recovery
XV Chapter 6: Data warehousing and Data Mining 3 hrs lecture
Techniques
Data Warehousing 1hr discussion
Introduction
Benefits Reading assignment(Home take)
Online Transaction Processing (OLTP) and
Data Warehousing
Data Mining
Introduction
Data Mining Techniques
XVI Revision on practical activities 3 hrs practical
PRACTICAL EXAMINATION 3hrs
Text Book
1. Connolly T., Begg C. and Strachan A.: Database Systems, 2nd, 3rd and 4th ed. Addison-Wesley Publishing
Company.
References
1. RamezElmasri, Shamkant B. Navathe , Fundamentals of Database Systems( 4thed ) , USA, Addison-Wesley,
2004
2. C.J.DATE , Introduction to Database systems(8thed), USA, Addison Wesley, 2003
3. Abraham Silberschatz, Henry F. Korth, S. Sudarshan ,Database System Concepts(4thed), USA, McGraw Hill
Inc. , 2002.
4. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom ,Database Systems :The Complete Book, USA,
Prentice Hall, 2002.
5. Ramakrishnan R. and Gehrke J., Database Management Systems ( 3rded), USA, McGraw Hill,2003
Methods of assessment
(100%)
• Mid 25 • Final Exam = 50
• Lab Assessment and Project Work with
presentation = 25
