research-article

Public Access

Towards Democratizing Relational Data Visualization

Authors:

Guoliang LiAuthors Info & Claims

SIGMOD '19: Proceedings of the 2019 International Conference on Management of Data

Pages 2025 - 2030

https://doi.org/10.1145/3299869.3314029

Published: 25 June 2019 Publication History

Abstract

The problem of data visualization is to transform data into a visual context such that people can easily understand the significance of data. Nowadays, data visualization becomes especially important, because it is the de facto standard for modern business intelligence and successful data science. This tutorial will cover three specific topics: visualization languages define how the users can interact with various visualization systems; efficient data visualization processes the data and produces visualizations based on well-specified user queries; smart data visualization recommends data visualizations based on underspecified user queries. In this tutorial, we will go logically through these prior art, paying particular attentions on problems that may attract the interest from the database community.

References

[1]

Sameer Agarwal, Barzan Mozafari, Aurojit Panda, Henry Milner, Samuel Madden, and Ion Stoica. 2013. BlinkDB: Queries with Bounded Errors and Bounded Response Times on Very Large Data. In ACM

Digital Library

[2]

Christopher Ahlberg. 1996. Spotfire: an information exploration environment. In SIGMOD Record. ACM.

Digital Library

[3]

Daniel Alabi and Eugene Wu. 2016. PFunk-H: approximate query processing using perceptual models. In HILDA .

Digital Library

[4]

Leilani Battle, Marco Angelini, Carsten Binnig, Tiziana Catarci, Philipp Eichmann, Jean-Daniel Fekete, Giuseppe Santucci, Michael Sedlmair, and Wesley Willett. 2018. Evaluating Visual Data Analysis Systems: A Discussion Report. In HILDA .

Digital Library

[5]

Leilani Battle, Remco Chang, Jeffrey Heer, and Mike Stonebraker. 2017. Position statement: The case for a visualization performance benchmark. In DSIA Workshop .

[6]

Leilani Battle, Remco Chang, and Michael Stonebraker. 2015. Dynamic Prefetching of Data Tiles for Interactive Visualization. In SIGMOD .

Digital Library

[7]

Benjamin B. Bederson, Jesse Grosjean, and Jon Meyer. 2004. Toolkit Design for Interactive Structured Graphics. In IEEE TSE .

Digital Library

[8]

Nikos Bikakis, George Papastefanatos, Melina Skourla, and Timos Sellis. 2016. A Hierarchical Aggregation Framework for Efficient Multilevel Visual Exploration and Analysis. In Computer Science .

[9]

Michael Bostock and Jeffrey Heer. 2009. Protovis: A Graphical Toolkit for Visualization. In IEEE Transactions on Visualization & Computer Graphics .

Digital Library

[10]

Sye Min Chan, Ling Xiao, J Gerth, and P Hanrahan. 2008. Maintaining interactivity while exploring massive time series. In IEEE .

[11]

Andrew Crotty, Alex Galakatos, Emanuel Zgraggen, Carsten Binnig, and Tim Kraska. 2015. Vizdom: Interactive Analytics through Pen and Touch. In PVLDB .

Digital Library

[12]

Victor Dibia and cC aug atay Demiralp. 2018. Data2Vis: Automatic Generation of Data Visualizations Using Sequence-to-Sequence Recurrent Neural Networks. In arXiv .

[13]

Bolin Ding, Silu Huang, Surajit Chaudhuri, Kaushik Chakrabarti, and Chi Wang. 2016a. Sample

[14]

Seek: Approximating Aggregates with Distribution Precision Guarantee. In SIGMOD .

[15]

Bolin Ding, Silu Huang, Surajit Chaudhuri, Kaushik Chakrabarti, and Chi Wang. 2016b. Sample

[16]

seek: Approximating aggregates with distribution precision guarantee. In SIGMOD .

[17]

