{"id":8879,"date":"2018-08-23T19:57:45","date_gmt":"2018-08-23T19:57:45","guid":{"rendered":"https:\/\/www.inspirenignite.com\/jntuh\/?p=8879"},"modified":"2021-10-27T22:48:14","modified_gmt":"2021-10-27T22:48:14","slug":"jntuh-m-tech-2017-2018-r17-detailed-syllabus-database-internals","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuh\/jntuh-m-tech-2017-2018-r17-detailed-syllabus-database-internals\/","title":{"rendered":"JNTUH M.Tech 2017-2018 (R17) Detailed Syllabus Database Internals"},"content":{"rendered":"<p>Database Internals Detailed Syllabus for Web Technology M.Tech first year first sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course.<\/p>\n<p>The detailed syllabus for Database Internals M.Tech 2017-2018 (R17) first year first sem is as follows.<\/p>\n<p>M.Tech. I Year I Sem.<\/p>\n<p><strong>Course Objectives:<\/strong> By the end of the course, student will know:<\/p>\n<ul>\n<li>History and Structure of databases<\/li>\n<li>How to design a database<\/li>\n<li>How to convert the design into the appropriate tables<\/li>\n<li>Handling Keys appropriately<\/li>\n<li>Enforcing Integrity Constraints to keep the database consistent<\/li>\n<li>Normalizing the tables to eliminate redundancies<\/li>\n<li>Querying relational data<\/li>\n<li>and processing the queries<\/li>\n<li>Storage Optimizing Strategies for easy retrieval of data through index<\/li>\n<li>Triggers, Procedures and Cursors ,Transaction Management<\/li>\n<li>Distributed databases management system concepts and Implementation<\/li>\n<\/ul>\n<p><strong>UNIT &#8211; I :\u00a0<\/strong>Database System Applications, Purpose of Database Systems, View of Data \u2013 Data Abstraction, Instances and Schemas, Data Models \u2013 the ER Model, Relational Model, Other Models \u2013 Database Languages \u2013 DDL, DML, Database Access from Applications Programs, Transaction Management, Data Storage and Querying, Database Architecture, Database Users and Administrators, ER diagrams,. Relational Model: Introduction to the Relational Model \u2013 Integrity Constraints Over Relations, Enforcing Integrity constraints, Querying relational data, Logical data base Design, Introduction to Views \u2013Altering Tables and Views, Relational Algebra, Basic SQL Queries, Nested Queries, Complex Integrity Constraints in SQL, Triggers<\/p>\n<p><strong>UNIT &#8211; II :<\/strong> Introduction to Schema Refinement \u2013 Problems Caused by redundancy, Decompositions \u2013 Problem related to decomposition, Functional Dependencies &#8211; Reasoning about FDS, Normal Forms \u2013 FIRST, SECOND, THIRD Normal forms \u2013 BCNF \u2013Properties of Decompositions- Loss less- join Decomposition, Dependency preserving Decomposition, Schema Refinement in Data base Design \u2013 Multi valued Dependencies \u2013 FOURTH Normal Form, Join Dependencies, FIFTH Normal form.<\/p>\n<p><strong>UNIT &#8211; III :<\/strong> Transaction Management: The ACID Properties, Transactions and Schedules, Concurrent Execution of Transactions \u2013 Lock Based Concurrency Control, Deadlocks \u2013 Performance of Locking \u2013 Transaction Support in SQL. Concurrency Control: Serializability, and recoverability \u2013 Introduction to Lock Management \u2013 Lock<br \/>\nConversions, Dealing with Deadlocks, Specialized Locking Techniques \u2013 Concurrency Control without Locking. Crash recovery: Introduction to Crash recovery, Introduction to ARIES, the Log, and Other Recovery related Structures, the Write-Ahead Log Protocol, Check pointing, recovering from a System Crash, Media recovery<\/p>\n<p><strong>UNIT &#8211; IV :<\/strong> Overview of Storage and Indexing: Data on External Storage, File Organization, and Indexing \u2013 Clustered Indexes, Primary and Secondary Indexes, Index data Structures \u2013 Hash Based Indexing, Tree based Indexing, Storing data: Disks and Files: -The Memory Hierarchy \u2013 Redundant Arrays of Independent Disks. Tree Structured Indexing: Intuitions for tree Indexes, Indexed Sequential Access Methods (ISAM), B+ Trees: A Dynamic Index Structure, Search, Insert, Delete. Hash Based Indexing: Static Hashing, Extendable hashing, Linear Hashing, Extendable Vs Linear Hashing.<\/p>\n<p><strong>UNIT &#8211; V :<\/strong> Distributed databases: Introduction to distributed databases, Distributed DBMS architectures, Storing data in a distributed DBMS, Distributed catalog management, Distributed query processing Updating distributed data, Distributed transactions, Distributed concurrency control, Distributed recovery<\/p>\n<p><strong>TEXT BOOKS:<\/strong><\/p>\n<ul>\n<li>Data base Management Systems, Raghu Ramakrishnan, Johannes Gehrke, TMH, 3rd Edition, 2003.<\/li>\n<li>Data base System Concepts, A. Silberschatz, H.F. Korth, S. Sudarshan, McGraw hill, VI edition, 2006.<\/li>\n<li>Fundamentals of Database Systems 5th edition, Ramez Elmasri, Shamkant B. Navathe, Pearson Education, 2008.<\/li>\n<\/ul>\n<p><strong>REFERENCE BOOKS:<\/strong><\/p>\n<ul>\n<li>Introduction to Database Systems, C.J. Date, Pearson Education.<\/li>\n<li>Database Management System Oracle SQL and PL\/SQL, P.K. Das Gupta, PHI.<\/li>\n<li>Database System Concepts, Peter Rob, &amp; Carlos Coronel, Cengage Learning, 2008.<\/li>\n<li>Database Systems, A Practical approach to Design Implementation and Management Fourth edition, Thomas Connolly, Carolyn Begg, Pearson education.<\/li>\n<li>Database-Principles, Programming and Performance, P. O\u2019Neil &amp; E. O\u2019Neil, 2nd ed, ELSEVIER<\/li>\n<li>Fundamentals of Relational Database Management Systems, S. Sumathi, S. Esakkirajan, Springer.<\/li>\n<li>Introduction to Database Management, M.L. Gillenson and others, Wiley Student Edition.<\/li>\n<li>Database Development and Management, Lee Chao, Auerbach publications, Taylor &amp; Francis Group.<\/li>\n<li>Distributed Databases Principles &amp; Systems, Stefano Ceri, Giuseppe Pelagatti, TMH.<\/li>\n<li>Principles of Distributed Database Systems, M. Tamer Ozsu, Patrick Valduriez , Pearson Education, 2nd Edition.<\/li>\n<li>Distributed Database Systems, Chhanda Ray, Pearson<\/li>\n<\/ul>\n<p>For all other M.Tech 1st Year 1st Sem syllabus go to <a href=\"https:\/\/www.inspirenignite.com\/jntuh\/jntuh-first-year-first-sem-web-technology-for-m-tech-2017-2018-r17-batch\/\">JNTUH M.Tech Web Technology 1st Year 1st Sem Course Structure for (R17) Batch.<\/a><\/p>\n<p>All details and yearly new syllabus will be updated here time to time. Subscribe, like us on facebook and follow us on google plus for all updates.<\/p>\n<p>Do share with friends and in case of questions please feel free drop a comment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Internals Detailed Syllabus for Web Technology M.Tech first year first sem is covered here. This gives the details about credits, number of hours and other details along with reference [&hellip;]<\/p>\n","protected":false},"author":2259,"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":[73,62],"tags":[],"class_list":["post-8879","post","type-post","status-publish","format-standard","hentry","category-m-tech","category-syllabus"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/8879","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\/2259"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/comments?post=8879"}],"version-history":[{"count":2,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/8879\/revisions"}],"predecessor-version":[{"id":13880,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/8879\/revisions\/13880"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/media?parent=8879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/categories?post=8879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/tags?post=8879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}