Subject Code & Name: GI25301 – Spatial Database Management System
Regulation: R-2025
Semester: III (Third Semester)
Branch: B.E. Geoinformatics Engineering (Geo)
Credits / L-T-P: 4 Credits | L-T-P: 3-0-2
Course Objectives
- To develop skills in designing and managing databases with emphasis on spatial data structures and models.
Full Unit-wise Syllabus
Unit I – 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
Unit II – 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.
Unit III – 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.
Unit IV – 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
Activities: 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.
Course Outcomes (COs)
- CO1: Explain the architecture, components and functionalities of DBMS and Spatial DBMS.
- CO2: Design spatial databases using ER, relational, and object-oriented data models.
- CO3: Apply SQL and spatial SQL for querying, manipulating, and managing spatial data.
- CO4: Implement spatial indexing, recovery, security mechanisms, and perform spatial analysis using geometrical and topological operations.
Assessment Pattern (Quick Note)
- Weightage: Continuous Assessment 50% | End Semester Examinations 50%
- Internal methodology: Quiz (5%), Project (15%), Assignment Programs (25%), Practical (25%), Internal Examinations (30%)
Source: Official Anna University – B.E. Geoinformatics Engineering R-2025 Curriculum
Last Updated: September 2026
Comments
Post a Comment