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.
Unit 1: Introduction, Basic Concepts and Advanced DBMS Architecture
9 hoursLimits 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
Unit 2: Query Processing and Optimization
9 hoursQuery 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
Unit 3: Transaction Management, Concurrency and Recovery
9 hoursSchedules, 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
Unit 4: Advanced Database Models
9 hoursParallel 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
Unit 5: Database Security and Recent Trends
9 hoursCIA 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.