Autonomic workload management for DBMs

DBM 的自主工作负载管理

• 批准号: 394981-2009
• 负责人: Martin, Patrick
• 金额: $ 3.99万
• 依托单位: Queen's University
• 依托单位国家: 加拿大
• 项目类别: Collaborative Research and Development Grants
• 财政年份: 2012
• 资助国家: 加拿大
• 起止时间: 2012-01-01 至 2013-12-31
• 项目状态: 已结题
• 来源: https://www.nserc-crsng.gc.ca/ase-oro/Details-Detailles_eng.asp?id=498629
• 关键词: Autonomic; workload; management; DBMs

The current trend for enterprises to consolidate different workloads, such as business intelligence (BI) and transaction processing (OLTP), with different performance requirements onto a single database server means that the management of the database management system (DBMS) is becoming increasingly complex and costly. The competition among the workloads for server resources, for example, must be managed based on the importance and the demands of the workloads. BI workloads are especially resource-intensive and are often of lower importance than OLTP workloads. We must therefore be able to ensure that BI queries make progress while the requirements of more important workloads are met. Existing workload management techniques, such as assigning operating system priorities to workloads, or terminating then restarting BI queries in order to free up their resources, are inadequate.

企业将具有不同性能要求的不同工作负载（如商业智能（BI）和事务处理（OLTP））整合到单个数据库服务器上的当前趋势意味着数据库管理系统（DBMS）的管理变得越来越复杂和昂贵。例如，必须根据工作负载的重要性和需求来管理工作负载之间对服务器资源的竞争。BI工作负载尤其是资源密集型工作负载，其重要性通常低于OLTP工作负载。因此，我们必须能够确保BI查询取得进展，同时满足更重要的工作负载的要求。现有的工作负载管理技术，例如为工作负载分配操作系统优先级，或终止然后重新启动BI查询以释放其资源，是不够的。