公开(公告)号：US08700608B2

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

申请号：US12188683

申请日：2008-08-08

申请人： Peter Belknap ,  Benoit Dageville ,  Dinesh Das ,  Khaled Yagoub ,  Mohamed Zait ,  Mohamed Ziauddin

发明人： Peter Belknap ,  Benoit Dageville ,  Dinesh Das ,  Khaled Yagoub ,  Mohamed Zait ,  Mohamed Ziauddin

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

CPC分类号： G06F17/30469 ,  G06F17/30463

摘要： Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.

摘要翻译： 公开了方法，技术和机制，以确保根据已被验证为实际最佳的查询计划来执行数据库命令。 除非在极少数情况下，数据库服务器不执行查询计划，除非数据库服务器首先进行了验证。 数据库服务器接收执行数据库命令的请求。 数据库服务器确定未验证的计划是满足请求的最佳方案。 而不是冒险未验证的计划的未知行为，数据库服务器而是根据验证的计划满足请求。 随后 - 例如作为计划作业的一部分 - 数据库服务器执行未验证的计划以确定性能统计信息。 至少基于性能统计信息，数据库服务器确定是否验证未验证的计划。 还公开了并发和乐观验证的技术。

公开(公告)号：US20090106219A1

公开(公告)日：2009-04-23

申请号：US12188683

申请日：2008-08-08

申请人： Peter Belknap ,  Benoit Dageville ,  Dinesh Das ,  Khaled Yagoub ,  Mohamed Zait ,  Mohamed Ziauddin

发明人： Peter Belknap ,  Benoit Dageville ,  Dinesh Das ,  Khaled Yagoub ,  Mohamed Zait ,  Mohamed Ziauddin

IPC分类号： G06F17/30

CPC分类号： G06F17/30469 ,  G06F17/30463

摘要： Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.

摘要翻译： 公开了方法，技术和机制，以确保根据已被验证为实际最佳的查询计划来执行数据库命令。 除非在极少数情况下，数据库服务器不执行查询计划，除非数据库服务器首先进行了验证。 数据库服务器接收执行数据库命令的请求。 数据库服务器确定未验证的计划是满足请求的最佳方案。 而不是冒险未验证的计划的未知行为，数据库服务器而是根据验证的计划满足请求。 随后 - 例如作为计划作业的一部分 - 数据库服务器执行未验证的计划以确定性能统计信息。 至少基于性能统计，数据库服务器确定是否验证未验证的计划。 还公开了并发和乐观验证的技术。

公开(公告)号：US09058356B2

公开(公告)日：2015-06-16

申请号：US12188678

申请日：2008-08-08

申请人： Dinesh Das ,  Cetin Ozbutun ,  Hong Su ,  Mohamed Zait ,  Yali Zhu ,  Mohamed Ziauddin ,  Peter Belknap ,  Khaled Yagoub

发明人： Dinesh Das ,  Cetin Ozbutun ,  Hong Su ,  Mohamed Zait ,  Yali Zhu ,  Mohamed Ziauddin ,  Peter Belknap ,  Khaled Yagoub

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

摘要： Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower cost. The set of baseline plans are plans that, for one reason or another, have been determined to provide acceptable actual performance in at least one execution context. When the database server receives a request to execute a particular command, the database server, if possible, always executes the command according to the lowest predicted cost baseline plan. The database server may evolve the plan baseline to include additional plans by generating and testing new plans in response to new requests to execute the database command, or as part of a query optimization or tuning process.

公开(公告)号：US20090106306A1

公开(公告)日：2009-04-23

申请号：US12188678

申请日：2008-08-08

申请人： Dinesh Das ,  Cetin Ozbutun ,  Hong Su ,  Mohamed Zait ,  Yali Zhu ,  Mohamed Ziauddin ,  Peter Belknap ,  Khaled Yagoub

发明人： Dinesh Das ,  Cetin Ozbutun ,  Hong Su ,  Mohamed Zait ,  Yali Zhu ,  Mohamed Ziauddin ,  Peter Belknap ,  Khaled Yagoub

IPC分类号： G06F17/30

CPC分类号： G06F17/30469 ,  G06F17/30463

摘要： Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower cost. The set of baseline plans are plans that, for one reason or another, have been determined to provide acceptable actual performance in at least one execution context. When the database server receives a request to execute a particular command, the database server, if possible, always executes the command according to the lowest predicted cost baseline plan. The database server may evolve the plan baseline to include additional plans by generating and testing new plans in response to new requests to execute the database command, or as part of a query optimization or tuning process.

