{"id":358,"date":"2016-11-04T15:12:41","date_gmt":"2016-11-04T15:12:41","guid":{"rendered":"http:\/\/www.inspirenignite.com\/anna-university\/?p=358"},"modified":"2019-07-17T07:13:56","modified_gmt":"2019-07-17T07:13:56","slug":"anna-university-b-tech-it-r13-6th-advanced-database-technology-detailed-syllabus","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/anna-university-b-tech-it-r13-6th-advanced-database-technology-detailed-syllabus\/","title":{"rendered":"Anna University B.Tech IT (R13) 6th Advanced Database Technology Detailed Syllabus"},"content":{"rendered":"<p>Advanced Database Technology Syllabus for B.Tech 6th 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 Advanced Database Technology B.Tech (R13) sixthsem is as follows<\/p>\n<p><strong>OBJECTIVES:<\/strong> The student should be made to:<\/p>\n<ul>\n<li>Be familiar with a commercial relational database system (Oracle) by writing SQL using the system.<\/li>\n<li>Be familiar with the relational database theory, and be able to write relational algebra expressions for queries.<\/li>\n<\/ul>\n<p><strong>UNIT I : PARALLEL AND DISTRIBUTED DATABASES \u00a0<\/strong> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 [9 hours]<\/p>\n<p>Database System Architectures: Centralized and Client-Server Architectures \u2013 Server System Architectures \u2013 Parallel Systems- Distributed Systems \u2013 Parallel Databases: I\/O Parallelism \u2013 Inter and Intra Query Parallelism \u2013 Inter and Intra operation Parallelism \u2013 Distributed Database Concepts &#8211; Distributed Data Storage \u2013 Distributed Transactions \u2013 Commit Protocols \u2013 Concurrency Control \u2013 Distributed Query Processing \u2013 Three Tier Client Server Architecture- Case Studies.<\/p>\n<p><strong>UNIT II : OBJECT AND OBJECT RELATIONAL DATABASES<\/strong> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 [9 hours]<\/p>\n<p>Concepts for Object Databases: Object Identity \u2013 Object structure \u2013 Type Constructors \u2013 Encapsulation of Operations \u2013 Methods \u2013 Persistence \u2013 Type and Class Hierarchies \u2013 Inheritance \u2013 Complex Objects \u2013 Object Database Standards, Languages and Design: ODMG Model \u2013 ODL \u2013 OQL \u2013 Object Relational and Extended \u2013 Relational Systems : Object Relational features in SQL \/ Oracle \u2013 Case Studies.<\/p>\n<p><strong>UNIT III : XML DATABASES \u00a0 \u00a0 \u00a0<\/strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0[9 hours]<\/p>\n<p>XML Databases: XML Data Model \u2013 DTD &#8211; XML Schema &#8211; XML Querying \u2013 Web Databases \u2013 JDBC \u2013 Information Retrieval \u2013 Data Warehousing \u2013 Data Mining.<\/p>\n<p style=\"text-align: center\"><strong><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">Download iStudy<\/a> <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">Android<\/a><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\"> App for complete Anna University syllabus, results, timetables and all other updates. There are no ads and no pdfs and will make your life way easier.<\/a><\/strong><\/p>\n<p><strong>[TOTAL: 45 PERIODS]<\/strong><\/p>\n<p><strong>OUTCOMES<\/strong>: Upon completion of the course, the student should be able to:<\/p>\n<ul>\n<li>Apply query evaluation techniques and query optimization techniques.<\/li>\n<li>Develop transaction processing systems with concurrency control.<\/li>\n<li>Design and develop a database application system as part of a team.<\/li>\n<\/ul>\n<p><strong>REFERENCES:<\/strong><\/p>\n<ul>\n<li>Henry F Korth, Abraham Silberschatz and S. Sudharshan, \u201cDatabase System Concepts\u201d, Sixth Edition, McGraw Hill, 2011.<\/li>\n<li>C.J.Date, A.Kannan and S.Swamynathan,\u201dAn Introduction to Database Systems\u201d, Eighth Edition, Pearson Education, 2006.<\/li>\n<li>R. Elmasri, S.B. Navathe, \u201cFundamentals of Database Systems\u201d, Fifth Edition, Pearson Education\/Addison Wesley, 2007.<\/li>\n<li>Thomas Cannolly and Carolyn Begg, \u201cDatabase Systems, A Practical Approach to Design, Implementation and Management\u201d, Third Edition, Pearson Education, 2007.<\/li>\n<li>Subramaniam, \u201c Multimedia Databases\u201d, Morgan Kauffman Publishers, 2008.<\/li>\n<\/ul>\n<p>For all other B.Tech IT 6th sem syllabus go to <a href=\"http:\/\/www.inspirenignite.com\/anna-university\/anna-university-b-tech-information-technology-6th-sem-course-structure-for-r13-batch\/\">Anna University B.Tech Information Technology (IT) 6th Sem Course Structure for (R13) Batch<\/a>.\u00a0All details and yearly new syllabus will be updated here time to time.<\/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>Advanced Database Technology Syllabus for B.Tech 6th sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course. [&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":[1],"tags":[],"class_list":["post-358","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/users\/2259"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/comments?post=358"}],"version-history":[{"count":2,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/358\/revisions"}],"predecessor-version":[{"id":10625,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/358\/revisions\/10625"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}