Punit R. Doshi, Elke A. Rundensteiner, and Matthew O. Ward. 2003. Prefetching for Visual Data Exploration. In Masters Theses .

[18]

Niklas Elmqvist and Jean Daniel Fekete. 2010. Hierarchical Aggregation for Information Visualization: Overview, Techniques, and Design Guidelines. In IEEE Transactions on Visualization & Computer Graphics .

Digital Library

[19]

J Fekete and C Plaisant. 2003. Interactive information visualization of a million items. In The Craft of Information Visualization .

Digital Library

[20]

Erich Fuchs, Thiemo Gruber, Jiri Nitschke, and Bernhard Sick. 2010. Online Segmentation of Time Series Based on Polynomial Least-Squares Approximations. In IEEE Transactions on Pattern Analysis & Machine Intelligence .

Digital Library

[21]

Hector Gonzalez, Alon Y Halevy, Christian S Jensen, Anno Langen, Jayant Madhavan, Rebecca Shapley, Warren Shen, and Jonathan Goldberg-Kidon. 2010. Google fusion tables: web-centered data management and collaboration. In SIGMOD .

Digital Library

[22]

David Gotz and Zhen Wen. 2009. Behavior-driven visualization recommendation. In IUI .

Digital Library

[23]

Gregor Hackenbroich, Gregor Hackenbroich, Gregor Hackenbroich, and Volker Markl. 2014. Faster visual analytics through pixel-perfect aggregation. In PVLDB .

[24]

Pat Hanrahan. 2006. VizQL:a language for query, analysis and visualization. In SIGMOD .

Digital Library

[25]

Jeffrey Heer, Stuart K Card, and James A Landay. 2005. Prefuse: a toolkit for interactive information visualization. In CHI .

Digital Library

[26]

Joseph M Hellerstein, Ron Avnur, Andy Chou, Christian Hidber, Chris Olston, Vijayshankar Raman, Tali Roth, and Peter J Haas. 1999. Interactive data analysis: The control project. In Computer. IEEE.

Digital Library

[27]

Prasanth Jayachandran, Karthik Tunga, Niranjan Kamat, and Arnab Nandi. 2014. Combining user interaction, speculative query execution and sampling in the DICE system. In PVLDB .

Digital Library

[28]

Lilong Jiang, Protiva Rahman, and Arnab Nandi. 2018. Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines. In SIGMOD .

Digital Library

[29]

Uwe Jugel, Zbigniew Jerzak, Gregor Hackenbroich, and Volker Markl. 2014. M4: a visualization-oriented time series data aggregation. In PVLDB .

Digital Library

[30]

Alexander Kalinin, Ugur Cetintemel, and Stan Zdonik. 2014. Interactive data exploration using semantic windows. In SIGMOD .

Digital Library

[31]

Sean Kandel, Andreas Paepcke, Joseph M. Hellerstein, and Jeffrey Heer. 2011. Wrangler: interactive visual specification of data transformation scripts. In CHI .

Digital Library

[32]

Sean Kandel, Ravi Parikh, Andreas Paepcke, Joseph M. Hellerstein, and Jeffrey Heer. 2012. Profiler: integrated statistical analysis and visualization for data quality assessment. In AVI .

Digital Library

[33]

Albert Kim, Eric Blais, Aditya G. Parameswaran, Piotr Indyk, Samuel Madden, and Ronitt Rubinfeld. 2015. Rapid Sampling for Visualizations with Ordering Guarantees. In PVLDB .

Digital Library

[34]

Deqing Li, Honghui Mei, Yi Shen, Shuang Su, Wenli Zhang, Junting Wang, Ming Zu, and Wei Chen. 2018. ECharts: A declarative framework for rapid construction of web-based visualization. In Visual Informatics .

[35]

Lauro Lins, James T. Klosowski, and Carlos Scheidegger. 2013. Nanocubes for Real-Time Exploration of Spatiotemporal Datasets. In IEEE Transactions on Visualization & Computer Graphics .

