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

11. 发明授权

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

12. 发明申请

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.
摘要翻译：提供了解决数据库查询语言语句结构性能问题的方法。该方法包括在优化器处接收数据库查询语言语句，评估搜索空间中的选择以生成语句的执行计划，以及生成注释以记录在生成执行计划时选择每个选择的一个或多个原因。

13. 发明授权

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.
摘要翻译：提供了解决数据库查询语言语句结构性能问题的方法。该方法包括在优化器处接收数据库查询语言语句，评估搜索空间中的选择以生成语句的执行计划，以及生成注释以记录在生成执行计划时选择每个选择的一个或多个原因。

14. 发明申请

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

15. 发明申请

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

16. 发明授权

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.

17. 发明授权

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

18. 发明申请

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

19. 发明授权

US07779008B2 Parallel partition-wise aggregation 有权
标题翻译：并行分区聚合
公开(公告)号：US07779008B2
公开(公告)日：2010-08-17
申请号：US11060260
申请日：2005-02-16
申请人： Benoit Dageville , Bhaskar Ghosh , Rushan Chen , Thierry Cruanes , Mohamed Zait
发明人： Benoit Dageville , Bhaskar Ghosh , Rushan Chen , Thierry Cruanes , Mohamed Zait
IPC分类号： G06F17/30
CPC分类号： G06F9/4494
摘要： Techniques are provided for performing a parallel aggregation operation on data that resides in a container, such as a relational table. During generation of the execution plan for the operation, it is determined whether partition-wise aggregation should be performed, based on the grouping keys involved in the aggregation and the partition keys used to partition the container. If partition-wise aggregation is to be performed, then the assignments given to the slave processes that are assigned to scan a container are made on a partition-wise basis. The scan slaves themselves may perform full or partial aggregation (depending on whether they are the only scan slaves assigned to the partition). If the scan slaves perform no aggregation, or only partial aggregation, then the scan slaves redistribute the data items to aggregation slaves that are local to the scan slaves.
摘要翻译：提供了用于对驻留在诸如关系表的容器中的数据执行并行聚合操作的技术。在生成操作的执行计划时，基于聚合中涉及的分组密钥和用于分区容器的分区密钥，确定是否应该执行分区聚合。如果要执行分区聚合，则分配给分配给扫描容器的从属进程的分配是以分区方式进行的。扫描从站本身可以执行完全或部分聚合（取决于它们是否是分配给分区的唯一扫描从站）。如果扫描从站不执行聚合或仅执行部分聚合，则扫描从站将数据项重新分配到扫描从站本地的聚合从站。

20. 发明申请

US20050038784A1 Method and mechanism for database partitioning 有权
标题翻译：数据库分区的方法和机制
公开(公告)号：US20050038784A1
公开(公告)日：2005-02-17
申请号：US10952390
申请日：2004-09-27
申请人： Mohamed Zait , Benoit Dageville
发明人： Mohamed Zait , Benoit Dageville
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30312 , G06F17/30492 , Y10S707/99932 , Y10S707/99942
摘要： The present invention is directed to a method and mechanism for partitioning using information not directly located in the object being partitioned. According to an embodiment of the invention, foreign key-primary key relationships are utilized to create join conditions between multiple database tables to implement partitioning of a database object. Also, disclosed are methods and mechanisms to perform partition pruning.
摘要翻译：本发明涉及一种使用不直接位于被划分的对象中的信息进行分区的方法和机制。根据本发明的实施例，利用外键 - 主键关系来创建多个数据库表之间的连接条件以实现数据库对象的分区。此外，公开了执行分割修剪的方法和机制。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式