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

1. 发明授权

US07440935B2 Method and system for query directives and access plan hints 有权
标题翻译：查询指令和访问计划提示的方法和系统
公开(公告)号：US07440935B2
公开(公告)日：2008-10-21
申请号：US10839487
申请日：2004-05-05
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F7/00
CPC分类号： G06F17/30471 , G06F17/30306 , Y10S707/99932 , Y10S707/99934
摘要： A query plan modification system and method relates to a database system that includes a cost-based optimizer for generating access plans. The database system also permits a user to view an access plan that has been generated by a particular SQL query and modify the access plan if desired. The user specifies customizations that are associated with the access plan so that when that plan is executed, the customizations are executed as well. Exemplary customizations include specifying an initialization file specific to a query, specifying different implementation methods than those in the original access plan, prohibiting rebuilding of an access plan, and over-riding or ignoring a clause within the query that is used to generate the access plan.
摘要翻译：查询计划修改系统和方法涉及包括用于生成访问计划的基于成本的优化器的数据库系统。数据库系统还允许用户查看由特定SQL查询生成的访问计划，并根据需要修改访问计划。用户指定与访问计划相关联的自定义，以便在执行该计划时，还会执行自定义。示例性定制包括指定特定于查询的初始化文件，指定与原始访问计划中的不同的实现方法，禁止重建访问计划，以及覆盖或忽略用于生成访问计划的查询内的子句。

2. 发明授权

US08775412B2 Method and system for a self-healing query access plan 有权
标题翻译：自愈式查询访问计划的方法和系统
公开(公告)号：US08775412B2
公开(公告)日：2014-07-08
申请号：US10754010
申请日：2004-01-08
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30595 , G06F17/30474
摘要： A self-healing database engine and optimizer framework support automatically responding to execution errors to allow continued execution of a query plan. Upon encountering an execution error, the database engine automatically initiates a rebuilding of the query plan and executes the rebuilt execution plan. If an error is encountered in the rebuilt query plan then the query implementation methods are analyzed. If a query function is identified for which an alternative implementation method is available, then this alternative implementation method is substituted to create a new query plan. The new query plan is then executed to determine if the error is corrected.
摘要翻译：自修复数据库引擎和优化器框架支持自动响应执行错误，以允许继续执行查询计划。遇到执行错误时，数据库引擎会自动启动重建查询计划并执行重建的执行计划。如果在重建的查询计划中遇到错误，则会分析查询实现方法。如果识别出可用的替代实现方法的查询功能，则替代该替代实现方法来创建新的查询计划。然后执行新的查询计划以确定错误是否被更正。

3. 发明申请

US20080281780A1 Query Directives And Access Plan Hints 有权
标题翻译：查询指令和访问计划提示
公开(公告)号：US20080281780A1
公开(公告)日：2008-11-13
申请号：US12175048
申请日：2008-07-17
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F17/30
CPC分类号： G06F17/30471 , G06F17/30306 , Y10S707/99932 , Y10S707/99934
摘要： A query plan modification system and method relate to a database system that includes a cost-based optimizer for generating access plans. The database system also permits a user to view an access plan that has been generated by a particular SQL query and modify the access plan if desired. The user specifies customizations that are associated with the access plan so that when that plan is executed, the customizations are executed as well. Exemplary customizations include specifying an initialization file specific to a query, specifying different implementation methods than those in the original access plan, prohibiting rebuilding of an access plan, and over-riding or ignoring a clause within the query that is used to generate the access plan.
摘要翻译：查询计划修改系统和方法涉及包括用于生成访问计划的基于成本的优化器的数据库系统。数据库系统还允许用户查看由特定SQL查询生成的访问计划，并根据需要修改访问计划。用户指定与访问计划相关联的自定义，以便在执行该计划时，还会执行自定义。示例性定制包括指定特定于查询的初始化文件，指定与原始访问计划中的不同的实现方法，禁止重建访问计划，以及覆盖或忽略用于生成访问计划的查询内的子句。

4. 发明申请

