Advanced visualization for OLAP

Data visualization is one of the big issues of database research. OLAP as a decision support technology is highly related to the developments of data visualization area. In this paper we demonstrate how the Cube Presentation Model (CPM), a novel presentational model for OLAP screens, can be naturally mapped on the Table Lens, which is an advanced visualization technique from the Human-Computer Interaction area, particularly tailored for cross-tab reports. We consider how the user interacts with an OLAP screen and based on the particularities of Table Lens, we propose an automated proactive users support. Finally, we discuss the necessity and the applicability of advanced visualization techniques in the presence of recent technological developments.

[1]  宮崎 耕,et al.  W. H. Inmon, Building the Data Warehouse , 1993 .

[2]  Jiawei Han,et al.  Towards on-line analytical mining in large databases , 1998, SGMD.

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

[4]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[5]  Thomas Ruf,et al.  Dealing with Complex Reports in OLAP Applications , 1999, DaWaK.

[6]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[7]  Alfred Inselberg.  Visualization and knowledge discovery for high dimensional data , 2001, Proceedings Second International Workshop on User Interfaces in Data Intensive Systems. UIDIS 2001.

[8]  Panos Vassiliadis,et al.  Modelling and Optimisation Issues for Multidimensional Databases , 2000, CAiSE.

[9]  Timos K. Sellis,et al.  MAC: Conceptual data modeling for OLAP , 2001, DMDW.

[10]  Timos K. Sellis,et al.  A survey of logical models for OLAP databases , 1999, SGMD.

[11]  Jennifer Widom,et al.  The Lowell database research self-assessment , 2003, CACM.

[12]  Ramana Rao,et al.  The table lens: merging graphical and symbolic representations in an interactive focus + context visualization for tabular information , 1994, CHI '94.

[13]  Ramana Rao,et al.  Table lens as a tool for making sense of data , 1996, AVI '96.

[14]  Bernhard Thalheim,et al.  OLAP databases and aggregation functions , 2001, Proceedings Thirteenth International Conference on Scientific and Statistical Database Management. SSDBM 2001.

[15]  Matthias Jarke,et al.  A toolkit for negotiation support interfaces to multi-dimensional data , 1997, SIGMOD '97.

[16]  Panos Vassiliadis,et al.  CPM: A Cube Presentation Model for OLAP , 2003, DaWaK.

[17]  G. A. Miller.  THE PSYCHOLOGICAL REVIEW THE MAGICAL NUMBER SEVEN, PLUS OR MINUS TWO: SOME LIMITS ON OUR CAPACITY FOR PROCESSING INFORMATION 1 , 1956 .