Advanced Database Management System syllabus
2019 PATTERN. This is the 2019 pattern syllabus, the latest SPPU has published on its site for Third Year Information Technology. A 2024 pattern syllabus for this year has not been published there yet, so confirm with your college which pattern applies to you.
314445B · Third Year Information Technology, SPPU 2019 pattern. Every unit, the marks scheme, course outcomes and books, copied from the official syllabus PDF.
Unit-wise syllabus
Review of Relational Data Model and Relational Database Constraints
6 hoursRelational model concepts, Relational model constraints and relational database schemas, Update operations, anomalies, dealing with constraint violations, Types and violations. Overview of Object- Oriented Concepts – Objects, Basic properties. Advantages, examples, Abstract data types, Encapsulation, class hierarchies, polymorphism examples.
Parallel and Distributed Databases
6 hoursIntroduction to Parallel Databases, Architectures for parallel databases, Parallel query evaluation Parallelizing individual operations, Parallel query optimizations. Introduction to distributed databases, Distributed DBMS architectures, storing data in a Distributed DBMS, Distributed catalog management, Distributed Query processing, Updating distributed data, Distributed transactions, Distributed Concurrency control and Recovery. TE (Information Technology) Syllabus (2019 Course) 24 Curriculum for Third Year of Information Technology (2019 Course), Savitribai Phule Pune University
NoSQL Databases
6 hoursIntroduction, Overview, and History of NoSQL Databases- The definition of Four Types of No SQL Databases. NoSQL Key/Value Database: MongoDB, Column-Oriented Database: Apache Cassandra, Comparison of Relational and NoSQL databases, NoSQL database Development Tools (Map Reduce/Hive) and Programming Languages (XML/JSON)
Data Warehousing
6 hoursArchitectures and components of data warehouse, Characteristics and limitations of data warehouse, Data warehouse schema (Star, Snowflake), OLAP Architecture (ROLAP/MOLAP/HOLAP), Introduction to decision support system, Views and Decision support
Data Mining
6 hoursIntroduction to Data Mining, KDD seven step process, Architecture of data mining, Introduction to predictive and descriptive algorithms, Data mining software and applications
Enhanced Data Models for Advanced Applications
6 hoursActive database concepts and triggers; Temporal, Spatial, and Deductive Databases – Basic concepts. More Recent Applications: Mobile databases; Multimedia databases; Geographical Information Systems; Genome data management.
Marks and credits
| Head | Marks | Credit |
|---|---|---|
| Mid-Sem (mid-semester exam) | 30 | 3 |
| End-semester exam | 70 |
Prerequisite: 1. Database Management System.
Course outcomes
- CO1Differentiate relational and object-oriented databases.
- CO2Illustrate parallel & distributed database architectures.
- CO3Apply concepts of NoSQL Databases.
- CO4Explain concepts of data warehouse and OLAP technologies.
- CO5Apply data mining algorithms and various software tools.
- CO6Comprehend emerging and enhanced data models for advanced applications.
Books
Text books
- Silberschatz A., Korth H., Sudarshan S, Database System Concepts, McGraw Hill Publication, ISBN-0-07-120413-X, Sixth Edition.
- S. K. Singh, Database Systems: Concepts, Design and Application, Pearson Publication, ISBN-978- 81-317-6092-5.
Reference books
- Kristina Chodorow, Michael Dirolf, “MongoDB: The Definitive Guide”, O’Reilly Publications
- Jiawei Han, Micheline Kamber, Jian Pei, “Data Mining: Concepts and Techniques”, Elsevier
- Mario Piattini, Oscar Diaz “Advanced Database Technology and Design”- online book.
- M. Tamer Özsu, Patrick Valduriez, “Principles of Distributed Database Systems” Prentice Hall,
- 5. Ramez Elmasri and Shamkant B. Navathe “Fundamentals of Database System”7th Edition
FAQ
How many units are in Advanced Database Management System?
Advanced Database Management System (314445B) has 6 units: Unit I Review of Relational Data Model and Relational Database Constraints (6 h); Unit II Parallel and Distributed Databases (6 h); Unit III NoSQL Databases (6 h); Unit IV Data Warehousing (6 h); Unit V Data Mining (6 h); Unit VI Enhanced Data Models for Advanced Applications (6 h).
What is the marks scheme for Advanced Database Management System?
The official Information Technology 2019 pattern syllabus lists mid-semester (Mid-Sem) for 30 marks and the end-semester exam for 70 marks, for 3 credits.
What should I know before Advanced Database Management System?
Prerequisite listed in the syllabus: 1. Database Management System.