Advanced visualization for OLAP

ABSTRACT

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.

REFERENCES

• 1: Michael Gebhardt , Matthias Jarke , Stephan Jacobs, A toolkit for negotiation support interfaces to multi-dimensional data, Proceedings of the 1997 ACM SIGMOD international conference on Management of data, p.348-356, May 11-15, 1997, Tucson, Arizona, United States
• 2: Jiawei Han, Towards on-line analytical mining in large databases, ACM SIGMOD Record, v.27 n.1, p.97-107, March 1998 [doi>10.1145/273244.273273]
• 3: W. H. Inmon, Building the data warehouse (2nd ed.), John Wiley & Sons, Inc., New York, NY, 1996
• 4: Visualization and Knowledge Discovery for High Dimensional Data, Proceedings of the Second International Workshop on User Interfaces to Data Intensive Systems (UIDIS'01), p.1, May 31-June 01, 2001
• 5: D.A. Keim. Visual Data Mining. Tutorials of the 23rd International Conference on Very Large Data Bases, Athens, Greece, 1997.
• 6: Hans-Joachim Lenz , Bernhard Thalheim, OLAP Databases and Aggregation Functions, Proceedings of the 13th International Conference on Scientific and Statistical Database Management, p.91-100, July 18-20, 2001
• 7: Various Authors: The Lowell Database Research Self Assessment. Lowell, Massachusetts USA, May 4-6, 2003. Available at: http://research.microsoft.com/~Gray/lowell/.
• 8: Andreas Maniatis, Panos Vassiliadis, Spiros Skiadopoulos, Yannis Vassiliou: Advanced Visualization for OLAP (long version).
• 9: George A. Miller. The magical number seven, plus or minus two: Some limits on our capacity for processing information http://psychclassics.yorku.ca/Miller/. Psychological Review, 63, 81--97 (1956).
• 10: Microsoft Corp. OLEDB for OLAP February 1998. Available at: http://www.microsoft.com/data/oledb/olap/.
• 11: Andreas Maniatis, Panos Vassiliadis, Spiros Skiadopoulos, Yannis Vassiliou: CPM: A Cube Presentation Model for OLAP. DaWaK 2003, Prague, Czech Republic, September 3-5 2003.
• 12: Peter Pirolli , Ramana Rao, Table lens as a tool for making sense of data, Proceedings of the workshop on Advanced visual interfaces, May 27-29, 1996, Gubbio, Italy [doi>10.1145/948449.948460]
• 13: Sunita Sarawagi , Rakesh Agrawal , Nimrod Megiddo, Discovery-Driven Exploration of OLAP Data Cubes, Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology, p.168-182, March 23-27, 1998
• 14: Ramana Rao , Stuart K. Card, The table lens: merging graphical and symbolic representations in an interactive focus + context visualization for tabular information, Proceedings of the SIGCHI conference on Human factors in computing systems: celebrating interdependence, p.318-322, April 24-28, 1994, Boston, Massachusetts, United States [doi>10.1145/191666.191776]
• 15: Thomas Ruf , Jürgen Görlich , Ingo Reinfels, Dealing with Complex Reports in OLAP Applications, Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery, p.41-54, September 01, 1999
• 16: Aris Tsois, Nikos Karayannidis, Timos Sellis: MAC: Conceptual Data Modeling for OLAP. Proc. of the International Workshop on DMDW 2001.
• 17: Panos Vassiliadis , Timos Sellis, A survey of logical models for OLAP databases, ACM SIGMOD Record, v.28 n.4, p.64-69, Dec.1999 [doi>10.1145/344816.344869]
• 18: Panos Vassiliadis , Spiros Skiadopoulos, Modelling and Optimisation Issues for Multidimensional Databases, Proceedings of the 12th International Conference on Advanced Information Systems Engineering, p.482-497, June 05-09, 2000

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Data models

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages
          Subjects: Report writers
  H.5 INFORMATION INTERFACES AND PRESENTATION (I.7)
      H.5.2 User Interfaces (D.2.2, H.1.2, I.3.6)

General Terms:
Design, Human Factors

Keywords:
on-line analytical processing, visualization