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

1. 发明申请

US20050131878A1 Dynamic performance views with a parallel single cursor model 有权
标题翻译：具有并行单光标模型的动态性能视图
公开(公告)号：US20050131878A1
公开(公告)日：2005-06-16
申请号：US10898300
申请日：2004-07-23
申请人： Rushan Chen , Bhaskar Ghosh , Thierry Cruanes , Patrick Amor , Benoit Dageville
发明人： Rushan Chen , Bhaskar Ghosh , Thierry Cruanes , Patrick Amor , Benoit Dageville
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A query coordinator handles a multiple-server dynamic performance query by sending remote query slaves (1) first information for generating a complete plan for the query, and (2) second information for participating in the dynamic performance view portion of the query. If the slaves on the remote servers are unable to use the first information to generate an equivalent query (for example, if they reside in a database server that has closed the database), then the slaves on the remote servers use the second information to participate in the dynamic performance view portion of the query.
摘要翻译：查询协调器通过发送远程查询从站来处理多服务器动态性能查询（1）用于生成查询的完整计划的第一信息，以及（2）用于参与查询的动态性能视图部分的第二信息。如果远程服务器上的从站无法使用第一个信息来生成等效查询（例如，如果它们位于已关闭数据库的数据库服务器中），则远程服务器上的从站将使用第二个信息来参与在查询的动态性能视图部分。

2. 发明申请

US20070038595A1 Query processing in a parallel single cursor model on multi-instance configurations, using hints 有权
标题翻译：使用提示在多实例配置上的并行单光标模型中进行查询处理
公开(公告)号：US20070038595A1
公开(公告)日：2007-02-15
申请号：US11202453
申请日：2005-08-11
申请人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville
发明人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： A database statement is processed in a multi-server system, in a manner to increase the possibility that slave server processes on remote nodes will generate execution plans that are equivalent to the corresponding execution plan generated by the query coordinator process. A set of hints is generated based on the same information on which the master plan is based. The set of hints is sent to remote nodes, where respective remote plans are generated based in part on the set of hints. Use of the hints in generation of the remote plan increases the possibility that the remote plan will be equivalent to the master plan and that the slaves on the other database server will be able to join in parallel processing of the database statement.
摘要翻译：在多服务器系统中处理数据库语句，以增加从属服务器在远程节点上处理的可能性将生成与查询协调器进程生成的相应执行计划相等的执行计划。基于主计划所基于的相同信息生成一组提示。一组提示被发送到远程节点，其中基于一组提示部分地生成相应的远程计划。使用提示生成远程计划会增加远程计划等同于主计划的可能性，并且其他数据库服务器上的从站将能够并行处理数据库语句。

3. 发明授权

US08086645B2 Compilation and processing a parallel single cursor model 有权
标题翻译：编译并处理并行单光标模型
公开(公告)号：US08086645B2
公开(公告)日：2011-12-27
申请号：US10824887
申请日：2004-04-13
申请人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville , Rushan Chen
发明人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville , Rushan Chen
IPC分类号： G06F7/00
CPC分类号： G06F17/30445
摘要： Techniques are provided for executing query statements, or portions thereof, in parallel without using slave SQL to communicate to each slave the operations to be performed by the slave. Instead of generating one cursor for the query coordinator (QC) based on the original statement, and separate cursors for each DFO based on the slave SQL, the techniques involve sharing the cursor that is generated from the original statement among the various participants involved in the parallel execution of the operations specified in the original statement.
摘要翻译：提供了用于并行执行查询语句或其部分的技术，而不使用从属SQL向从机通知由从机执行的操作。基于原始语句而不是为查询协调器（QC）生成一个游标，并且基于从属SQL为每个DFO分别设置游标，这些技术涉及共享从原始语句生成的游标，并行执行原始语句中指定的操作。

4. 发明授权

