{"id":555,"date":"2016-07-24T06:12:07","date_gmt":"2016-07-24T06:12:07","guid":{"rendered":"http:\/\/www.inspirenignite.com\/jntuk\/?p=555"},"modified":"2016-08-07T12:26:38","modified_gmt":"2016-08-07T12:26:38","slug":"jntuk-b-tech-advanced-databaseselective-ii-for-r13-batch","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuk\/jntuk-b-tech-advanced-databaseselective-ii-for-r13-batch\/","title":{"rendered":"JNTUK B.Tech Advanced Databases(Elective \u2013 II) for R13 Batch."},"content":{"rendered":"<p>JNTUK B.Tech Advanced Databases (Elective \u2013 II) gives you detail information of Advanced Databases (Elective \u2013 II) R13 syllabus It will be help full to understand you complete curriculum of the year.<\/p><div class=\"a9916ad81d5189659b0bfae0b37c143c\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-1181153414625576\"\r\n     data-ad-slot=\"9648548092\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<p><strong>Course Objectives<\/strong><\/p>\n<ul>\n<li>Be able to design high-quality relational databases and database applications.<\/li>\n<li>Have developed skills in advanced visual&amp; conceptual modeling and database design.<\/li>\n<li>Be able to translate complex conceptual data models into logical and physical data Base designs.<\/li>\n<li>Have developed an appreciation of emergingdatabase trends as theyapplyto semi-structured data, the internet,andobject-oriented databases.<\/li>\n<\/ul>\n<p><strong>Course Outcomes<\/strong><\/p>\n<ul>\n<li>Identify, describe, and categorize database objects<\/li>\n<li>Design and implement advanced queries using Structured Query Language<\/li>\n<li>Design, construct and maintain a database and various database objects using procedural language constructs, forms and reports to solve problems<\/li>\n<li>Administer a database by recommending and implementing procedures including database tuning, backup and recovery<\/li>\n<li>Propose, implement and maintain database security mechanisms<\/li>\n<li>Explore non-relational database systems and structures<\/li>\n<\/ul>\n<p><strong>Syllabus<\/strong><\/p>\n<p><strong>UNIT \u2013 I : Algorithms for Query Processing and Optimization<\/strong>:Translating SQL queries into relational algebra- algorithms for external sorting-algorithms for select and join operations-algorithms for project and set operations-implementing aggregate operations and outer joins-combining operations using pipelining-using heuristics in query optimization.<\/p>\n<p><strong>UNIT \u2013II: Data base systems architecture and the system Catalog<\/strong>:System architectures for DBMSs, Catalogs for Relational DBMSs, System catalog information in oracle. Practical database design and tuning:Physical Database Design in Relational Databases-an overview of Database Tuning in Relational systems.<\/p>\n<p><strong>UNIT \u2013 III: Distributed DBMS Concepts and Design<\/strong>:Introduction-function and architecture of a Distributed DBMS- Distributed Relational Database Design-transparencies in a Distributed DBMS-Date\u2019s Twelve Rules for Distributed DBMS. Distributed DBMS-Advanced Concepts:Distributed Transaction Management-Distributed Concurrency Control-Distributed Deadlock Management-Distributed Database Recovery-The X\/Open Distributed Transaction processing model-Replication Servers.<\/p>\n<p><strong>UNIT \u2013 IV: Introduction to Object DBMSs<\/strong>:Advanced Database Applications-Weaknesses of RDBMSs-Object oriented Concepts-Storing objects in a Relational Database-Next generation Database systems. Object-Oriented DBMSs-Concepts and Design :Introduction to Object-Oriented Data Models and DBMSs-OODBMS perspectives-Persistence-Issues in OODBMSs-The object Oriented Database System\u00a0Manifesto-Advantages and Disadvantages of OODBMSs-Object oriented Database Design.<\/p>\n<p><strong>UNIT V: Object-Oriented DBMSs-Standards and Systems:<\/strong>Object management group-Object Database Standard ODMG3.0, 1999-Object store.Object relational DBMSs:Introduction to Object-relational Database systems- third generation Database manifesto-Postgres-an early ORDBMS-SQL3.<\/p>\n<p><strong>UNIT \u2013 VI : Emerging database technologies and applications:<\/strong> Hadoop, BIg Data characteristics, NO SQL databases, BASE, Brewer&#8217;s theorem, Relationship between CAP, ACID and No SQL databases, comparison with Relational databases, No SQL databases types, Comparative study of NoSQL products, Case studies using MangoDB and Cassandra.<\/p>\n<p><strong>TEXT BOOK<\/strong><\/p>\n<ul>\n<li>\u201cFundamentals of Database Systems\u201d, ElmasriNavate, 5\/e, Pearson Education.<\/li>\n<li>Principles of distributed databases S Ceri and Palgettgi TMH<\/li>\n<li>Getting started with No SQL Databases , Gaurav Vaish<\/li>\n<\/ul>\n<p><strong>REFERENCES BOOKS<\/strong><\/p>\n<ul>\n<li>\u201cPrinciples of Distributed Database Systems\u201d, Ozsu, 2\/e, PHI.<\/li>\n<\/ul>\n<p>For more information about all JNTU updates please stay connected to us on FB and don\u2019t hesitate to ask any questions in the comment.<\/p>\n<div class=\"a9916ad81d5189659b0bfae0b37c143c\" data-index=\"2\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-1181153414625576\"\r\n     data-ad-slot=\"8060844699\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>JNTUK B.Tech Advanced Databases (Elective \u2013 II) gives you detail information of Advanced Databases (Elective \u2013 II) R13 syllabus It will be help full to understand you complete curriculum of [&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":[2],"tags":[],"class_list":["post-555","post","type-post","status-publish","format-standard","hentry","category-syllabus"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/posts\/555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/users\/2259"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/comments?post=555"}],"version-history":[{"count":1,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/posts\/555\/revisions"}],"predecessor-version":[{"id":556,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/posts\/555\/revisions\/556"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/media?parent=555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/categories?post=555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuk\/wp-json\/wp\/v2\/tags?post=555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}