公开(公告)号：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）用于参与查询的动态性能视图部分的第二信息。 如果远程服务器上的从站无法使用第一个信息来生成等效查询（例如，如果它们位于已关闭数据库的数据库服务器中），则远程服务器上的从站将使用第二个信息来参与 在查询的动态性能视图部分。

公开(公告)号：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.

摘要翻译： 在多服务器系统中处理数据库语句，以增加从属服务器在远程节点上处理的可能性将生成与查询协调器进程生成的相应执行计划相等的执行计划。 基于主计划所基于的相同信息生成一组提示。 一组提示被发送到远程节点，其中基于一组提示部分地生成相应的远程计划。 使用提示生成远程计划会增加远程计划等同于主计划的可能性，并且其他数据库服务器上的从站将能够并行处理数据库语句。

公开(公告)号：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

申请人： 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.

摘要翻译： 从原始数据库语句生成的游标包括在并行执行原始语句中指定的操作的各参与者之间共享的主计划。 对于无法共享相同光标的参与者（如远程服务器上的从属进程），将生成远程光标。 为主计划和远程计划生成签名，并进行比较，以确保远程计划等同于主计划。 向远程服务器提供了各种参数和统计信息，以增加远程计划与主计划相当的可能性。

公开(公告)号：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）用于参与查询的动态性能视图部分的第二信息。 如果远程服务器上的从站无法使用第一个信息来生成等效查询（例如，如果它们位于已关闭数据库的数据库服务器中），则远程服务器上的从站将使用第二个信息来参与 在查询的动态性能视图部分。

公开(公告)号：US06978458B1

公开(公告)日：2005-12-20

申请号：US09715552

申请日：2000-11-17

申请人： Bhaskar Ghosh ,  Benoit Dageville

发明人： Bhaskar Ghosh ,  Benoit Dageville

IPC分类号： G06F9/46

CPC分类号： G06F17/30486 ,  Y10S707/99937

摘要： Techniques are provided for evenly distributing data items of a particular set of data to a plurality of buckets. The buckets of data items may then be assigned to processes to perform operations on the data items in parallel with the other processes. In one embodiment, the set of data (which may come from tables or be the result set of a previous operation) is divided into a plurality of subsets. For each subset of the plurality of subsets, a sample of data items is randomly selected. The sampling itself may be performed in parallel, with each sampling process using a different seed to randomize its selection of samples. The sampled data items are sorted and ranges are determined based on distribution keys of the sampled data items. The ranges are assigned to buckets, and the data items are then distributed to the buckets assigned to the range into which their distribution key falls.

摘要翻译： 提供了用于将特定数据集合的数据项均匀分配到多个桶的技术。 然后可以将数据桶的桶分配给与其他处理并行地对数据项执行操作的处理。 在一个实施例中，数据集（其可以来自表格或作为先前操作的结果集）被分成多个子集。 对于多个子集的每个子集，随机选择数据项的样本。 采样本身可以并行执行，每个采样过程使用不同的种子随机选择样品。 对取样的数据项进行排序，并根据采样数据项的分配密钥确定范围。 范围被分配给桶，然后将数据项分配给分配给它们的分配密钥落入的范围的桶。

公开(公告)号：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.

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

公开(公告)号：US07475056B2

公开(公告)日：2009-01-06

申请号：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.

摘要翻译： 在多服务器系统中处理数据库语句，以增加从属服务器在远程节点上处理的可能性将生成与查询协调器进程生成的相应执行计划相等的执行计划。 基于主计划所基于的相同信息生成一组提示。 一组提示被发送到远程节点，其中基于一组提示部分地生成相应的远程计划。 使用提示生成远程计划会增加远程计划等同于主计划的可能性，并且其他数据库服务器上的从站将能够并行处理数据库语句。

公开(公告)号：US20050132383A1

公开(公告)日：2005-06-16

申请号：US10824887

申请日：2004-04-13

申请人： Bhaskar Ghosh ,  Thierry Cruanes ,  Benoit Dageville ,  Rushan Chen

发明人： Bhaskar Ghosh ,  Thierry Cruanes ,  Benoit Dageville ,  Rushan Chen

IPC分类号： G06F7/00 ,  G06F17/30

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分别设置游标，这些技术涉及共享从原始语句生成的游标， 并行执行原始语句中指定的操作。

公开(公告)号：US20050131881A1

公开(公告)日：2005-06-16

申请号：US10944175

申请日：2004-09-16

申请人： Bhaskar Ghosh ,  Thierry Cruanes ,  Benoit Dageville

发明人： Bhaskar Ghosh ,  Thierry Cruanes ,  Benoit Dageville

IPC分类号： G06F7/00 ,  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的技术以与每个从属单元通信以执行执行计划以及何时执行计划的哪些部分。 还提供了在查询协调器的控制下从属执行的状态转换引擎。