research-article

Free access

Polaris: a system for query, analysis, and visualization of multidimensional databases

Authors:

Pat HanrahanAuthors Info & Claims

Communications of the ACM, Volume 51, Issue 11

Pages 75 - 84

https://doi.org/10.1145/1400214.1400234

Published: 01 November 2008 Publication History

All formats PDF

Abstract

During the last decade, multidimensional databases have become common in the business and scientific worlds. Analysis places significant demands on the interfaces to these databases. It must be possible for analysts to easily and incrementally change both the data and their views of it as they cycle between hypothesis and experimentation.

In this paper, we address these demands by presenting the Polaris formalism, a visual query language for precisely describing a wide range of table-based graphical presentations of data. This language compiles into both the queries and drawing commands necessary to generate the visualization, enabling us to design systems that closely integrate analysis and visualization. Using the Polaris formalism, we have built an interactive interface for exploring multidimensional databases that analysts can use to rapidly and incrementally build an expressive range of views of their data as they engage in a cycle of visual analysis.

Supplementary Material

PDF File (p75-stolte.jp.pdf)

Requires Asian Language Support in Adobe Reader and Japanese Language Support in Your Browser.

Download
1.28 MB

References

[1]

Aiken, A., Chen, J., Stonebraker, M, and Woodruff, A. Tioga-2: A direct manipulation database visualization environment. Proceeding of the 12th International Conference on Data Engineering, February 1996, pp. 208--217.

Digital Library

[2]

Becker, R., Cleveland, W. S., and Douglas Martin, R. Trellis graphics displays: A multi-dimensional data visualization tool for data mining. 3rd Annual Conference on Knowledge Discovery in Databases, August 1997.

[3]

Bertin, J. Graphics and Graphic Information Processing. Walter de Gruyter, Berlin, 1980.

[4]

Bertin, J. Semiology of Graphics. The University of Wisconsin Press, Madison, WI, 1983. Translated by W J. Berg.

Digital Library

[5]

Bosch, R., Stolte, C., Stoll, G., Rosenblum, M., and Hanrahan, P. Performance analysis and visualization of parallel systems using SimOS and Rivet: A case study. Proceedings of the Sixth Annual Symposium on High-Performance Computer Architecture, January 2000, pp. 360--371.

[6]

Buja, A., Cook, D., and Swayne, D. F. Interactive high-dimensional data visualization. Journal of Computational and Graphical Statistics, 5(1):7--99,1996.

[7]

Cleveland, W. s. The Elements of Graphing Data. Wadsworth Advanced Books and Software, Pacific Grove, CA, 1985.

Digital Library

[8]

Cleveland, W. s. Visualizing Data. Hobart Press, New Jersey, 1993.

Digital Library

[9]

Igehy, H., Stoll, G., and Hanrahan, P. The design of a parallel graphics interface. Proceedings of SIGGRAPH, 1998, pp. 141--150.

Digital Library

[10]

Kosslyn, S. M. Elements of Graph Design. W.h. Freeman and Co., New York, NY, 1994.

[11]

Livny, M., Ramakrishnan, R., Beyer, K., Chen, G., Donjerkovic, D., Lawande, S., Myllymaki, J., and Wenger, K. Devise: Integrated querying and visual exploration of large datasets. Proceeding of ACM SIGMOD, May, 1997.

Digital Library

[12]

Mackinlay, J. D. Automating the design of graphical presentations of relational information. ACM Transaction of Graphics, April 1986, pp. 110--141.

Digital Library

[13]

Rogowitz, B. and Treinish, L. How Not to lie with visualization. Computers in Physics, May/June 1996, pp. 268--274.

Digital Library

[14]

Roth, S. F., Lucas, P., Senn, J. A., Gomberg, C. C., Burks, M. B., Stroffolino, P. J., Kolojejchick, J., and Dunmire, C. Visage: A user interface environment for exploring information. Proceeding of Information Visualization, october 1996, pp. 3--12.

Digital Library

[15]

spotfire Inc. {online} Available: http://www.spotfire.com, cited September 2001.

[16]

Stevens, S. S. on the theory of scales of measurement. Science, 103:677--680.

[17]

Stolte, C. Query, analysis, and visualization of multidimensional databases. PhD Dissertation, Stanford University, June 2003.

Digital Library

[18]

Thomsen, E. OLAP Solutions: Building Multidimensional Information Systems. Wiley Computer Publishing, New York, 1997.

Digital Library

[19]

Travis, D. Effective Color Displays: Theory and Practice. Academic Press, London, 1991.

[20]

Tufte, E. R. The Visual Display of Quantitative Information. Graphics Press, Box 430, Cheshire, CT, 1983.

Digital Library

[21]

Ward, M. Xmdv Tool: Integrating multiple methods for visualizing multivariate data. Proceedings of Visualization, October 1994, pp. 326--331.

Digital Library

[22]

Wilkinson, L. The Grammar of Graphics. Springer, New York, NY, 1999.

Digital Library

Cited By

Xia JLiu JBrown NChen YFeng YFilkov VRay BZhou M(2024)Refinement Types for VisualizationProceedings of the 39th IEEE/ACM International Conference on Automated Software Engineering10.1145/3691620.3695550(1871-1881)Online publication date: 27-Oct-2024
https://dl.acm.org/doi/10.1145/3691620.3695550
DeValk KElmqvist N(2023)Riverside: A design study on visualization for situation awareness in cybersecurityInformation Visualization10.1177/1473871623118922023:1(40-66)Online publication date: 17-Aug-2023
https://doi.org/10.1177/14738716231189220
Pandey AL'Yi SWang QBorkin MGehlenborg N(2023)GenoREC: A Recommendation System for Interactive Genomics Data VisualizationIEEE Transactions on Visualization and Computer Graphics10.1109/TVCG.2022.320940729:1(570-580)Online publication date: Jan-2023
https://doi.org/10.1109/TVCG.2022.3209407
Show More Cited By

