ICS 424: Advanced Database Systems

​

ICS 424: Advanced Database Systems

 
Course Information
Class/Laboratory Schedule: 

Three 50 minutes lectures per week (3-0-3)

Designation: 
 Elective Course
Course Level: 
 Undergraduate
Prerequisites
Prerequisite(s) by Topic: 
  • Basic Concepts & Features of Database Systems
  • Database Design Models & Methodology
  • Database Languages
  • Practice with A Real Database Management System
Prerequisite Courses: 
ICS 324: Database Systems
Catalog Description: 

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.

Textbook(s): 

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.
Course Outcomes: 

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.
Topics Covered: 
  • 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.
  • Recovery.
  • Database Administration & Security.
  • Distributed & Replicated Databases.
  • Object-Oriented & Object-Relational DBs.
  • Intro to Data Warehousing and Data Mining.
  • Other Emerging Database Technologies.​