US07340452B2 Parallel single cursor model on multiple-server configurations 有权
标题翻译：多服务器配置上的并行单光标模型
公开(公告)号：US07340452B2
公开(公告)日：2008-03-04
申请号：US10901411
申请日：2004-07-27
申请人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville , Shrikanth Shankar
发明人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville , Shrikanth Shankar
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99933 , Y10S707/99934
摘要： A cursor that is generated from an original database statement includes a master plan that is shared among the various participants involved in the parallel execution of the operations specified in the original statement. For participants that cannot share the same cursor, such as slave processes on remote servers, a remote cursor is generated. Signatures are generated for both the master plan and the remote plans, and compared to ensure that the remote plans are equivalent to the master plans. Various parameters and statistics are provided to remote servers to increase the likelihood that the remote plans will be equivalent to the master plan.
摘要翻译：从原始数据库语句生成的游标包括在并行执行原始语句中指定的操作的各参与者之间共享的主计划。对于无法共享相同光标的参与者（如远程服务器上的从属进程），将生成远程光标。为主计划和远程计划生成签名，并进行比较，以确保远程计划等同于主计划。向远程服务器提供了各种参数和统计信息，以增加远程计划与主计划相当的可能性。

5. 发明授权

US07203676B2 Dynamic performance views with a parallel single cursor model 有权
标题翻译：具有并行单光标模型的动态性能视图
公开(公告)号：US07203676B2
公开(公告)日：2007-04-10
申请号：US10898300
申请日：2004-07-23
申请人： Rushan Chen , Bhaskar Ghosh , Thierry Cruanes , Patrick A. Amor , Benoit Dageville
发明人： Rushan Chen , Bhaskar Ghosh , Thierry Cruanes , Patrick A. Amor , Benoit Dageville
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A query coordinator handles a multiple-server dynamic performance query by sending remote query slaves (1) first information for generating a complete plan for the query, and (2) second information for participating in the dynamic performance view portion of the query. If the slaves on the remote servers are unable to use the first information to generate an equivalent query (for example, if they reside in a database server that has closed the database), then the slaves on the remote servers use the second information to participate in the dynamic performance view portion of the query.
摘要翻译：查询协调器通过发送远程查询从站来处理多服务器动态性能查询（1）用于生成查询的完整计划的第一信息，以及（2）用于参与查询的动态性能视图部分的第二信息。如果远程服务器上的从站无法使用第一个信息来生成等效查询（例如，如果它们位于已关闭数据库的数据库服务器中），则远程服务器上的从站将使用第二个信息来参与在查询的动态性能视图部分。

6. 发明授权

US07685095B2 Executing a parallel single cursor model 有权
标题翻译：执行并行单光标模型
公开(公告)号：US07685095B2
公开(公告)日：2010-03-23
申请号：US10944175
申请日：2004-09-16
申请人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville
发明人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99932
摘要： Techniques are provided for executing database statements, or portions thereof, in parallel without using slave SQL to communicate to each slave the operations to be performed by the slave. Techniques are provided for incorporating within a shared cursor the code fragments that govern both sides of the interaction between a query coordinator (QC) and remotely-located slaves. Further, techniques are provided for the QC to communicate with each slave on how and which portions of the execution plan to execute and when. A state-transition engine for slave execution under the control of the query-coordinator is also provided.
摘要翻译：提供了用于并行地执行数据库语句或其部分的技术，而不使用从属SQL向从属单元通信由从属单元执行的操作。提供了在共享游标中并入管理查询协调器（QC）和远程定位的从站之间的交互的两侧的代码片段的技术。此外，提供了用于QC的技术以与每个从属单元通信以执行执行计划以及何时执行计划的哪些部分。还提供了在查询协调器的控制下从属执行的状态转换引擎。

7. 发明申请

