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

21. 发明授权

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.
摘要翻译：一种具有持久数据结构的方法，装置和计算机程序产品，用于与查询语句分开地存储用于查询语句的调整信息的简档。持久性数据结构中的配置文件包括用于标识查询语句的语句签名，以及调整语句的操作。

22. 发明申请

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

23. 发明申请

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.
摘要翻译：一个后台进程会自动识别一个执行错误的查询，该后台进程定期查看当前正在执行的每个查询，并将当前执行时间与优化器估计的执行时间进行比较。具有负执行时间差的每个查询执行可以被自动识别为一个逃跑查询执行。导致执行失效的查询执行计划可以自动调整，以生成更有效的执行计划。

24. 发明申请

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.
摘要翻译：公开了用于存储与查询语句分开的用于查询语句的调整信息的简档的持久数据结构。持久性数据结构包括用于标识语句的语句签名，以及调整语句的动作。

25. 发明授权

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.

26. 发明申请

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

27. 发明授权

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

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式