Faculty of Engineering - Ain Shams University, Home

Advanced Database Systems Design

Course Aims
● Understand the fundamental concepts of query processing and optimization ● Understand transaction processing concepts, concurrency control techniques, and database recovery techniques. ● Understand database security and authorization. ● Understand Object-oriented database concepts and XML language. ● Understand distributed databases and client-server architecture. ● Understand database technology for decision support systems.
Course Goals
Decent Work and Economic Growth
Industry, Innovation and Infrastructure
Sustainable Cities and Communities

CSE244

English Description

Relational algebra language. Query processing and optimization. Transaction processing. Concurrency control. Database recovery. Object databases: Standards, Languages, Design. Object-relational databases. Database security. Distributed database systems architecture. XML, semi-structured, and Internet databases. Data warehousing. Introduction to data mining.
Arabic Description

Relational algebra language. Query processing and optimization. Transaction processing. Concurrency control. Database recovery. Object databases: Standards, Languages, Design. Object-relational databases. Database security. Distributed database systems architecture. XML, semi-structured, and Internet databases. Data warehousing. Introduction to data mining.

Department
Computer and Systems Engineering
Credit Hours
3
Grades
Total ( 100 ) = Midterm (25) + tr.Major Assessment (30 = tr.Industry 0% , tr.Project 15% , tr.Self_learning 5% , tr.Seminar 15% ) + tr.Minor Assessment (5) + Exam Grade (40)
Hours
Lecture Hours: 2, Tutorial Hours: 2, Lab Hours: 0
Required SWL
100
Equivalent ECTS
4

Ramez Elmasri, and Shamkant B. Navathe, Fundamentals of Database Systems, 6th edition, Addison-Wesley, 2011.