公开(公告)号：US20080155641A1

公开(公告)日：2008-06-26

申请号：US11614024

申请日：2006-12-20

申请人： Thomas A. Beavin ,  Baoqiu Cui ,  You-Chin Fuh ,  William Y. Kyu ,  Adarsh R. Pannu ,  Lin Qiao ,  Basuki N. Soetarman

发明人： Thomas A. Beavin ,  Baoqiu Cui ,  You-Chin Fuh ,  William Y. Kyu ,  Adarsh R. Pannu ,  Lin Qiao ,  Basuki N. Soetarman

IPC分类号： G06F17/00

CPC分类号： G06F16/217 ,  G06F16/21

摘要： A method and system for managing a computer system are described. The method and system include defining and storing a policy using a policy manager. In one aspect, the policy manager also activates and resolves conflicts between policies. The policy is a declarative statement of a directive to be carried out by the computer system. The method and system also include using a policy executor to determine whether a request to the computer system is covered by the policy. The method and system further include utilizing the computer system to carry out the directive for the policy if the request is covered by the policy through a policy enforcer.

摘要翻译： 描述了一种用于管理计算机系统的方法和系统。 该方法和系统包括使用策略管理器来定义和存储策略。 一方面，策略管理器也激活和解决策略之间的冲突。 该策略是由计算机系统执行的指令的声明性声明。 该方法和系统还包括使用策略执行器来确定对策略是否覆盖对计算机系统的请求。 该方法和系统还包括利用计算机系统执行策略的指示，如果该请求被策略执行者所涵盖。

公开(公告)号：US08060495B2

公开(公告)日：2011-11-15

申请号：US12255520

申请日：2008-10-21

申请人： Thomas A. Beavin ,  Patrick D. Bossman ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

发明人： Thomas A. Beavin ,  Patrick D. Bossman ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

IPC分类号： G06F17/30

CPC分类号： G06F17/30463

摘要： An apparatus, system, and method are disclosed for improving query execution plan efficiency in a database management system. The present invention binds both static database queries and dynamic database queries to new query execution plans (QEPs) that produce the same result set as a former QEP bound to the database queries. Next, the present invention identifies one of the former QEPs and the new QEP as an active QEP and automatically collects execution statistics for one of the former QEPs and the new QEP. Finally, the present invention automatically selects one of the former QEPs and the new QEP as the active QEP in response to completion of the automatic collection of execution statistics, the active QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the active QEP selected based on the execution statistics.

摘要翻译： 公开了一种用于提高数据库管理系统中的查询执行计划效率的装置，系统和方法。 本发明将静态数据库查询和动态数据库查询绑定到新的查询执行计划（QEP），该查询执行计划（QEP）产生与数据库查询绑定的前一个QEP相同的结果集。 接下来，本发明将前一个QEP和新的QEP之一识别为活动QEP，并自动收集前一个QEP和新的QEP之一的执行统计信息。 最后，本发明响应于完成执行统计的自动收集而自动选择前者QEP和新QEP中的一个作为活动QEP，选择活动QEP使得自动选择的QEP基于性能标准提供最佳执行性能 与自动未选择的QEP相比，基于执行统计信息选择活动QEP。

公开(公告)号：US20100114868A1

公开(公告)日：2010-05-06

申请号：US12255520

申请日：2008-10-21

申请人： Thomas A. Beavin ,  Patrick D. Bossman ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

发明人： Thomas A. Beavin ,  Patrick D. Bossman ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F17/30463

摘要： An apparatus, system, and method are disclosed for improving query execution plan efficiency in a database management system. The present invention binds both static database queries and dynamic database queries to new query execution plans (QEPs) that produce the same result set as a former QEP bound to the database queries. Next, the present invention identifies one of the former QEPs and the new QEP as an active QEP and automatically collects execution statistics for one of the former QEPs and the new QEP. Finally, the present invention automatically selects one of the former QEPs and the new QEP as the active QEP in response to completion of the automatic collection of execution statistics, the active QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the active QEP selected based on the execution statistics.

