User Tools

Site Tools


spatial-dbs

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
spatial-dbs [2014/11/03 05:30]
malumbo [Learning Objectives]
spatial-dbs [2014/11/27 05:49] (current)
malumbo [Literature]
Line 4: Line 4:
  
 Lecturer: Malumbo Chaka Chipofya Lecturer: Malumbo Chaka Chipofya
 +
 +Material for each class of the course can be found here on the spatial databases [[Spatial Databases Classes|Classes]] page
  
 ====== Course Description ====== ​ ====== Course Description ====== ​
 +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.
  
-===== Learning Objectives =====+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"​). 
 +====== Learning Objectives ​======
 The main learning objectives of this course are The main learning objectives of this course are
   - to gain a general understanding of what Spatial Databases and Database Management Systems are and what they do   - to gain a general understanding of what Spatial Databases and Database Management Systems are and what they do
Line 13: Line 22:
   - explore a few contemporary database models   - explore a few contemporary database models
 ====== Main Topics and Tentative Schedule ====== ====== Main Topics and Tentative Schedule ======
 +Material for each class of the course can be found on the spatial databases [[Spatial Databases Classes|Classes]] page
 +
   - Prelude: Data and problem solving in science and applications   - Prelude: Data and problem solving in science and applications
       - A small gallery of geospatial applications to be used throughout the course       - A small gallery of geospatial applications to be used throughout the course
Line 64: Line 75:
  
 ====== Literature ====== ====== Literature ======
 +
 +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
 +
 +====== Classes ======
 +Spatial Databases: A soft Introduction [[Spatial Databases Classes|Classes]] WS2014/15
spatial-dbs.1414999846.txt.gz · Last modified: 2014/11/03 05:30 by malumbo