US20080215536A1 AUTONOMICALLY GENERATING A QUERY IMPLEMENTATION THAT MEETS A DEFINED PERFORMANCE SPECIFICATION 审中-公开
公开(公告)号：US20080215536A1
公开(公告)日：2008-09-04
申请号：US12108027
申请日：2008-04-23
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F17/30
CPC分类号： G06F16/24524 , G06F16/24542
摘要： A database query optimizer allows specifying a performance specification for a query. When an access plan is created, the actual performance for executing the query using the access plan is determined and compared to the performance specification for the query. If the actual performance does not satisfy the performance specification for the query, the query optimizer autonomically generates a different access plan to see if the performance improves. If an access plan that meets the performance specification is generated, the new access plan is stored in the access plan cache for the query. If no access plan can be generated that meets the performance specification for the query, the access plan that provided the best performance is selected and stored in the access plan cache for the query.

5. 发明授权

US07133861B2 Query access plan rebuilds 有权
标题翻译：查询访问计划重建
公开(公告)号：US07133861B2
公开(公告)日：2006-11-07
申请号：US10727420
申请日：2003-12-04
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30463 , G06F17/30457 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943
摘要： A method, apparatus and system that in an embodiment detect that a trigger exists, where the trigger indicates a potential need to rebuild a saved query access plan, and determine whether a previous job associated with the trigger created a new access plan that was identical to the saved access plan. If a previous job associated with the trigger has already created the new access plan and found that it was identical to the saved access plan, then the query is performed with the saved access plan, since there is no advantage to be gained by creating the new access plan again. In this way, multiple jobs are kept from repeatedly re-creating an access plan that is identical to one that already exists.
摘要翻译：在一个实施例中，检测到触发器存在的方法，装置和系统，其中触发器指示重建保存的查询访问计划的潜在需要，并且确定与触发相关联的先前作业是否创建了与触发器相同的新的访问计划保存的访问计划。如果与触发器相关联的先前作业已经创建了新的访问计划，并发现它与保存的访问计划相同，则使用保存的访问计划执行查询，因为创建新的访问计划没有任何好处访问计划再次。以这种方式，保留多个作业以重复重新创建与已经存在的访问计划相同的访问计划。

6. 发明授权

US09135298B2 Autonomically generating a query implementation that meets a defined performance specification 有权
标题翻译：自动生成满足定义的性能规范的查询实现
公开(公告)号：US09135298B2
公开(公告)日：2015-09-15
申请号：US12107938
申请日：2008-04-23
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F17/30
CPC分类号： G06F17/30433 , G06F17/30463
摘要： A database query optimizer allows specifying a performance specification for a query. When an access plan is created, the actual performance for executing the query using the access plan is determined and compared to the performance specification for the query. If the actual performance does not satisfy the performance specification for the query, the query optimizer autonomically generates a different access plan to see if the performance improves. If an access plan that meets the performance specification is generated, the new access plan is stored in the access plan cache for the query. If no access plan can be generated that meets the performance specification for the query, the access plan that provided the best performance is selected and stored in the access plan cache for the query.
摘要翻译：数据库查询优化器允许为查询指定性能规范。当创建访问计划时，确定使用访问计划执行查询的实际性能，并将其与查询的性能规范进行比较。如果实际性能不符合查询的性能规范，则查询优化器将自动生成不同的访问计划，以查看性能是否提高。如果生成符合性能规范的访问计划，则新访问计划将存储在查询的访问计划缓存中。如果不能生成满足查询性能规范的访问计划，则提供最佳性能的访问计划被选择并存储在查询的访问计划缓存中。

7. 发明授权

US07882399B2 Intelligent job functionality 有权
标题翻译：智能作业功能
公开(公告)号：US07882399B2
公开(公告)日：2011-02-01
申请号：US11955465
申请日：2007-12-13
申请人： Paul Reuben Day , Roger Alan Mittelstadt , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Roger Alan Mittelstadt , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F11/00
CPC分类号： G06F11/079 , G06F11/0715
摘要： A method, apparatus, and program product utilize intelligent job functionality to diagnose an error in a computer. After detecting an error in a first job processing a task, and in response to another attempt to perform the task, a job selection algorithm selects a predetermined job in which to perform the task and diagnose the error. The predetermined job can be the first job or a new job associated with a signature that corresponds to the task that experienced the error. The predetermined job can be used to diagnose the error in a debugging session. Alternately, the first job may enter a debug session immediately after experiencing an error.
摘要翻译：方法，装置和程序产品利用智能作业功能来诊断计算机中的错误。在检测到处理任务的第一作业中的错误，并且响应于执行任务的另一尝试，作业选择算法选择执行任务并诊断错误的预定作业。预定作业可以是与经历错误的任务对应的签名相关联的第一作业或新作业。预定作业可用于诊断调试会话中的错误。或者，第一个作业可能在遇到错误后立即进入调试会话。

