Distributed and Object-Oriented Database (CSC480) — Notes, Syllabus & Past Questions

Study of non-relational and multi-site database management.

Elective Course6 Chapters
Chapter 1Past Questions

Introduction to Distributed Database

Distributed Data Processing, Distributed Database Systems, Promises of DDBS, Complicating Factors, Design Issues of DDBMS, and Distributed DBMS Architectures: Autonomy, Distribution.

View Questions
Chapter 2Past Questions

Distributed Database Design and Access Control

Top-Down Design Process, Distribution Design Issues, Fragmentation, Allocation, Data Directory, View Management, Data Security, Semantic Integrity Control.

View Questions
Chapter 3Past Questions

Query Processing, Decomposition, and Localization

Query Processing Problem, Objectives of Query processing, Complexity of RA Operations, Characterization of Query Processors, Layers of Query Processing, Query Decomposition.

View Questions
Chapter 4Past Questions

Distributed Concurrency Control

Serializability Theory, Taxonomy of Concurrency Control Mechanisms, Lock Based Concurrency Control Algorithms, Time-Stamp Based Concurrency Control Algorithms.

View Questions
Chapter 5Past Questions

Object Oriented Database Concepts

Overview of Object-Oriented Concepts, Object Identity, Object Structure, and Type Constructors, Encapsulation of Operations, Methods, and Persistence, Type Hierarchies and Inheritance, Complex Objects.

View Questions
Chapter 6Past Questions

OODBMS Languages and Design

Object Model, Object Definition Language, Object Query Language, Object Database Conceptual Design, Examples of ODBMSs.

View Questions