Part of the MSc in Geographical Information Science (Modular Access for Part-Time Study)
This course builds on the theory and techniques taught in the Spatial Modelling course, with the aim of extending and deepening appreciation of formal database management.
The course begins by looking further at relational database management systems, considering a means of assessing the 'relational-ness' of such systems, together with SQL particularly in the context of standardisation efforts.
The course continues by examining Object-Oriented and Object-Relational approaches, together with issues important to GIS such as hybrid versus integrated data models and the long transaction.
The course extends students’ knowledge of commercial data models, reviewing their advantages and disadvantages, together with looking at case studies of database management in the commercial GIS environment. Practicals extend the student’s knowledge of standard SQL, examine Oracle Spatial in detail and introduce MySQL and its spatial extension.
NB: This module assumes some previous knowledge of the subject.
Tuesdays From 14th Jan 2014 (5 weeks)