Advanced Database

Trainers
Dr. Solomon Demissie |

This course covers advanced database management system design principles and techniques. The course materials will be drawn from both classic and recent research literature. Possible topics include access methods, query processing and optimization, transaction processing, distributed databases, object-oriented and object-relational databases, data warehousing, data mining, Web and semi-structured data, search engines, etc. Programming projects are required.

Prerequisites: An introductory database course.

Course Information

COURSE OBJECTIVES

The main objective of the course is to explain the advanced topics in the Data Base Management Systems. It also enables the students to acquire more knowledge about the data base concepts and its current issues.

Upon completion of the course, you should be able to:

Describe the basic concepts of Relational Database Design
Explain Database implementation and tools
Describe SQL and Database System catalog.
Describe the process of DB Query processing and evaluation.
Discuss the concepts of transaction management.
Explain the Database Security and Authorization.
Describe the design of Distributed Databases.
Know how to design a Database and XML.
Describe the basic concept of Data warehousing and Data mining
Discuss the emerging Database Models, Technologies and Applications

COURSE TOPICS

CHAPTER ONE: FUNDAMENTAL DATABASE CONCEPTS

Concepts of Relational Database
Database Design and Implementation
Advance SQL
Database System Catalog

CHAPTER TWO: PARALLEL AND DISTRIBUTED DATABASES

Database Architectures
Centralized and Client-Server Architectures
Parallel Systems- Distributed Systems Architectures
Parallel Databases
Distributed Database Concepts
Distributed Data Storage
Distributed Transactions
Distributed Query Processing
Three Tier Client Server Architecture

CHAPTER THREE: OBJECTS AND OBJECT-RELATIONAL DATABASES

Concepts of Object Databases
Object Database Standards
Languages and Design
Relational Systems
Object Relational features in SQL/Oracle

CHAPTER FOUR: XML DATABASES

XML Databases
XML Data Model
XML Schema
XML Querying
Web Databases

CHAPTER FIVE: MOBILE DATABASES

Mobile databases Management
Mobile computing architecture
Wireless communication
Client/network relationship
Characteristics of mobile environment

CHAPTER SIX: EMERGING DATABASE SYSTEMS

Multimedia database
Parallel database
Spacial database
Introduction to Data Mining
Introduction to Data Warehousing

DELIVERY METHODS

Lecture
Paper Review
Assignments and Demonstrations
Project work
Exam

COURSE REFERENCES

Özsu, M. Tamer, Valduriez, Patrick, Principles of Distributed Database Systems. Wiley-Springer, 2020
Principles of Distributed Database System, 3rd Edition, Tamer Ozsu, Springer, 2011
Saeed K. Rahimi, Frank S. Haug, Distributed Database Management Systems: A Practical Approach, Wiley-IEEE Computer Society Pr, 2010
R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Fifth Edition, Pearson Education/Addison Wesley, 2007. 2. Thomas Cannolly and Carolyn Begg, “Database Systems, A Practical Approach to Design, Implementation and Management”, Third Edition, Pearson Education, 2007.
Henry F Korth, Abraham Silberschatz, S. Sudharshan, “Database System Concepts”, Fifth Edition, McGraw Hill, 2006. 4. C.J.Date, A.Kannan and S.Swamynathan,”An Introduction to Database Systems”, 8th Edition, Pearson Education, 2006.
V.S.Subramanian, “Principles of Multimedia Database Systems”, Harcourt India Pvt Ltd., 2001. Vijay Kumar, “Mobile Database Systems”, John Wiley & Sons, 2006

COURSE ASSESSMENT

Final Written Examination: 30%
Article Review: 20%
Assignment/Project 50%