Distributed and Object Oriented Database - Syllabus
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-1Overview of E-commerce and its significance in the digital age.
-
E-business vs E-commerce
IN-2Understanding the differences between E-business and E-commerce.
-
Features of E-commerce
IN-3Key characteristics and benefits of E-commerce.
-
Pure vs Partial E-commerce
IN-4Types of E-commerce models and their applications.
-
History of E-commerce
IN-5Evolution and development of E-commerce over time.
-
E-commerce Framework
IN-6Understanding the components of E-commerce framework including People, Public Policy, Marketing and Advertisement, Support Services, and Business Partnerships.
-
Types of E-commerce
IN-7Overview 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-8Common obstacles and difficulties faced in E-commerce.
-
Status of E-commerce in Nepal
IN-9Current state and trends of E-commerce in Nepal.
-
Overview of Electronic Transaction Act of Nepal
IN-10Understanding the legal framework governing E-commerce in Nepal.
-
Software Engineering Ethics
IN-11Ethical considerations and principles in software engineering, including accountability, privacy, and intellectual property.
-
Distributed Computing in Grid and Cloud
IN-12Exploring the role of distributed computing in grid and cloud environments, including its applications and benefits.
-
Trends in Data Warehousing
IN-13Current and emerging trends in data warehousing, including big data, cloud computing, and real-time analytics.
-
Male vs. Female Entrepreneurship
IN-14Comparing and contrasting the experiences, challenges, and opportunities faced by male and female entrepreneurs. Understanding the implications for entrepreneurial success.
-
Entrepreneur vs. Inventor
IN-15Distinguishing between entrepreneurs and inventors. Understanding the differences in their roles, skills, and contributions to innovation and business growth.
-
Semantic Data Control
IN-16This topic explains the concept of semantic data control in distributed DBMS.
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 transaction.
Properties of transactions-Atomicity, Consistency, Isolation and Durability.
Architectural aspects of Distributed Transaction, Transaction Serialization.
2.3 DistributedConcurrency 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.
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. Inter-
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 Typed 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.
Lab works
Students should implement all the concepts of object oriented and distributed databases mentioned
in the course.