Given the need for the management of geographic historical operational data, this work proposes and verifies the design and implementation of an architecture for a Spatial Data Warehouse (SDW), using FOSS4G tools such as: PostgreSQL + PostGIS for the spatial database; Talend Open Studio + SDI for the ETL procedure; GeoServer as a map server; SOLAP in SpagoBI Server and its secondary tools. The implementation of ADE (Spatial Data Warehouse) allowed the analysis of a case study that demonstrates the possibility of the application of ADE in management processes in social, business or research areas.
- Spatial data store
CACES Knowledge Areas
- 216A Network and Database Design and Administration