Multidimensional database for crime prevention

The concept of multidimensional database and OLAP are usually understood as a part of Business intelligence. The paper presents the design of multidimensional database for crime prevention containing aggregated data from various crime registers and many other different sources for population, unemployment, properties, health, facilities etc. ETL processes enable to harmonize, aggregate, anonymize and integrate data among different topics. Fact tables are interlinked due to several shared dimensions, especially geographical and temporal dimensions. The SW and GIS solution includes a map client and a dashboard panel to implement selected OLAP principles and to provide easy tools for exploring and understanding complex factors and impacts of changes, and finally also for strategic crime prevention.