摘要翻译： 公开了一种用于提高数据库管理系统中的查询执行计划效率的装置，系统和方法。 本发明将静态数据库查询和动态数据库查询绑定到新的查询执行计划（QEP），该查询执行计划（QEP）产生与数据库查询绑定的前一个QEP相同的结果集。 接下来，本发明将前一个QEP和新的QEP之一识别为活动QEP，并自动收集前一个QEP和新的QEP之一的执行统计信息。 最后，本发明响应于完成执行统计的自动收集而自动选择前者QEP和新QEP中的一个作为活动QEP，选择活动QEP使得自动选择的QEP基于性能标准提供最佳执行性能 与自动未选择的QEP相比，基于执行统计信息选择活动QEP。

公开(公告)号：US08645356B2

公开(公告)日：2014-02-04

申请号：US13431981

申请日：2012-03-28

申请人： Patrick D Bossman ,  Curt L. Cotner ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Kun Peng Ren

发明人： Patrick D Bossman ,  Curt L. Cotner ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Kun Peng Ren

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30477 ,  G06F17/30463 ,  G06F17/30675 ,  G06F17/30935 ,  G06F17/30938

摘要： An adaptive query execution plan enhancement is provided by: selecting a sample of literal sets from an execution history of a query statement; determining a plurality of access paths by applying each literal set in the sample to the query statement; for each given access path of the plurality of access paths, determining a total execution cost by applying each literal set in the sample to the given access path; and selecting a preferred access path from the plurality of access paths based on the total execution costs for each given access path. A plurality of preferred access paths for a plurality of query statements in an application workload is collected and may be presented as a query execution plan enhancement recommendation to users.

摘要翻译： 通过以下方式提供自适应查询执行计划增强：从查询语句的执行历史中选择文字集合的样本; 通过将样本中的每个文字集合应用于查询语句来确定多个访问路径; 对于所述多个访问路径中的每个给定访问路径，通过将所述样本中的每个文字集合应用于所述给定访问路径来确定总执行成本; 以及基于每个给定访问路径的总执行成本从多个访问路径中选择优选的访问路径。 收集用于应用工作负载中的多个查询语句的多个优选访问路径，并且可以将其作为查询执行计划增强推荐呈现给用户。

公开(公告)号：US07644063B2

公开(公告)日：2010-01-05

申请号：US11840703

申请日：2007-08-17

申请人： Patrick D. Bossman ,  Frank D. Bower ,  John J. Campbell ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terrence P. Purcell

发明人： Patrick D. Bossman ,  Frank D. Bower ,  John J. Campbell ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terrence P. Purcell

IPC分类号： G06F17/30

CPC分类号： G06F17/30474

摘要： An apparatus, system, and method are disclosed for ensuring query execution plan stability in a database management system. The present invention binds a static database query to a new query execution plan (QEP) that produces the same result set as an original QEP bound to the static database query. Next, the present invention identifies one of the original QEP and the new QEP as a primary QEP and automatically collects execution statistics for the original QEP and the new QEP. Finally, the present invention automatically selects one of the original QEP and the new QEP as the primary QEP in response to completion of the automatic collection of execution statistics, the primary QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the primary QEP selected based on the execution statistics.

摘要翻译： 公开了一种用于确保数据库管理系统中的查询执行计划稳定性的装置，系统和方法。 本发明将静态数据库查询绑定到新的查询执行计划（QEP），该计划产生与绑定到静态数据库查询的原始QEP相同的结果集。 接下来，本发明将原始QEP和新QEP中的一个标识为主QEP，并自动收集原始QEP和新QEP的执行统计信息。 最后，本发明响应于完成执行统计的自动收集而自动选择原始QEP和新QEP中的一个作为主QEP，选择主QEP使得自动选择的QEP基于性能标准提供最佳执行性能 与自动未选择的QEP相比，基于执行统计信息选择主要QEP。

公开(公告)号：US20090049012A1

公开(公告)日：2009-02-19

申请号：US11840703

申请日：2007-08-17

申请人： Patrick D. Bossman ,  Frank D. Bower ,  John J, Campbell ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

发明人： Patrick D. Bossman ,  Frank D. Bower ,  John J, Campbell ,  You-Chin Fuh ,  Adarsh R. Pannu ,  Terence P. Purcell

IPC分类号： G06F17/30

CPC分类号： G06F17/30474

