Distributed and Object Oriented Database - Syllabus

Course Overview and Structure

Embark on a profound academic exploration as you delve into the Distributed and Object Oriented Database course (DOOD) within the distinguished Tribhuvan university's CSIT department. Aligned with the 2074 Syllabus, this course (CSC466) seamlessly merges theoretical frameworks with practical sessions, ensuring a comprehensive understanding of the subject. Rigorous assessment based on a 60 + 20 + 20 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.


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:

    • Discuss basic concepts related to distribute 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.

Units

Key Topics

  • Introduction to E-commerce
    IN-1

    Overview of E-commerce and its significance in the digital age.

  • E-business vs E-commerce
    IN-2

    Understanding the differences between E-business and E-commerce.

  • Features of E-commerce
    IN-3

    Key characteristics and benefits of E-commerce.

  • Pure vs Partial E-commerce
    IN-4

    Types of E-commerce models and their applications.

  • History of E-commerce
    IN-5

    Evolution and development of E-commerce over time.

  • E-commerce Framework
    IN-6

    Understanding the components of E-commerce framework including People, Public Policy, Marketing and Advertisement, Support Services, and Business Partnerships.

  • Types of E-commerce
    IN-7

    Overview of different types of E-commerce including B2C, B2B, C2B, C2C, M-Commerce, U-commerce, Social-Ecommerce, and Local E-commerce.

  • Challenges in E-commerce
    IN-8

    Common obstacles and difficulties faced in E-commerce.

  • Status of E-commerce in Nepal
    IN-9

    Current state and trends of E-commerce in Nepal.

  • Overview of Electronic Transaction Act of Nepal
    IN-10

    Understanding the legal framework governing E-commerce in Nepal.

  • Software Engineering Ethics
    IN-11

    Ethical considerations and principles in software engineering, including accountability, privacy, and intellectual property.

  • Distributed Computing in Grid and Cloud
    IN-12

    Exploring the role of distributed computing in grid and cloud environments, including its applications and benefits.

  • Trends in Data Warehousing
    IN-13

    Current and emerging trends in data warehousing, including big data, cloud computing, and real-time analytics.

  • Male vs. Female Entrepreneurship
    IN-14

    Comparing and contrasting the experiences, challenges, and opportunities faced by male and female entrepreneurs. Understanding the implications for entrepreneurial success.

  • Entrepreneur vs. Inventor
    IN-15

    Distinguishing between entrepreneurs and inventors. Understanding the differences in their roles, skills, and contributions to innovation and business growth.

  • Semantic Data Control
    IN-16

    This topic explains the concept of semantic data control in distributed DBMS.

Key Topics

  • Distributed Database Concepts
    DI-1

    Introduction to distributed database concepts and their advantages.

  • Data Fragmentation, Replication and Allocation
    DI-2

    Techniques for data fragmentation, replication, and allocation in distributed databases.

  • Distributed Database Design Techniques
    DI-3

    Methods and approaches for designing distributed databases.

  • Types of Distributed Database Systems
    DI-4

    Overview of different types of distributed database systems.

Key Topics

  • Passing by Value and by Reference
    OB-10

    Understanding the difference between passing method parameters by value and by reference in Java.

  • Object Oriented Database Concept
    OB-1

    Introduction to object oriented database concepts, including data types, object evolution, and characteristics of object oriented data models.

  • Object Hierarchies
    OB-2

    Understanding object hierarchies, including generalization, specialization, and aggregation.

  • Object Schema and Inter-object Relationships
    OB-3

    Defining object schema and understanding inter-object relationships, similarities, and differences with other data models.

  • OODBMS Architecture Approach
    OB-4

    Overview of OODBMS architecture approaches, including extended relational model, semantic database, and object oriented programming language extension.

  • Object Oriented DBMS Architecture
    OB-5

    In-depth look at object oriented DBMS architecture, including performance issues, application selection, and database design.

  • Structured Typed and ADTs
    OB-6

    Understanding structured typed and abstract data types (ADTs) in object oriented DBMS.

  • Object Identity and Extending ER Model
    OB-7

    Concepts of object identity and extending the entity-relationship (ER) model in object oriented DBMS.

  • Storage and Access Methods
    OB-8

    Storage and access methods in object oriented DBMS, including query processing and optimization.

  • Data Access API
    OB-9

    Overview of data access APIs, including ODBC, DB Library, DAO, ADO, JDBC, and OLEDB.

Lab works

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