Till KTH:s startsida Till KTH:s startsida

Logga in till din kurswebb

Du är inte inloggad på KTH så innehållet är inte anpassat efter dina val.

Ändra tidsperiod eller vy
Vecka 13 2015 Visa i Mitt schema
Mån 23 mar 13:00-15:00 L1 - Introduction + Spatial Database Course Overview
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

Database Management Systems (DBMS)

Geospatial database applications

Geospatial data manipulation

DBMS support for geospatial data

Reading: [RSV1,SC1]

Ons 25 mar 10:00-12:00 L2 - Introduction to Relational Databases and Modeling
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

The data modeling process

The Entity-Relationship (E-R) model

- Entities, attributes, relationships, cardinalities, keys

​Mapping ER to logical schema

Relational databases and SQL



Reading: [SC2.2,PGRi.2]

Tors 26 mar 13:00-17:00 Lab-1 Introduction to RDBMS and SQL
VT 2015
Datorlaboration
Plats: Nils
Vecka 14 2015 Visa i Mitt schema
Ons 1 apr 10:00-12:00 L3 - SQL and Data Indexing Techniques in Relational Databases
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

More SQL

- Joins and other DML

- Views​

- Functions (procedures)

​Data storage and indexing in relational databases

Basic indexing in an DBMS

Reading: [PGRi.3,PGR35.3-4,PGR11]

Vecka 15 2015 Visa i Mitt schema
Ons 8 apr 13:00-17:00 Lab-2 Introduction to Relational Database and Modeling
VT 2015
Datorlaboration
Plats: Nils
Vecka 16 2015 Visa i Mitt schema
Mån 13 apr 13:00-15:00 L4 - Spatial Concepts and Data Modeling in Spatial Databases
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

Motivation, requirements, and approaches for Spatial DBMS

Representation of spatial objects

- Geographic space models

- Representation modes

​Steps to do spatial data modeling

Final mini project



Reading: [RSV3.3-5,SC2]

Tors 16 apr 08:00-12:00 Lab-3 SQL and Data Indexing Techniques in Relational Database
VT 2015
Datorlaboration
Plats: Nils
Vecka 17 2015 Visa i Mitt schema
Tis 21 apr 10:00-12:00 L5 - Spatial Query Languages
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

Spatial data modeling review

- Basic concepts and case study

Structured Query Language for RDBMS review

- “Advanced” features and examples

GSQL: Spatially extended Structured Query Language

- Basic concepts and examples

Reading: [RSV2,RSV3.2-5,SC3,PGS4]

Tis 21 apr 13:00-17:00 Lab-4 ​ Data Modeling with SDBMS(1): Conceptual and Logical Modeling
VT 2015
Datorlaboration
Plats: Nils
Vecka 18 2015 Visa i Mitt schema
Tis 28 apr 10:00-12:00 L6 - Spatial Data Storage and Access Methods
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

Physical Data Model and Data Storage in Database

- ​Physical Data Model in DBMS (e.g. RDBMS)

- Data Storage in DBMS (e.g. RDBMS)

Spatial Data Storage and Access Methods in SDB

​- Spatial Data Storage in SDB

- Spatial Data Access Methods in SDB

Working with Spatial Data Access using SQL

- Using spatial indices to speed up the processing of spatial queries

Performance Tuning of SDB

- Involving Spatial Data Storage and Access Methods

- Experiments in PostGIS/PostgreSQL

Reading: [RSV6,SC4]

Tis 28 apr 13:00-17:00 Lab-5 A Small GIS Project with Spatial Databases
VT 2015
Datorlaboration
Plats: Nils

Students can work on the mini-project and get assistance for the Lab 4 exercises. 

Vecka 19 2015 Visa i Mitt schema
Tis 5 maj 10:00-12:00 L7 - Spatial Queries Processing and Optimization
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

Concepts of Query Processing and Optimization (QPO)

Spatial query processing and optimization

Other techniques of QPO in SDB



Reading: [RSV7,SC5]

Tis 5 maj 13:00-17:00 Lab-6 Introduction to pgRouting
VT 2015
Datorlaboration
Plats: Fagott
Vecka 20 2015 Visa i Mitt schema
Tis 12 maj 10:00-12:00 L8 - Introduction to Commercial Systems
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

Intro to ArcSDE

- Introduction

- Characteristics

- ESRI Geodatabase

- Functionalities​

Intro to Oracle Spatial (10g)

Reading: [RSV8]

Tis 12 maj 13:00-17:00 Lab-7 A Small GIS Project with Spatial Databases
VT 2015
Datorlaboration
Plats: Nils
Vecka 21 2015 Visa i Mitt schema
Tis 19 maj 10:00-12:00 L9 - Architecture, Standards, Trends and Application of SDB
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

Various architectures of spatial databases

Trends of spatial database techniques

Recall final mini project requirements + presentations

Reading: [SC8]

Tis 19 maj 13:00-17:00 Lab-8 A Small GIS Project with Spatial Databases
VT 2015
Datorlaboration
Plats: Nils
Vecka 22 2015 Visa i Mitt schema
Mån 25 maj 10:00-12:00 L10 - Advanced Topics in Spatial Data Management and Processing: Case Studies
VT 2015
Föreläsning Lärare: Gyözö Gidofalvi
Anmärkning: Egen sal, DKV 30, Seminar room 3085

Outline:

Introduction

Conceptual Modelling

Architecture

Mån 25 maj 13:00-17:00 Lab-9 A Small GIS Project with Spatial Databases
VT 2015
Datorlaboration
Plats: Nils
Vecka 23 2015 Visa i Mitt schema
Mån 1 jun 09:00-13:00 Exam
VT 2015
Tentamen
Plats: V11