Advanced Database (CSC475) — Notes, Syllabus & Past Questions

Complex database architectures, distributed systems, and NoSQL databases.

Core Course5 Chapters
Chapter 118 Pages

Enhanced Entity Relationship Model and Relational Model

Entity Relationship Model Revised, Subclasses, Superclasses and Inheritance, Specialization and Generalization, Constraints and characteristics of specialization and Generalization, Union Types.

Read Notes
Chapter 29 Pages

Object and Object Relational Databases

Object Database Concepts, Object Database Extensions to SQL, The ODMG Object Model and the Object Definition Language ODL, Object Database Conceptual Design, Object Query Language OQL.

Read Notes
Chapter 38 Pages

Query Processing and Optimization

Concept of Query Processing; Query Trees and Heuristics for Query Optimization; Choice of Query Execution Plans; Cost-Based Optimization.

Read Notes
Chapter 412 Pages

Distributed Databases, NOSQL Systems, and BigData

Distributed Database Concepts and Advantages, Data Fragmentation, Replication and Allocation Techniques for Distributed Database Design, Types of Distributed Database Systems.

Read Notes
Chapter 55 Pages

Advanced Database Models, Systems, and Applications

Active Database Concepts and Triggers, Temporal Database Concepts, Spatial Database Concepts, Multimedia Database Concepts, Deductive Database Concepts.

Read Notes

Related Study Resources for Advanced Database (CSC475)

Subject HubAdvanced Database (CSC475)Official CurriculumAdvanced Database SyllabusTU Board PapersAdvanced Database Past QuestionsSemester Directory8th Sem Subjects