CAREER: Mining Hints from Text Documents to Guide Automated Database Performance Tuning

职业：从文本文档中挖掘提示来指导自动数据库性能调优

• 批准号: 2239326
• 负责人: Immanuel Trummer
• 金额: $ 59.49万
• 依托单位: Cornell University
• 依托单位国家: 美国
• 项目类别: Continuing Grant
• 财政年份: 2023
• 资助国家: 美国
• 起止时间: 2023-04-01 至 2028-03-31
• 项目状态: 未结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=2239326&HistoricalAwards=false
• 关键词: CAREER; Mining; Hints; Text; Documents

Database management systems; that is, systems that process and manage large data sets, are used widely, across virtually all sectors of industry. Their performance depends on a variety of tuning decisions, determining how the system processes data internally. For lay users, it is very hard to find settings that optimize performance. This has motivated the creation of automated database tuning tools that try to find optimal settings for them. However, crucial information for database tuning is often available in the form of natural language text, including, for instance, the database manual, text documents describing data sets, as well as discussions on database-centric Internet forums. Currently, automated tools are unable to benefit from such text, making them inefficient. This project aims at creating automated database tuning tools that extract useful information for tuning from a variety of text documents. By increasing the quality of automated tuning tools, the project empowers lay users and reduces the need for highly specialized workers in industry, currently causing staff shortages and hampering the adoption of new technology. At the same time, the project aims at the creation of new teaching offerings, helping to educate the next generation of data professionals.The project is divided into two primary research thrusts, dedicated to the two categories of text documents that are most useful for database system tuning: text about data sets and text about database management systems. Transformer-based language models will be used to extract relevant information from such text documents. The resulting insights can be used in multiple ways for database tuning: to guide data profiling operations prior to tuning, to refine cost models used for tuning, or to restrict the search space of tuning choices. The project will explore all of those options, combining insights gained from text with other sources of information (e.g., trial runs that result in performance measurements for specific tuning choices). The project will consider a representative set of classical database tuning problems, including, for instance, the problem of selecting auxiliary index data structures to optimally support data processing, as well as the problem of finding optimal values for database system configuration parameters. All project outcomes will be integrated into a software package for automated database tuning, using text documents as input. This software will be released to the public.This award reflects NSF's statutory mission and has been deemed worthy of support through evaluation using the Foundation's intellectual merit and broader impacts review criteria.

数据库管理系统；也就是说，处理和管理大型数据集的系统几乎在行业的所有领域都广泛使用。它们的性能取决于各种调整决策，确定系统如何内部处理数据。对于外行用户，很难找到优化性能的设置。这促使创建自动化数据库调整工具，这些工具试图为其找到最佳的设置。但是，数据库调整的关键信息通常以自然语言文本的形式获得，例如，数据库手册，描述数据集的文本文档以及以数据库为中心的Internet论坛上的讨论。当前，自动化工具无法从此类文本中受益，从而使其效率低下。该项目旨在创建自动化数据库调整工具，以从各种文本文档中提取有用的信息。通过提高自动调整工具的质量，该项目使使用用户能力并减少了对行业高度专业工人的需求，目前导致员工短缺并阻碍了新技术的采用。同时，该项目旨在创建新的教学产品，帮助教育下一代数据专业人员。该项目分为两个主要的研究推力，专门针对两类文本文档，这些文本文档对于数据库系统调整最有用：有关数据集和有关数据库管理系统的文本和文本。基于变压器的语言模型将用于从此类文本文档中提取相关信息。所得的见解可以多种方式用于数据库调整：在调整之前指导数据分析操作，以完善用于调整的成本模型或限制调整选择的搜索空间。该项目将探索所有这些选项，将从文本获得的见解与其他信息来源相结合（例如，试用的运行，可以为特定的调整选择提供绩效测量）。该项目将考虑一组代表性的经典数据库调整问题，包括选择辅助索引数据结构以最佳支持数据处理的问题，以及找到数据库系统配置参数的最佳值的问题。所有项目成果将使用文本文档作为输入将软件包集成到用于自动数据库调整的软件包中。该软件将发布给公众。该奖项反映了NSF的法定任务，并被认为是使用基金会的知识分子优点和更广泛的影响评论标准的评估值得支持的。

项目成果

DB-BERT: making database tuning tools “read” the manual

• DOI: 10.1007/s00778-023-00831-y
• 发表时间: 2023-12
• 期刊: The VLDB Journal
• 作者: Immanuel Trummer