Enhancing the involvement of decision makers in data mart design

Bargui, Fahmi; Ben-Abdallah, Hanêne; Feki, Jamel

doi:10.1504/ijdats.2019.098820

Cited by 2 publications

(2 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Inversely, Top-down approaches may produce a DW schema closely related to the users' requirements; it may be incomplete when the requirements are not exhaustive or are ambiguous, or need data not existing in the DS. The third category of approaches is a compromise that aims to benefit from the advantages of top-down and bottom-up approaches while avoiding the shortcomings of each one [8] [9] [10] [11].…”

Section: General Context and Basic Conceptsmentioning

confidence: 99%

See 1 more Smart Citation

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

Alzahrani

Alqarni

Feki

2020

IJCIT

Self Cite

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: General Context and Basic Conceptsmentioning

confidence: 99%

“…Other authors in [11] have focused on using a decisional ontology to support the decision-makers requirements specification. They present a NL goal-based template to express the requirements and enhance the involvement of the stakeholders.…”

Section: IIImentioning

confidence: 99%