BIGDATA: F: Bringing Interactive Data Management to Scientists, Analysts, and the Masses: A Holistic Unification of Spreadsheets and Databases
BIGDATA:F:为科学家、分析师和大众带来交互式数据管理:电子表格和数据库的全面统一
基本信息
- 批准号:1633755
- 负责人:
- 金额:$ 179.54万
- 依托单位:
- 依托单位国家:美国
- 项目类别:Standard Grant
- 财政年份:2016
- 资助国家:美国
- 起止时间:2016-09-01 至 2022-08-31
- 项目状态:已结题
- 来源:
- 关键词:
项目摘要
With the proliferation of datasets in many spheres of our everyday life, including science, finance, and commerce, managing tabular data, i.e., data represented by a set of tables or relations, has become increasingly essential. The state of the art in tabular data management spans two distinct paradigms with a sharp divide--spreadsheets and databases--with drastically different strengths and weaknesses; both enjoying tremendous successes but facing fundamental limitations. To date, interactive ad-hoc management of large data remains cumbersome and difficult. This project aims to holistically unify database and spreadsheet technology, and thus bring to scientists, analysts, and lay users, the ease of use and interactivity of spreadsheets with the scalability, expressiveness, and collaboration capabilities of databases.The project develops DataSpread, a system to holistically unify databases with spreadsheets--to marry the traditional strengths of scalability, expressiveness, and consistency of databases with the interactivity of spreadsheets that billions of end-users are so familiar with, and in the process rethink user-facing interactions beyond spreadsheets which the project will develop and evaluate via extensive user studies. The research team studies the development of new models, algorithms, structures, and interaction primitives to make the unification practical. Specifically, this research develops new methods for compactly representing spreadsheet data and computing over queries on a spreadsheet, positionally aware indexing structures, and mechanisms for efficiently propagating updates to the user viewport. The project also studies the design of new interaction primitives to replace full-fledged SQL, which is more conducive to a spreadsheet interface, and in support for user-centric transactions. While aiming at developing general techniques to advance the state of the art in data management, the project will be driven by the collaborators' real-world challenges--for use cases, pain points, practical deployment, joint open-source development, and critical evaluation and feedback.
随着数据集在我们日常生活的许多领域中的激增,包括科学、金融和商业,管理表格数据,即由一组表或关系表示的数据变得越来越重要。表格数据管理的最新技术跨越了两种截然不同的模式--电子表格和数据库--具有截然不同的优势和劣势;两者都取得了巨大的成功,但都面临着根本的限制。到目前为止,大数据的交互式特别管理仍然既繁琐又困难。这个项目的目标是全面统一数据库和电子表格技术,从而为科学家、分析师和非专业用户带来电子表格的易用性和互动性,以及数据库的可伸缩性、表现力和协作能力。该项目开发数据扩展,这是一个将数据库和电子表格全面统一的系统--将数据库的可伸缩性、表现力和一致性的传统优势与数十亿最终用户如此熟悉的电子表格的互动性结合在一起,并在此过程中重新考虑电子表格之外面向用户的交互,该项目将通过广泛的用户研究来开发和评估这些电子表格。研究小组研究新的模型、算法、结构和交互原语的开发,以使统一成为现实。具体地说,这项研究开发了紧凑地表示电子表格数据和对电子表格上的查询进行计算的新方法、位置感知索引结构以及将更新高效地传播到用户视区的机制。该项目还研究了新的交互原语的设计,以取代更有利于电子表格界面的成熟SQL,并支持以用户为中心的事务。虽然该项目旨在开发通用技术以推进数据管理的最新水平,但该项目将受到合作者在现实世界中的挑战--用例、痛点、实际部署、联合开源开发以及批判性评估和反馈--的推动。
项目成果
期刊论文数量(17)
专著数量(0)
科研奖励数量(0)
会议论文数量(0)
专利数量(0)
Open Relation Modeling: Learning to Define Relations between Entities
- DOI:10.18653/v1/2022.findings-acl.26
- 发表时间:2021-08
- 期刊:
- 影响因子:0
- 作者:Jie Huang;K. Chang;Jinjun Xiong;Wen-mei W. Hwu
- 通讯作者:Jie Huang;K. Chang;Jinjun Xiong;Wen-mei W. Hwu
Faster, Higher, Stronger: Redesigning Spreadsheets for Scale
更快、更高、更强:重新设计电子表格以实现规模化
- DOI:10.1109/icde.2019.00217
- 发表时间:2019
- 期刊:
- 影响因子:0
- 作者:Bendre, Mangesh;Wattanawaroon, Tana;Rahman, Sajjadur;Mack, Kelly;Liu, Yuyang;Zhu, Shichu;Lu, Yu;Yang, Ping-Jing;Zhou, Xinyan;Chang, Kevin Chen-Chuan
- 通讯作者:Chang, Kevin Chen-Chuan
Optimally Leveraging Density and Locality for Exploratory Browsing and Sampling
最佳地利用密度和位置进行探索性浏览和采样
- DOI:10.1145/3209900.3209903
- 发表时间:2018
- 期刊:
- 影响因子:0
- 作者:Kim, Albert;Xu, Liqi;Siddiqui, Tarique;Huang, Silu;Madden, Samuel;Parameswaran, Aditya
- 通讯作者:Parameswaran, Aditya
On Analyzing Graphs with Motif-Paths
- DOI:10.14778/3447689.3447714
- 发表时间:2021-02
- 期刊:
- 影响因子:0
- 作者:Xiaodong Li;Reynold Cheng;K. Chang;Caihua Shan;Chenhao Ma;Hongtai Cao
- 通讯作者:Xiaodong Li;Reynold Cheng;K. Chang;Caihua Shan;Chenhao Ma;Hongtai Cao
Anti-Freeze for Large and Complex Spreadsheets: Asynchronous Formula Computation
大型复杂电子表格的防冻:异步公式计算
- DOI:10.1145/3299869.3319876
- 发表时间:2019
- 期刊:
- 影响因子:0
- 作者:Bendre, Mangesh;Wattanawaroon, Tana;Mack, Kelly;Chang, Kevin;Parameswaran, Aditya
- 通讯作者:Parameswaran, Aditya
{{
item.title }}
{{ item.translation_title }}
- DOI:
{{ item.doi }} - 发表时间:
{{ item.publish_year }} - 期刊:
- 影响因子:{{ item.factor }}
- 作者:
{{ item.authors }} - 通讯作者:
{{ item.author }}
数据更新时间:{{ journalArticles.updateTime }}
{{ item.title }}
- 作者:
{{ item.author }}
数据更新时间:{{ monograph.updateTime }}
{{ item.title }}
- 作者:
{{ item.author }}
数据更新时间:{{ sciAawards.updateTime }}
{{ item.title }}
- 作者:
{{ item.author }}
数据更新时间:{{ conferencePapers.updateTime }}
{{ item.title }}
- 作者:
{{ item.author }}
数据更新时间:{{ patent.updateTime }}
Kevin Chang其他文献
Limited Relevance of the Very Low Risk Prostate Cancer Classification in the Modern Era: Results from a Large Institutional Active Surveillance Cohort.
现代极低风险前列腺癌分类的相关性有限:大型机构主动监测队列的结果。
- DOI:
10.1016/j.eururo.2023.02.013 - 发表时间:
2023 - 期刊:
- 影响因子:23.4
- 作者:
K. Shee;J. Cowan;A. Balakrishnan;D. Escobar;Kevin Chang;S. Washington;Hao G Nguyen;K. Shinohara;M. Cooperberg;Peter R. Carroll - 通讯作者:
Peter R. Carroll
Hypnosedative Use and Predictors of Successful Withdrawal in New Patients Attending a Falls Clinic
- DOI:
10.2165/11584480-000000000-00000 - 发表时间:
2012-09-22 - 期刊:
- 影响因子:3.800
- 作者:
Jenna Joester;Constance M. Vogler;Kevin Chang;Sarah N. Hilmer - 通讯作者:
Sarah N. Hilmer
Management of dialysis access in the post-transplantation patient
移植后患者透析通路的管理
- DOI:
10.1053/j.semvascsurg.2024.10.005 - 发表时间:
2024-12-01 - 期刊:
- 影响因子:2.400
- 作者:
Lindsay Lynch;Kevin Chang;Ashlee Stutsrim;Maureen Sheehan;Matthew Edwards - 通讯作者:
Matthew Edwards
Refinement and Dissemination of a Digital Platform for Sharing Transportation Education Materials
交通教育材料共享数字平台的完善和传播
- DOI:
- 发表时间:
2015 - 期刊:
- 影响因子:0
- 作者:
Kevin Chang;Shane A. Brown;R. Perkins;L. Boyle;W. Cofer - 通讯作者:
W. Cofer
Hazard assessment of airborne and foodborne biodegradable polyhydroxyalkanoates microplastics and non-biodegradable polypropylene microplastics
空气传播和食源生物可降解聚羟基链烷酸酯微塑料以及不可生物降解聚丙烯微塑料的危害评估
- DOI:
10.1016/j.envint.2025.109311 - 发表时间:
2025-02-01 - 期刊:
- 影响因子:9.700
- 作者:
Hua Zha;Shengjie Li;Aoxiang Zhuge;Jian Shen;Yuanyuan Yao;Kevin Chang;Lanjuan Li - 通讯作者:
Lanjuan Li
Kevin Chang的其他文献
{{
item.title }}
{{ item.translation_title }}
- DOI:
{{ item.doi }} - 发表时间:
{{ item.publish_year }} - 期刊:
- 影响因子:{{ item.factor }}
- 作者:
{{ item.authors }} - 通讯作者:
{{ item.author }}
{{ truncateString('Kevin Chang', 18)}}的其他基金
III: Small: Social Discovery of Users and Content in Social Media Through Similarity-Based and Graph-Based Inference of Attributes and Queries
III:小:通过基于相似性和基于图的属性和查询推断来社交发现社交媒体中的用户和内容
- 批准号:
1619302 - 财政年份:2016
- 资助金额:
$ 179.54万 - 项目类别:
Standard Grant
III: Small: Towards Agile Information Integration for Large Scale-- Data Aware Indexing and Search over Unstructured Data
III:小:迈向大规模敏捷信息集成——非结构化数据的数据感知索引和搜索
- 批准号:
1018723 - 财政年份:2010
- 资助金额:
$ 179.54万 - 项目类别:
Standard Grant
ITR: Shallow Integration over the Deep Web: A Holistic Approach
ITR:深网浅层集成:整体方法
- 批准号:
0313260 - 财政年份:2003
- 资助金额:
$ 179.54万 - 项目类别:
Continuing Grant
CAREER: MetaQuerier: Dynamic Ad Hoc Information Integration Across the Internet
职业:MetaQuerier:跨互联网的动态临时信息集成
- 批准号:
0133199 - 财政年份:2002
- 资助金额:
$ 179.54万 - 项目类别:
Continuing Grant
相似海外基金
METzero - Bringing the water sector towards Net-Zero using Microbial Electrochemical Technologies (METs)
METzero - 利用微生物电化学技术 (MET) 将水务行业带向净零
- 批准号:
EP/X040356/1 - 财政年份:2024
- 资助金额:
$ 179.54万 - 项目类别:
Research Grant
AUGSOC - Bringing the Augmented Society to Reality: Shaping Perception, Resilience, and Rights for Everyday AR
AUGSOC - 将增强社会变为现实:塑造日常 AR 的感知、弹性和权利
- 批准号:
EP/Z000068/1 - 财政年份:2024
- 资助金额:
$ 179.54万 - 项目类别:
Research Grant
Bringing Equality Home: A New Gender Agenda
把平等带回家:新的性别议程
- 批准号:
FL230100104 - 财政年份:2024
- 资助金额:
$ 179.54万 - 项目类别:
Australian Laureate Fellowships
An innovative concept bringing live gamified drone racing/VR immersive experience to high streets, making use of large vacant spaces in city centres
一种创新概念,利用市中心的大片空置空间,将现场游戏化无人机赛车/VR 沉浸式体验带入大街
- 批准号:
10070622 - 财政年份:2023
- 资助金额:
$ 179.54万 - 项目类别:
Collaborative R&D
Bringing nutrition to life among vulnerable populations: experiences from Latin America and Canada
为弱势群体提供营养:拉丁美洲和加拿大的经验
- 批准号:
485623 - 财政年份:2023
- 资助金额:
$ 179.54万 - 项目类别:
Miscellaneous Programs
Collaborative Research: SaTC: EDU: RoCCeM: Bringing Robotics, Cybersecurity and Computer Science to the Middled School Classroom
合作研究:SaTC:EDU:RoCCeM:将机器人、网络安全和计算机科学带入中学课堂
- 批准号:
2312057 - 财政年份:2023
- 资助金额:
$ 179.54万 - 项目类别:
Standard Grant
SCC-PG: Sustainable Vertiports for Bringing Autonomous Drone Swarm Inspection to Oil and Gas Industry Community
SCC-PG:可持续垂直起落机场为石油和天然气行业带来自主无人机群检查
- 批准号:
2323050 - 财政年份:2023
- 资助金额:
$ 179.54万 - 项目类别:
Standard Grant
CAREER: From Quantum to Classical and Back: Bringing 2D Spectroscopy Insights into Focus
职业生涯:从量子到经典再回归:聚焦二维光谱学见解
- 批准号:
2236625 - 财政年份:2023
- 资助金额:
$ 179.54万 - 项目类别:
Standard Grant
Catalyzing STEM Education: Bringing K-12 Educators, College STEM and Education Faculty together to recruit, prepare, and retain future STEM educators
促进 STEM 教育:将 K-12 教育工作者、大学 STEM 和教育教师聚集在一起,招募、准备和留住未来的 STEM 教育工作者
- 批准号:
2243431 - 财政年份:2023
- 资助金额:
$ 179.54万 - 项目类别:
Standard Grant
Collaborative Research: SaTC: EDU: RoCCeM: Bringing Robotics, Cybersecurity and Computer Science to the Middled School Classroom
合作研究:SaTC:EDU:RoCCeM:将机器人、网络安全和计算机科学带入中学课堂
- 批准号:
2312058 - 财政年份:2023
- 资助金额:
$ 179.54万 - 项目类别:
Standard Grant