SPPU · Third Year Information Technology · 2024 Pattern
Advanced Database Management System
PEC-321B-IT · Elective I · Semester V · 3 credits · CCE 30 + end-semester 70
One of the Elective I options.
Unit 1: Parallel and Distributed Databases
9 hoursIntegrity constraints; shared-memory, shared-disk and shared-nothing parallel architectures; distributed storage, horizontal and vertical fragmentation, catalogs, distributed query processing and concurrency control.
Marks: 14 in the end-semester exam · CCE: Unit test (12 marks, Units 1 & 2)
- Parallel database architectures
- Distributed databases and data storage
- Horizontal and vertical fragmentation
- Distributed query processing
- Distributed concurrency control
Unit 2: NoSQL and MongoDB
9 hoursLimits of relational databases; key-value, document, column-family and graph stores; MongoDB architecture and collections; CRUD with insertOne, find, updateMany and deleteMany; indexing.
Marks: 14 in the end-semester exam · CCE: Unit test (12 marks, Units 1 & 2)
- Limitations of relational databases
- Types of NoSQL databases
- MongoDB architecture and collections
- MongoDB CRUD operations
- Indexing in MongoDB
Unit 3: Advanced NoSQL and Vector Databases
9 hoursColumn stores and Cassandra's architecture; graph databases and Neo4j; from NoSQL to vector databases, embeddings and high-dimensional retrieval.
Marks: 14 in the end-semester exam · CCE: Assignments or case study (12 marks, Units 3 & 4)
- Column-oriented databases and Cassandra
- Graph databases and Neo4j
- Vector databases and embeddings
Unit 4: Cloud Data Warehousing
9 hoursData-warehouse architecture; star, snowflake and fact-constellation schemas; ROLAP, MOLAP and HOLAP; ETL; cloud warehouses such as Snowflake and BigQuery.
Marks: 14 in the end-semester exam · CCE: Assignments or case study (12 marks, Units 3 & 4)
- Data warehouse architecture
- Star, snowflake and fact constellation schemas
- OLAP: ROLAP, MOLAP and HOLAP
- ETL
- Cloud data warehouses
Unit 5: Streams, Time Series and Specialised Models
9 hoursEvent streaming with Kafka; time-series databases for IoT; spatial and GIS data; active databases and triggers; the KDD process with cloud ML tools.
Marks: 14 in the end-semester exam · CCE: Seminar, open-book test or quiz (6 marks, Unit 5)
- Stream processing with Kafka
- Time-series databases
- Spatial databases and GIS data
- Active databases and the KDD process
Unit contents are summarised from the official SPPU syllabus . AiCanCode.org is not affiliated with Savitribai Phule Pune University.