Distributed and Object Oriented Database

Course Title: Distributed and Object Oriented Database

Course No: CSC480

Nature of the Course: Theory + Lab

Semester: 8

Full Marks: 60 + 20 + 20

Pass Marks: 24 + 8 + 8

Credit Hours: 3

Course Description

This course aims to discuss concepts of distributed and object oriented database management systems. Main focus is given to basic concepts of DDBMS, distributed database design, distributed query processing, distributed concurrency control, concepts of OODBMS, and language and design of object oriented database.

Course Objectives

The main objectives of this course are to:

Discuss basic concepts related to distributed DBMS
Exemplify design of distributed database
Describe distributed query processing and concurrency control
Discuss basic concepts of OODBMS
Demonstrate language and design for distributed database

Course Contents

1. Introduction to Distributed Database

4 hrs

1.1. Distributed Data Processing

1.2. Distributed Database Systems

1.3. Promises of DDBS

1.4. Complicating Factors

1.5. Design Issues of DDBMS

1.6. Distributed DBMS Architectures: Autonomy, Distribution, Heterogeneity DDBMS Architecture – Client/Server, Peer to peer, MDBS

2. Distributed Database Design and Access Control

4 hrs

2.1. Top-Down Design Process

2.2. Distribution Design Issues

2.8. Semantic Integrity Control

3. Query Processing, Decomposition, and Localization

6 hrs

3.1. Query Processing Problem

3.2. Objectives of Query processing

3.3. Complexity of RA Operations

3.4. Characterization of Query Processors

3.5. Layers of Query Processing

3.6. Query Decomposition

3.7. Localization of Distributed Data

4. Distributed Concurrency Control

8 hrs

4.1. Serializability Theory

4.2. Taxonomy of Concurrency Control Mechanisms

4.3. Lock Based Concurrency Control Algorithms

4.4. Time-Stamp Based Concurrency Control Algorithms

4.5. Optimistic Concurrency Control Algorithms

4.6. Deadlock management

5. Object Oriented Database Concepts

6 hrs

5.1. Overview of Object-Oriented Concepts

5.2. Object Identity, Object Structure, and Type Constructors

5.3. Encapsulation of Operations, Methods, and Persistence

5.4. Type Hierarchies and Inheritance

5.5. Complex Objects

5.6. Other Objected-Oriented Concepts

6. OODBMS Languages and Design

6 hrs

6.1. Object Model

6.2. Object Definition Language

6.3. Object Query Language

6.4. Object Database Conceptual Design

6.5. Examples of ODBMSs

Laboratory Works

Students should implement all the concepts of object oriented and distributed databases mentioned in the course.

Text Books

1.M. Tamer Özsu and Patrick Valduriez, Principles of Distributed Database Systems, Fourth Edition, Springer, 2019.
2.ElmasriRamez and NavatheShamkant, Fundamentals of Database System, Seventh Edition, Pearson Education, 2017.

Notes:

This syllabus follows the official BSC-CSIT curriculum of Tribhuvan University. In case of any doubt or revision, the university's published syllabus shall be considered authoritative.

Distributed & Object Oriented Database

Distributed & Object Oriented Database

Select University

Select Program

TabFlux . Distributed and Object Oriented Database . TU . BSC-CSIT

Distributed and Object Oriented Database

Course Description

Course Objectives

Course Contents

Laboratory Works

Text Books

Notes: