EAE5051 Spatial databases
Faculty of Science
EAE5051 Spatial databases is a level 5, 6-credit-point, postgraduate unit from the Faculty of Science, offered in 2027 in Semester 2 at Clayton. It needs FIT9132 and EAE4051 and unlocks 1 unit.
- Credit points
- 6
- Offered in 2027
- Semester 2
- Clayton
- Assessment
- No exam
- 3 tasks
Reviews
No reviews yetNo reviews yet. Be the first to review EAE5051.
Requisites
Before EAE5051
Prerequisites
Pass these before you enrol.
After EAE5051
1 unit list EAE5051 as a prerequisite or corequisite.
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 Microsoft SQL Server and its spatial extensions as the primary enterprise database management system, Power BI for spatial data visualisation and reporting and ESRI’s ArcGIS platform and enterprise geodatabases. These tools reflect the program’s current engagement with industry practice, where you develop, design and implement real world skills in enterprise spatial database environments.
Offerings in 2027
| Teaching period | Campus | Mode |
|---|---|---|
| Second semester | Clayton | On campus |
Assessment
- Practical workDemonstration40%
- Project 1Project30%
- Project 2Project30%
Assessment details may change. Please refer to the assessment information in Moodle closer to the start of the teaching period.
Learning outcomes
When you finish this unit, you should be able to:
- 1
Analyse the structure and characteristics of enterprise spatial database systems;
- 2
Apply the principles of spatial database design to model real-world geographic phenomena;
- 3
Construct and evaluate spatial data models to address practical geographic information problems;
- 4
Design and execute spatial queries using enterprise database management systems;
- 5
Implement an enterprise spatial database solution using industry-standard tools and platforms.
Workload and teaching
- Practical activities30 hours
- Workshops24 hours
- Teaching approachActive learning
1-weekly lecture videos;
2-hour workshops;
3-hour practicals/projects and
6-hour independent study per week
The unit is composed of online pre-recorded weekly videos, recommended readings, two-hour workshops, and three-hour computer-based practicals/projects on a weekly basis. The workshops are designed to engage you in learning through (1) reviewing and discussing key concepts introduced in the online videos, (2) presenting case studies, or (3) collectively designing and implementing a spatial database to address selected problems. The workshops and lecture videos are to explain the concepts and principles and demonstrate their applications. Practicals help develop skills and competency. The projects are designed to help develop ability to apply the learnt knowledge and skills to solve real world problems.
Learning resources
Recommended resources
Textbook: Rigaux, Scholl and Voisard, 2002. Spatial databases: With application to GIS, Morgan Kaufmann, ISBN: 1558605886.
Duckham, M., Sun, Q. C., and Worboys, M. (2024). GIS: A Computing Perspective, 3rd ed. CRC Press. ISBN: 9781032539737/ 9780429168093.
Other readings to be advised during the course.
Technology resources
SQL Server Management Studio (SSMS)
ArcGIS Pro 3.7 — Monash campus licence
Power BI Desktop
Where it fits
EAE5051 is part of 1 area of study in the 2027 handbook.
Contacts
- Chief Examiners
- Mr Manu Hinojosa
Common questions
What can I take after EAE5051?
EAE5051 is a prerequisite or corequisite for 1 unit, including EAE5018.
When is EAE5051 offered?
In 2027, EAE5051 runs in Semester 2 at Clayton.
Does EAE5051 have an exam?
No. EAE5051 has 3 assessment tasks and no exam.
Which majors and minors include EAE5051?
EAE5051 is part of Earth science.