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...
Main Authors: | , , |
---|---|
Other Authors: | |
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 |