Advanced Databases detailed Syllabus for Master of Computer Applications (MCA), R19 regulation has been taken from the JNTUH official website and presented for the students affiliated to JNTUH course structure. For Course Code, Subject Names, Theory Lectures, Tutorial, Practical/Drawing, Credits, and other information do visit full semester subjects post given below. The Syllabus PDF files can also be downloaded from the universities official website.
For all the other MCA 3rd Year 1st Sem Syllabus for R19 Regulation JNTUH, visit Master of Computer Applications 3rd Year 1st Sem R19 Scheme.
For all the (Professional Elective-II) subjects refer to Professional Elective-II Scheme. The detail syllabus for advanced databases is as follows.
Course Objectives:
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Course Outcomes:
- Understand theoretical and practical aspects of distributed database systems.
- Study and identify various issues related to the development of distributed database system.
- Understand the design aspects of object oriented database system and related development.
Unit I
Introduction; Distributed Data Processing, Distributed Database System, Promises of DDBSs, Problem areas. Distributed DBMS Architecture: Architectural Models for Distributed DBMS, DDMBS Architecture. Distributed Database Design: Alternative Design Strategies, Distribution Design issues, Fragmentation, Allocation.
Unit II
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Unit III
Transaction Management: Definition, properties of transaction, types of transactions, distributed concurrency control: serializability, concurrency control mechanisms and algorithms, time – stamped and optimistic concurrency control Algorithms, deadlock Management.
Unit IV
Distributed DBMS Reliability: Reliability concepts and measures, fault-tolerance in distributed systems, failures in Distributed DBMS, local and distributed reliability protocols, site failures and network partitioning. Parallel Database Systems: Parallel database system architectures, parallel data placement, parallel query processing, load balancing, database clusters.
Unit V
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Text Books:
- M.Tamer OZSU and Patuck Valduriez: Principles of Distributed Database Systems, Pearson Edn. Asia, 2001.
- Stefano Ceri and Giuseppe Pelagatti: Distributed Databases, McGraw Hill.
Reference Books:
- Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: Database Systems: The Complete Book,2nd Edition, Pearson International Edition
For detail Syllabus of all other subjects of 3rd Year 1st Sem Master of Computer Applications, visit MCA 3rd Year 1st Sem Syllabus Subjects.
For all MCA results, visit JNTUH MCA all years, and semester results from direct links.