Title: From spatial data warehouse and decision-making tool to SOLAP generalisation approach for efficient road risk analysis

Authors: Khalissa Amieur Derbal; Zioual Tahar; Kamel Boukhalfa; Ibtissem Frihi; Zaïa Alimazighi

Addresses: Computer Science Department, USTHB University, Algiers ' Computer Science Department, Higher National School of Computer Sciences, Algiers ' Computer Science Department, USTHB University, Algiers ' Computer Science Department, UMBB University, Algiers ' Computer Science Department, USTHB University, Algiers

Abstract: Plague of modern times, the phenomenon of the traffic accidents hampers heavily resources of the society. The road mows every year thousands of deaths and tens of thousands wounded. This frightening number of victims requires a study of this phenomenon in order to extract all indicators affecting this problem and allow proposing preventive measures. Traditionally, the analysis is performed on alphanumeric data, but some phenomenon as road risk are closely related to their geographic environments where the need to integrate the geographical dimension in the analysis process. In previous work, we have integrated geographic information (GI) represented by a road object in the analysis of this phenomenon. A map with road network theme is so displayed as a response to a SOLAP query. Graphic markers are used to emphasise certain information like dangerous roads. Although displayed maps may be congested and imperceptible, we so propose to improve the displayed information quality by adapting the displayed map to the needs of decision-makers. Maps with different levels of detail are so provided and associated with different analysis levels. This is achieved through on-the-fly map generalisation, which is a well known concept, widely addressed in cartographic domain that we adapt to SOLAP applications. A geospatial decision-making solution based on a spatial data warehouse and a geospatial tool is developed. Some functionalities of our developed geo-decisional tool are described in the experiment section.

Keywords: spatial OLAP; SOLAP; spatial data warehouse; SDW; on-the-fly map generalisation; hierarchical spatial data structures; geospatial decision making; road risks; risk assessment; traffic accidents; road accidents; geographic information; dangerous roads; information quality.

DOI: 10.1504/IJITM.2016.079605

International Journal of Information Technology and Management, 2016 Vol.15 No.4, pp.364 - 386

Received: 01 Dec 2014
Accepted: 23 Jun 2015

Published online: 22 Sep 2016 *

Full-text access for editors Access for subscribers Purchase this article Comment on this article