SPPU TE Computer syllabus

SPPU · Third Year Computer Engineering · 2024 Pattern

Advanced Databases

PEC362DCOM · Elective III · Semester VI · 3 credits · CCE 30 + end-semester 70

One of the Elective III options.

All notes for this subjectSQL lessons
  1. Unit 1: Introduction, Basic Concepts and Advanced DBMS Architecture

    9 hours

    Limits of traditional DBMS; centralised and two- and three-tier client–server architectures; fragmentation and replication; shared-memory, shared-disk and shared-nothing; cloud databases, DBaaS and multi-tenancy.

    Marks: 14 in the end-semester exam · CCE: Unit test (12 marks, Units 1 & 2)

    • Advanced DBMS needs and architectures
    • Client–server database architecture
    • Data fragmentation and replication
    • Parallel database architectures
    • Cloud databases and DBaaS
  2. Unit 2: Query Processing and Optimization

    9 hours

    Query cost, selection, sorting, joins, expression evaluation; transformations, statistics, evaluation plans, materialised views; parallel and distributed query processing.

    Marks: 14 in the end-semester exam · CCE: Unit test (12 marks, Units 1 & 2)

    • Query processing: selection, sorting and joins
    • Query optimisation and evaluation plans
    • Parallel and distributed query processing
  3. Unit 3: Transaction Management, Concurrency and Recovery

    9 hours

    Schedules, conflict and view serialisability, cascading rollback, recoverable, strict and rigorous schedules; lock-, timestamp- and validation-based protocols; log-based recovery, WAL, checkpoints, ARIES.

    Marks: 14 in the end-semester exam · CCE: Assignments or case study (12 marks, Units 3 & 4)

    • Schedules, serialisability and recoverability
    • Lock-based and timestamp-based concurrency control
    • Log-based recovery, WAL and checkpoints
    • ARIES recovery
  4. Unit 4: Advanced Database Models

    9 hours

    Parallel databases, speed-up, scale-up and forms of parallelism; distributed DBMS architectures, concurrency and query processing; XML, DTD, XML Schema, XPath, XQuery and FLWOR.

    Marks: 14 in the end-semester exam · CCE: Assignments or case study (12 marks, Units 3 & 4)

    • Parallel databases: speed-up and parallelism
    • Distributed databases
    • XML: schema, DTD, XPath and XQuery
  5. Unit 5: Database Security and Recent Trends

    9 hours

    CIA goals, authentication, authorisation and RBAC, encryption; audit trails, activity monitoring, SQL injection and insider threats; sanitisation, masking and anonymisation; NewSQL, cloud and NoSQL security.

    Marks: 14 in the end-semester exam · CCE: Seminar, open-book test or quiz (6 marks, Unit 5)

    • Database security: authentication, authorisation and encryption
    • Database auditing, threats and SQL injection
    • Data privacy: masking and anonymisation
    • NewSQL and modern database trends

Unit contents are summarised from the official SPPU syllabus . AiCanCode.org is not affiliated with Savitribai Phule Pune University.