利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

30 条记录 (耗时 0.033 秒)

    SQL execution plan baselines
    1.
    发明授权
    SQL execution plan baselines 有权

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

    SQL Execution Plan Baselines
    2.
    发明申请
    SQL Execution Plan Baselines 有权
    SQL执行计划基准

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

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

    SQL execution plan baselines
    3.
    发明授权
    SQL execution plan baselines 有权
    SQL执行计划基线

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

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

    SQL execution plan verification
    4.
    发明授权
    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
    5.
    发明申请
    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.

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

    Maintaining and Utilizing SQL Execution Plan Histories
    9.
    发明申请
    Maintaining and Utilizing SQL Execution Plan Histories 有权
    维护和利用SQL执行计划历史

    公开(公告)号：US20090106321A1

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

    申请号：US12188673

    申请日：2008-08-08

    申请人： Dinesh Das ,  Yali Zhu ,  Mohamed Ziauddin ,  Benoit Dageville ,  Hong Su

    发明人： Dinesh Das ,  Yali Zhu ,  Mohamed Ziauddin ,  Benoit Dageville ,  Hong Su

    IPC分类号： G06F17/30

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

    摘要： Approaches, techniques, and mechanisms are disclosed for maintaining a history of query plans executed for a database command, along with information related to each query plan. A database server receives a request to execute a particular command. The database server determines a plan for executing the particular command. The database server adds first information to a plan history associated with the particular command. The plan history comprises information related to a plurality of plans that have been generated for the particular command. The first information may include, for example, properties of the plan (including an outline of the plan) as well as statistics collected during execution of the plan. The database server may implement techniques for periodically refreshing information in a plan history. The database server may also implement techniques for purging old or less important plans.

    摘要翻译： 公开了用于维护针对数据库命令执行的查询计划的历史以及与每个查询计划相关的信息的方法，技术和机制。 数据库服务器接收执行特定命令的请求。 数据库服务器确定执行特定命令的计划。 数据库服务器将第一个信息添加到与特定命令相关联的计划历史记录中。 计划历史包括与为特定命令生成的多个计划相关的信息。 第一个信息可以包括例如计划的属性（包括计划的纲要）以及执行计划期间收集的统计数据。 数据库服务器可以实现用于在计划历史中周期性地刷新信息的技术。 数据库服务器还可以实现用于清除旧的或不太重要的计划的技术。

    Maintaining and utilizing SQL execution plan histories
    10.
    发明授权
    Maintaining and utilizing SQL execution plan histories 有权
    维护和利用SQL执行计划历史

    公开(公告)号：US08335767B2

    公开(公告)日：2012-12-18

    申请号：US12188673

    申请日：2008-08-08

    申请人： Dinesh Das ,  Yali Zhu ,  Mohamed Ziauddin ,  Benoit Dageville ,  Hong Su

    发明人： Dinesh Das ,  Yali Zhu ,  Mohamed Ziauddin ,  Benoit Dageville ,  Hong Su

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

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

    摘要： Approaches, techniques, and mechanisms are disclosed for maintaining a history of query plans executed for a database command, along with information related to each query plan. A database server receives a request to execute a particular command. The database server determines a plan for executing the particular command. The database server adds first information to a plan history associated with the particular command. The plan history comprises information related to a plurality of plans that have been generated for the particular command. The first information may include, for example, properties of the plan (including an outline of the plan) as well as statistics collected during execution of the plan. The database server may implement techniques for periodically refreshing information in a plan history. The database server may also implement techniques for purging old or less important plans.

    摘要翻译： 公开了用于维护针对数据库命令执行的查询计划的历史以及与每个查询计划相关的信息的方法，技术和机制。 数据库服务器接收执行特定命令的请求。 数据库服务器确定执行特定命令的计划。 数据库服务器将第一个信息添加到与特定命令相关联的计划历史记录中。 计划历史包括与为特定命令生成的多个计划相关的信息。 第一个信息可以包括例如计划的属性（包括计划的纲要）以及执行计划期间收集的统计数据。 数据库服务器可以实现用于在计划历史中周期性地刷新信息的技术。 数据库服务器还可以实现用于清除旧的或不太重要的计划的技术。