| Title | Toward a Natural Language-Based Approach for the Specification of Decisional-Users Requirements |
| Publication Type | Conference Paper |
| Year of Publication | 2020 |
| Authors | Alzahrani, A., Feki, J. |
| Conference Name | 2020 3rd International Conference on Computer Applications Information Security (ICCAIS) |
| Keywords | cleaning, complex task, Constellation schema, critical task, Data analysis, data analytics, Data Warehouse, Data Warehouse technology, data warehouses, decision making, decision-makers, decision-making processes, decisional-users requirements, DW design, DW model, DW multidimensional schema, great challenge research domain, Human Behavior, multidimensional components, Multidimensional Model, natural language, natural language NL-template, natural language processing, Natural languages, NL-templates, OLAP, On-Line-Analytical-Processing queries, Ontologies, pubcrawl, query processing, query-like English sentences, requirement-gathering phase, Resiliency, Scalability, Star schema, Task Analysis, Tools, Writing |
| Abstract | The number of organizations adopting the Data Warehouse (DW) technology along with data analytics in order to improve the effectiveness of their decision-making processes is permanently increasing. Despite the efforts invested, the DW design remains a great challenge research domain. More accurately, the design quality of the DW depends on several aspects; among them, the requirement-gathering phase is a critical and complex task. In this context, we propose a Natural language (NL) NL-template based design approach, which is twofold; firstly, it facilitates the involvement of decision-makers in the early step of the DW design; indeed, using NL is a good and natural means to encourage the decision-makers to express their requirements as query-like English sentences. Secondly, our approach aims to generate a DW multidimensional schema from a set of gathered requirements (as OLAP: On-Line-Analytical-Processing queries, written according to the NL suggested templates). This approach articulates around: (i) two NL-templates for specifying multidimensional components, and (ii) a set of five heuristic rules for extracting the multidimensional concepts from requirements. Really, we are developing a software prototype that accepts the decision-makers' requirements then automatically identifies the multidimensional components of the DW model. |
| DOI | 10.1109/ICCAIS48893.2020.9096732 |
| Citation Key | alzahrani_toward_2020 |
Toward a Natural Language-Based Approach for the Specification of Decisional-Users Requirements