利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

27 条记录 (耗时 0.021 秒)

    TECHNIQUES FOR RECOMMENDING PARALLEL EXECUTION OF SQL STATEMENTS
    11.
    发明申请
    TECHNIQUES FOR RECOMMENDING PARALLEL EXECUTION OF SQL STATEMENTS 有权
    推荐使用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语句的建议。 在一些实施例中，该建议可以包括指定从并行执行获得的性能改进程度的报告，并行执行消耗的附加系统资源以及与推荐的并行执行计划有关的其他统计信息。

    Hybrid optimization strategies in automatic SQL tuning
    12.
    发明申请
    Hybrid optimization strategies in automatic SQL tuning 有权
    自动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。

    SQL tuning sets
    17.
    发明授权
    SQL tuning sets 有权
    SQL调优集

    公开(公告)号：US07664778B2

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

    申请号：US10936449

    申请日：2004-09-07

    申请人： Khaled Yagoub ,  Benoit Dageville ,  Mohamed Ziauddin ,  Karl Dias

    发明人： Khaled Yagoub ,  Benoit Dageville ,  Mohamed Ziauddin ,  Karl Dias

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

    CPC分类号： G06F17/30474 ,  G06F17/30306 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99944

    摘要： A method and system for storing one or more database query language statements and performance information for each query language statement as a persistent database object. In one or more embodiments, the method and system stores the resource intensive statements and the performance information for each resource intensive statement as a second persistent database object.

    摘要翻译： 用于将每个查询语言语句的一个或多个数据库查询语言语句和性能信息存储为持久数据库对象的方法和系统。 在一个或多个实施例中，该方法和系统将资源密集型语句和每个资源密集型语句的性能信息存储为第二持久数据库对象。

    SQL execution plan verification
    19.
    发明授权
    SQL execution plan verification 有权
    SQL执行计划验证

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

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

    SQL Execution Plan Verification
    20.
    发明申请
    SQL Execution Plan Verification 有权
    SQL执行计划验证

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

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