Advanced Database system
Course Title Advanced Database Systems
Module Title Database and Information Management
Module Code INSY-M2031 Course Code: INSY2032
CP/ECTS 5
Study Hours Lecture: 48 Laboratory: 32 Tutorial: 0 Home Study:55
Instructor’s Name:
Information
Office Phone: Email: aminu.mohammed@aau.edu.et
Office Location: Eshetu Chole, 424
Consultation Hours:
Course Academic Year: II
Information
Semester: II
Course Schedule:
Class Room:
Prerequisite(s): INSY2031
Mode of Delivery: Parallel
Course This course includes Query processing and optimization; data base administration,
Description performance tuning, recovery and back up; object-oriented database, design
techniques, and implementation issues; advanced and emerging database systems
concepts - data warehousing, data mining…
Learning At the end of this course the students will be able to:
Outcomes
● Understand and explain the basics of transaction management in database
systems
● Explain database query processing and optimization concepts
● Describe database integrity and security
● Comprehend mechanisms and facilities for database recovery
● Understand the concepts behind distributed Database Design and Management
● Understand the concepts in Object Oriented database design and management
● Explain the nature and relationship between OODBMS, ORDBMS and RDBMS
Course Content
Topic Duration (Week) Reading list
Chapter 1: Transaction Management and Concurrency 3 Text: Chapter 22
Control
1.1. Transactions
1.2. Transaction Support
1.3. Concurrency Control
1.3.1.Problems of Concurrent Sharing
1.3.2.Concept of Serializability
1.3.3.Concurrency Control Mechanism
1.4. Database Recovery
1.4.1.Transaction and Recovery
1.4.2. Recovery techniques and facilities
Chapter 2: Query Processing and Optimization 3 Text: Chapter 23
2.1 Overview
2.2 Query Processing steps
2.2.1 Query Decomposition
2.2.2 optimization,
2.2.3 code generation, and
2.2.4 Execution
2.3 Approaches to Query Optimization
2.3.1 Heuristic Approach (using Transformation Rules
for Relational Algebra Operators)
2.3.2 Pipelining
Chapter 3: Database Integrity and, Security 3
3.1 Defining Database Integrity and Security Text: Chapter 20
3.2 Integrity
3.2.1 Integrity Concept & Subsystem
3.2.2 Integrity Constraints
3.2.3 Types of Constraints
3.3 Security
3.3.1 Database threats
3.3.2 Identification and Authentication
3.3.3 Categories of Control
3.3.4 Implementation of Security Subsystem
3.3.5 Data Encryption
3.4 Database Security on the web
3.5 Statistical Database security
Chapter 4: Distributed Database Systems 3 Text: Chapter 24 & 25
4.1 Concepts of Distributed Databases
4.2 Pros and Cons of Distributed Databases
4.3 Functions and Architectures for DDBMS
4.4 Distributed Database Design
4.4.1 Fragmentation
4.4.2 Replication
4.4.3 Allocation
4.5 Levels of Transparency in DDBMS
4.6 General Rules for DDBMSs
Chapter 5: Object Oriented DBMS 3 Text: Chapter 27
(OODBMS)
1.1 Advanced database applications.
Text: Chapter 9 (ORDBMS)
1.2 History of Database System
1.3 Weakness of RDBMSs for advanced database
applications.
1.4 Object-oriented concepts.
1.5 Problems of storing objects in relational
database.
1.6 Basics of object-oriented database analysis and
design.
1.7 The next generation of database systems.
1.8 Brief Overview of OODBMS
1.9 Brief Overview of ORDBMS
Teaching Strategy The course will be delivered in the form of lectures, demonstration, student
presentations, group discussions, and individual and group project works.
Assessment The evaluation shall be based on both formative and summative assessment which
Criteria include:
Assessment Forms % of credit allotted
Lecture (100%)
10
● Participation and Attendance
25
25
● Quizzes and Assignments
40
● Test
● Final examination
Practice (100%)
10
● Participation and Attendance
20
40
● Lab Assignments
30
● Lab Exam
● Project
Role of Delivers lectures, prepares reading assignments and topics for group discussion,
Instructor(s) prepares projects by discussion with student, gives consultation and advises students on
project works and assignments, prepares and evaluates quiz, assignment, midterm and
final examination.
Cover full implementation and administration of RDBMS and object orientation
database using DBMS tools
Role of Students Attend lectures, lab session and presentation, work in team on group work, participate
in group discussion, discusses with the instructor on topics of interest for project work,
delivers and presents project work, attend quiz, midterm and final examination.
Required software SQL SERVER /My SQL/ PostgreSQL
and/or hardware
Reference Text Book
1. Thomas M. Connolly, Carolyn E. Begg, Database Systems: A Practical Approach to
Design, Implementation and Management 6th Ed, 2015
References
1. RamezElmasri, Shamkant B. Navathe , Fundamentals of Database Systems, 7th
Edition, Pearson, 2016
2. C.J.DATE , Introduction to Database systems(8thed), USA, Addison Wesley, 2004
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
