专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US07877379B2 Delaying evaluation of expensive expressions in a query 有权
标题翻译：在查询中延迟评估昂贵的表达式
公开(公告)号：US07877379B2
公开(公告)日：2011-01-25
申请号：US11242361
申请日：2005-09-30
申请人： Allison Waingold , Rafi Ahmed , Bhaskar Ghosh , Dinesh Das , Mohamed Zait
发明人： Allison Waingold , Rafi Ahmed , Bhaskar Ghosh , Dinesh Das , Mohamed Zait
IPC分类号： G06F7/00
CPC分类号： G06F17/30463 , Y10S707/99932
摘要： Techniques are provided for delaying evaluation of expensive expressions in a query. Expensive expressions in the query are established by cost information or by looking up a list of known expensive expressions for a match. After an execution plan is determined by using the early evaluation technique, one or more equivalent execution plans is established. The one or more equivalent execution plans may include both a type of execution plans that delay evaluation of expensive expressions and a type of execution plans that do not. In addition, the one or more equivalent execution plans may include both parallelized and non-parallelized alternatives to the execution plan identified by the early evaluation technique. Finally, based on a set of criteria, which may include comparing cost information among all the equivalent execution plans generated thus far, the best execution plan is chosen for the query.
摘要翻译：提供了用于延迟查询中昂贵表达式的评估的技术。查询中的昂贵表达式是通过成本信息建立的，或通过查找匹配的已知昂贵表达式的列表来确定。在通过使用早期评估技术确定执行计划之后，建立一个或多个等效执行计划。一个或多个等效执行计划可以包括延迟对昂贵表达式的评估的执行计划的类型以及不执行计划的类型。此外，一个或多个等效执行计划可以包括由早期评估技术识别的执行计划的并行化和非并行化替代方案。最后，基于一组标准，其中可能包括比较到目前为止生成的所有等效执行计划中的成本信息，为查询选择最佳执行计划。

2. 发明申请

US20070078812A1 Delaying evaluation of expensive expressions in a query 有权
标题翻译：在查询中延迟评估昂贵的表达式
公开(公告)号：US20070078812A1
公开(公告)日：2007-04-05
申请号：US11242361
申请日：2005-09-30
申请人： Allison Waingold , Rafi Ahmed , Bhaskar Ghosh , Dinesh Das , Mohamed Zait
发明人： Allison Waingold , Rafi Ahmed , Bhaskar Ghosh , Dinesh Das , Mohamed Zait
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , Y10S707/99932
摘要： Techniques are provided for delaying evaluation of expensive expressions in a query. Expensive expressions in the query are established by cost information or by looking up a list of known expensive expressions for a match. After an execution plan is determined by using the early evaluation technique, one or more equivalent execution plans is established. The one or more equivalent execution plans may include both a type of execution plans that delay evaluation of expensive expressions and a type of execution plans that do not. In addition, the one or more equivalent execution plans may include both parallelized and non-parallelized alternatives to the execution plan identified by the early evaluation technique. Finally, based on a set of criteria, which may include comparing cost information among all the equivalent execution plans generated thus far, the best execution plan is chosen for the query.
摘要翻译：提供了用于延迟查询中昂贵表达式的评估的技术。查询中的昂贵表达式是通过成本信息建立的，或通过查找匹配的已知昂贵表达式的列表来确定。在通过使用早期评估技术确定执行计划之后，建立一个或多个等效执行计划。一个或多个等效执行计划可以包括延迟对昂贵表达式的评估的执行计划的类型以及不执行计划的类型。此外，一个或多个等效执行计划可以包括由早期评估技术识别的执行计划的并行化和非并行化替代方案。最后，基于一组标准，其中可能包括比较到目前为止生成的所有等效执行计划中的成本信息，为查询选择最佳执行计划。

3. 发明授权

US09058356B2 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.

4. 发明申请

