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

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

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.