Advanced Spatial Database Methods (P01223)

? Credit Points : 10 ? SCQF Level : 11 ? Acronym : GEO-P-GISASDM

The course builds on Spatial Modelling and develops a thorough grounding in database methods, extending these to understand the representation and storage of spatial objects using relational and object database management systems. Spatio-temporal databases are also discussed. The course places database management systems, including spatial extensions, in their commercial context. It continue by considering issues such as corporate systems, large spatial databases, data warehousing, metadatabases and related standards. The course engenders strong practical skills using Oracle and SQL, including methods of database publication using XML.

Entry Requirements

? Pre-requisites : spatial modelling

? Costs : none

Subject Areas

Home subject area

Postgraduate Courses (School of GeoSciences), (School of GeoSciences, Schedule N)

Delivery Information

? Normal year taken : Postgraduate

? Delivery Period : Block 3 only

? Contact Teaching Time : 4 hour(s) per week for 5 weeks

First Class Information

Date	Start	End	Room	Area	Additional Information
08/01/2008	14:00	16:00	Room 3.18, Old Infirmary (Geography)	Central

All of the following classes

Type	Day	Start	End	Area
Lecture	Tuesday	14:00	18:00	Central

Summary of Intended Learning Outcomes

By the end of this module, students should have achieved and demonstrated, or be able to achieve and demonstrate, the ability to:
-understand the database methods used to store spatial and attribute data in the context of geographical information systems
-appreciate the historical development of these systems
-implement a data model and understand the methods of normalisation
-understand the concept of database management in the corporate environment and its implications
-critically review the available technologies, assessing their merits and shortcomings
-compare and contrast database management systems and their use within GIS
-predict future developments and understand the implications of standardisation efforts
-use Structured Query Language (SQL) for both the manipulation and definition of objects within a relational database management system
-extended use of the Oracle relational database management system through SQL*Plus, SQL*Loader and SQL*Forms
-store and interrogate spatial data within Oracle and the use of Oracle Spatial
-locate, read and summarise relevant literature, from both traditional and electronic media, to extend your understanding of the topic
-develop reasoned arguments, firmly grounded in the available literature
-plan and write assignments, within the specified parameters and to a professional standard
-take responsibility for your own learning through reading and the preparation of assignments, and reflect upon your learning experience