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

Spreadsheets
Information management
Visualization
Relational database systems
Scalability
Demonstrations
Processing

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

DATASPREAD : Unifying databases and spreadsheets. / Bendre, Mangesh; Sun, Bofan; Zhang, Ding; Zhou, Xinyan; Chang, Kevin Chen Chuan; Parameswaran, Aditya.

Proceedings of the VLDB Endowment. 12. ed. Association for Computing Machinery, 2015. p. 2000-2003 (Proceedings of the VLDB Endowment; Vol. 8, No. 12).

Research output: Chapter in Book/Report/Conference proceedingChapter

Bendre, M, Sun, B, Zhang, D, Zhou, X, Chang, KCC & Parameswaran, A 2015, DATASPREAD: Unifying databases and spreadsheets. in Proceedings of the VLDB Endowment. 12 edn, Proceedings of the VLDB Endowment, no. 12, vol. 8, Association for Computing Machinery, pp. 2000-2003, 3rd 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, 9/11/06. https://doi.org/10.14778/2824032.2824121
Bendre M, Sun B, Zhang D, Zhou X, Chang KCC, Parameswaran A. DATASPREAD: Unifying databases and spreadsheets. In Proceedings of the VLDB Endowment. 12 ed. Association for Computing Machinery. 2015. p. 2000-2003. (Proceedings of the VLDB Endowment; 12). https://doi.org/10.14778/2824032.2824121
Bendre, Mangesh ; Sun, Bofan ; Zhang, Ding ; Zhou, Xinyan ; Chang, Kevin Chen Chuan ; Parameswaran, Aditya. / DATASPREAD : Unifying databases and spreadsheets. Proceedings of the VLDB Endowment. 12. ed. Association for Computing Machinery, 2015. pp. 2000-2003 (Proceedings of the VLDB Endowment; 12).
@inbook{c415e712a070463398b0755d5e0d313d,
title = "DATASPREAD: Unifying databases and spreadsheets",
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.",
author = "Mangesh Bendre and Bofan Sun and Ding Zhang and Xinyan Zhou and Chang, {Kevin Chen Chuan} and Aditya Parameswaran",
year = "2015",
month = "1",
day = "1",
doi = "10.14778/2824032.2824121",
language = "English (US)",
series = "Proceedings of the VLDB Endowment",
publisher = "Association for Computing Machinery",
number = "12",
pages = "2000--2003",
booktitle = "Proceedings of the VLDB Endowment",
edition = "12",

}

TY - CHAP

T1 - DATASPREAD

T2 - Unifying databases and spreadsheets

AU - Bendre, Mangesh

AU - Sun, Bofan

AU - Zhang, Ding

AU - Zhou, Xinyan

AU - Chang, Kevin Chen Chuan

AU - Parameswaran, Aditya

PY - 2015/1/1

Y1 - 2015/1/1

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=84953849089&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84953849089&partnerID=8YFLogxK

U2 - 10.14778/2824032.2824121

DO - 10.14778/2824032.2824121

M3 - Chapter

AN - SCOPUS:84953849089

T3 - Proceedings of the VLDB Endowment

SP - 2000

EP - 2003

BT - Proceedings of the VLDB Endowment

PB - Association for Computing Machinery

ER -