Kalender

Exportera Om schema på KTH

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

Kalender

Logga in till din kurswebb

Tidsperiod

Vy

Kontakt