公开(公告)号：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。

公开(公告)号：US20100030758A1

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

申请号：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。

公开(公告)号：US09256642B2

公开(公告)日：2016-02-09

申请号：US12827926

申请日：2010-06-30

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

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

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

CPC分类号： G06F17/30445

摘要： Techniques for automatically recommending parallel execution of a SQL statement. In one set of embodiments, a first determination can be made regarding whether a SQL statement can be executed in parallel. Further, a second determination can be made regarding whether executing the SQL statement in parallel is faster than executing the statement in serial by a predetermined factor. If the first determination and second determination are positive (i.e., the statement can be executed in parallel and parallel execution is faster by the predetermined factor), a recommendation can be provided indicating that the SQL statement should be executed in parallel. In some embodiments, the recommendation can include a report specifying the degree of performance improvement gained from parallel execution, additional system resources consumed by parallel execution, and other statistics pertaining to the recommended parallel execution plan.

摘要翻译： 自动推荐并行执行SQL语句的技术。 在一组实施例中，可以首先确定是否可以并行执行SQL语句。 此外，可以进行关于并行执行SQL语句是否比以预定因子串行执行语句更快的第二确定。 如果第一确定和第二确定是正的（即，可以并行执行语句并且并行执行以预定因子更快），则可以提供指示应该并行执行SQL语句的建议。 在一些实施例中，该建议可以包括指定从并行执行获得的性能改进程度的报告，并行执行消耗的附加系统资源以及与推荐的并行执行计划有关的其他统计信息。

公开(公告)号：US20120005188A1

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

申请号：US12827926

申请日：2010-06-30

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

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

IPC分类号： G06F17/30

CPC分类号： G06F17/30445

摘要： Techniques for automatically recommending parallel execution of a SQL statement. In one set of embodiments, a first determination can be made regarding whether a SQL statement can be executed in parallel. Further, a second determination can be made regarding whether executing the SQL statement in parallel is faster than executing the statement in serial by a predetermined factor. If the first determination and second determination are positive (i.e., the statement can be executed in parallel and parallel execution is faster by the predetermined factor), a recommendation can be provided indicating that the SQL statement should be executed in parallel. In some embodiments, the recommendation can include a report specifying the degree of performance improvement gained from parallel execution, additional system resources consumed by parallel execution, and other statistics pertaining to the recommended parallel execution plan.

摘要翻译： 自动推荐并行执行SQL语句的技术。 在一组实施例中，可以首先确定是否可以并行执行SQL语句。 此外，可以进行关于并行执行SQL语句是否比以预定因子串行执行语句更快的第二确定。 如果第一确定和第二确定是正的（即，可以并行执行语句并且并行执行以预定因子更快），则可以提供指示应该并行执行SQL语句的建议。 在一些实施例中，该建议可以包括指定从并行执行获得的性能改进程度的报告，并行执行消耗的附加系统资源以及与推荐的并行执行计划有关的其他统计信息。

公开(公告)号：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的性能相关联的统计量。 该方法可以通过存储，显示和/或提供关于统计信号的信号来得出结论。

公开(公告)号：US20090077017A1

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

申请号：US12188981

申请日：2008-08-08

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

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

IPC分类号： G06F17/30

CPC分类号： G06F17/30306

摘要： Techniques are provided for analyzing performance differences for a set of database query language statements on two different database systems. The performance analysis is based on quantitative measurements and estimates of the execution of the set of database query language statements on the two different database systems. This performance analysis process may be used by database administrators to predict impacts to performance due to a change in a database system.

摘要翻译： 提供了用于分析两个不同数据库系统上的一组数据库查询语言语句的性能差异的技术。 性能分析基于对两个不同数据库系统上的数据库查询语言语句集的执行的定量测量和估计。 数据库管理员可以使用此性能分析过程来预测由于数据库系统发生变化而对性能的影响。

公开(公告)号：US20090077016A1

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

申请号：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.

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