Abstract
Multi-dimensional data occurs in many domains while a wide variety of text based and visual interfaces for querying such data exists. But many of these interfaces are not applicable to OLAP, as they do not support the use of dimension hierarchies for selection and aggregation. We introduce an interface technique which supports visual querying of OLAP data. It is based on a data graph rather than a data cube representation of the data. Our interface presents each dimension hierarchy in a zoomable panel which supports selection and aggregation at multiple levels. Users explore data and query by making selections in several dimension views. Three view coordinations are identified; progressive, global and result only. We demonstrate our interface technique with an example web log dataset of site visits organised into time, downloads, visitor address and referrer address dimensions. This article provides an extended treatment of an earlier short paper [6].
This is a preview of subscription content, log in via an institution to check access.
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
Ahlberg, C., Shneiderman, B.: Visual information seeking: tight coupling of dynamic query filters with starfield displays. In: Proceedings of CHI 1994, Boston, MA, April 1995. ACM Press, New York (1995)
Liechti, O., Sifer, M., Ichikawa, T.: Structured Graph Format: XML metadata for describing web site structure. In: Proc. of the 7th World Wide Web Conference, pp. 11–32 (1998)
North, C., Shneiderman, B.: Snap-Together visualization: a user interface for coordinating visualizations via relational schemata. In: Proc. of Advanced Visual Interfaces (2000)
Plaisant, C., Bruns, T., Doan, K., Shneiderman, B.: Interface and data architecture for query previews in networked information systems. ACM Transactions on Information Systems, 17 3, 320–341 (1999)
Pedersen, T., Jensen, C.: Multidimensional Database Technology. IEEE Computer 34(12) (2001)
Sifer, M.: A visual interface technique for exploring OLAP data with coordinated dimension hierarchies. In: Proc. ACM Conference on Information and Knowledge Management, New Orleans, November 2003, pp. 532–535 (2003)
Shneiderman, B.: Tree visualisation with treemaps: a 2-d space-filling approach. ACM Transactions on Graphics 11(1), 92–99 (1992)
Spence, R., Tweedie, L.: The Attribute Explorer: information synthesis via exploration. Interacting with Computers 11(2), 137–146 (1998)
Spenke, M., Beilken, C., Berlage, T.: FOCUS: the interactive table for product comparison and selection. In: Proceedings of UIST 1996, pp. 41–50. ACM Press, New York (1996)
Stolte, C., Tang, D., Hanrahan, P.: Query, Analysis, and Visualization of Hierarchically Structured Data using Polaris. In: Proc. ACM SIGKDD (July 2002)
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
Sifer, M. (2005). Exploring Web Logs with Coordinated OLAP Dimension Hierarchies. In: Bhalla, S. (eds) Databases in Networked Information Systems. DNIS 2005. Lecture Notes in Computer Science, vol 3433. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-31970-2_17
Download citation
DOI: https://doi.org/10.1007/978-3-540-31970-2_17
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-25361-7
Online ISBN: 978-3-540-31970-2
eBook Packages: Computer ScienceComputer Science (R0)