EAE5051 · Spatial databases

Overview

Spatial data are associated with geographical locations. A spatial database is a database system that provides spatial data types in its data model and query language and supports spatial data types in its implementation. This unit focuses on the theories that underpin the design of such spatially enabled databases and the fundamental principles and methods in their implementation. The major contents include the concepts of database systems and database models, structured query language, spatial database models and spatial database design, spatial data types, spatial indexing and spatial join, spatial operators and spatial querying, enterprise spatial databases and their implementation. It also introduces the open-source Postgres database management system and its spatial extension PostGIS, and ESRI’s proprietary file, mobile and enterprise geodatabases, and uses them as tools to facilitate the understanding of theories and the development of design and implementation skills.

Offerings

Assessment

The Handbook does not list a final examination among the assessment items. That is not a guarantee there is none.

Assessment details may change. Please refer to the assessment information in Moodle closer to the start of the teaching period.

Requisites

Learning outcomes

1. Understand the characteristics of spatial databases;
2. Grasp the principles of spatial databases and their design;
3. Be proficient in solving practical spatial data modelling tasks;
4. Design queries to interact with a spatial database;
5. Implement a specific spatial database.

Workload

• 1-hour lecture videos; • 2-hour workshops; • 3-hour practicals/projects and • 6-hour independent study per week

Student experience, not official rules. Nothing here changes what the Handbook says.