Robustness in database management

数据库管理的稳健性

• 批准号: 311981-2008
• 负责人: Aboulnaga, Ashraf
• 金额: $ 1.97万
• 依托单位: University of Waterloo
• 依托单位国家: 加拿大
• 项目类别: Discovery Grants Program - Individual
• 财政年份: 2012
• 资助国家: 加拿大
• 起止时间: 2012-01-01 至 2013-12-31
• 项目状态: 已结题
• 来源: https://www.nserc-crsng.gc.ca/ase-oro/Details-Detailles_eng.asp?id=503256
• 关键词: 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秒)。数据库管理中的另一种健壮性形式是对故障的恢复能力。即使在硬件或软件出现故障的情况下，数据库的用户也应继续可用。目前，大多数数据库用户都期待这种“始终在线”的操作。