Digital Library

[36]

Zhicheng Liu, Biye Jiang, and Jeffrey Heer. 2013. imMens : real-time visual querying of big data. In EuroVIS .

Digital Library

[37]

Yuyu Luo, Xuedi Qin, Nan Tang, and Guoliang Li. 2018a. DeepEye: Towards Automatic Data Visualization. In ICDE .

[38]

Yuyu Luo, Xuedi Qin, Nan Tang, Guoliang Li, and Xinran Wang. 2018b. DeepEye: Creating Good Data Visualizations by Keyword Search. In SIGMOD .

Digital Library

[39]

Jock Mackinlay, Pat Hanrahan, and Chris Stolte. 2007. Show me: Automatic presentation for visual analysis. In TVCG. IEEE.

Digital Library

[40]

Bryan McDonnel and Niklas Elmqvist. 2009. Towards utilizing gpus in information visualization: A model and implementation of image-space operations. In TVCG. IEEE.

Digital Library

[41]

Bostock Michael, Ogievetsky Vadim, and Heer Jeffrey. 2011. D3: Data-Driven Documents. In IEEE Transactions on Visualization & Computer Graphics .

Digital Library

[42]

Dominik Moritz, Danyel Fisher, Bolin Ding, and Chi Wang. 2017. Trust, but Verify: Optimistic Visualizations of Approximate Queries for Exploring Big Data. In CHI .

Digital Library

[43]

Dominik Moritz, Chenglong Wang, Greg L Nelson, Halden Lin, Adam M Smith, Bill Howe, and Jeffrey Heer. 2018. Formalizing Visualization Design Knowledge as Constraints: Actionable and Extensible Models in Draco. In InfoVIS .

[44]

Kristi Morton, Hannaneh Hajishirzi, Magdalena Balazinska, and Dan Grossman. 2016. View-Driven Deduplication with Active Learning. In arXiv .

[45]

Thomas Neumann. 2011. Efficiently compiling efficient query plans for modern hardware .VLDB Endowment.

Digital Library

[46]

Thomas Neumann and Alfons Kemper. 2015. Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems. In SIGMOD .

Digital Library

[47]

Daniel B Perry, Bill Howe, Alicia MF Key, and Cecilia Aragon. 2013. VizDeck: Streamlining exploratory visual analytics of scientific data. In iConference .

[48]

Harald Piringer, Christian Tominski, Philipp Muigg, and Wolfgang Berger. 2009. A Multi-Threading Architecture to Support Interactive Visual Exploration. In TVCG .

Digital Library

[49]

Marianne Procopio, Carlos Scheidegger, Eugene Wu, and Remco Chang. 2017. Load-n-Go: Fast Approximate Join Visualizations That Improve Over Time. In DSIA .

[50]

Fotis Psallidas and Eugene Wu. 2018a. Demonstration of Smoke: A Deep Breath of Data-Intensive Lineage Applications. In SIGMOD (demo) .

Digital Library

[51]

Fotis Psallidas and Eugene Wu. 2018b. Provenance in Interactive Visualizations. In HILDA .

Digital Library

[52]

Fotis Psallidas and Eugene Wu. 2018c. Smoke: Fine-grained Lineage at Interactive Speeds. In VLDB .

Digital Library

[53]

Xuedi Qin, Yuyu Luo, Nan Tang, and Guoliang Li. 2018a. DeepEye: An automatic big data visualization framework. In Big Data Mining & Analytics .

[54]

Xuedi Qin, Yuyu Luo, Nan Tang, and Guoliang Li. 2018b. Deepeye: Visualizing your data by keyword search. In EDBT Vision .

[55]

Sajjadur Rahman, Maryam Aliakbarpour, Ha Kyung Kong, Eric Blais, Karrie Karahalios, Aditya Parameswaran, Ronitt Rubinfield, Sajjadur Rahman, Maryam Aliakbarpour, and Ha Kyung Kong. 2017. I've seen "enough": incrementally improving visualizations to support rapid decision making. In PVLDB .

