GI5301: Spatial Database Management System Syllabus for Geoinformatics 3rd Sem 2019 Regulation Anna University

Spatial Database Management System detailed syllabus for Geoinformatics Engineering (Geoinformatics) for 2019 regulation curriculum has been taken from the Anna Universities official website and presented for the Geoinformatics 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 Geoinformatics 3rd Sem 2019 regulation scheme. The detailed syllabus of spatial database management system is as follows.

Course Objective:

For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.

Unit I

Introduction
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 – Multi layer architecture of SDBMS – GIS and SDBMS

Unit II

For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.

Unit III

Query Language
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

For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.

Unit V

Design and Development
Exploring Spatial Geometry, Organizing spatial data, Spatial data relationships and functionalities of any one commercial and one FOSS DBMS each – Application program and user Interfaces.

Course Outcome:

For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.

Text Books:

1. Shashi Shekhar, Sanjay Chawla,||Spatial Databases a Tour|| Prentice Hall, 2003.
2. Philippe Rigaux, Michel Scholl, Agnes Voisard ” Spatial Databases with application to GIS | Morgan Kaufmann,ISBN13: 9781558605886, ISBN10: 1558605886,2002

References:

1. Abraham Silberschatz, Henry F. Korth and S.Sudharshan, “Database Syste Concepts|, seventh edition, McGraw Hill, 2019.
2. Ravi Kothuri, Albert Godfrind, Euro Beinat “Pro Oracle Spatial for Oracle Database 11g |, Apress , ISBN13 : 9788181288882, 2007.
3. Regina, Leo Hsu “PostGIS in Action||, Oreilly and Associates Inc., ISBN-13: 9781935182269, ISBN-10: 1935182269, 2011.
4. Elamasri | Navathe – Fundamentals of Database Systems, Pearson Education,3rd Edition,2001, ISBN: 81-7808-137-7
5. Hussein Nasser, Learning ArcGIS Geodatabases,Packt Publishing Limited, 2014,ISBN-978-1-78398-864-8.

For detailed syllabus of all other subjects of Geoinformatics Engineering, 2019 regulation curriculum do visit Geoinformatics 3rd Sem subject syllabuses for 2019 regulation.

For all Geoinformatics Engineering results, visit Anna University Geoinformatics all semester results direct link.