Kalender

Outline:

• Database Management Systems (DBMS)
• Geospatial database applications
• Geospatial data manipulation
• DBMS support for geospatial data

Reading: [RSV1,SC1]

Outline:

• The data modeling process
• The Entity-Relationship (E-R) model
  • Entities, attributes, relationships, cardinalities, keys
• Mapping ER to logical schema
• Relational databases
• SQL crash course

Reading:

• Basic SQL: [PGRi.2, SC2.2]
• SQL Functions: [PGR35.3-4]
• PL/pgSQL: Browse [PGR39]
• Advanved SQL: [PGRi.3]

Outline:

• Data storage and indexing in relational databases
• Basic indexing in a DBMS

Reading:

Outline:

• Motivation, requirements, and approaches for Spatial DBMS
• Representation of spatial objects
  • Geographic space models
  • Representation modes
• Steps to do spatial data modeling

Reading: [RSV3.3-5,SC2]

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]

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]

Outline:

• Concepts of Query Processing and Optimization (QPO)
• Spatial query processing and optimization
• Other techniques of QPO in SDB

Reading: [RSV7,SC5.1-3]

Outline:

• Intro to ArcSDE
  • Introduction
  • Characteristics
  • ESRI Geodatabase
  • Functionalities
• Intro to Oracle Spatial (10g)

Reading: [RSV8]

Outline:

• Various architectures of spatial databases
• Trends of spatial database techniques
• Recall final mini project

Outline:

• Introduction
• Conceptual modelling
• Architecture
• pgRaster

Reading: PostGIS documentation [PGS Ch5]

Oral group presentations of student projects (note seminar room location 3085)

For each project:

• 10 minute presentation (approximately 10 slides about the design, implementation, and assessment of the project)
• 10 minute discussions (subsequently groups formulate and submit written feedback on each of the other projects, see mini project assignment deliverables and assessment)