{"id":24671,"date":"2020-07-20T07:40:21","date_gmt":"2020-07-20T07:40:21","guid":{"rendered":"https:\/\/www.inspirenignite.com\/jntuh\/advanced-databases-syllabus-for-mca-3rd-year-1st-sem-r19-regulation-jntuh-professional-elective-ii\/"},"modified":"2020-07-20T07:40:21","modified_gmt":"2020-07-20T07:40:21","slug":"advanced-databases-syllabus-for-mca-3rd-year-1st-sem-r19-regulation-jntuh-professional-elective-ii","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuh\/advanced-databases-syllabus-for-mca-3rd-year-1st-sem-r19-regulation-jntuh-professional-elective-ii\/","title":{"rendered":"Advanced Databases Syllabus for MCA 3rd Year 1st Sem R19 Regulation JNTUH (Professional Elective-II)"},"content":{"rendered":"<p align=\"justify\">Advanced Databases detailed Syllabus for Master of Computer Applications (MCA), R19 regulation has been taken from the <a href=\"https:\/\/jntuh.ac.in\/syllabus\/\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">JNTUH<\/a> 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.<\/p>\n<p align=\"justify\">For all the other MCA 3rd Year 1st Sem Syllabus for R19 Regulation JNTUH, visit <a href=\"..\/mca-3rd-year-1st-sem-syllabus-for-r19-regulation-jntuh\">Master of Computer Applications 3rd Year 1st Sem R19 Scheme<\/a>. <\/p>\n<p align=\"justify\">For all the (Professional Elective-II) subjects refer to <a href=\"..\/mca-3rd-year-1st-sem-professional-elective-ii-syllabus-for-r19-regulation-jntuh\">Professional Elective-II Scheme<\/a>. The detail syllabus for advanced databases is as follows.  <\/p>\n<h4>Course Objectives:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdfs platform to make students&#8217;s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&amp;pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>.  <\/p>\n<h4>Course Outcomes:<\/h4>\n<ol>\n<li>Understand theoretical and practical aspects of distributed database systems.<\/li>\n<li>Study and identify various issues related to the development of distributed database system.<\/li>\n<li>Understand the design aspects of object oriented database system and related development.<\/li>\n<\/ol>\n<h4>Unit I<\/h4>\n<p>  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.<\/p>\n<h4>Unit II<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdfs platform to make students&#8217;s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&amp;pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>.  <\/p>\n<h4>Unit III<\/h4>\n<p>  Transaction Management: Definition, properties of transaction, types of transactions, distributed concurrency control: serializability, concurrency control mechanisms and algorithms, time &#8211; stamped and optimistic concurrency control Algorithms, deadlock Management.<\/p>\n<h4>Unit IV<\/h4>\n<p>  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.<\/p>\n<h4>Unit V<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdfs platform to make students&#8217;s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&amp;pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>.  <\/p>\n<h4>Text Books:<\/h4>\n<ol>\n<li>M.Tamer OZSU and Patuck Valduriez: Principles of Distributed Database Systems, Pearson Edn. Asia, 2001.<\/li>\n<li>Stefano Ceri and Giuseppe Pelagatti: Distributed Databases, McGraw Hill.<\/li>\n<\/ol>\n<h4>Reference Books:<\/h4>\n<ol>\n<li>Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: Database Systems: The Complete Book,2nd Edition, Pearson International Edition<\/li>\n<\/ol>\n<p align=\"justify\">For detail Syllabus of all other subjects of 3rd Year 1st Sem Master of Computer Applications, visit <a href=\"..\/category\/mca+3rd-year\">MCA 3rd Year 1st Sem Syllabus<\/a> Subjects.<\/p>\n<p align=\"justify\">For all MCA results, visit <a href=\"https:\/\/www.inspirenignite.com\/jntuh\/jntuh-mca-results\/\">JNTUH MCA all years, and semester results <\/a>from direct links.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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. [&hellip;]<\/p>\n","protected":false},"author":2344,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[130],"tags":[],"class_list":["post-24671","post","type-post","status-publish","format-standard","hentry","category-mca"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/24671","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/users\/2344"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/comments?post=24671"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/24671\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/media?parent=24671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/categories?post=24671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/tags?post=24671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}