Database Management System (DBMS)
Overview
Database Management System (DBMS) is software that enables the creation, management, and manipulation of databases, allowing users to store, retrieve, and analyze spatial and non-spatial data. In GIS, spatial DBMS extends traditional database capabilities with geometry storage, spatial indexing, and geographic queries.
Key Concepts
Relational DBMS organizes data in tables with rows and columns (PostgreSQL, SQL Server). Spatial extension adds geometry types and spatial functions to a DBMS (PostGIS, SQL Server Spatial). Spatial index enables fast retrieval of features by location (R-tree, quadtree). SQL (Structured Query Language) is the standard language for database queries. ACID properties ensure reliable transactions (Atomicity, Consistency, Isolation, Durability).
Spatial DBMS Options
| DBMS | Spatial Extension | License |
|---|---|---|
| PostgreSQL | PostGIS | Open source |
| SQL Server | Spatial | Commercial |
| MySQL | Spatial | Open source |
| Oracle | Spatial | Commercial |
| SQLite | SpatiaLite | Open source |
Appendix
Created: 2025-12-13 | Modified: 2025-12-13