US20050138015A1 High load SQL driven statistics collection 审中-公开
标题翻译：高负载SQL驱动的统计信息收集
公开(公告)号：US20050138015A1
公开(公告)日：2005-06-23
申请号：US10936427
申请日：2004-09-07
申请人： Benoit Dageville , Mohamed Ziauddin , Mohamed Zait , Dinesh Das
发明人： Benoit Dageville , Mohamed Ziauddin , Mohamed Zait , Dinesh Das
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F16/24549 , G06F16/217 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A method for receiving a database query language statement and statistics information about the statement at an optimizer, and identifying an inaccurate statistic for the statement, is disclosed.
摘要翻译：公开了一种用于在优化器处接收数据库查询语言语句和关于语句的统计信息以及识别语句的不准确统计的方法。

5. 发明申请

US20050119999A1 Automatic learning optimizer 审中-公开
标题翻译：自动学习优化器
公开(公告)号：US20050119999A1
公开(公告)日：2005-06-02
申请号：US10935906
申请日：2004-09-07
申请人： Mohamed Zait , Benoit Dageville , Dinesh Das , Khaled Yagoub , Mohamed Ziauddin
发明人： Mohamed Zait , Benoit Dageville , Dinesh Das , Khaled Yagoub , Mohamed Ziauddin
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F16/24549 , G06F16/217 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A method of gathering performance information about a workload, and automatically identifying a set of high-load database query language statements from the workload based on the performance information, is disclosed.
摘要翻译：公开了一种收集有关工作负载的性能信息的方法，并且基于性能信息自动从工作负载中识别一组高负载数据库查询语言语句。

6. 发明授权

US07747606B2 Automatic SQL tuning advisor 有权
标题翻译：自动SQL调优顾问
公开(公告)号：US07747606B2
公开(公告)日：2010-06-29
申请号：US10936778
申请日：2004-09-07
申请人： Benoit Dageville , Mohamed Ziauddin , Khaled Yagoub , Mohamed Zait , Dinesh Das , Karl Dias , Mark Ramacher , Leng Leng Tan
发明人： Benoit Dageville , Mohamed Ziauddin , Khaled Yagoub , Mohamed Zait , Dinesh Das , Karl Dias , Mark Ramacher , Leng Leng Tan
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A method for receiving a database query language statement and performance information about the statement at an optimizer and generating one or more tuning actions for the statement with the performance information is disclosed.
摘要翻译：公开了一种用于在优化器处接收数据库查询语言语句和关于语句的性能信息的方法，并且针对具有性能信息的语句生成一个或多个调优操作。

7. 发明申请

US20050120000A1 Auto-tuning SQL statements 有权
标题翻译：自动调整SQL语句
公开(公告)号：US20050120000A1
公开(公告)日：2005-06-02
申请号：US10935908
申请日：2004-09-07
申请人： Mohamed Ziauddin , Benoit Dageville , Mohamed Zait , Dinesh Das
发明人： Mohamed Ziauddin , Benoit Dageville , Mohamed Zait , Dinesh Das
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： Auto-tuning can be performed by receiving a database query language statement and performance information related to the statement, determining whether one or more performance statistics of the statement are available or missing in the performance information, and determining an auto-tuning hint for each missing statistic.
摘要翻译：可以通过接收与该语句相关的数据库查询语言语句和性能信息来确定语句的一个或多个性能统计信息是否在性能信息中可用或丢失来执行自动调整，以及确定每个缺失的自动调整提示统计。

8. 发明授权

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

9. 发明授权

US07739263B2 Global hints 有权
标题翻译：全球提示
公开(公告)号：US07739263B2
公开(公告)日：2010-06-15
申请号：US10936781
申请日：2004-09-07
申请人： Dinesh Das , Benoit Dageville , Mohamed Ziauddin , Mohamed Zait
发明人： Dinesh Das , Benoit Dageville , Mohamed Ziauddin , Mohamed Zait
IPC分类号： G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A method for determining a name for a query block of a database query language statement, and associating one or more tuning hints with the query block using the name.
摘要翻译：一种用于确定数据库查询语言语句的查询块的名称并使用该名称将一个或多个调优提示与查询块相关联的方法。

10. 发明申请

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

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式