A hybrid approach for data mart schema design from NL-OLAP requirements

Authors:
Fahmi Bargui;Hanene Ben-Abdallah;Jamel Feki
Affiliations:
Mir@cl Laboratory FSEG, University of Sfax Tunisia;Mir@cl Laboratory FSEG, University of Sfax Tunisia;Mir@cl Laboratory FSEG, University of Sfax Tunisia
Venue:
NLDB'09 Proceedings of the 14th international conference on Applications of Natural Language to Information Systems
Year:
2009

Citing 3
Cited 0

Process-Oriented Requirement Analysis Supporting the Data Warehouse Design Process - A Use Case Driven Approach

DEXA '00 Proceedings of the 11th International Conference on Database and Expert Systems Applications
An approach to engineering the requirements of data warehouses

Requirements Engineering
GRAnD: A goal-oriented approach to requirement analysis in data warehouses

Decision Support Systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

OLAP systems remain difficult to develop for two primary reasons. The first reason is that the REQ analysis step is typically overlooked [1]. The second reason is that, even when attention is accorded to this step, REQ are described from a too technical perspective for decision makers to understand and validate [2]. However, the lack of user involvement in the specification can easily lead to the failure of the project. To ensure the involvement of decision makers in REQ specification, two solutions are offered: non technical notations for OLAP REQ expression (cf., tabular format [3]) and approaches to assist decision makers in identifying their REQ (cf., goal-driven approaches with either a graphical notation [1] or SQL scenarios [4], reuse of MultiDimensional (MD) patterns representing generic OLAP REQ [5]). Despite the assistance they offer, the proposed REQ notations and specification approaches presume that the decision makers are familiar with the MD concepts and their relationships.