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.

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:

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

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

• Lecture
• Paper Review
• Assignments and Demonstrations
• Project work
• Exam

• Ö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

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

The course, Advanced Database Management Systems is intended to develop students' understanding of the basic concepts of database systems, thus enabling you acquire skills in designing and implementing Database Management Systems. This course also provides students with practical knowledge and hands-on experience in implementing and maintaining a system. We hope that students will find the course enlightening and that theywill find it both interesting and useful.