Abstract
OLAP applications are widely used by business analysts as a decision support tool. While exploring the cube, end-users are rapidly confronted by analyzing a huge number of drill paths according to the different dimensions. Generally, analysts are only interested in a small part of them which corresponds to either high statistical associations between dimensions or atypical cell values. This paper fits in the scope of discovery-driven dynamic exploration. It presents a method coupling OLAP technologies and mining techniques to facilitate the whole process of exploration of the data cube by identifying the most relevant dimensions to expand. At each step of the process, a built-in rank on dimensions is restituted to the users. It is performed through indicators computed on the fly according to the user-defined data selection. A proof of the implementation of this concept on the Oracle 10g system is described at the end of the paper.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Agresti, A.: Categorical Data Analysis. Wiley, New York (1990)
Cariou, V., Cubillé, J., Derquenne, C., Goutier, S., Guisnel, F., Klajnmic, H.: Built-in Indicators to Automatically Detect Interesting Cells in a Cube. In: Song, I.-Y., Eder, J., Nguyen, T.M. (eds.) DaWaK 2007. LNCS, vol. 4654, pp. 123–134. Springer, Heidelberg (2007)
Caron, E.A.M., Daniels, H.A.M.: Explanation of exceptional values in multi-dimensional business databases. European Journal of Operational Research 188(3), 884–897 (2008)
Chen, Q.: Mining exceptions and quantitative association rules in OLAP data cube. PhD Thesis, School of Computing Science, Simon Fraser University, British Columbia, Canada (1999)
Jobson, J.D.: Applied Multivariate Data Analysis. Regression and Experimental Design, vol. I. Springer, New York (1991)
Palpanas, T., Koudas, N.: Using Datacube aggregates for approximate querying and deviation detection. IEEE Trans. on Knowledge and Data Engineering 17(11), 1–11 (2005)
Sarawagi, S., Agrawal, R., Megiddo, N.: Discovery-driven exploration of OLAP data cubes. Technical report, IBM Almaden Research Center, San Jose, USA (1998)
Sarawagi, S.: Explaining differences in multidimensional aggregates. In: Proceedings of the 25th International Conference On Very Large Databases (VLDB 1999) (1999)
Sarawagi, S.: User-adaptative exploration of multidimensional data. In: Proceedings of the 26th International Conference On Very Large Databases (VLDB 2000) (2000)
Sathe, G., Sarawagi, S.: Intelligent Rollups in Multidimensional OLAP Data. In: Proceedings of the 27th International Conference On Very Large Databases (VLDB 2001) (2001)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Cariou, V., Cubillé, J., Derquenne, C., Goutier, S., Guisnel, F., Klajnmic, H. (2008). Built-In Indicators to Discover Interesting Drill Paths in a Cube. In: Song, IY., Eder, J., Nguyen, T.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2008. Lecture Notes in Computer Science, vol 5182. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-85836-2_4
Download citation
DOI: https://doi.org/10.1007/978-3-540-85836-2_4
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-85835-5
Online ISBN: 978-3-540-85836-2
eBook Packages: Computer ScienceComputer Science (R0)