摘要翻译： 披露了用于维护数据库命令的一组基线查询计划的方法，技术和机制。 除极少数情况下，数据库服务器只能根据基准线执行命令，即使数据库服务器预测不同的计划成本较低。 一组基准计划是由于某种原因决定在至少一个执行环境中提供可接受的实际绩效的计划。 当数据库服务器接收到执行特定命令的请求时，如果可能，数据库服务器总是根据最低预测成本基线计划执行该命令。 数据库服务器可以通过生成和测试新计划以响应执行数据库命令的新请求，或作为查询优化或调整过程的一部分，来演进计划基准以包括额外的计划。

公开(公告)号：US09189522B2

公开(公告)日：2015-11-17

申请号：US12188678

申请日：2008-08-08

申请人： Dinesh Das ,  Cetin Ozbutun ,  Hong Su ,  Mohamed Zait ,  Yali Zhu ,  Mohamed Ziauddin ,  Peter Belknap ,  Khaled Yagoub

发明人： Dinesh Das ,  Cetin Ozbutun ,  Hong Su ,  Mohamed Zait ,  Yali Zhu ,  Mohamed Ziauddin ,  Peter Belknap ,  Khaled Yagoub

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

CPC分类号： G06F17/30469 ,  G06F17/30463

摘要： Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower cost. The set of baseline plans are plans that, for one reason or another, have been determined to provide acceptable actual performance in at least one execution context. When the database server receives a request to execute a particular command, the database server, if possible, always executes the command according to the lowest predicted cost baseline plan. The database server may evolve the plan baseline to include additional plans by generating and testing new plans in response to new requests to execute the database command, or as part of a query optimization or tuning process.

摘要翻译： 披露了用于维护数据库命令的一组基线查询计划的方法，技术和机制。 除极少数情况下，数据库服务器只能根据基准线执行命令，即使数据库服务器预测不同的计划成本较低。 一组基准计划是由于某种原因决定在至少一个执行环境中提供可接受的实际绩效的计划。 当数据库服务器接收到执行特定命令的请求时，如果可能，数据库服务器总是根据最低预测成本基线计划执行该命令。 数据库服务器可以通过生成和测试新计划以响应执行数据库命令的新请求，或作为查询优化或调整过程的一部分，来演进计划基准以包括额外的计划。

公开(公告)号：US08688689B2

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

申请号：US12827943

申请日：2010-06-30

申请人： Hailing Yu ,  Peter Belknap ,  Benoit Dageville ,  Karl Dias ,  Khaled Yagoub

发明人： Hailing Yu ,  Peter Belknap ,  Benoit Dageville ,  Karl Dias ,  Khaled Yagoub

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

CPC分类号： G06F17/30463

摘要： Techniques are provided for automatically recommending alternative execution plans for a SQL statement. Information pertaining to one or more execution plans for a SQL statement can be retrieved from a set of plan sources. The one or more execution plans can include the current execution plan for the statement and one or more historical execution plans. Based on the retrieved information, the performance of the one or more execution plans can be compared to each other. Based on the comparison, a recommendation can be provided to a user indicating that a particular execution plan (e.g., a historical execution plan) should be used in place of the current execution plan to execute the SQL statement.

摘要翻译： 提供了技术来自动推荐SQL语句的替代执行计划。 有关SQL语句的一个或多个执行计划的信息可以从一组计划源中检索。 一个或多个执行计划可以包括该语句的当前执行计划和一个或多个历史执行计划。 基于检索到的信息，可以将一个或多个执行计划的性能彼此进行比较。 基于该比较，可以向用户提供指示使用特定执行计划（例如，历史执行计划）来​​代替执行SQL语句的当前执行计划的建议。

公开(公告)号：US08903801B2

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

申请号：US12188975

申请日：2008-08-08

申请人： Peter Belknap ,  Benoit Dageville ,  Karl Dias ,  Khaled Yagoub

发明人： Peter Belknap ,  Benoit Dageville ,  Karl Dias ,  Khaled Yagoub

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30306 ,  G06F17/30442 ,  G06F17/30477 ,  G06F17/30536 ,  G06F17/30864 ,  Y10S707/99932

摘要： Techniques are provided for a fully-automated process for tuning database query language statements that selects database query language statements for tuning, tunes the database query language statements and generates tuning recommendations, tests the tuning recommendations, and determines whether to implement the tuning recommendations based on the test results. The fully-automated tuning process may also automatically implement certain tuning recommendations and monitor the performance of the database query language statements for which tuning recommendations have been implemented.

