Data Warehouses and On-Line Analytical Processing systems rely on a multidimensional model that includes dimensions, hierarchies, and measures. Such model allows to express users' requirements for supporting the decision-making process and to facilitate its afterward implementation. Although Data Warehouses typically include a spatial or location dimension, this dimension is usually represented in an alphanumeric format. However, it is well-known that a visual representation of spatial data allows to reveal patterns that are difficult to discover otherwise. Further, a multidimensional model is seldom used for representing spatial data.In this work we propose an extension of a conceptual multidimensional model with spatial dimensions, spatial hierarchies, and spatial measures. We also consider the inclusion of topological relationships and topological operators in the model. We analyze different scenarios showing the significance and convenience of the proposed extension.
Decisional systems are crucial for enterprise improvement. They allow the consolidation of heterogeneous data from distributed enterprise data stores into strategic indicators. An essential component of this data consolidation is the Extract, Transform, and Load (ETL) process. In the research literature there has been very few work defining conceptual models for ETL processes. At the same time, there are currently many tools that manage such processes. However, each tool uses its own model, which is not necessarily able to communicate with the models of other tools. In this paper, we propose a platform-independent conceptual model of ETL processes based on the Business Process Model Notation (BPMN) standard. We also show how such a conceptual model can be implemented using Business Process Execution Language (BPEL), a standard executable language for specifying interactions with web services.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.