Intended learning outcomes
- Understand the object-relational model and its support to 2D geometries according to OGC standards.
- Employ the “theme algebra” (relational algebra extension) to formulate queries with geometric and alphanumeric data.
- Construct the conceptual model extended with geometries and topological constraints.
- Construct topological matrixes to compose constraints and queries; choose and adapt a pattern matrix to satisfy project requirements.
- Construct geometries via SQL (e.g., in PostGIS) and integrate with layer-based graphical presentation (e.g., in QuantumGIS).
- Understand the 3D representation and integration in the object-relational (e.g., X3D in PostGIS); implement scene¬- graphs with grouping nodes and with event generation and animations.
- Understand Boolean and vector models to represent non-structured information.
- Employ indexation process and information retrieval techniques using reference system (e.g., Lucene); choose distance metrics to satisfy project requirements.