{"id":50163,"date":"2023-03-22T05:35:06","date_gmt":"2023-03-22T05:35:06","guid":{"rendered":"https:\/\/www.inspirenignite.com\/anna-university\/gi3301-spatial-database-management-system-syllabus-for-geo-2021-regulation\/"},"modified":"2023-03-22T05:35:06","modified_gmt":"2023-03-22T05:35:06","slug":"gi3301-spatial-database-management-system-syllabus-for-geo-2021-regulation","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/gi3301-spatial-database-management-system-syllabus-for-geo-2021-regulation\/","title":{"rendered":"GI3301: Spatial Database Management system syllabus for Geo 2021 regulation"},"content":{"rendered":"<p align=\"justify\">Spatial Database Management system detailed syllabus for Geoinformatics Engineering (Geo) for 2021 regulation curriculum has been taken from the <a class=\"rank-math-link\" href=\"https:\/\/cac.annauniv.edu\/\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Anna University<\/a> official website and presented for the Geo students. For course code, course name, number of credits for a course and other scheme related information,  do visit full semester subjects post given below. <\/p>\n<p align=\"justify\">For Geoinformatics Engineering 3rd Sem scheme and its subjects, do visit <a class=\"rank-math-link\" href=\"..\/geo-3rd-sem-syllabus-2021-regulation\">Geo 3rd Sem 2021 regulation scheme<\/a>. The detailed syllabus of spatial database management system is as follows. <\/p>\n<p>  <title>Spatial Database Management system<\/title><\/p>\n<h4>Course Objectives:<\/h4>\n<h4 id=\"istudy\" style=\"text-align:center\"><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Download the iStudy App for all syllabus and other updates.<\/a><br \/><a class=\"rank-math-link\" 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;text-align:center\"><\/a><\/h4>\n<h4>Unit I<\/h4>\n<p>  <strong>INTRODUCTION 9<\/strong> Data &#8211; Information &#8211; File system Vs DBMS &#8211; Database Management Systems &#8211; Database architectures, users and administrators &#8211; Classification of Database Management Systems -Spatial Data &#8211; Points, Lines, Polygons &#8211; definition of SDBMS &#8211; user classes of SDBMS -Multilayer architecture of SDBMS &#8211; GIS and SDBMS.<\/p>\n<h4>Unit II<\/h4>\n<h4 id=\"istudy\" style=\"text-align:center\"><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Download the iStudy App for all syllabus and other updates.<\/a><br \/><a class=\"rank-math-link\" 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;text-align:center\"><\/a><\/h4>\n<h4>Unit III<\/h4>\n<p>  <strong>QUERY LANGUAGE 9<\/strong> SQL &#8211; Data Definition &#8211; Data Manipulation &#8211; Basic structure of SQL &#8211; Set operations -Aggregate Functions &#8211; Simple queries &#8211; spatial Vs non spatial &#8211; Nested sub queries &#8211; Complex queries &#8211; Views &#8211; Trigger &#8211; OGIS standard for extending SQL &#8211; example spatial SQL queries -Object relational SQL.<\/p>\n<h4>Unit IV<\/h4>\n<h4 id=\"istudy\" style=\"text-align:center\"><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Download the iStudy App for all syllabus and other updates.<\/a><br \/><a class=\"rank-math-link\" 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;text-align:center\"><\/a><\/h4>\n<h4>Unit V<\/h4>\n<p>  <strong>SPATIAL DATABASE SYSTEMS AND APPLICATION DESIGN AND DEVELOPMENTS 9<\/strong> Exploring Spatial Geometry &#8211; Organizing spatial data &#8211; spatial data relationships and functionalities of any one commercial and one FOS SDBMS each &#8211; Application program and user Interfaces.<\/p>\n<h4>Course Outcomes:<\/h4>\n<h4 id=\"istudy\" style=\"text-align:center\"><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Download the iStudy App for all syllabus and other updates.<\/a><br \/><a class=\"rank-math-link\" 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;text-align:center\"><\/a><\/h4>\n<h4>Text Books:<\/h4>\n<ol>\n<li>Shashi Shekhar, Sanjay Chawla,Spatial Databases a Tour Prentice Hall, 1st edition, 2003.<\/li>\n<li>Philippe Rigaux, Michel Scholl, Agnes Voisard Spatial Databases Morgan Kaufmann,2001<\/li>\n<\/ol>\n<h4>Reference Books:<\/h4>\n<ol>\n<li>Abraham Silberschatz, Henry F. Korthand S. Sudharshan,Database System Concepts, 7th edition, McGraw Hill, 2020.<\/li>\n<li>Ravi Kothuri, Albert Godfrind, Euro Beinat Pro Oracle Spatial for Oracle Database 11g, Apress, 2019.<\/li>\n<li>Regina, Leo Hsu Post GIS in Action, Oreilly&amp;AssociatesInc., third edition (2021).<\/li>\n<li>Vijay Gandhi; James Kang; Shashi Shekhar, Spatial Databases. Minnesota univ minneapolis dept of electrical and computer engineering, 2007<\/li>\n<li>Albert K. W. Yeung &amp; G. Brent Hall , Spatial Data and Spatial Database Systems, 2007<\/li>\n<\/ol>\n<p align=\"justify\">For detailed syllabus of all other subjects of Geoinformatics Engineering, 2021 regulation curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/geo+3rd-sem\">Geo 3rd Sem subject syllabuses for 2021 regulation<\/a>. <\/p>\n<p align=\"justify\">For all Geoinformatics Engineering results, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/anna-university\/anna-university-results\/\">Anna University Geo all semester results<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Spatial Database Management system detailed syllabus for Geoinformatics Engineering (Geo) for 2021 regulation curriculum has been taken from the Anna University official website and presented for the Geo students. For [&hellip;]<\/p>\n","protected":false},"author":2297,"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":[46,80],"tags":[],"class_list":["post-50163","post","type-post","status-publish","format-standard","hentry","category-3rd-sem","category-geo"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/50163","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\/2297"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/comments?post=50163"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/50163\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=50163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=50163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=50163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}