Requirements-based approach for multidimensional design

Moukhi, Nawfal El; Azami, Ikram El; Mouloudi, Abdelaziz; Elmounadi, Abdelali

doi:10.1016/j.procs.2019.01.041

Cited by 4 publications

(3 citation statements)

References 11 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…OVERVIEW OF THE PROPOSED APPROACH The design of a DW is a complex, difficult and tedious task [18] [19] [20]; it requires skilled persons in design approaches and, in On-Line Transaction Processing (OLTP) and OLAP systems. Therefore, involving the decision-makers reveals a challenge since they completely ignore the DW design approaches.…”

Section: IVmentioning

confidence: 99%

A Prototyped NL-Based Approach for the Design of Multidimensional Data Warehouse

Alzahrani

Alqarni

Feki

2020

IJCIT

View full text Add to dashboard Cite

Organizations are more and more interested in the Data Warehouse (DW) technology and data analytics to base their decision-making processes on scientific arguments instead of intuition. Despite the efforts invested, the DW design issue remains a great challenging research domain. The design quality of the DW depends on several aspects, as the requirement gathering. In this context, we propose a Natural Language (NL) based design approach, which is twofold, first, it facilitates the involvement of the decision-makers in the DW design process; indeed, NL can encourage the decision-makers to express their requirements as English-like sentences conform to NL-templates. Secondly, our approach aims to generate semi-automatically a DW schema from a set of requirements gathered as analytical queries compliant to the NL-templates. This design approach relies on (i) two easy-to-use NL-templates to specifying the analysis components, and (ii) a set of five heuristic rules for extracting the multidimensional concepts from the requirements. We demonstrate the feasibility of our approach by developing the prototype Natural Language Decisional Requirements to DW Schema (NLDR2DWS).

show abstract

Section: IVmentioning

confidence: 99%

A Prototyped NL-Based Approach for the Design of Multidimensional Data Warehouse

Alzahrani

Alqarni

Feki

2020

IJCIT

View full text Add to dashboard Cite

show abstract

“…In order to overcome these gaps, the authors tried through this paper to present a new hybrid method of the sequential compound type that allows to offer relevant results in a reasonable time and to collect and analyze requirements expressed in a natural language that can be used by all users and without the intervention of any developer or designer. To carry out this new method, the authors used their previous works [1], [2], [14]- [17] by combining the data-driven method X-ETL with the requirements-driven method XCube Assist.…”

Section: Related Workmentioning

confidence: 99%

“…In this sense, the authors introduced through this paper, a new hybrid method that is easy to use with a reasonable deployment time. The new hybrid method is based on a combination between the data-driven method X-ETL [1] and the requirements-driven method XCube Assist [2]. The paper is organized as follows: Section 2 presents the different hybrid methods developed to date as well as a critical analysis and comparison between these different methods.…”

Section: Introductionmentioning

confidence: 99%

Merge of X-ETL and XCube towards a Standard Hybrid Method for Designing Data Warehouses

Moukhi¹,

Azami²,

Mouloudi³

et al. 2019

IJACSA

Self Cite

View full text Add to dashboard Cite

There is no doubt that the hybrid approach is the best paradigm for designing effective multidimensional schemas. Its strength lies in its ability to combine the top-down and bottom-up approaches, thus exploiting the advantages of both approaches. In this paper, the authors try to identify and analyze the different hybrid methods developed for building data warehouses. The analysis revealed that the existing methods are too complicated and time consuming in the deployment phase. In order to solve this problem, the authors introduced a new hybrid method that is easy to use and saves a huge amount of deployment time. This new method consists of two main steps: the first data driven step allows an analysis of the source models by using the X-ETL method and gives rise to star models. The second requirements driven step performs a semantic analysis of the needs expressed in natural language by using the XCube Assist method. This analysis allows to improve the quality of star models generated by the X-ETL method without the intervention of a designer.

show abstract

Toward a methodology of requirements definition for prognostics and health management system to support aircraft predictive maintenance

Verhagen

Curran

2020

Aerospace Science and Technology

View full text Add to dashboard Cite

Requirements-based approach for multidimensional design

Cited by 4 publications

References 11 publications

A Prototyped NL-Based Approach for the Design of Multidimensional Data Warehouse

A Prototyped NL-Based Approach for the Design of Multidimensional Data Warehouse

Merge of X-ETL and XCube towards a Standard Hybrid Method for Designing Data Warehouses

Toward a methodology of requirements definition for prognostics and health management system to support aircraft predictive maintenance

Contact Info

Product

Resources

About