摘要： An apparatus, system, and method are disclosed for ensuring query execution plan stability in a database management system. The present invention binds a static database query to a new query execution plan (QEP) that produces the same result set as an original QEP bound to the static database query. Next, the present invention identifies one of the original QEP and the new QEP as a primary QEP and automatically collects execution statistics for the original QEP and the new QEP. Finally, the present invention automatically selects one of the original QEP and the new QEP as the primary QEP in response to completion of the automatic collection of execution statistics, the primary QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the primary QEP selected based on the execution statistics.

摘要翻译： 公开了一种用于确保数据库管理系统中的查询执行计划稳定性的装置，系统和方法。 本发明将静态数据库查询绑定到新的查询执行计划（QEP），该计划产生与绑定到静态数据库查询的原始QEP相同的结果集。 接下来，本发明将原始QEP和新QEP中的一个标识为主QEP，并自动收集原始QEP和新QEP的执行统计信息。 最后，本发明响应于完成执行统计的自动收集而自动选择原始QEP和新QEP中的一个作为主QEP，选择主QEP使得自动选择的QEP基于性能标准提供最佳执行性能 与自动未选择的QEP相比，基于执行统计信息选择主要QEP。

公开(公告)号：US07970757B2

公开(公告)日：2011-06-28

申请号：US12049644

申请日：2008-03-17

申请人： Snehal S. Antani ,  Chon N. Lei ,  Adarsh R. Pannu ,  Rajesh P. Ramachandran

发明人： Snehal S. Antani ,  Chon N. Lei ,  Adarsh R. Pannu ,  Rajesh P. Ramachandran

IPC分类号： G06F17/30

CPC分类号： G06F17/30442

摘要： A computer program product for database query optimization including a computer usable medium having a computer readable program, wherein the computer readable program, when executed on a computer, causes the computer to receive a database query, search the database query for a literal term, replace the literal term in the database query with a placeholder term to put the database query in a template form, search a directory for a replacement query that corresponds to the database query in the template form, replace the database query with the replacement query and include the placeholder term in the replacement query, and replace the placeholder term in the replacement query with the corresponding literal term to put the replacement query in an executable format, wherein the replacement query is an optimized substitute for the database query.

摘要翻译： 一种用于数据库查询优化的计算机程序产品，包括具有计算机可读程序的计算机可用介质，其中所述计算机可读程序在计算机上执行时使计算机接收数据库查询，在数据库查询中搜索文本术语，替换 数据库查询中的字面术语用占位符术语将数据库查询放在模板表单中，在目录中搜索与模板表单中数据库查询相对应的替换查询，将数据库查询替换为替换查询，并将 替换查询中的占位符术语，并将替换查询中的占位符术语替换为相应的文字术语，将替换查询放在可执行格式中，其中替换查询是数据库查询的优化替代。

公开(公告)号：US20090234800A1

公开(公告)日：2009-09-17

申请号：US12049644

申请日：2008-03-17

申请人： Snehal S. Antani ,  Chon N. Lei ,  Adarsh R. Pannu ,  Rajesh P. Ramachandran

发明人： Snehal S. Antani ,  Chon N. Lei ,  Adarsh R. Pannu ,  Rajesh P. Ramachandran

IPC分类号： G06F17/30

CPC分类号： G06F17/30442

摘要： A computer program product for database query optimization including a computer usable medium having a computer readable program, wherein the computer readable program, when executed on a computer, causes the computer to receive a database query, search the database query for a literal term, replace the literal term in the database query with a placeholder term to put the database query in a template form, search a directory for a replacement query that corresponds to the database query in the template form, replace the database query with the replacement query and include the placeholder term in the replacement query, and replace the placeholder term in the replacement query with the corresponding literal term to put the replacement query in an executable format, wherein the replacement query is an optimized substitute for the database query.

摘要翻译： 一种用于数据库查询优化的计算机程序产品，包括具有计算机可读程序的计算机可用介质，其中所述计算机可读程序在计算机上执行时使计算机接收数据库查询，在数据库查询中搜索文本术语，替换 数据库查询中的字面术语用占位符术语将数据库查询放在模板表单中，在目录中搜索与模板表单中数据库查询相对应的替换查询，将数据库查询替换为替换查询，并将 替换查询中的占位符术语，并将替换查询中的占位符术语替换为相应的文字术语，将替换查询放在可执行格式中，其中替换查询是数据库查询的优化替代。