Postgraduate Course: Advanced Spatial Database Methods (PGGE11083)
Course Outline
| School | School of Geosciences |
College | College of Science and Engineering |
| Credit level (Normal year taken) | SCQF Level 11 (Postgraduate) |
Availability | Available to all students |
| SCQF Credits | 10 |
ECTS Credits | 5 |
| Summary | 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 methods. 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 vs. integrated data models and the long transaction. The means of encoding spatial data such that it can be held and queried within formal database management systems is examined. The course extends student's knowledge of commercial data models, reviewing their advantages and disadvantages, together with looking at case studies of database management in the commercial GIS environment. Further themes include 'big data', spatial data mining, performance, indexing and spatial metadata. Practical exercises extend the student¿s knowledge of standard SQL, examine Oracle Spatial in detail and introduce PostgreSQL / POSTGIS and MySQL and its spatial extension. |
| Course description |
Week 1
Understanding Database Management Theory
Practical: SQL 1
Week 2
Beyond Relational Database Management Systems
Practical: SQL 2
Week 3
Combining Spatial and Non-Spatial: Integrated Data Models and Oracle Spatial
Practical: Oracle Spatial
Week 4
Extending our Understanding of Spatial Data Models and Spatial Databases
Practical: Accessing Spatial objects from GIS and DB Designer Demonstration: Oracle Forms
Week 5
Alternative Spatial Extensions and Case Studies
Practical: Comparing DBMS (PostgreSQL, POSTGIS, MySQL)
|
Entry Requirements (not applicable to Visiting Students)
| Pre-requisites |
|
Co-requisites | |
| Prohibited Combinations | |
Other requirements | None |
| Additional Costs | none |
Information for Visiting Students
| Pre-requisites | None |
| High Demand Course? |
Yes |
Course Delivery Information
|
| Academic year 2021/22, Available to all students (SV1)
|
Quota: 40 |
| Course Start |
Block 3 (Sem 2) |
Timetable |
Timetable |
| Learning and Teaching activities (Further Info) |
Total Hours:
100
(
Lecture Hours 12,
Seminar/Tutorial Hours 12,
Programme Level Learning and Teaching Hours 2,
Directed Learning and Independent Learning Hours
74 )
|
| Assessment (Further Info) |
Written Exam
0 %,
Coursework
100 %,
Practical Exam
0 %
|
| Additional Information (Assessment) |
Assessed Practical:
Oracle Spatial Searching in SQL (30%) - Due Week 3
Group Project:
Proposal (5%) - Due Week 2
Written submission (max 1500 words) (30%) - Due in Flexible Learning Week
Seminar / Demonstration (35%) - Due in Flexible Learning Week |
| Feedback |
Not entered |
| No Exam Information |
Learning Outcomes
On completion of this course, the student will be able to:
- understand the benefits of formal database management and its implications and be able to predict future developments and understand the implications of standardisation efforts
- understand how database methods can be used to store spatial and attribute data in the context of geographical information systems, be able to critically review the different technologies and commercially-available models, assessing their merits and shortcomings and to understand the issue of performance in the context of database management
- understand the concepts of data modelling and be able to deconstruct real-world problems into appropriate models using appropriate tools
- use Structured Query Language (SQL) for the manipulation of objects within a relational database management system
- use and understand the Oracle relational database management system, Oracle Spatial as a means of storing and manipulating spatial data alongside attributes, and be able to contrast Oracle with different systems
|
Reading List
Please see current reading list for the course at: https://eu01.alma.exlibrisgroup.com/leganto/readinglist/searchlists
Reading List (selected references)
- Date, C.J. (1995) An Introduction to Database Systems (7th edition) Addison-Wesley
- Egenhofer, M.J. (1992) Why not SQL! International Journal of Geographical Information Systems, 6 (2), 71-86
- Kothuri, R.V., A. Godfrind and E.Beinat (2007) Pro Oracle Spatial for 11g, Apress
- Lake, R., D. Burggraf, M. Trninic and L. Rae (2004) Geography Mark-Up Language: Foundation for the Geo-Web, John Wiley & Sons
- Rigaux, P., Scholl, M. and Voisard, A. (2002) Spatial Databases with Application to GIS. Morgan Kaufmann
- Wachowicz, Monica (1999) Object-oriented design for temporal GIS. Taylor & Francis, London
- Worboys, M.F. and Duckham, M. (2004) GIS: A Computing Perspective. CRC Press, Second Edition
|
Additional Information
| Course URL |
http://www.geos.ed.ac.uk/ |
| Graduate Attributes and Skills |
Not entered |
| Keywords | PGGE11083,Database management,Oracle Spatial,SQL,data models |
Contacts
| Course organiser | Mr Bruce Gittings
Tel: (0131 6)50 2558
Email: Bruce@ed.ac.uk |
Course secretary | Ms Heather Penman
Tel: (0131 6)50
Email: heather.penman@ed.ac.uk |
|
|
University Homepage