Digital Library

[56]

Oliver Rübel, Kesheng Wu, Hank Childs, Jeremy Meredith, Cameron GR Geddes, Estelle Cormier-Michel, Sean Ahern, Gunther H Weber, Peter Messmer, Hans Hagen, et almbox. 2008. High performance multivariate visual data exploration for extremely large data. In SC .

[57]

Gabriel Ryan, Abigail Mosca, Remco Chang, and Eugene Wu. 2018. At a Glance: Approximate Entropy as a Measure of Line Chart Visualization Complexity. In InfoVIS .

[58]

Bahador Saket, Dominik Moritz, Halden Lin, Victor Dibia, Cagatay Demiralp, and Jeffrey Heer. 2018. Beyond heuristics: Learning visualization design. In arXiv .

[59]

Anish Das Sarma, Hongrae Lee, Hector Gonzalez, Jayant Madhavan, and Alon Halevy. 2012. Efficient spatial sampling of large geographical tables. In SIGMOD .

Digital Library

[60]

A Satyanarayan, D Moritz, K Wongsuphasawat, and J Heer. 2016. Vega-Lite: A Grammar of Interactive Graphics. In IEEE Transactions on Visualization & Computer Graphics .

Digital Library

[61]

Arvind Satyanarayan, Ryan Russell, Jane Hoffswell, and Jeffrey Heer. 2015. Reactive Vega: A Streaming Dataflow Architecture for Declarative Interactive Visualization. In IEEE Transactions on Visualization & Computer Graphics .

[62]

Jinwook Seo and Ben Shneiderman. 2005. A rank-by-feature framework for interactive exploration of multidimensional data. In Information Visualization .

Digital Library

[63]

Ben Shneiderman. 1983. Direct Manipulation: A Step Beyond Programming Languages. In IEEE Computer .

Digital Library

[64]

Tarique Siddiqui, Albert Kim, John Lee, Karrie Karahalios, and Aditya G. Parameswaran. 2016. Effortless Data Exploration with zenvisage: An Expressive and Interactive Visual Analytics System. In PVLDB .

Digital Library

[65]

Tarique Siddiqui, John Lee, Albert Kim, Edward Xue, Xiaofo Yu, Sean Zou, Lijin Guo, Changfeng Liu, Chaoran Wang, Karrie Karahalios, and Aditya G. Parameswaran. 2017. Fast-Forwarding to Desired Visualizations with Zenvisage. In CIDR .

[66]

C. D Stolper, A Perer, and D Gotz. 2014. Progressive Visual Analytics: User-Driven Visual Exploration of In-Progress Analytics. In IEEE Transactions on Visualization & Computer Graphics .

[67]

C. Stolte and P. Hanrahan. 2000. Polaris: a system for query, analysis and visualization of multi-dimensional relational databases. In Information Visualization .

[68]

Farhan Tauheed, Thomas Heinis, Felix Shürmann, Henry Markram, and Anastasia Ailamaki. 2012. SCOUT: Prefetching for Latent Feature Following Queries. In PVLDB .

Digital Library

[69]

Manasi Vartak, Samuel Madden, Aditya Parameswaran, and Neoklis Polyzotis. 2014. SEEDB: automatically generating query visualizations. In PVLDB .

Digital Library

[70]

Manasi Vartak, Sajjadur Rahman, Samuel Madden, Aditya G. Parameswaran, and Neoklis Polyzotis. 2015. SEEDB: Efficient Data-Driven Visualization Recommendations to Support Visual Analytics. In PVLDB .

Digital Library

[71]

Hadley Wickham. 2010. A Layered Grammar of Graphics. In Journal of Computational & Graphical Statistics .

[72]

Leland Wilkinson. 2005. The grammar of graphics .Springer. 673--677 pages.

