Prediction in OLAP Data Cubes

Fatima Zahra Salmam (), Mohamed Fakir () and Rahhal Errattahi ()
Additional contact information
Fatima Zahra Salmam: Laboratory of Information Processing and Decision Support, Department of Computer Science, Faculty of Sciences and Technology, Sultan Moulay, Slimane University, Morocco
Mohamed Fakir: Laboratory of Information Processing and Decision Support, Department of Computer Science, Faculty of Sciences and Technology, Sultan Moulay, Slimane University, Morocco
Rahhal Errattahi: Laboratory of Information Processing and Decision Support, Department of Computer Science, Faculty of Sciences and Technology, Sultan Moulay, Slimane University, Morocco

Journal of Information & Knowledge Management (JIKM), 2016, vol. 15, issue 02, 1-14

Abstract: Online analytical processing (OLAP) provides tools to explore data cubes in order to extract the interesting information, it refers to techniques used to query, visualise and synthesise the multidimensional data. Nevertheless OLAP is limited on visualisation, structuring and exploring manually the data cubes. On the other side, data mining allows algorithms that offer automatic knowledge extraction, such as classification, explanation and prediction algorithms. However, OLAP is not capable of explaining and predicting events from existing data; therefore, it is possible to make a more efficient online analysis by coupling data mining and OLAP to allow the user to assist in this new task of knowledge extraction. In this paper, we will carry on within works achieved in this theme and we suggest to extend the abilities of OLAP to prediction (enhancing the OLAP abilities and techniques by introducing a predictive model based on a data mining algorithms). The model is calculated on the aggregated data, and prediction is done on detailed missing data. Our approach is based on regression trees and neural networks; it consists to predict facts having a missed measures value in the data cubes. The user will have in his disposition, a new platform called PredCube, that offers the possibility to query, visualise and synthesise the multidimensional data, and also to predict missing values in the data cube using three data mining methods, and evaluate the quality of the prediction by comparing the average error and the execution time given by each one.

Keywords: Online analysis OLAP; data mining; multidimensional data cube; prediction; regression tree; neural network (search for similar items in EconPapers)
Date: 2016
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.worldscientific.com/doi/abs/10.1142/S0219649216500222
Access to full text is restricted to subscribers

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:wsi:jikmxx:v:15:y:2016:i:02:n:s0219649216500222

Ordering information: This journal article can be ordered from

DOI: 10.1142/S0219649216500222

Access Statistics for this article

Journal of Information & Knowledge Management (JIKM) is currently edited by Professor Suliman Hawamdeh

More articles in Journal of Information & Knowledge Management (JIKM) from World Scientific Publishing Co. Pte. Ltd.
Bibliographic data for series maintained by Tai Tone Lim ().