{"id":539,"date":"2021-09-02T18:20:30","date_gmt":"2021-09-02T18:20:30","guid":{"rendered":"https:\/\/itgeeks.in\/home\/?p=539"},"modified":"2021-09-02T18:20:32","modified_gmt":"2021-09-02T18:20:32","slug":"2k6cs-705a-advanced-database-systems","status":"publish","type":"post","link":"https:\/\/itgeeks.in\/home\/?p=539","title":{"rendered":"2K6CS 705(A) ADVANCED DATABASE SYSTEMS"},"content":{"rendered":"\n<p><strong>Module I (13 hours)<\/strong><br>Object-Based Databases &#8211; Complex Data Types &#8211; Structured Types and Inheritance in SQL &#8211; Table Inheritance &#8211; Array and Multiset Types in SQL &#8211; Object-Identity and Reference Types in SQL -Implementing O-R Features &#8211; Persistent Programming Languages &#8211; Object-Oriented versus Object-Relational models<br><strong>Module II (13 hours)<\/strong><br>Data Analysis and Mining &#8211; Decision-Support Systems &#8211; Data Analysis and OLAP &#8211; Data Warehousing -Data Mining. Information Retrieval &#8211; Relevance Ranking Using Terms &#8211; Relevance Using Hyperlinks -Synonyms, Homonyms and Ontologies &#8211; Indexing of Documents &#8211; Measuring Retrieval Effectiveness -Web Search Engines &#8211; Information Retrieval and Structured Data.<br><strong>Module III (13 hours)<\/strong><br>Database-System Architectures \u2013 Centralized, Client\u2013Server and Server System Architectures \u2013 Parallel and Distributed Systems. Parallel Databases &#8211; I\/O Parallelism \u2013 Interquery, Intraquery, Intraoperation andInteroperation Parallelism &#8211; Design of Parallel Systems. Distributed Databases &#8211; Homogeneous and Heterogeneous Databases &#8211; Distributed Data Storage &#8211; Distributed Transactions &#8211; Commit Protocols -Concurrency Control in Distributed Databases &#8211; Distributed Query Processing &#8211; Heterogeneous DistributedDatabases.<br><strong>Module IV (13 hours)<\/strong><br>Advanced Data Types and New Applications &#8211; Time in Databases &#8211; Spatial and Geographic Data -Multimedia Databases &#8211; Mobility and Personal Databases. Advanced Transaction Processing &#8211; Transaction-Processing Monitors &#8211; Transactional Workflows &#8211; E-Commerce &#8211; Main-Memory Databases &#8211; Real-TimeTransaction Systems &#8211; Long-Duration Transactions &#8211; Transaction Management in Multidatabases.<\/p>\n\n\n\n<p><strong>Text books<\/strong><br>1.<a href=\"https:\/\/itgeeks.in\/home\/?p=540\">Database System Concepts, 5\/E, A. Silberschatz, H. F. Korth and S. Sudarshan, Mc-Graw Hill<\/a><br><strong>Reference books<\/strong><br>1.<a href=\"https:\/\/itgeeks.in\/home\/?p=542\">\u00a0R. Elmasri and S. B. Navathe: Fundamentals of Database Systems, 5th Edition, Addison-Wesley<\/a><br>2.<a href=\"https:\/\/itgeeks.in\/home\/?p=544\">\u00a0Database Management Systems, 3\/E, Raghu Ramakrishnan and J. Gehrke, Mc-Graw Hill<\/a><\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"https:\/\/itgeeks.in\/home\/?p=202\">Question Papers<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Module I (13 hours)Object-Based Databases &#8211; Complex Data Types &#8211; Structured Types and Inheritance in SQL &#8211; Table Inheritance &#8211;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,22,9,8],"tags":[7],"class_list":["post-539","post","type-post","status-publish","format-standard","hentry","category-ku-s7-cse","category-ku-syb-s7","category-ku-syllabus","category-syllabus","tag-kannur-university"],"_links":{"self":[{"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/posts\/539","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=539"}],"version-history":[{"count":1,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/posts\/539\/revisions"}],"predecessor-version":[{"id":546,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/posts\/539\/revisions\/546"}],"wp:attachment":[{"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=539"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}