SPPU TE IT syllabus

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.

All notes for this subject
  1. Unit 1: Parallel and Distributed Databases

    9 hours

    Integrity 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
  2. Unit 2: NoSQL and MongoDB

    9 hours

    Limits 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
  3. Unit 3: Advanced NoSQL and Vector Databases

    9 hours

    Column 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
  4. Unit 4: Cloud Data Warehousing

    9 hours

    Data-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
  5. Unit 5: Streams, Time Series and Specialised Models

    9 hours

    Event 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.