US20060182046A1 Parallel partition-wise aggregation 有权
标题翻译：并行分区聚合
公开(公告)号：US20060182046A1
公开(公告)日：2006-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分类号： H04L12/16 , H04Q11/00
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.
摘要翻译：提供了用于对驻留在诸如关系表的容器中的数据执行并行聚合操作的技术。在生成操作的执行计划时，基于聚合中涉及的分组密钥和用于分区容器的分区密钥，确定是否应该执行分区聚合。如果要执行分区聚合，则分配给分配给扫描容器的从属进程的分配是以分区方式进行的。扫描从站本身可以执行完全或部分聚合（取决于它们是否是分配给分区的唯一扫描从站）。如果扫描从站不执行聚合或仅执行部分聚合，则扫描从站将数据项重新分配到扫描从站本地的聚合从站。

8. 发明授权

US07051034B1 Dynamic optimization for processing a restartable sub-tree of a query execution plan 有权
标题翻译：用于处理查询执行计划的可重新启动的子树的动态优化
公开(公告)号：US07051034B1
公开(公告)日：2006-05-23
申请号：US10325782
申请日：2002-12-18
申请人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville
发明人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville
IPC分类号： G06F17/30
CPC分类号： G06F17/30625 , G06F17/30979 , Y10S707/99942 , Y10S707/99945
摘要： Execution of a restartable sub-tree of a query execution plan comprises determining whether use of parallel processes is a preferred or optimal mode of executing the sub-tree. The determination is based, at least in part, on how long it takes to restart the sub-tree using two or more parallel processes and/or how long it takes to probe the sub-tree, i.e., to fetch a row that meets one or more conditions or correlations associated with the sub-query, using the two or more parallel processes. Thus, a dynamic computational cost-based operation is described, which determines at query runtime whether to execute the restartable sub-tree using a single server process or multiple parallel server processes.
摘要翻译：执行查询执行计划的可重新开始的子树包括确定并行进程的使用是否是执行子树的优选或最佳模式。该决定至少部分地基于使用两个或更多个并行进程重新启动子树所需的时间和/或探测子树需要多长时间，即，获取满足一个或更多与子查询相关联的条件或相关性，使用两个或多个并行进程。因此，描述了基于动态计算成本的操作，其在查询运行时确定是否使用单个服务器进程或多个并行服务器进程来执行可重新启动的子树。

9. 发明申请

US20050131879A1 Parallel single cursor model on multiple-server configurations 有权
标题翻译：多服务器配置上的并行单光标模型
公开(公告)号：US20050131879A1
公开(公告)日：2005-06-16
申请号：US10901411
申请日：2004-07-27
申请人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville , Shrikanth Shankar
发明人： Bhaskar Ghosh , Thierry Cruanes , Benoit Dageville , Shrikanth Shankar
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99933 , Y10S707/99934
摘要： A cursor that is generated from an original database statement includes a master plan that is shared among the various participants involved in the parallel execution of the operations specified in the original statement. For participants that cannot share the same cursor, such as slave processes on remote servers, a remote cursor is generated. Signatures are generated for both the master plan and the remote plans, and compared to ensure that the remote plans are equivalent to the master plans. Various parameters and statistics are provided to remote servers to increase the likelihood that the remote plans will be equivalent to the master plan.
摘要翻译：从原始数据库语句生成的游标包括在并行执行原始语句中指定的操作的各参与者之间共享的主计划。对于无法共享相同光标的参与者（如远程服务器上的从属进程），将生成远程光标。为主计划和远程计划生成签名，并进行比较，以确保远程计划等同于主计划。向远程服务器提供了各种参数和统计信息，以增加远程计划与主计划相当的可能性。

10. 发明授权

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.
摘要翻译：提供了用于对驻留在诸如关系表的容器中的数据执行并行聚合操作的技术。在生成操作的执行计划时，基于聚合中涉及的分组密钥和用于分区容器的分区密钥，确定是否应该执行分区聚合。如果要执行分区聚合，则分配给分配给扫描容器的从属进程的分配是以分区方式进行的。扫描从站本身可以执行完全或部分聚合（取决于它们是否是分配给分区的唯一扫描从站）。如果扫描从站不执行聚合或仅执行部分聚合，则扫描从站将数据项重新分配到扫描从站本地的聚合从站。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式