DataSpread: Unifying Databases and Spreadsheets
DataSpread: Unifying Databases and Spreadsheets
复制标题
DataSpread：统一数据库和电子表格
DOI：
--
复制
发表时间：
2015
影响因子：
2.5
通讯作者：
Aditya G. Parameswaran
中科院分区：
文献类型：
--
作者：
M. Bendre;Bofan Sun;Ding Zhang;Xinyan Zhou;K. Chang;Aditya G. Parameswaran
电子表格软件通常是临时表格数据管理，处理和可视化的首选工具，尤其是在微小的数据集上，关系数据库系统提供了与电子表格软件的重要功能，表达性和效率虽然缺乏易用性和临时分析功能，但我们演示了数据探索工具，可以整体统一数据库和电子表格。基于Excel的电子表格前端，同时并行管理后端数据库中的所有数据，尤其是PostgreSQL。 - 自然，同时还添加了传统关系数据库的优势，例如可伸缩性和使用任意SQL导入，过滤或加入外部或内部表的能力，并使结果出现在电子表格中。 - 末端和后端。
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.