This page contains Syllabus of Advanced Database Management System of CSIT.
|Title||Advanced Database Management System|
|Nature of course||Theory + Lab|
|Full marks||60 + 20 + 20|
|Pass marks||24 + 8 + 8|
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.
Units and Unit Content
- 1. The Relational Model of Data and RDBMS Implementation Techniques
- teaching hours: 5 hrs
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.
- 2. The extended Entity Relationship Model and Object Model
- teaching hours: 6 hrs
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.
- 3. Emerging Database Management System Technologies
- teaching hours: 18 hrs
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.
- 4. New Database Applications and Environments
- teaching hours: 8 hrs
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;
- 5. Database Related Standards
- teaching hours: 8 hrs
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 and Practical works
Laboratory Projects: 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.