Three 50 minutes lectures per week (3-0-3)
Designation: Elective Course
Course Level: Undergraduate
Prerequisite(s) by Topic:
- Basic Concepts & Features of Database Systems
- Database Design Models & Methodology
- Database Languages
- Practice with A Real Database Management System
Advanced data models: object-oriented model, and object-relational model, conceptual database design. Transaction processing: transactions, failure and recovery, and concurrency control techniques. Database backup and recovery. Query processing and optimization. Database security. Distributed databases: distributed data storage, distributed query processing, distributed transaction processing and concurrency control. Homogeneous and heterogeneous solutions, client-server architecture. XML and relational databases. Introduction to data warehousing, introduction to other current trends in database systems.
Fundamentals of Database Systems, 5th Edition, by Elmasri and Navathe, Addison- Wesley, 2006.
Reference(s) and Other Material:
- Database Systems: A Practical Approach to Design, Implementation and Management, Thomas M. Connolly, Carolyn E. Begg, Addison-Wesley, 3/E, 2004
- Database Management Systems, Ramakrishnan and Gehrke, 3/E, McGraw-Hill College.
- Database System Concepts, by Silbershatz, Korth and Sudershan, 3/E, McGraw-Hill College.
After completion of this course, the student shall be able to:
- Use an automated database design tool to design complex database systems.
- Apply object-relational data model concepts in database modeling and design.
- Learn how to process and optimize database transactions.
- Learn how to implement concurrency and recovery of database transactions.
- Understand the security issues of database systems and implement proper security measures in database systems.
- Understand the architecture and implementation of distributed and replicated database systems.
- Design distributed database systems.
- Understand the basics of data warehousing.
- Understand the basics of new trends such as: XML in relational databases, logic database, spatial data, multimedia databases, and federated databases.
- File Organization (Self Reading).
- The Relational Data Model: Version2.
- Advanced Data Modeling.
- Client-Server Architecture.
- Databases on the Web.
- XML & Relation Databases.
- The System Catalog.
- Query Processing and Optimization.
- Transaction Processing.
- Concurrency Control.
- Database Administration & Security.
- Distributed & Replicated Databases.
- Object-Oriented & Object-Relational DBs.
- Intro to Data Warehousing and Data Mining.
- Other Emerging Database Technologies.