Index Terms

Polaris: a system for query, analysis, and visualization of multidimensional databases

Recommendations

Query, analysis, and visualization of hierarchically structured data using Polaris
KDD '02: Proceedings of the eighth ACM SIGKDD international conference on Knowledge discovery and data mining

In the last several years, large OLAP databases have become common in a variety of applications such as corporate data warehouses and scientific computing. To support interactive analysis, many of these databases are augmented with hierarchical ...
Polaris: A System for Query, Analysis, and Visualization of Multidimensional Relational Databases

In the last several years, large multidimensional databases have become common in a variety of applications such as data warehousing and scientific computing. Analysis and exploration tasks place significant demands on the interfaces to these databases. ...
Polaris: A System for Query, Analysis and Visualization of Multi-Dimensional Relational Databases
INFOVIS '00: Proceedings of the IEEE Symposium on Information Vizualization 2000

In the last several years, large multi-dimensional databases have become common in a variety of applications such as data warehousing and scientific computing. Analysis and exploration tasks place significant demands on the interfaces to these ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image Communications of the ACM

Communications of the ACM Volume 51, Issue 11

Remembering Jim Gray

November 2008

122 pages

ISSN:0001-0782

EISSN:1557-7317

DOI:10.1145/1400214

Issue’s Table of Contents

Copyright © 2008 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 November 2008

Published in CACM Volume 51, Issue 11

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Research-article
Popular
Refereed

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

60
Total Citations
View Citations
6,559
Total Downloads

Downloads (Last 12 months)384
Downloads (Last 6 weeks)54

Reflects downloads up to 23 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

Xia JLiu JBrown NChen YFeng YFilkov VRay BZhou M(2024)Refinement Types for VisualizationProceedings of the 39th IEEE/ACM International Conference on Automated Software Engineering10.1145/3691620.3695550(1871-1881)Online publication date: 27-Oct-2024
https://dl.acm.org/doi/10.1145/3691620.3695550
DeValk KElmqvist N(2023)Riverside: A design study on visualization for situation awareness in cybersecurityInformation Visualization10.1177/1473871623118922023:1(40-66)Online publication date: 17-Aug-2023
https://doi.org/10.1177/14738716231189220
Pandey AL'Yi SWang QBorkin MGehlenborg N(2023)GenoREC: A Recommendation System for Interactive Genomics Data VisualizationIEEE Transactions on Visualization and Computer Graphics10.1109/TVCG.2022.320940729:1(570-580)Online publication date: Jan-2023
https://doi.org/10.1109/TVCG.2022.3209407
Franke MReina GKoch S(2023)Toward Reproducible Visual Analysis Results2023 IEEE 16th Pacific Visualization Symposium (PacificVis)10.1109/PacificVis56936.2023.00018(102-106)Online publication date: Apr-2023
https://doi.org/10.1109/PacificVis56936.2023.00018
Schreck TAlbert DBedek MHorvath KJeitler KKubicek BSemlitsch TShao LSiebenhofer-Kroitzsch A(2023)Adaptive Visualization of Health Information Based on Cognitive Psychology: Scenarios, Concepts, and Research OpportunitiesVisualization Psychology10.1007/978-3-031-34738-2_7(165-195)Online publication date: 7-Nov-2023
https://doi.org/10.1007/978-3-031-34738-2_7
Robertson SHarley KSalehi N(2022)Opportunities and risks for engaging research participants with self-logged menstrual health dataProceedings of the Workshop on Human-In-the-Loop Data Analytics10.1145/3546930.3547501(1-7)Online publication date: 12-Jun-2022
https://dl.acm.org/doi/10.1145/3546930.3547501
Chen YWu EIves ZBonifati AEl Abbadi A(2022)PI2: End-to-end Interactive Visualization Interface Generation from QueriesProceedings of the 2022 International Conference on Management of Data10.1145/3514221.3526166(1711-1725)Online publication date: 10-Jun-2022
https://dl.acm.org/doi/10.1145/3514221.3526166
Wang AEpperson WDeLine RDrucker S(2022)Diff in the Loop: Supporting Data Comparison in Exploratory Data AnalysisProceedings of the 2022 CHI Conference on Human Factors in Computing Systems10.1145/3491102.3502123(1-10)Online publication date: 29-Apr-2022
https://dl.acm.org/doi/10.1145/3491102.3502123
Shennat AWadge WKuo A(2022)The Dimensional Analysis of Data Flow Programs That Include Multidimensional and User-Defined Functions2022 IEEE International Conference on Big Data (Big Data)10.1109/BigData55660.2022.10020739(2781-2789)Online publication date: 17-Dec-2022
https://doi.org/10.1109/BigData55660.2022.10020739
Vitsaxaki KNtoa SMargetis GSpyratos N(2022)Interactive Visual Exploration of Big Relational DatasetsInternational Journal of Human–Computer Interaction10.1080/10447318.2022.207300739:10(2033-2047)Online publication date: 22-May-2022
https://doi.org/10.1080/10447318.2022.2073007
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Digital Edition

View this article in digital edition.

Digital Edition

Magazine Site

View this article on the magazine site (external)

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Article

Media

Figures

Other

Tables

View Issue’s Table of Contents