摘要翻译： 提供了一种全自动化过程的技术，用于调整数据库查询语言语句，该语句选择用于调优的数据库查询语言语句，调整数据库查询语言语句，并生成调优建议，测试调优建议，并确定是否实施基于 测试结果。 全自动调整过程还可以自动实现某些调优建议并监视已实施调优建议的数据库查询语言语句的性能。

公开(公告)号：US07970755B2

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

申请号：US12217249

申请日：2008-07-02

申请人： Peter Belknap ,  Khaled Yagoub ,  Karl Dias ,  Benoit Dageville

发明人： Peter Belknap ,  Khaled Yagoub ,  Karl Dias ,  Benoit Dageville

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

CPC分类号： G06F11/3688

摘要： Systems, methods, and other embodiments associated with test execution of user SQL in server code are described. One example method includes producing a reproduced execution environment that reproduces a portion of an execution environment in which a user SQL runs. The example method may also include running the user SQL in the reproduced execution environment and capturing a statistic associated with performance of the user SQL while the user SQL runs in the reproduced execution environment. The method may conclude by storing, displaying, and/or providing a signal concerning the statistic.

摘要翻译： 描述与服务器代码中的用户SQL的测试执行相关联的系统，方法和其他实施例。 一个示例性方法包括产生再现其中用户SQL运行的执行环境的一部分的再现的执行环境。 该示例方法还可以包括在再现的执行环境中运行用户SQL，并且在用户SQL在再现的执行环境中运行时捕获与用户SQL的性能相关联的统计量。 该方法可以通过存储，显示和/或提供关于统计信号的信号来得出结论。

公开(公告)号：US20100005340A1

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

申请号：US12217249

申请日：2008-07-02

申请人： Peter Belknap ,  Khaled Yagoub ,  Karl Dias ,  Benoit Dageville

发明人： Peter Belknap ,  Khaled Yagoub ,  Karl Dias ,  Benoit Dageville

IPC分类号： G06F11/00

CPC分类号： G06F11/3688

摘要： Systems, methods, and other embodiments associated with test execution of user SQL in server code are described. One example method includes producing a reproduced execution environment that reproduces a portion of an execution environment in which a user SQL runs. The example method may also include running the user SQL in the reproduced execution environment and capturing a statistic associated with performance of the user SQL while the user SQL runs in the reproduced execution environment. The method may conclude by storing, displaying, and/or providing a signal concerning the statistic.

摘要翻译： 描述与服务器代码中的用户SQL的测试执行相关联的系统，方法和其他实施例。 一个示例性方法包括产生再现其中用户SQL运行的执行环境的一部分的再现的执行环境。 该示例方法还可以包括在再现的执行环境中运行用户SQL，并且在用户SQL在再现的执行环境中运行时捕获与用户SQL的性能相关联的统计量。 该方法可以通过存储，显示和/或提供关于统计信号的信号来得出结论。

公开(公告)号：US07979422B2

公开(公告)日：2011-07-12

申请号：US12221131

申请日：2008-07-30

申请人： Peter Belknap ,  Khaled Yagoub ,  Karl Dias ,  Benoit Dageville ,  Thierry Cruanes ,  Anupam Singh

发明人： Peter Belknap ,  Khaled Yagoub ,  Karl Dias ,  Benoit Dageville ,  Thierry Cruanes ,  Anupam Singh

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30306 ,  G06F17/30471

摘要： Systems, methods, and other embodiments associated with hybrid optimization strategies in automatic SQL tuning are described. One example method includes receiving a first (e.g., cost-based) execution plan for a user structured query language statement (User SQL) from a first (e.g., cost-based) optimizer. The example method may also include receiving a second (e.g., rules-based) execution plan for the User SQL from a second, different (e.g., rules-based) query optimizer. The method may include identifying a preferred execution plan based on data produced by test executing the execution plans in a reproduced execution environment that reproduces at least a portion of an execution environment in which the user SQL runs. The method may also include controlling a database to execute the User SQL using the preferred execution plan.

摘要翻译： 描述了与自动SQL调优中的混合优化策略相关联的系统，方法和其他实施例。 一个示例性方法包括从第一（例如基于成本的）优化器接收用户结构化查询语言语句（User SQL）的第一（例如基于成本的）执行计划。 示例性方法还可以包括从第二不同（例如，基于规则的）查询优化器接收针对用户SQL的第二（例如基于规则的）执行计划。 该方法可以包括基于在再现执行用户SQL运行的执行环境的至少一部分的再现执行环境中执行执行计划的测试产生的数据来识别优选执行计划。 该方法还可以包括控制数据库以使用优选的执行计划来执行User SQL。