Course Content -1. Syllabus -2. Lecture Notes -3. Homeworks -4. Quizzes -5. Exams

1. Syllabus

Course Syllabus for ICS 424 for Term 062

• Syllabus

Catalog Course 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.

Course Contents

1.     Review of ICS324

2. Disk Storage, Basic File Structures, and Hashing

3. Indexing Structures for Files

4. Algorithms for Query Processing and Optimization

5. Physical Database Design and Tuning

6. Introduction to Transaction Processing Concepts and Theory

7. Concurrency Control Techniques

8. Database Recovery Techniques

9. Concepts for Object Databases

10. Object Relational and Extended Relational Systems

11. Database Security and Authorization

12. Enhanced Data Models for Advanced Applications

13. Distributed Databases and Client-Server Architectures

14. XML and Internet Databases

15. Emerging Database Technologies and Applications

16. Data Mining Concepts

17. Overview of Data warehousing and OLAP

Grading Policy

 Attendance and Participation                          2 %

 Quizzes                                                          12 %

Homeworks                                                    18 %

Major Exam 1                                                18 %

Major Exam 2                                                20 %

Final Exam                                                     30 %

Instructor

Dr. Salahadin Mohammed Adam (Office: (22) 102, phone: x1721). E-mail: adam@kfupm.edu.sa
Office hours: SMW: 11:00 – 11:50 AM & U  02:00 - 02:50 PM & T 10:00 - 10:50 AM

Textbooks