DATASPREAD: Unifying databases and spreadsheets

Mangesh Bendre, Bofan Sun, Ding Zhang, Xinyan Zhou, Kevin Chen Chuan Chang, Aditya Parameswaran

Research output: Chapter in Book/Report/Conference proceedingChapter

Abstract

Spreadsheet software is often the tool of choice for ad-hoc tabular data management, processing, and visualization, especially on tiny data sets. On the other hand, relational database systems offer significant power, expressivity, and efficiency over spreadsheet software for data management, while lacking in the ease of use and ad-hoc analysis capabilities. We demonstrate DATASPREAD, a data exploration tool that holistically unifies databases and spreadsheets. It continues to offer a Microsoft Excel-based spreadsheet front-end, while in parallel managing all the data in a back-end database, specifically, PostgreSQL. DATASPREAD retains all the advantages of spreadsheets, including ease of use, ad-hoc analysis and visualization capabilities, and a schema-free nature, while also adding the advantages of traditional relational databases, such as scalability and the ability to use arbitrary SQL to import, filter, or join external or internal tables and have the results appear in the spreadsheet. DATASPREAD needs to reason about and reconcile differences in the notions of schema, addressing of cells and tuples, and the current "pane" (which exists in spreadsheets but not in traditional databases), and support data modifications at both the front-end and the back-end. Our demonstration will center on our first and early prototype of the DATASPREAD, and will give the attendees a sense for the enormous data exploration capabilities offered by unifying spreadsheets and databases.

Original languageEnglish (US)
Title of host publicationProceedings of the VLDB Endowment
PublisherAssociation for Computing Machinery
Pages2000-2003
Number of pages4
Edition12
DOIs
StatePublished - Jan 1 2015
Event3rd Workshop on Spatio-Temporal Database Management, STDBM 2006, Co-located with the 32nd International Conference on Very Large Data Bases, VLDB 2006 - Seoul, Korea, Republic of
Duration: Sep 11 2006Sep 11 2006

Publication series

NameProceedings of the VLDB Endowment
Number12
Volume8
ISSN (Electronic)2150-8097

Other

Other3rd Workshop on Spatio-Temporal Database Management, STDBM 2006, Co-located with the 32nd International Conference on Very Large Data Bases, VLDB 2006
CountryKorea, Republic of
CitySeoul
Period9/11/069/11/06

    Fingerprint

ASJC Scopus subject areas

  • Computer Science (miscellaneous)
  • Computer Science(all)

Cite this

Bendre, M., Sun, B., Zhang, D., Zhou, X., Chang, K. C. C., & Parameswaran, A. (2015). DATASPREAD: Unifying databases and spreadsheets. In Proceedings of the VLDB Endowment (12 ed., pp. 2000-2003). (Proceedings of the VLDB Endowment; Vol. 8, No. 12). Association for Computing Machinery. https://doi.org/10.14778/2824032.2824121