Robustness in database management

数据库管理的稳健性

• 批准号: 311981-2008
• 负责人: Aboulnaga, Ashraf
• 金额: $ 1.97万
• 依托单位: University of Waterloo
• 依托单位国家: 加拿大
• 项目类别: Discovery Grants Program - Individual
• 财政年份: 2008
• 资助国家: 加拿大
• 起止时间: 2008-01-01 至 2009-12-31
• 项目状态: 已结题
• 来源: https://www.nserc-crsng.gc.ca/ase-oro/Details-Detailles_eng.asp?id=396598
• 关键词: Robustness; database; management

Database systems are an essential component of the software infrastructure for a wide range of business and scientific applications. One of the main problems with database systems is the significant cost and effort required for database administration and tuning. To address this problem, there has been a lot of research on making database systems more self-managing. For self-managing database systems, robustness is an objective that is becoming increasingly important in modern computing environments. One form of robustness is performance predictability. Instead of aiming for maximum performance, even if this performance is sensitive to system and workload conditions, self-managing database systems should aim for robust performance that is adequate for application needs and stable under different conditions. Users of database systems currently encode such predictability requirements as service-level objectives (e.g., response time must be below three seconds). Another form of robustness in database management is resilience to failures. The database should continue to be available to its users even in the face of hardware or software failures. Such "always on" operation is currently expected by most database users.

数据库系统是广泛的商业和科学应用软件基础设施的重要组成部分。数据库系统的主要问题之一是数据库管理和调优所需的大量成本和工作。为了解决这个问题，已经有很多关于使数据库系统更加自我管理的研究。对于自管理数据库系统，鲁棒性是在现代计算环境中变得越来越重要的目标。鲁棒性的一种形式是性能可预测性。自管理数据库系统不应以最大性能为目标，即使这种性能对系统和工作负载条件敏感，但应致力于满足应用程序需求并在不同条件下保持稳定的鲁棒性能。数据库系统的用户目前将这种可预测性需求编码为服务级别目标（例如，响应时间必须低于3秒）。数据库管理中另一种形式的健壮性是对故障的弹性。即使在硬件或软件出现故障的情况下，该数据库也应继续向用户提供。这种“永远在线”的操作是目前大多数数据库用户所期望的。