I-Corps: Pain-free Database Administration via Workload Intelligence

I-Corps：通过工作负载智能进行无痛数据库管理

• 批准号: 1624330
• 负责人: Barzan Mozafari
• 金额: $ 5万
• 依托单位: Regents of the University of Michigan - Ann Arbor
• 依托单位国家: 美国
• 项目类别: Standard Grant
• 财政年份: 2016
• 资助国家: 美国
• 起止时间: 2016-02-15 至 2016-08-31
• 项目状态: 已结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=1624330&HistoricalAwards=false
• 关键词: Corps; Pain; free; Database; Administration

Businesses are increasingly relying on database systems to support mission-critical applications. Consequently, running a database system has become a major operational cost for businesses as poor database performance can directly impact revenue and user experience. Database administrators (DBAs) are required to constantly monitor, diagnose, and rectify any performance decays. Unfortunately, the manual process of debugging and diagnosing database problems is extremely tedious and non-trivial. Rather than being caused by a single slow query, performance problems can be due to a large number of concurrent and competing queries creating compounded and hard-to-isolate effects. Sudden changes in request volume, query patterns, network traffic, or data distribution can cause previously abundant resources to become scarce, and the performance to plummet.This I-Corps team has developed a tool for assisting DBAs in quickly and reliably diagnosing performance problems in a database. By analyzing hundreds of statistics and configurations collected over the lifetime of the system, this tool's algorithm quickly identifies a small set of potential causes and presents them to the DBA. The goal of this project is to investigate the commercialization opportunities of this technology through customer discovery. Moreover, the team plans on locating and interacting with Beta users who are willing to use the proposed program and provide critical feedback on (i) what they like, (ii) what needs to be improved, (iii) what needs to be added, and (iv) what these customers are willing to pay.

企业越来越依赖数据库系统来支持关键任务应用程序。因此，运行数据库系统已成为企业的主要运营成本，因为糟糕的数据库性能会直接影响收入和用户体验。数据库管理员（DBA）需要不断地监视、诊断和纠正任何性能衰退。不幸的是，调试和诊断数据库问题的手动过程非常繁琐且不容易。性能问题不是由单个慢查询引起的，而是由于大量并发和竞争查询造成的复合和难以隔离的影响。请求量、查询模式、网络流量或数据分布的突然变化可能导致以前丰富的资源变得稀缺，性能急剧下降。I-Corps团队开发了一种工具，用于帮助DBA快速可靠地诊断数据库中的性能问题。通过分析在系统生命周期内收集的数百个统计信息和配置，该工具的算法可以快速识别出一小部分潜在原因，并将其呈现给DBA。该项目的目标是通过客户发现来调查这项技术的商业化机会。此外，该团队计划定位并与愿意使用拟议程序的Beta用户进行互动，并提供关于（i）他们喜欢什么，（ii）需要改进什么，（iii）需要添加什么，以及（iv）这些客户愿意支付什么的关键反馈。