Scribd
Upload
35 views1 page

Dbms (Advanced)

The document outlines the course CSN-511: Advanced Database Management Systems offered by the Indian Institute of Technology Roorkee's Computer Science and Engineering department. It includes details such as contact hours, examination duration, credits, prerequisites, course objectives, and a breakdown of course content. The course covers advanced database concepts, concurrency control, recovery systems, distributed databases, advanced data types, and applications in data mining.

Uploaded by

singh.nitrr.ik
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
35 views1 page

Dbms (Advanced)

The document outlines the course CSN-511: Advanced Database Management Systems offered by the Indian Institute of Technology Roorkee's Computer Science and Engineering department. It includes details such as contact hours, examination duration, credits, prerequisites, course objectives, and a breakdown of course content. The course covers advanced database concepts, concurrency control, recovery systems, distributed databases, advanced data types, and applications in data mining.

Uploaded by

singh.nitrr.ik
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

INDIAN INSTITUTE OF TECHNOLOGY ROORKEE

NAME OF DEPT/CENTRE: Computer Science and Engineering

1. Subject Code: CSN-511 Course Title: Advanced Database Management


Systems

2. Contact Hours: L: 3 T: 1 P: 0

3. Examination Duration (Hrs.): Theory 33 Practical 0

4. Relative Weight: CWS 15 PRS 0


MT MTE 35 ETE 50 PRE 0

5. Credits: 4 6. Semester: Spring

7. Subject Area: MSC/DHC

8. Pre-requisite: CSN-351

9. Objective: To e ducate s tudents a bout a dvanced c oncepts pe rtaining t o da tabases,


database management systems and their applications

10. Details of the Course:

Sl. Contents Contact


No. Hours
1. Review of D BMS co ncepts; Relational da tabase systems, 3
applications of DBMS.
2. Transactions & Serializability: Concurrent executions, 6
Serializability View and conflict serializability, Recoverability,
3. Concurrency Control: Lock based protocols, timestamp based 6
protocols, validation based protocols, deadlock handling, insert
and delete operations
4. Recovery System: Failure classification, recovery and atomicity, 6
log based recovery, shadow paging, buffer management, remote
backup systems
5. Distributed Databases: H omogeneous and he terogeneous 6
databases, di stributed t ransactions, c ommit pr otocols,
concurrency control in distributed databases
6. Advanced Data T ypes: T ime i n da tabases, s patial and 5
geographic databases, multimedia databases
7. Advanced applications : Knowledge discovery and data mining, 6
data mining functionalities, classification of data mining
systems, data warehousing concepts, slicing, dicing, schemas,
data warehouse architecture, introduction to Data Mining Query
Language (DMQL)
8. Study of typical DBMS packages. 4
Total 42

You might also like