Abstract
Business data collection is growing exponentially in recent years. A variety of industries and businesses have adopted new technologies of data storages such as data warehouses. On Line Analytical Processing (OLAP) has become an important tool for executives, managers, and analysts to explore, analyze, and extract interesting patterns from enormous amount of data stored in data warehouses and multidimensional databases. However, it is difficult for human analysts to interpret and extract meaningful information from large amount of data if the data is presented in textual form as relational tables. Visualization and interactive tools employ graphical display formats that help analysts to understand and extract useful information fast from huge data sets. This paper presents a new visual interactive exploration technique for an analysis of multidimensional databases. Users can gain both overviews and refine views on any particular region of interest of data cubes through the combination of interactive tools and navigational functions such as drilling down, rolling up, and slicing. Our technique allows users who are not experts in OLAP technology to explore and analyze OLAP data cubes and data warehouses without generating sophisticated queries. Furthermore, the visualization in our technique displays the exploration path enhancing the user’s understanding of the exploration.
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
Chaudhuri, S., Dayal, U.: An overview of data warehousing and olap technology. SIGMOD Rec. 26, 65–74 (1997)
O’Donnell, P., Draper, N.: An experimental evaluation of an alternative to the pivot table for ad hoc access to olap dat. In: Proceedings of the 2004 IFIP International Conference on Decision Support Systems (DSS 2004): Decision Support in an Uncertain and Complex World (2004)
Microsoft excel:user’s guide 2, version 4.0. Redmond, WA Microsoft Corperation (1992)
Thomsen, E.: OLAP Solutions Building Multidimensional Information Systems. Wiley Computer Publishing, Chichester (1997)
Eick, S.G.: Visualizing multi-dimensional data. SIGGRAPH Computer Graphics 34, 61–67 (2000)
Inselberg, A., Dimsdale, B.: Parallel coordinates for visualizing multidimensional geometry. In: Computer Graphics (Proceedings of CG International), pp. 25–44 (1987)
Chris Stolte, D.T., Hanrahan, P.: Polaris: a system for query, analysis, and visualization of multidimensional relational databases. IEEE Transactions on Visualization and Computer Graphics 8, 52–65 (2002)
Chris Stolte, D.T., Hanrahan, P.: Query, analysis, and visualization of hierarchically structured data using polaris. In: Proceedings of the sixth ACM SIGKDD international conference on Knowledge discovery and data mining, pp. 112–122. ACM Press, New York (2002)
Maniatis, A.S., Vassiliadis, P., Skiadopoulos, S., Vassiliou, Y.: Advance visualization for olap. In: Proceedings of the 6th ACM international workshop on data wareshousing and OLAP, pp. 9–16. ACM Press, New York (2003)
Techapichetvanich, K., Datta, A., Owens, R.: Hddv: Hierarchical dynamic dimensional visualization. In: Proc. IASTED International Conference on Databases and Applications, pp. 157–162 (2004)
Nolan, C.: Manipulate and query olap data using adomd and multidimensional expression. Microsoft Systems Journal. Microsoft (1999)
(Microsoft), http://msdn.microsoft.com
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Techapichetvanich, K., Datta, A. (2005). Interactive Visualization for OLAP. In: Gervasi, O., et al. Computational Science and Its Applications – ICCSA 2005. ICCSA 2005. Lecture Notes in Computer Science, vol 3482. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11424857_23
Download citation
DOI: https://doi.org/10.1007/11424857_23
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-25862-9
Online ISBN: 978-3-540-32045-6
eBook Packages: Computer ScienceComputer Science (R0)