Digital Library

[73]

Kanit Wongsuphasawat, Zening Qu, Dominik Moritz, Riley Chang, Felix Ouk, Anushka Anand, Jock Mackinlay, Bill Howe, and Jeffrey Heer. 2017. Voyager 2: Augmenting visual analysis with partial view specifications. In CHI .

Digital Library

[74]

Eugene Wu, Leilani Battle, and Samuel R. Madden. 2014. The case for data visualization management systems. In Cancer Letters .

[75]

Eugene Wu, Lilong Jiang, Larry Xu, and Arnab Nandi. 2016. Graphical Perception in Animated Bar Charts. In arXiv .

[76]

Eugene Wu and Samuel Madden. 2013. Scorpion: Explaining Away Outliers in Aggregate Queries. In VLDB .

Digital Library

[77]

Eugene Wu and Arnab Nandi. 2015. Towards perception-aware interactive data visualization systems. In DSIA Workshop .

[78]

Eugene Wu, Fotis Psallidas, Zhengjie Miao, Haoci Zhang, and Laura Rettig. 2017a. Combining Design and Performance in a Data Visualization Management System. In CIDR .

[79]

Eugene Wu, Fotis Psallidas, Zhengjie Miao, Haoci Zhang, Laura Rettig, Yifan Wu, and Thibault Sellam. 2017b. Combining Design and Performance in a Data Visualization Management System. In CIDR .

[80]

Emanuel Zgraggen, Alex Galakatos, Andrew Crotty, Jean-Daniel Fekete, and Tim Kraska. 2017. How progressive visualizations affect exploratory analysis. In IEEE Transactions on Visualization & Computer Graphics. IEEE.

Cited By

Taylor LGupta VJung K(2024)Leveraging Visualization and Machine Learning Techniques in Education: A Case Study of K-12 State Assessment DataMultimodal Technologies and Interaction10.3390/mti80400288:4(28)Online publication date: 8-Apr-2024
https://doi.org/10.3390/mti8040028
Song YLu JZhao XWong RZhang H(2024)Demonstration of FeVisQA: Free-Form Question Answering over Data Visualization2024 IEEE 40th International Conference on Data Engineering (ICDE)10.1109/ICDE60146.2024.00417(5417-5420)Online publication date: 13-May-2024
https://doi.org/10.1109/ICDE60146.2024.00417
Gatterbauer W(2023)A Tutorial on Visual Representations of Relational QueriesProceedings of the VLDB Endowment10.14778/3611540.361157816:12(3890-3893)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.14778/3611540.3611578
Show More Cited By

Index Terms

Towards Democratizing Relational Data Visualization
1. Human-centered computing
  1. Visualization
    1. Visualization techniques

Recommendations

Effective Big Data Visualization
IDEAS '17: Proceedings of the 21st International Database Engineering & Applications Symposium

In the last several years, big data analytics has found an increasing role in our everyday lives. Data visualization has long been accepted as an integral part of data analytics. However, data visualization systems are not equipped to handle the ...
Telling Stories with Data Visualization
NHT '15: Proceedings of the 2015 Workshop on Narrative & Hypertext

In this article we survey the historical background and development of information and data visualization, and an overview of the intersection of data visualization with storytelling applied to the field of data journalism, where it finds its most ...
Democratizing Open Energy Data for Public Discourse using Visualization
CHI EA '18: Extended Abstracts of the 2018 CHI Conference on Human Factors in Computing Systems

For this demo, we will show two interactive visualizations: Energy Futures and Pipeline Incidents. We designed and developed these visualizations as part of an open data initiative that aims to create interactive data visualizations to help make Canada'...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '19: Proceedings of the 2019 International Conference on Management of Data

June 2019

2106 pages

ISBN:9781450356435

DOI:10.1145/3299869