8. 发明授权

US07685101B2 Query directives and access plan hints 有权
标题翻译：查询指令和访问计划提示
公开(公告)号：US07685101B2
公开(公告)日：2010-03-23
申请号：US12175036
申请日：2008-07-17
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F17/00
CPC分类号： G06F17/30471 , G06F17/30306 , Y10S707/99932 , Y10S707/99934
摘要： A query plan modification system and method relate to a database system that includes a cost-based optimizer for generating access plans. The database system also permits a user to view an access plan that has been generated by a particular SQL query and modify the access plan if desired. The user specifies customizations that are associated with the access plan so that when that plan is executed, the customizations are executed as well. Exemplary customizations include specifying an initialization file specific to a query, specifying different implementation methods than those in the original access plan, prohibiting rebuilding of an access plan, and over-riding or ignoring a clause within the query that is used to generate the access plan.
摘要翻译：查询计划修改系统和方法涉及包括用于生成访问计划的基于成本的优化器的数据库系统。数据库系统还允许用户查看由特定SQL查询生成的访问计划，并根据需要修改访问计划。用户指定与访问计划相关联的自定义，以便在执行该计划时，还会执行自定义。示例性定制包括指定特定于查询的初始化文件，指定与原始访问计划中的不同的实现方法，禁止重建访问计划，以及覆盖或忽略用于生成访问计划的查询内的子句。

9. 发明申请

US20090158091A1 Intelligent Job Functionality 有权
标题翻译：智能工作功能
公开(公告)号：US20090158091A1
公开(公告)日：2009-06-18
申请号：US11955465
申请日：2007-12-13
申请人： Paul Reuben Day , Roger Alan Mittelstadt , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Roger Alan Mittelstadt , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F11/07
CPC分类号： G06F11/079 , G06F11/0715
摘要： A method, apparatus, and program product utilize intelligent job functionality to diagnose an error in a computer. After detecting an error in a first job processing a task, and in response to another attempt to perform the task, a job selection algorithm selects a predetermined job in which to perform the task and diagnose the error. The predetermined job can be the first job or a new job associated with a signature that corresponds to the task that experienced the error. The predetermined job can be used to diagnose the error in a debugging session. Alternately, the first job may enter a debug session immediately after experiencing an error.
摘要翻译：方法，装置和程序产品利用智能作业功能来诊断计算机中的错误。在检测到处理任务的第一作业中的错误，并且响应于执行任务的另一尝试，作业选择算法选择执行任务并诊断错误的预定作业。预定作业可以是与经历错误的任务对应的签名相关联的第一作业或新作业。预定作业可用于诊断调试会话中的错误。或者，第一个作业可能在遇到错误后立即进入调试会话。

10. 发明授权

US08161037B2 Method for autonomically generating a query implementation that meets a defined performance specification 失效
标题翻译：用于自动生成满足定义的性能规范的查询实现的方法
公开(公告)号：US08161037B2
公开(公告)日：2012-04-17
申请号：US10860402
申请日：2004-06-03
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F17/20 , G06F15/16
CPC分类号： G06F17/30433 , G06F17/30463
摘要： A database query optimizer allows specifying a performance specification for a query. When an access plan is created, the actual performance for executing the query using the access plan is determined and compared to the performance specification for the query. If the actual performance does not satisfy the performance specification for the query, the query optimizer autonomically generates a different access plan to see if the performance improves. If an access plan that meets the performance specification is generated, the new access plan is stored in the access plan cache for the query. If no access plan can be generated that meets the performance specification for the query, the access plan that provided the best performance is selected and stored in the access plan cache for the query.
摘要翻译：数据库查询优化器允许为查询指定性能规范。当创建访问计划时，确定使用访问计划执行查询的实际性能，并将其与查询的性能规范进行比较。如果实际性能不符合查询的性能规范，则查询优化器将自动生成不同的访问计划，以查看性能是否提高。如果生成符合性能规范的访问计划，则新访问计划将存储在查询的访问计划缓存中。如果不能生成满足查询性能规范的访问计划，则提供最佳性能的访问计划被选择并存储在查询的访问计划缓存中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式