CAREER: Generating Application-Specific Database Management Systems

职业：生成特定于应用程序的数据库管理系统

• 批准号: 2027575
• 负责人: Alvin Cheung
• 金额: $ 51.85万
• 依托单位: University of California-Berkeley
• 依托单位国家: 美国
• 项目类别: Continuing Grant
• 财政年份: 2020
• 资助国家: 美国
• 起止时间: 2020-04-01 至 2024-06-30
• 项目状态: 已结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=2027575&HistoricalAwards=false
• 关键词: CAREER; Generating; Application; Specific; Database

Database management systems (DBMSs) are designed to be general-purpose tools that support a wide variety of applications, from banking to social networking and making scientific discoveries. To improve the performance of such applications, researchers have leveraged the unique characteristics of application areas to build domain-specific DBMSs that outperform traditional implementations. Performing such specialization requires labor intensive, complex, and error prone efforts. The intellectual merits of this project are to advance the state of the art in application-specific DBMS design by investigating techniques to perform such domain specialization automatically. As part of this project's broader impacts, the lessons and techniques learned will be integrated into programming languages and classes that the PI routinely teaches.Specifically, this proposal aims to leverage recent advances in programming systems and data management research to build tools that can automatically understand database application semantics. Given such knowledge, the goals of this project are to 1) create tools that can automatically optimize the specific set of queries that can potentially be issued by the application, and prove that the optimized queries are semantically equivalent to the inputs; 2) investigate techniques to automatically select the optimal framework (in terms of execution time, resources required, etc) to execute the queries issued by the application, and 3) devise new languages for programmers to express their data consistency needs when queries are to be executed across a distributed set of nodes, and build an implementation of such languages. All software artifacts developed in this project are released to the public, with plans to incorporate their usage in both the undergraduate and graduate curricula. In addition, as part of the project is to collect and study the shortcomings of real-world database applications, the collected applications are collected into a repository that is publicly accessible repository for researchers and practitioners in the field to experiment and reproduce the results.

数据库管理系统（dbms）被设计成支持各种应用程序的通用工具，从银行到社会网络，再到科学发现。为了提高这类应用程序的性能，研究人员利用应用程序领域的独特特征来构建优于传统实现的特定于领域的dbms。执行这样的专门化需要劳动密集、复杂且容易出错的工作。这个项目的智力优势在于，通过研究自动执行这种领域专门化的技术，提高了特定于应用程序的DBMS设计的最新水平。作为该项目更广泛影响的一部分，学到的经验教训和技术将被整合到PI日常教授的编程语言和课程中。具体来说，本提案旨在利用编程系统和数据管理研究的最新进展来构建能够自动理解数据库应用程序语义的工具。有了这些知识，这个项目的目标是：1)创建能够自动优化应用程序可能发出的特定查询集的工具，并证明优化的查询在语义上等同于输入；2)研究自动选择最优框架（在执行时间、所需资源等方面）来执行应用程序发出的查询的技术，3)为程序员设计新的语言，以便在跨分布式节点集执行查询时表达他们的数据一致性需求，并构建这种语言的实现。在这个项目中开发的所有软件工件都向公众发布，并计划在本科和研究生课程中合并它们的使用。此外，作为项目的一部分，收集和研究实际数据库应用程序的缺点，收集到的应用程序被收集到一个存储库中，该存储库是该领域的研究人员和实践者可以公开访问的存储库，以进行实验和重现结果。

项目成果

Demonstration of Chestnut: An In-memory Data Layout Designer for Database Applications

栗子演示：数据库应用的内存数据布局设计器

• DOI: 10.1145/3318464.3384712
• 发表时间: 2020
• 期刊: ACM SIGMOD Conference
• 作者: Mingwei Samuel, Cong Yan

Generating Application-specific Data Layouts for In-memory Databases

• DOI: 10.14778/3342263.3342630
• 发表时间: 2019-07
• 期刊: Proc. VLDB Endow.
• 作者: Cong Yan;Alvin Cheung

Changes in Software Ecosystems

软件生态系统的变化

• DOI: 10.1184/r1/19799314.v1
• 发表时间: 2022
• 期刊: PLATEAU
• 作者: Matute, Gabriel;Cheung, Alvin;Chasins, Sarah
• 通讯作者: Chasins, Sarah