Dynamic reduction of query result sets for interactive visualizaton

Modern database management systems (DBMS) have been designed to efficiently store, manage and perform computations on massive amounts of data. In contrast, many existing visualization systems do not scale seamlessly from small data sets to enormous ones. We have designed a three-tiered visualization...

Full description

Bibliographic Details
Main Authors: Battle, Leilani, Stonebraker, Michael, Chang, Remco
Other Authors: Massachusetts Institute of Technology. Computer Science and Artificial Intelligence Laboratory
Format: Article
Language:en_US
Published: 2014
Online Access:http://hdl.handle.net/1721.1/90853
https://orcid.org/0000-0001-9184-9058
https://orcid.org/0000-0003-3870-636X
_version_ 1824457849460228096
author Battle, Leilani
Stonebraker, Michael
Chang, Remco
author2 Massachusetts Institute of Technology. Computer Science and Artificial Intelligence Laboratory
author_facet Massachusetts Institute of Technology. Computer Science and Artificial Intelligence Laboratory
Battle, Leilani
Stonebraker, Michael
Chang, Remco
author_sort Battle, Leilani
collection MIT
description Modern database management systems (DBMS) have been designed to efficiently store, manage and perform computations on massive amounts of data. In contrast, many existing visualization systems do not scale seamlessly from small data sets to enormous ones. We have designed a three-tiered visualization system called ScalaR to deal with this issue. ScalaR dynamically performs resolution reduction when the expected result of a DBMS query is too large to be effectively rendered on existing screen real estate. Instead of running the original query, ScalaR inserts aggregation, sampling or filtering operations to reduce the size of the result. This paper presents the design and implementation of ScalaR, and shows results for an example application, displaying satellite imagery data stored in SciDB as the back-end DBMS.
first_indexed 2024-09-23T14:27:33Z
format Article
id mit-1721.1/90853
institution Massachusetts Institute of Technology
language en_US
last_indexed 2024-09-23T14:27:33Z
publishDate 2014
record_format dspace
spelling mit-1721.1/908532022-09-29T09:31:24Z Dynamic reduction of query result sets for interactive visualizaton Battle, Leilani Stonebraker, Michael Chang, Remco Massachusetts Institute of Technology. Computer Science and Artificial Intelligence Laboratory Massachusetts Institute of Technology. Department of Electrical Engineering and Computer Science Battle, Leilani Stonebraker, Michael Modern database management systems (DBMS) have been designed to efficiently store, manage and perform computations on massive amounts of data. In contrast, many existing visualization systems do not scale seamlessly from small data sets to enormous ones. We have designed a three-tiered visualization system called ScalaR to deal with this issue. ScalaR dynamically performs resolution reduction when the expected result of a DBMS query is too large to be effectively rendered on existing screen real estate. Instead of running the original query, ScalaR inserts aggregation, sampling or filtering operations to reduce the size of the result. This paper presents the design and implementation of ScalaR, and shows results for an example application, displaying satellite imagery data stored in SciDB as the back-end DBMS. 2014-10-09T18:58:40Z 2014-10-09T18:58:40Z 2013-10 Article http://purl.org/eprint/type/ConferencePaper 978-1-4799-1293-3 INSPEC Accession Number: 13999124 http://hdl.handle.net/1721.1/90853 Battle, Leilani, Michael Stonebraker, and Remco Chang. “Dynamic Reduction of Query Result Sets for Interactive Visualizaton.” 2013 IEEE International Conference on Big Data (October 6-9, 2013) Silicon Valley, CA. IEEE. p.1-8. https://orcid.org/0000-0001-9184-9058 https://orcid.org/0000-0003-3870-636X en_US http://dx.doi.org/10.1109/BigData.2013.6691708 2013 IEEE International Conference on Big Data Creative Commons Attribution-Noncommercial-Share Alike http://creativecommons.org/licenses/by-nc-sa/4.0/ application/pdf MIT web domain
spellingShingle Battle, Leilani
Stonebraker, Michael
Chang, Remco
Dynamic reduction of query result sets for interactive visualizaton
title Dynamic reduction of query result sets for interactive visualizaton
title_full Dynamic reduction of query result sets for interactive visualizaton
title_fullStr Dynamic reduction of query result sets for interactive visualizaton
title_full_unstemmed Dynamic reduction of query result sets for interactive visualizaton
title_short Dynamic reduction of query result sets for interactive visualizaton
title_sort dynamic reduction of query result sets for interactive visualizaton
url http://hdl.handle.net/1721.1/90853
https://orcid.org/0000-0001-9184-9058
https://orcid.org/0000-0003-3870-636X
work_keys_str_mv AT battleleilani dynamicreductionofqueryresultsetsforinteractivevisualizaton
AT stonebrakermichael dynamicreductionofqueryresultsetsforinteractivevisualizaton
AT changremco dynamicreductionofqueryresultsetsforinteractivevisualizaton