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 and SQL

Reading: [SC2.2,PGRi.2]

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]

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]

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]

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 requirements + tutorial
• presentations

Reading: [SC8]

Outline:

• Introduction
• 
  Conceptual Modelling
• 
  Architecture