Advanced Database Management System - Syllabus

Embark on a profound academic exploration as you delve into the Advanced Database Management System course () within the distinguished Tribhuvan university's CSIT department. Aligned with the 2065 Syllabus, this course (CSC-401) 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.

Course Synopsis: To study the concept of advanced database techniques.

Goal: To study the further advanced database techniques beyond the fundamental database techniques which were covered in the sophomore year (fourth semester) BSc. CSIT course, and thus to acquaint the students with some relatively advanced issues. At the end of the course students should be able to: critically assess new developments in database technology, interpret and explain the impact of emerging database standards. Evaluate the contribution of database theory to practical implementation of database management systems.


The Relational Model of Data and RDBMS Implementation Techniques

Theoretical concepts, Relational model conformity and Integrity, Advanced SQL programming, Query optimization, Concurrency control and Transaction management, Database performance tuning, Distributed relational systems and Data Replication, Security considerations.

The extended Entity Relationship Model and Object Model

The ER model revisited, Motivation for complex data types, User defined abstract data types and structured types, Subclasses, Super classes, Inheritance, Specialization and Generalization, Constraints and Characteristics of specialization and Generalization, Relationship types of degree higher than two, Relational database design by EER-to- relational mapping, basic concepts on UML.

Emerging Database Management System Technologies

Object Oriented Database concepts: object identity, structure, and type constructors; encapsulation of operations, methods, and persistence; type and class hierarchies and inheritance; structures and unstructured complex objects and type extensibility; polymorphism, multiple inheritance and selective inheritance, versions and configurations;

Object Relational Database concepts: overview of SQL and its object-relational features (the SQL standard and its components, object-relational support in SQL-99); evolution and current trends of database technology (with respect to the features of the Informix Universal Server and Oracle8); implementation and related issues for extended type systems; the nested relational model;

Active database concepts: Generalized model for active databases and oracle Triggers; design and implement issues for active databases potential applications for active databases;

Temporal database concepts: Time representation, calendars, and time dimensions; incorporating time in relational databases using tuple versioning, incorporating time in object-oriented databases using attribute versioning, time series data;

Multimedia Databases: The nature of multimedia data and applications; spatial database concepts and architecture, introduction to multimedia database concepts;

Deductive databases and Query processing: Prolog/Datalog notations, clausal form and horn clauses; interpretations of rules;

Mobile Databases: Mobile computing architecture, characteristics of mobile environments, data management issues; Geographic Information Systems: GIS applications, data management requirements of GIS, specific GIS data operations.

New Database Applications and Environments

Data Mining: Overview of data mining technology (associated rules, classification, clustering), applications of data mining; Data Warehousing: Overview of data warehousing, typical functionality of a data warehouse;

Database Related Standards

SQL standards, SQL 1999, SQL 2003, Object Data Management Group (ODMG) version 3.0 standards (ODL, OQL), Standards for interoperability and integration e.g. Web Services, SOAP, XML related specifications, e.g. XML Documents, DTD, XML Schema, X-Query, X- Path.

Lab works

The course involves a mini project using any one of the popular Commercial Object-Oriented DBMS software such as Oracle, MS SQL Server etc., along with any MVC software development framework.