Skip to Main content Skip to Navigation
Conference papers

A Report-Driven Approach to Design Multidimensional Models

Abstract : Today, large organisations and regulated markets are subject to the control of external audit associations, which require the submission of a huge amount of information in the form of predefined and rigidly structured reports. The compilation of these reports requires the extraction, transformation and integration of data from different heterogeneous operational databases. This task is usually performed by developing a software ad hoc for each report, or by adopting a data warehouse and analysis tools, which are now established technologies. Unfortunately, the data warehousing process is notoriously long and error prone, and is therefore particularly inefficient when the output of the data warehousing is represented by a limited number of reports. This article presents “MMBR”, an approach that can generate a multidimensional model from the structure of expected reports as data warehouse output. The approach is able to generate the multidimensional model and populate the data warehouse by defining a knowledge base specific to the domain. Although the use of semantic information in data storage is not new, the novel contribution of our approach is represented by the idea of simplifying the design phase of the data warehouse, making it more efficient, by using an industry-specific knowledge base and a report-based approach.
Document type :
Conference papers
Complete list of metadata

Cited literature [24 references]  Display  Hide  Download

https://hal.inria.fr/hal-02060695
Contributor : Hal Ifip <>
Submitted on : Thursday, March 7, 2019 - 3:28:06 PM
Last modification on : Friday, June 11, 2021 - 9:26:03 AM
Long-term archiving on: : Sunday, June 9, 2019 - 9:48:54 AM

File

 Restricted access
To satisfy the distribution rights of the publisher, the document is embargoed until : 2022-01-01

Please log in to resquest access to the document

Licence


Distributed under a Creative Commons Attribution 4.0 International License

Identifiers

Citation

Antonia Azzini, Stefania Marrara, Andrea Maurino, Amir Topalović. A Report-Driven Approach to Design Multidimensional Models. 7th International Symposium on Data-Driven Process Discovery and Analysis (SIMPDA), Dec 2017, Neuchatel, Switzerland. pp.105-127, ⟨10.1007/978-3-030-11638-5_6⟩. ⟨hal-02060695⟩

Share

Metrics

Record views

188