Distributed and Object Oriented Database - Syllabus

Embark on a profound academic exploration as you delve into the Distributed and Object Oriented Database course () within the distinguished Tribhuvan university's CSIT department. Aligned with the 2065 Syllabus, this course (CSC-457) seamlessly merges theoretical frameworks with practical sessions, ensuring a comprehensive understanding of the subject. Rigorous assessment based on a 60 marks system, coupled with a challenging passing threshold of , propels students to strive for excellence, fostering a deeper grasp of the course content.

This 3 credit-hour journey unfolds as a holistic learning experience, bridging theory and application. Beyond theoretical comprehension, students actively engage in practical sessions, acquiring valuable skills for real-world scenarios. Immerse yourself in this well-structured course, where each element, from the course description to interactive sessions, is meticulously crafted to shape a well-rounded and insightful academic experience.

This course introduces fundamental concept and implementation of object oriented and distributed database systems with focus on data distribution, query processing, transaction processing, concurrency control and recovery.

Unit 1

1.1   Introduction to Distributed Database: Distributed Data Processing, Concepts of Distributed     Database. Distributed vs. Centralized Database System; advantage and application. Transparency, performance and reliability, Problem areas of Distributed Database.  Integrity Constraints in Distributed databases.

1.2   Distributed Database Architectures : DBMS standardization,  Architectural models for Distributed DBMS – autonomy, distribution and heterogeneity, Distributed  Database architecture – Client/Server , Peer – to – peer distributed systems, MDBMS Architecture, Distributed Catalog management.

1.3   Distributed Database Design: Design strategies and issues. Data Replication. Data Fragmentation – Horizontal, Vertical and Mixed. Resource allocation. Semantic Data Control in Distributed DBMS.

Unit 2

2.1   Distributed Query Processing: Query Decomposition and Data localization for distributed data, join ordering, semi-join strategy, Distributed Query Optimization methods.

2.2   Distributed Transaction Management: The concept and role of the transaction. Properties of transactions-Atomicity, Consistency, Isolation and Durability. Architectural aspects of Distributed Transaction, Transaction Serialization.

2.3   Distributed Concurrency Control: Lock-based and Timestamp-based Concurrency Control methods. Optimistic method for Concurrency Control. Deadlock management – prevention, avoidance detection, and resolution. Non-serializable schedule and nested distributed transaction.

2.4   Reliability of Distributed DBMS and Recovery: Concept and measures of reliability, Failure analysis, types of failures. Distributed Reliability Protocols. Recovery techniques. Two Phase Commit, Presumed abort, Presumed commit. Three phase commit, Partitions, Scalability of Replication.

Unit 3

3.1   Object Oriented Database Concept: Data types and Object, Evolution of Object Oriented Concepts, Characteristics of Object Oriented Data Model. Object Hierarchies – Generalization, Specialization, Aggregation. Object Schema. Enter-object Relationships, Similarities and difference between Object Oriented Database model and Other Data models.

3.2   OODBMS Architecture Approach: The Extended Relational Model Approach. Semantic Database Approach, Object Oriented Programming Language Extension Approach, DBMS Generator Approach, the Object Definition Language and the Object Query Language.

3.3   The Object Oriented DBMS Architecture, Performance Issue in Object Oriented DBMS, Application Selection for Object Oriented DBMS, the Database Design for an Object Relational DBMS. The Structured Types and ADTs, Object identity, Extending the ER Model, Storage and Access Methods, Query Processing, Query Optimization, Data Access API (ODBC, DB Library, DAO, ADO, JDBC, OLEDB), Distributed Computing Concept in Com, COBRA.

All distributed and OO database components mentioned in this course. (Practical implementation in Oracle 9i or Oracle 10g covering both Distributed and Object Oriented Database Features)