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 course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Geoinformatics Engineering 3rd Sem scheme and its subjects, do visit Geo 3rd Sem 2021 regulation scheme. The detailed syllabus of spatial database management system is as follows.
Course Objectives:
Download the iStudy App for all syllabus and other updates.
Unit I
INTRODUCTION 9 Data – Information – File system Vs DBMS – Database Management Systems – Database architectures, users and administrators – Classification of Database Management Systems -Spatial Data – Points, Lines, Polygons – definition of SDBMS – user classes of SDBMS -Multilayer architecture of SDBMS – GIS and SDBMS.
Unit II
Download the iStudy App for all syllabus and other updates.
Unit III
QUERY LANGUAGE 9 SQL – Data Definition – Data Manipulation – Basic structure of SQL – Set operations -Aggregate Functions – Simple queries – spatial Vs non spatial – Nested sub queries – Complex queries – Views – Trigger – OGIS standard for extending SQL – example spatial SQL queries -Object relational SQL.
Unit IV
Download the iStudy App for all syllabus and other updates.
Unit V
SPATIAL DATABASE SYSTEMS AND APPLICATION DESIGN AND DEVELOPMENTS 9 Exploring Spatial Geometry – Organizing spatial data – spatial data relationships and functionalities of any one commercial and one FOS SDBMS each – Application program and user Interfaces.
Course Outcomes:
Download the iStudy App for all syllabus and other updates.
Text Books:
- Shashi Shekhar, Sanjay Chawla,Spatial Databases a Tour Prentice Hall, 1st edition, 2003.
- Philippe Rigaux, Michel Scholl, Agnes Voisard Spatial Databases Morgan Kaufmann,2001
Reference Books:
- Abraham Silberschatz, Henry F. Korthand S. Sudharshan,Database System Concepts, 7th edition, McGraw Hill, 2020.
- Ravi Kothuri, Albert Godfrind, Euro Beinat Pro Oracle Spatial for Oracle Database 11g, Apress, 2019.
- Regina, Leo Hsu Post GIS in Action, Oreilly&AssociatesInc., third edition (2021).
- Vijay Gandhi; James Kang; Shashi Shekhar, Spatial Databases. Minnesota univ minneapolis dept of electrical and computer engineering, 2007
- Albert K. W. Yeung & G. Brent Hall , Spatial Data and Spatial Database Systems, 2007
For detailed syllabus of all other subjects of Geoinformatics Engineering, 2021 regulation curriculum do visit Geo 3rd Sem subject syllabuses for 2021 regulation.
For all Geoinformatics Engineering results, visit Anna University Geo all semester results direct link.