You are in Geoinformatics - Creative Commons :: Spatial Databases: A soft Introduction
Lecturer: Malumbo Chaka Chipofya
Material for each class of the course can be found here on the spatial databases Classes page
Spatial databases are a core component of any medium to large scale deployment of geographic information systems and services. A Spatially enabled Database Management System (SDBMS) provides capabilities for storage, replication, and analysis of geospatial data. “Spatial is special” goes the not-so-old adage. As such spatial data require special methods for storage, search, and query formulation. For example, the sorts of questions that one may want to pose to a spatial database are often significantly more complex as compared to the question one may ask, for instance, a sales records database. Understanding database management systems in general and spatial databases in particular are therefore essential for any Geoinformatics professional.
This course will first cover the basics of database management systems and introduce spatial database management systems with a focus on the relational database model. In parallel to the study of database concepts, the course develop particular skills in qualitative spatial reasoning that will be used in query formulation. The qualitative reasoning concepts are useful for implementing support for intelligent query capabilities and improving human interaction. For example instead of searching for a place using coordinates it is more natural for human beings to refer to the general area or territory where the place located. Finally, the course will explore, briefly but in a practical way, spatial extensions in alternative database models. This follows some of the trends that can be seen in practice. Initially, the relational database model earned unquestioned prominence in the database domain. However, with the changing technological landscape, other database models are beginning to find use in popular applications. These include array databases, document-oriented databases, and graph databases among others. All material will illustrated with suitable examples.
The course will take place in two parallel sessions. One will be focused on spatial database management systems and the other will focus on qualitative spatial knowledge representation and reasoning. The two fields are connected by distinct utility of qualitative spatial representation in spatial database query formulation and evaluation.
Note: It is not possible to take both this course and the course “Qualitative Spatial Knowledge Representation and Reasoning” On Wednesdays, the course will be offered in StudLab 126 (together with “Qualitative Spatial Knowledge Representation and Reasoning”).
The main learning objectives of this course are
Material for each class of the course can be found on the spatial databases Classes page
(1 Session: 23.10.14)
(1 Session 3.a-b.: 30.10.14; 1 Session 3.c.i-ii.: 06.11.14)
(2 Sessions: 13.11.14, 20.11.14,)
(1 Session 5.a-c.: 27.11.14; 2 Sessions 5.d. : 4.12.14, 11.12.14)
(2 Sessions: 18.12.14, 8.01.15)
(3 Sessions: 15.01.15, 22.01.15, 29.01.15)
8. Conclusion: Summary of all lectures given and tips for future directions for research and further use cases. (1 Session: 5.02.15)
C.J. Date, An Introduction to Database Systems, 8th Edition. Pearson Education Inc., 2004.
PostGis manual - http://postgis.net/docs/
PostGis tutorial - http://workshops.boundlessgeo.com/postgis-intro/index.html
PostgreSQL manual - http://www.postgresql.org/docs/9.3/static/index.html
OGC SFS (Common architecture) - http://www.opengeospatial.org/standards/sfa
OGC SFS (SQL option) - http://www.opengeospatial.org/standards/sfs
Spatial Databases: A soft Introduction Classes WS2014/15