GI3301 Spatial Database Management System Syllabus:

GI3301 Spatial Database Management System Syllabus – Anna University Regulation 2021

COURSE OBJECTIVES:

 Introduce the students to the concepts of DBMS, Spatial Database Management System (SDBMS), Spatial Database design, basic application program development and user interfaces.

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 – Multilayer architecture of SDBMS – GIS and SDBMS.

UNIT II SPATIAL CONCEPTS AND DATA MODELS

Field based model – object based model – spatial data types – operations on spatial objects – Entity Relationship Model (ER Model) – Relational Model – Constraints and Normal forms of Relational Model – mapping ER model to Relational model – ER model with spatial concepts – Object-oriented data modeling with Unified Modeling Language(UML).

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 SPATIAL STORAGE AND INDEXING

Disk geometry – Buffer manager – Field-Record – File – File Structure – Clustering – Basic concepts of file organizations, indexing – Spatial Indexing – Grid files – R Tree – Concurrency support – Spatial Join index – Database recovery techniques – Database Security.

UNIT V SPATIAL DATABASE SYSTEMS AND APPLICATION DESIGN AND DEVELOPMENTS

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.

TOTAL: 45 PERIODS
COURSE OUTCOMES:

On completion of the course, the student is expected to
CO1 Understand the concepts, classification, architectures of DBMS, SDBMS
CO2 Provide the information on Field Based, Object Based, ER, Relational and UML models.
CO3 Enable the SQL, Extended SQL for handling Spatial and Non-Spatial Queries.
CO4 Show the methods of Storing, Indexing, Database Recovery and Data Security concepts
CO5 Give the Design and Development Environment of Spatial Data

TEXTBOOKS:

1. Shashi Shekhar, Sanjay Chawla,”Spatial Databases a Tour” Prentice Hall, 1st edition, 2003.
2. Philippe Rigaux, Michel Scholl, Agnès Voisard “Spatial Databases” Morgan Kaufmann,2001

REFERENCES:

1. Abraham Silberschatz, Henry F. Korthand S. Sudharshan,“Database System Concepts”, 7th edition, McGraw Hill, 2020.
2. Ravi Kothuri, Albert Godfrind, Euro Beinat “Pro Oracle Spatial for Oracle Database 11g”, Apress, 2019.
3. Regina, Leo Hsu “Post GIS in Action”, Oreilly&AssociatesInc., third edition (2021).
4. Vijay Gandhi; James Kang; Shashi Shekhar, “Spatial Databases.” Minnesota univ minneapolis dept of electrical and computer engineering, 2007
5. Albert K. W. Yeung & G. Brent Hall ,” Spatial Data and Spatial Database Systems”, 2007