DAREF: MDA framework for modelling data warehouse requirements and deducing the multidimensional schema
- PDF / 5,672,855 Bytes
- 23 Pages / 595.276 x 790.866 pts Page_size
- 77 Downloads / 151 Views
ORIGINAL ARTICLE
DAREF: MDA framework for modelling data warehouse requirements and deducing the multidimensional schema Omar El Beggar1 · Khadija Letrache1 · Mohammed Ramdani1 Received: 26 July 2018 / Accepted: 8 September 2020 © Springer-Verlag London Ltd., part of Springer Nature 2020
Abstract Nowadays, the growing importance of modelling in software engineering is without a doubt reinforced by the blossoming of model-driven architecture (MDA). In this trend, MDA could be considered the most convenient approach to integrate the modelling process in data warehousing projects. On the other hand, decision-makers are usually unable to express their business needs in a concise way that allows getting a valid data warehouse (DW), mainly due to the lack of standard methodologies and tools devoted to supporting this situation. This fact might expand the gap between the business world and the IT world and causes troublesome difficulties to interpret and model DW requirements. Moreover, applying MDA for this kind of project requires using new tools to avoid this drawback. In this paper, we provide an MDA framework to design DW requirements and generate afterwards the multidimensional schema. The framework is based on UML profiles and presents to decision-makers a graphical tool for modelling their strategic visions in order to build the system-to-be. Besides, the proposal allows for dealing with data historization and metadata in the generated multidimensional model to perform properly the extract transform load process. Keywords Data warehouse requirements · MDA · Multidimensional schema · Historization · Metadata · UML profile
1 Introduction Decision-makers expect to be able to visualize their business needs and communicate their requirements visually with the project stakeholders, in particular the IT experts. For this reason, using visual tools may improve communication during the elicitation phase of data warehouse requirements [1]. Furthermore, these tools may increase productivity and reduce the cost of DW manufacturing. It is common practice for DW developers to use a wide range of tools and techniques to design and develop isolated aspects of DW projects (storage, ETL process, online analytic processing (OLAP), reporting, etc.), instead of using integrated approaches or * Omar El Beggar [email protected] Khadija Letrache [email protected] Mohammed Ramdani [email protected] 1
LIM Laboratory‑Advanced Smart Systems, Department of Computer Science, Faculty of Sciences and Techniques of Mohammedia, University Hassan 2, Casablanca, Morocco
frameworks which deal with the overall DW process [2]. Most of them besides do not cover the decision-maker needs, although they are the end-users of the system-to-be. Interestingly, one of the most decisive phases that might strongly impact the DW development life cycle is the requirements analysis phase, as it has been claimed by the most of works in the literature [3–5]. DW projects could fail and have cost and time overruns if no enough attenti
Data Loading...
