CAREER: Designing a Predictable Database - An Overlooked Virtue

40年来对数据库系统的研究主要集中在提高平均原始性能上。可以理解的是，这种对更快性能的竞争忽略了我们数据库管理系统的可预测性。然而，随着数据库系统变得越来越复杂，其不稳定和不可预测的性能已成为数据库用户和管理员面临的主要挑战。随着任务关键型业务应用程序对其数据库的依赖性越来越大，保持高水平的数据库性能（即，服务水平保证）现在比以往任何时候都更加重要。由于当今数据库的高度非线性和不可预测性，云用户发现配置和调优其数据库实例具有挑战性。即使对于已部署的数据库，性能调优也已经成为一种黑色艺术，使合格的数据库管理员成为稀缺资源。在这个项目中，我们恢复了数据库系统设计中缺失的可预测性。首先，我们以原则性的方式量化数据库中不确定性的主要来源。然后，通过重新思考数据库系统的传统设计，我们构建了新一代的数据库，将可预测性视为第一类公民在其各个阶段的查询处理，从物理设计到内存管理和查询调度。此外，为了适应现有的数据库系统（这是不可预测的设计），我们提供了有效的工具和方法，更准确地预测其性能。以自下而上的方式和原则性的方式构建可预测的数据库，为改进现有的数据库产品提供了很好的见解，并可以引发未来数据库设计和实现方式的根本转变。有关此项目的更多信息，请访问https://web.eecs.umich.edu/~mozafari/predictabledb

Four decades of research on database systems has mostly focused on improving average raw performance. This competition for faster performance has, understandably, neglected predictability of our database management systems. However, as database systems have become more complex, their erratic and unpredictable performance has become a major challenge facing database users and administrators alike. With the increasing reliance of mission-critical business applications on their databases, maintaining high levels of database performance (i.e., service level guarantees) is now more important than ever. Cloud users find it challenging to provision and tune their database instances, due to the highly non-linear and unpredictable nature of today's databases. Even for deployed databases, performance tuning has become somewhat of a black art, rendering qualified database administrators a scare resource.In this project, we restore the missing virtue of predictability in the design of database systems. First, we quantify the major sources of uncertainty in a database in a principled manner. Then, by rethinking the traditional design of a database system, we architect a new generation of databases that treat predictability as a first class-citizen in their various stages of query processing, from physical design to memory management and query scheduling. Moreover, to accommodate existing database systems (which are not predictable by design), we provide effective tools and methodologies for predicting their performance more accurately. Building a predictable database in a bottom-up fashion and in a principled manner, offers great insight into improving existing database products and can instigate a radical shift in the way that future databases are designed and implemented. For more information on this project, please visit https://web.eecs.umich.edu/~mozafari/predictabledb