Data cubes retrieval and design in OLAP systems: from query analysis to visualisation tool
by Rahma Djiroun; Kamel Boukhalfa; Zaia Alimazighi
International Journal of Business Intelligence and Data Mining (IJBIDM), Vol. 14, No. 1/2, 2019

Abstract: Business intelligence systems provide an effective solution from large volumes of data for multidimensional online computing and analysis. Usually, in a decision-making process, organisations and enterprises, require several internal and/or external cubes which are often heterogeneous. Most of the time, the structure of these cubes is unknown to the decision-makers. To analyse a phenomenon, the decision-maker seeks among sets of cubes, in a collection, the cube which responds better to his need. In this context, we propose an approach that enables decision-makers to express their needs via a query expressed in a natural language, returns top-K relevant cubes and designs/constructs new cubes when no, or few deployed cubes are relevant. We propose a tool called RD-cubes-query implementing our approach in a ROLAP architecture. We use this tool in some experiments to validate our approach.

Online publication date: Tue, 11-Dec-2018

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Business Intelligence and Data Mining (IJBIDM):
Login with your Inderscience username and password:

    Username:        Password:         

Forgotten your password?


Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com