Part-II
Teaching scheme:
Lectures: 4 hrs/week
Practicals: 2 hrs/week
Examination scheme:
Theory paper: 100 Marks
Term Work: 25 Marks
Oral Exam:
Section – I
1. Object-Relational Databases – Nested relations, complex types, inheritances, reference types, querying with complex types, functions and procedures, OO versus Object-Relational. - (5)
2. Database Systems architectures – centralized & C/S architectures, server systems, distributed systems, networks types. - (5)
3. Distributed databases – Homogeneous & heterogeneous databases, distributed data storage, distributed transactions, commit protocols, concurrency control in distributed databases, availability, distributed query processing, heterogeneous distributed databases, directory systems. - (6)
4. Parallel Databases – Integrated, I/O parallelism, inter-query parallelism, intraquery parallelism, intra-operation parallelism, inter-operation parallelism, design of parallel systems. - (6)
Section – II
5. Application development & Administration – Web interfaces to databases, performance tuning, performance benchmarks, standardization, E-commerce, Legacy systems. - (8)
6. Advanced Querying & Information Retrieval – Decision support systems, data analysis and OLAP, Data mining, data-warehousing, Information retrieval systems. - (8)
7. Advanced transaction processing – Transaction-processing monitors, transactional workflows, main-memory databases, real-time transaction systems, long-duration transactions, transaction management in multi-databases. - (6)
Books:
1. Database system concepts – Silberschatz, Korth, Sudarshan – 4th Edi (MGH International Edition).
2. Database Management System – Raghu Ramkrishnan (MGH)
Term Work : It should consist of 8-10 assignments, out of which
a) 7-8 assignments should be based on above syllabus topics AND
b) 1-2 assignment should be based on Oracle / DB2 / MS SQL Server as case studies.
Reference www.unishivaji.ac.in/
|
No responses found. Be the first to respond...
|