Využití OLAP nadstaveb v GIS

vedoucí práce: Ing. Zdena Dobešová, Ph.D.

Summary

This thesis presents the results of the final part of the master study program on Geoinformatics at the Faculty of Science, Palacky University in Olomouc.

The contribution of OLAP technology for GIS was examined in this thesis. Possibilities of two OLAP extensions (OLAP for ArcGIS for ArcGIS Desktop 9.x and PostGeoOLAP for PostgreSQL/PostGIS) there were found out and described. Two test data cubes were created for this purpose.

Data cubes don’t have to contain spatial data, because results of OLAP analysis are joined with them only in GIS environment. For this reason OLAP extensions don’t have no other functionality towards database servers, which can perform OLAP analysis in own environment. Databases servers often have more possibilities in execution of OLAP analysis, so there isn’t considerable reason for using these extensions.

OLAP technology is shown as very effective tool for processing of considerable quantity of multidimensional data, which are often used in GIS. Resulting aggregated values can be visualized in GIS environment or analyzed in spatial or non-spatial form. In thesis the problem of successful using of OLAP technology during real project processing was discussed.

In the end there was presented other possibilities of development of OLAP technology and GIS cooperation. It is for example implementation of spatial query into OLAP analysis, which was mentioned in discussion part of thesis too. There was described possibility, how to obtain aggregated values from spatial layers instead of data in table form by OLAP analysis.