Intelligent data cube construction and exploration

Data cubes are multi-dimensional structures that consist of dimensions and measures. Analysts can view the performance measures via different perspectives provided by the available dimensions in data cubes. However, modeling of these meaningful dimensions and selection of informative measure is a difficult task for human data warehouse developers. In high dimensional environments, the sheer size and volume of data poses a number of challenges in order to generate meaningful data cubes. Nowadays, there is a growing requirement of automated and intelligent techniques that allows analysts to construct and explore the large cubes for better decision making. In this paper, we have reviewed the literature on intelligent data cubes construction and exploration. Literature review reveals that a number of techniques have been proposed to embed intelligence in data cubes. However, majority of the previously proposed technique targeted either on providing intelligence in cube construction or focused assisting the intelligent exploration of data cubes. However, there is very limited amount of work has been done in the integration of intelligent techniques for both cube construction and exploration. We believe that it is a strong area of research and the modern analytical systems demand the availability of intelligent techniques for both construction and exploration of large data cubes for making intelligent decisions. The objective of this paper is to present a critical review of the existing techniques and to propose a conceptual model that not only overcomes the individual limitations in the previous work but also merges the benefits of intelligent construction and exploration of cubes in parallel. However, the implementation of the proposed model is beyond the scope of this paper.

[1]  Sohail Asghar,et al.  Enhancing OLAP functionality using self-organizing neural networks , 2004 .

[2]  Hongjun Lu,et al.  Requirement-based data cube schema design , 1999, CIKM '99.

[3]  Navin Kumar,et al.  Navigation Rules for Exploring Large Multidimensional Data Cubes , 2006, Int. J. Data Warehous. Min..

[4]  Walid G. Aref,et al.  Knowledge cubes — A proposal for scalable and semantically-guided management of Big Data , 2013, 2013 IEEE International Conference on Big Data.

[5]  Sunita Sarawagi,et al.  Intelligent Rollups in Multidimensional OLAP Data , 2001, VLDB.

[6]  Nimrod Megiddo,et al.  Discovery-Driven Exploration of OLAP Data Cubes , 1998, EDBT.

[7]  Alvis Cheuk M. Fong,et al.  A data mining approach to knowledge discovery from multidimensional cube structures , 2013, Knowl. Based Syst..

[8]  Bernhard Mitschang,et al.  Augmenting OLAP exploration with dynamic advanced analytics , 2010, EDBT '10.

[9]  T. Critchlow,et al.  Hybrid Multidimensional Relational and Link Analytical Knowledge Discovery for Law Enforcement , 2008, 2008 IEEE Conference on Technologies for Homeland Security.

[10]  Ju-Hong Lee,et al.  Dynamic Update Cube for Range-sum Queries , 2001, VLDB.

[11]  Hongjun Lu,et al.  Condensed cube: an effective approach to reducing data cube size , 2002, Proceedings 18th International Conference on Data Engineering.

[12]  Terence R. Smith,et al.  Relative prefix sums: an efficient approach for querying dynamic OLAP data cubes , 1999, Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337).

[13]  Sunita Sarawagi,et al.  iDiff: Informative Summarization of Differences in Multidimensional Aggregates , 2001, Data Mining and Knowledge Discovery.

[14]  Peter Thanisch,et al.  Constructing OLAP cubes based on queries , 2001, DOLAP '01.

[15]  P. Radha Krishna,et al.  Fuzzy OLAP cube for qualitative analysis , 2005, Proceedings of 2005 International Conference on Intelligent Sensing and Information Processing, 2005..