General Chairs:
Peter Boncz
CWI & Vrije Universiteit Amsterdam, The Netherlands
,
Stefan Manegold
CWI & Universiteit Leiden, The Netherlands
,
Program Chairs:
Anastasia Ailamaki
EPFL, Switzerland
,
Amol Deshpande
University of Maryland, USA
,
Tim Kraska
MIT, USA

Copyright © 2019 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]

Sponsors

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 25 June 2019

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Funding Sources

973 Program of China
NSF of China
Huawei
TAL education
NSF

Conference

SIGMOD/PODS '19

Sponsor:

SIGMOD

SIGMOD/PODS '19: International Conference on Management of Data

June 30 - July 5, 2019

Amsterdam, Netherlands

Acceptance Rates

SIGMOD '19 Paper Acceptance Rate 88 of 430 submissions, 20%;

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

16
Total Citations
View Citations
1,248
Total Downloads

Downloads (Last 12 months)238
Downloads (Last 6 weeks)19

Reflects downloads up to 30 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

Taylor LGupta VJung K(2024)Leveraging Visualization and Machine Learning Techniques in Education: A Case Study of K-12 State Assessment DataMultimodal Technologies and Interaction10.3390/mti80400288:4(28)Online publication date: 8-Apr-2024
https://doi.org/10.3390/mti8040028
Song YLu JZhao XWong RZhang H(2024)Demonstration of FeVisQA: Free-Form Question Answering over Data Visualization2024 IEEE 40th International Conference on Data Engineering (ICDE)10.1109/ICDE60146.2024.00417(5417-5420)Online publication date: 13-May-2024
https://doi.org/10.1109/ICDE60146.2024.00417
Gatterbauer W(2023)A Tutorial on Visual Representations of Relational QueriesProceedings of the VLDB Endowment10.14778/3611540.361157816:12(3890-3893)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.14778/3611540.3611578
Chan TU LChoi BXu JCheng RDas SPandis ISelçuk Candan KAmer-Yahia S(2023)Large-scale Geospatial Analytics: Problems, Challenges, and OpportunitiesCompanion of the 2023 International Conference on Management of Data10.1145/3555041.3589401(21-29)Online publication date: 4-Jun-2023
https://dl.acm.org/doi/10.1145/3555041.3589401
Chan THou U LChoi BXu JCheng R(2023)Kernel Density Visualization for Big Geospatial Data: Algorithms and Applications2023 24th IEEE International Conference on Mobile Data Management (MDM)10.1109/MDM58254.2023.00046(231-234)Online publication date: Jul-2023
https://doi.org/10.1109/MDM58254.2023.00046
Battle L(2022)Analyzing online programming communities to enhance visualization languagesInteractions10.1145/350349029:1(27-29)Online publication date: 6-Jan-2022
https://dl.acm.org/doi/10.1145/3503490
Deagen MMcCusker JFateye TStouffer SBrinson LMcGuinness DSchadler L(2022)FAIR and Interactive Data Graphics from a Scientific Knowledge GraphScientific Data10.1038/s41597-022-01352-z9:1Online publication date: 27-May-2022
https://doi.org/10.1038/s41597-022-01352-z
Po LBikakis NDesimoni FPapastefanatos G(2022)Linked Data Visualization10.1007/978-3-031-79490-2Online publication date: 25-Mar-2022
https://doi.org/10.1007/978-3-031-79490-2
Freixa PPérez-Montoro MCodina L(2021)The binomial of interaction and visualization in digital news media: consolidation, standardization and future challengesEl Profesional de la información10.3145/epi.2021.jul.01Online publication date: 13-Jul-2021
https://doi.org/10.3145/epi.2021.jul.01
Siddiqui TChaudhuri SNarasayya V(2021)COMPAREProceedings of the VLDB Endowment10.14778/3476249.347629114:11(2419-2431)Online publication date: 27-Oct-2021
https://dl.acm.org/doi/10.14778/3476249.3476291
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

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 Publication

Media

Figures

Other

Tables

View Table of Contents