-
1.发明授权Executing nested subqueries of parallel table functions in the parallel single cursor model 有权在并行单光标模型中执行并行表函数的嵌套子查询公开(公告)号：US07451133B2
公开(公告)日：2008-11-11
申请号：US10930433
申请日：2004-08-30
CPC分类号： G06F7/00 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： Techniques are provided for processing a database statement that includes a table function capable of parallel execution, where the input of the table function is specified in a subquery. During compilation of the database statement, a global cursor is generated for the database statement. The global cursor includes a first plan component for executing the table function and a second plan component for generating input for the table function. A “dummy” cursor is then generated. When slaves execute the table function, they call the dummy cursor for input. When a slave calls the dummy cursor for input, the dummy cursor causes a context switch back to the global cursor, so that the second plan component within the first cursor generates the input for the slave.
摘要翻译： 提供了用于处理数据库语句的技术，该数据库语句包括能够并行执行的表函数，其中在子查询中指定了表函数的输入。 在编译数据库语句时，会为数据库语句生成一个全局游标。 全局光标包括用于执行表功能的第一计划组件和用于生成表功能的输入的第二计划组件。 然后生成“虚拟”光标。 当从站执行表功能时，它们调用虚拟光标进行输入。 当从机调用虚拟光标进行输入时，虚拟光标会使上下文切换回全局光标，以便第一个光标中的第二个计划组件生成从属设备的输入。
-
2.发明申请Executing nested subqueries of parallel table functions in the parallel single cursor model 有权在并行单光标模型中执行并行表函数的嵌套子查询公开(公告)号：US20050131880A1
公开(公告)日：2005-06-16
申请号：US10930433
申请日：2004-08-30
IPC分类号： G06F7/00
CPC分类号： G06F7/00 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： Techniques are provided for processing a database statement that includes a table function capable of parallel execution, where the input of the table function is specified in a subquery. During compilation of the database statement, a global cursor is generated for the database statement. The global cursor includes a first plan component for executing the table function and a second plan component for generating input for the table function. A “dummy” cursor is then generated. When slaves execute the table function, they call the dummy cursor for input. When a slave calls the dummy cursor for input, the dummy cursor causes a context switch back to the global cursor, so that the second plan component within the first cursor generates the input for the slave.
摘要翻译： 提供了用于处理数据库语句的技术，该数据库语句包括能够并行执行的表函数，其中在子查询中指定了表函数的输入。 在编译数据库语句时，会为数据库语句生成一个全局游标。 全局光标包括用于执行表功能的第一计划组件和用于生成表功能的输入的第二计划组件。 然后生成“虚拟”光标。 当从站执行表功能时，它们调用虚拟光标进行输入。 当从机调用虚拟光标进行输入时，虚拟光标会使上下文切换回全局光标，以便第一个光标中的第二个计划组件生成从属设备的输入。
-
3.发明申请公开(公告)号：US20050131890A1
公开(公告)日：2005-06-16
申请号：US10865178
申请日：2004-06-09
CPC分类号： G06F17/30445 , Y10S707/99932 , Y10S707/99938
摘要： Techniques are provided for processing, within a database server, a database statement, where at least one subtask required by the database statement is to be executed in parallel by a slave set. The database server determines whether the database statement includes an external expression, relative to the subtask, that (a) produces information that is required by slave processes in the slave set in order to perform the subtask, and (b) is not to be evaluated by each slave process in the slave set. During execution of the statement, if the database statement includes an external expression, then one or more external values are generated by causing the external expression to be evaluated, and the one or more external values are communicated to slaves of the slave set to allow the slave processes to perform respective portions of the subtask in parallel, without requiring each slave of the slave set to evaluate the external expression.
摘要翻译： 提供技术来在数据库服务器内处理数据库语句，数据库语句所要求的至少一个子任务将由从属集并行执行。 数据库服务器确定数据库语句是否包含相对于子任务的外部表达式，（a）产生从属集中的从属进程所需的信息以执行子任务，并且（b）不被评估 由从设备中的每个从属进程。 在执行语句期间，如果数据库语句包含外部表达式，则通过使外部表达式进行求值来生成一个或多个外部值，并将一个或多个外部值传送到从设备的从站，以允许 从属进程并行执行子任务的各个部分，而不需要从属集的每个从属点来评估外部表达式。
-
4.发明授权公开(公告)号：US07203672B2
公开(公告)日：2007-04-10
申请号：US10865178
申请日：2004-06-09
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99932 , Y10S707/99938
摘要： Techniques are provided for processing, within a database server, a database statement, where at least one subtask required by the database statement is to be executed in parallel by a slave set. The database server determines whether the database statement includes an external expression, relative to the subtask, that (a) produces information that is required by slave processes in the slave set in order to perform the subtask, and (b) is not to be evaluated by each slave process in the slave set. During execution of the statement, if the database statement includes an external expression, then one or more external values are generated by causing the external expression to be evaluated, and the one or more external values are communicated to slaves of the slave set to allow the slave processes to perform respective portions of the subtask in parallel, without requiring each slave of the slave set to evaluate the external expression.
摘要翻译： 提供技术来在数据库服务器内处理数据库语句，数据库语句所要求的至少一个子任务将由从属集并行执行。 数据库服务器确定数据库语句是否包含相对于子任务的外部表达式，（a）产生从属集中的从属进程所需的信息以执行子任务，并且（b）不被评估 由从设备中的每个从属进程。 在执行语句期间，如果数据库语句包含外部表达式，则通过使外部表达式进行求值来生成一个或多个外部值，并将一个或多个外部值传送到从设备的从站，以允许 从属进程并行执行子任务的各个部分，而不需要从属集的每个从属点来评估外部表达式。
-
5.发明申请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.
摘要翻译： 在多服务器系统中处理数据库语句，以增加从属服务器在远程节点上处理的可能性将生成与查询协调器进程生成的相应执行计划相等的执行计划。 基于主计划所基于的相同信息生成一组提示。 一组提示被发送到远程节点，其中基于一组提示部分地生成相应的远程计划。 使用提示生成远程计划会增加远程计划等同于主计划的可能性，并且其他数据库服务器上的从站将能够并行处理数据库语句。
-
公开(公告)号：US08315980B2
公开(公告)日：2012-11-20
申请号：US11175804
申请日：2005-07-05
IPC分类号： G06F7/00
CPC分类号： G06F9/5066 , G06F9/5005 , G06F2209/5017
摘要： Techniques are described for parallelizing qualifying window functions without reliance on partitioning criteria specified in the command that includes the qualifying window functions. Because the techniques do not rely on partitioning criteria specified in the command, the techniques may be used on commands in which no partitioning criteria is specified. In general, the techniques involve partitioning the work of a qualified window function into ranges, and sharing precomputed aggregate values between computational elements to calculate the value for the window functions.
摘要翻译： 描述了用于并行化限定窗口功能的技术，而不依赖于包含限定窗口功能的命令中指定的分区标准。 因为这些技术不依赖于命令中指定的分区标准，所以可以在不指定分区标准的命令上使用这些技术。 通常，这些技术涉及将合格的窗口函数的工作划分为范围，并在计算元素之间共享预计算的聚合值以计算窗口函数的值。
-
公开(公告)号：US07958160B2
公开(公告)日：2011-06-07
申请号：US10841991
申请日：2004-05-06
申请人： Bhaskar Ghosh , Thierry Cruanes , Rushan Chen , Shrikanth Shankar
发明人： Bhaskar Ghosh , Thierry Cruanes , Rushan Chen , Shrikanth Shankar
IPC分类号： G06F17/30
CPC分类号： G06F17/30445
摘要： Techniques are provided for generating execution plans for, and executing, database statements that contain filter subqueries. Upon receiving a database statement that contains a filter subquery, the database server builds an execution plan that includes a filter operation that is fed by a subtree that corresponds to the subquery. The database server performs a cost analysis to determine whether (1) the filter operation should be parallelized, and (2) the subquery tree should be parallelized. Techniques are also described for generating plans and executing queries where (1) both the filter operation and the subquery subtree are parallelized, (2) the filter operation is parallelized but the subquery subtree operation is performed serially, and (3) the filter operation is performed serially but the subquery subtree operation is parallelized.
摘要翻译： 提供了技术来生成包含过滤器子查询的数据库语句的执行计划和执行。 在收到包含过滤器子查询的数据库语句之后，数据库服务器构建一个执行计划，其中包含由子查询对应的子树进行的过滤操作。 数据库服务器执行成本分析来确定（1）是否应该并行化过滤器操作，以及（2）子查询树应该并行化。 还描述了用于生成计划和执行查询的技术，其中（1）过滤器操作和子查询子树都被并行化，（2）过滤操作并行化，但是子查询子树操作被串行执行，并且（3）过滤器操作 串行执行子查询子树操作并行化。
-
公开(公告)号：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
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）用于参与查询的动态性能视图部分的第二信息。 如果远程服务器上的从站无法使用第一个信息来生成等效查询（例如，如果它们位于已关闭数据库的数据库服务器中），则远程服务器上的从站将使用第二个信息来参与 在查询的动态性能视图部分。
-
公开(公告)号：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分别设置游标，这些技术涉及共享从原始语句生成的游标， 并行执行原始语句中指定的操作。
-
公开(公告)号：US07340452B2
公开(公告)日：2008-03-04
申请号：US10901411
申请日：2004-07-27
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.
摘要翻译： 从原始数据库语句生成的游标包括在并行执行原始语句中指定的操作的各参与者之间共享的主计划。 对于无法共享相同光标的参与者（如远程服务器上的从属进程），将生成远程光标。 为主计划和远程计划生成签名，并进行比较，以确保远程计划等同于主计划。 向远程服务器提供了各种参数和统计信息，以增加远程计划与主计划相当的可能性。
-
-
-
-
-
-
-
-
-
搜索结果
47 条记录 (耗时 0.023 秒)
