GI25301 Spatial Database Management System Syllabus:

GI25301 Spatial Database Management System Syllabus – Anna University UG Syllabus Regulation 2025

Course Objective
To develop skills in designing and managing databases with emphasis on spatial data structures and models.

Fundamentals of DBMS, SDBMS: DBMS concepts, architecture, users, and comparison with file systems; Introduction to SDBMS, spatial data types, GIS integration, and client–server architecture.
Practical:
1. Creation of database tables, relationships, and establishing client–server connectivity

Spatial Data Models, Database Design: Field-based and object-based models – Spatial data types and operations – Entity–Relationship (ER) model for spatial data – Relational data model – Constraints and normalization – Mapping ER model to relational model – Object-oriented data modeling – UML diagrams for spatial systems.
Practical:
1. ER modeling for spatial datasets and mapping to relational schema.
2. Object-oriented modeling using UML for spatial databases.

SQL, Spatial Query Processing: SQL (DDL, DML), queries, views, triggers, and constraints – Spatial SQL, OGC standards, and execution of spatial queries (buffer, overlay, topology).
Practical:
1. Implementation of SQL operations and execution of spatial queries on GIS datasets.

Spatial Storage, Indexing, Applications: Disk geometry and file organization – Buffer management – Clustering techniques – Indexing concepts – Spatial indexing methods (Grid files, R-tree) – Spatial join index – Query optimization – Concurrency control – Database recovery techniques – Security mechanisms in SDBMS – Spatial data organization in commercial and open-source SDBMS – Application programs and user interface design.
Practical:
1. Creation of spatial indexes and optimization of spatial queries
2. Implementation of database security, triggers, and recovery mechanisms

Tasks:
1. Design and implement a complete spatial database for a real-world application (e.g., watershed, land use, or agricultural planning) including ER modeling, schema design, data creation, and client–server setup.
2. Develop and execute complex SQL and spatial queries (buffer, overlay, intersection, spatial joins) on a given dataset, including indexing and query optimization, and interpret the results.
3. Create a simple spatial database application (using GIS interface or frontend) incorporating indexing, security, and recovery features; evaluate system performance and present findings.

Weightage: Continuous Assessment: 50%, End Semester Examinations: 50%

Methodology for Continuous Assessment : Quiz (5%), Project (15%), Assignment Programs (25%), Practical (25%), Internal Examinations (30%)

References
1. Nikos Mamoulis, Spatial Data Management, Springer Nature, 2022, ISBN: 978-3-03101884-8.
2. Shashi Shekhar, Sanjay Chawla, Spatial Databases: A Tour, Prentice Hall, 1st edition, 2003.
3. Philippe Rigaux, Michel Scholl, Agnès Voisard, Spatial Databases: With Application to GIS, The Morgan Kaufmann Series in Data Management Systems, Elsevier, 2001.
4. Avi Silberschatz, Henry F Korth, Sudarshan S, Database System Concepts, 7th edition, McGraw Hill, 2020.
5. Ravikanth V Kothuri, Albert Godfrind, Euro Beinat, Pro Oracle Spatial for Oracle Database 11g, Apress, 2019.
6. Regina LeoHsu, PostGIS in Action, O’Reilly & Associates Inc., 3rd edition, 2021.

E Resources
1. NPTEL – Database Management Systems
https://nptel.ac.in
2. NPTEL – Geographic Information Systems