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

1. 发明申请

US20050120001A1 SQL structure analyzer 有权
标题翻译： SQL结构分析器
公开(公告)号：US20050120001A1
公开(公告)日：2005-06-02
申请号：US10936426
申请日：2004-09-07
申请人： Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Mohamed Zait , Karl Dias
发明人： Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Mohamed Zait , Karl Dias
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A method to addresses structural performance problems of a database query language statement is provided. The method includes receiving a database query language statement at an optimizer, evaluating choices in a search space to generate an execution plan for the statement, and producing annotations to record one or more reasons for selecting each choice while generating the execution plan.
摘要翻译：提供了解决数据库查询语言语句结构性能问题的方法。该方法包括在优化器处接收数据库查询语言语句，评估搜索空间中的选择以生成语句的执行计划，以及生成注释以记录在生成执行计划时选择每个选择的一个或多个原因。

2. 发明授权

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.
摘要翻译：公开了一种用于在优化器处接收数据库查询语言语句和关于语句的性能信息的方法，并且针对具有性能信息的语句生成一个或多个调优操作。

3. 发明申请

US20050125427A1 Automatic SQL tuning advisor 有权
标题翻译：自动SQL调优顾问
公开(公告)号：US20050125427A1
公开(公告)日：2005-06-09
申请号：US10936778
申请日：2004-09-07
申请人： Benoit Dageville , Mohamed Ziauddin , Khaled Yagoub , Mohamed Zait , Dinesh Das , Karl Dias , Mark Ramacher , Leng Tan
发明人： Benoit Dageville , Mohamed Ziauddin , Khaled Yagoub , Mohamed Zait , Dinesh Das , Karl Dias , Mark Ramacher , Leng Tan
IPC分类号： G06F7/00 , G06F17/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.
摘要翻译：公开了一种用于在优化器处接收数据库查询语言语句和关于语句的性能信息的方法，并且针对具有性能信息的语句生成一个或多个调优操作。

4. 发明授权

US07634456B2 SQL structure analyzer 有权
标题翻译： SQL结构分析器
公开(公告)号：US07634456B2
公开(公告)日：2009-12-15
申请号：US10936426
申请日：2004-09-07
申请人： Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Mohamed Zait , Karl Dias
发明人： Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Mohamed Zait , Karl Dias
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A method to addresses structural performance problems of a database query language statement is provided. The method includes receiving a database query language statement at an optimizer, evaluating choices in a search space to generate an execution plan for the statement, and producing annotations to record one or more reasons for selecting each choice while generating the execution plan.
摘要翻译：提供了解决数据库查询语言语句结构性能问题的方法。该方法包括在优化器处接收数据库查询语言语句，评估搜索空间中的选择以生成语句的执行计划，以及生成注释以记录在生成执行计划时选择每个选择的一个或多个原因。

5. 发明授权

US07664730B2 Method and system for implementing a SQL profile 有权
标题翻译：实现SQL配置文件的方法和系统
公开(公告)号：US07664730B2
公开(公告)日：2010-02-16
申请号：US10936205
申请日：2004-09-07
申请人： Mohamed Ziauddin , Benoit Dageville , Mohamed Zait , Khaled Yagoub
发明人： Mohamed Ziauddin , Benoit Dageville , Mohamed Zait , Khaled Yagoub
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A method, apparatus, and computer program product with a persistent data structure for storing a profile of tuning information for a query statement separately from the query statement. The profile in the persistent data structure includes a statement signature to identify the query statement, and an action to tune the statement.
摘要翻译：一种具有持久数据结构的方法，装置和计算机程序产品，用于与查询语句分开地存储用于查询语句的调整信息的简档。持久性数据结构中的配置文件包括用于标识查询语句的语句签名，以及调整语句的操作。

6. 发明申请

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.
摘要翻译：公开了一种收集有关工作负载的性能信息的方法，并且基于性能信息自动从工作负载中识别一组高负载数据库查询语言语句。

7. 发明申请

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

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. 发明申请

US20050177557A1 Automatic prevention of run-away query execution 审中-公开
标题翻译：自动防止运行查询执行
公开(公告)号：US20050177557A1
公开(公告)日：2005-08-11
申请号：US10936779
申请日：2004-09-07
申请人： Mohamed Ziauddin , Benoit Dageville , Khaled Yagoub , Mohamed Zait
发明人： Mohamed Ziauddin , Benoit Dageville , Khaled Yagoub , Mohamed Zait
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F16/24549 , G06F16/217 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A run-away query execution is automatically identified by a background process that periodically looks at each of the currently executing queries and compares the current execution time with the execution time estimated by the optimizer. Each query execution having a negative execution time difference can be automatically identified as a run-away query execution. The query execution plans that result in run-away executions can then be automatically tuned to produce more efficient execution plans.
摘要翻译：一个后台进程会自动识别一个执行错误的查询，该后台进程定期查看当前正在执行的每个查询，并将当前执行时间与优化器估计的执行时间进行比较。具有负执行时间差的每个查询执行可以被自动识别为一个逃跑查询执行。导致执行失效的查询执行计划可以自动调整，以生成更有效的执行计划。

10. 发明申请

US20050125452A1 SQL profile 有权
标题翻译： SQL配置文件
公开(公告)号：US20050125452A1
公开(公告)日：2005-06-09
申请号：US10936205
申请日：2004-09-07
申请人： Mohamed Ziauddin , Benoit Dageville , Mohamed Zait , Khaled Yagoub
发明人： Mohamed Ziauddin , Benoit Dageville , Mohamed Zait , Khaled Yagoub
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A persistent data structure for storing a profile of tuning information for a query statement separately from the query statement is disclosed. The persistent data structure includes a statement signature to identify the statement, and an action to tune the statement.
摘要翻译：公开了用于存储与查询语句分开的用于查询语句的调整信息的简档的持久数据结构。持久性数据结构包括用于标识语句的语句签名，以及调整语句的动作。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式