På Svenska

AG2425 Spatial Databases 7.5 credits

Spatial Databases

Please note

The information on this page is based on a course plan that is not yet valid.

Geographic Information Systems (GIS) are being used in a wide variety of applications. A key component of any GIS application is the underlying spatial database which must be designed to support efficient data storage, access and analysis operations.This course focuses on the design and development of spatial databases. Particular emphasis will be placed on the use of data modeling techniques to design a GIS database for a specific application. Students will work in small groups to develop a conceptual design for a GIS database and will then work individually to build a spatial database using digital data available through digital library as well as data digitized from existing maps, imagery and field data collected using GPS. The resulting database will be used to perform some basic spatial analysis.

  • Educational level

    Second cycle

  • Academic level (A-D)

    C

  • Subject area

  • Grade scale

    A, B, C, D, E, FX, F

Course offerings

Spring 13 for programme students CANCELLED

  • Periods

    Spring 13 P3 (7.5 credits)

  • Application code

    60054

  • Start date

    2013 week: 2

  • End date

    2013 week: 11

  • Language of instruction

    English

  • Campus

    KTH Campus

  • Number of lectures

  • Number of exercises

  • Tutoring time

    Daytime

  • Form of study

    Normal

  • Number of places

    No limitation

  • Schedule

    Schedule (new window)

  • Course responsible

    Gyözö Gidófalvi, gyozo.gidofalvi@abe.kth.se

Spring 13 for programme students

Spring 14 for programme students

Spring 14 for programme students

  • Periods

    Spring 14 P4 (7.5 credits)

  • Application code

    60187

  • Start date

    2014 week: 13

  • End date

    2014 week: 23

  • Language of instruction

    English

  • Campus

    KTH Campus

  • Number of lectures

    20 (preliminary)

  • Number of exercises

  • Tutoring time

    Daytime

  • Form of study

    Normal

  • Number of places *

    Min. 1

    *) The Course date may be cancelled if number of admitted are less than minimum of places.

  • Schedule

    Schedule (new window)

  • Course responsible

    Gyözö Gidófalvi, gyozo.gidofalvi@abe.kth.se

  • Teacher

    Gyözö Gidofalvi <gyozo.gidofalvi@abe.kth.se>

  • Target group

    Open only for applicants to Science Without Borders, Brazil

Learning outcomes

The goals of this course are to enable students to develop a good understanding of the principles and techniques of relational database design as they apply to spatial databases; apply these principles and techniques in designing and building spatial databases; and use spatial databases to perform common types of queries and spatial analysis.

Course main content

  • Logical geographic data models for spatial databases, including vector and raster model
  • Physical data storage, data access methods, query processing and optimization
  • Design conceptual data models for spatial databases using a ER diagram approach
  • Process and retrieve geographic data from spatial databases using OGIS/SQL1999 interface and other specific interface (SDK) from database vendors
  • Optimize spatial database by applying spatial indexing technologies, pyramid structure, data compressing, etc
  • Basic operations of the Oracle Spatial databases and PostGIS/PostgreSQL open-source spatial database
  • Introduction to modern commercial and open-source (free) spatial databases products, e.g. Oracle 10g Spatial, ArcSDE 9.x, PostGIS 1.3/PostgreSQL 8.2, etc.
  • Advances and trends in spatial databases: network data model, spatio-temporal data model, spatial data mining, etc
  • Guest lectures on applications of spatial databases 

Disposition

Lectures 20h
Laboration 40h
Written exam

Eligibility

a) Eligibility to CSAMH program

b) Eligibility to TTGTM program

   AG2411  GIS Architecture and Algorithms

   For single course students:

    A course on GIS Architecture and Algorithms

Literature

Kurslitteraturen kommer att publiceras på kursens hemsida senast fyra veckor före kursstart.

Examination

  • LAB2 - Laboratory Work, 3.0 credits, grade scale: P, F
  • PRO1 - Project, 1.5 credits, grade scale: P, F
  • TEN2 - Examination, 3.0 credits, grade scale: A, B, C, D, E, FX, F

Requirements for final grade

Written examination (TENA; 3,0 cr)
Project Work (PRO1; 1,5 cr)
Laboratory Work (LABA; 3,0 cr)

Offered by

ABE/Geoinformatics

Contact

Gyözö Gidofalvi, Tel. 08-7907341, gyozo.gidofalvi@abe.kth.se

Examiner

Gyözö Gidofalvi <gyozo.gidofalvi@abe.kth.se>

Version

Course plan valid from: Autumn 13.
Examination information valid from: Autumn 10.