OLAP (On Line Analytical Processing) is a set of techniques and operators to facilitate the analysis of data that are usually stored in a specialized database known as data warehouse. Data is analyzed in order to provide information about a particular business subject called fact, for example, crimes, sales, shipments, among others. In this paper, we extend the functionality of an OLAP operator, known as map cube, with the definition and incorporation of a function called Trajectory. This function allows the analysts extract the trajectory followed by a set of facts. For example, the trajectory of crimes of each suspect, starting from his/her oldest crime to his/her more recent one. In order to prove the expediency of our proposal, we developed a prototype that was applied to a case study of crimes in Pennsylvania. Although more extensive experiments are required, our results show patterns that can help to understand the modus operandi of suspects.
Digital Object Identifier (DOI)
Moreno, Francisco; Camilo Alzate, Juan; and Hern?ndez, Jes?s
"Extracting Trajectories with the Map Cube Operator,"
Applied Mathematics & Information Sciences: Vol. 08:
5, Article 8.
Available at: https://digitalcommons.aaru.edu.jo/amis/vol08/iss5/8