公开(公告)号：US20140258300A1

公开(公告)日：2014-09-11

申请号：US14283772

申请日：2014-05-21

申请人： Daniel Baeumges ,  Lars Fricke ,  Christian Bensberg

发明人： Daniel Baeumges ,  Lars Fricke ,  Christian Bensberg

IPC分类号： G06F17/30

CPC分类号： G06F17/30598 ,  G06F17/30091 ,  G06F17/30194 ,  G06F17/30221 ,  G06F17/30339 ,  G06F17/30345

摘要： A recipient node of a multi-node data partitioning landscape can receive, directly from a requesting machine without being handled by a master node, a first data request related to a table. A target node of a plurality of processing nodes can be identified to handle the data request. The determining can include the recipient node applying partitioning information to determine a target data partition of the plurality of data partitions to which the data request should be directed and mapping information associating each data partition of the plurality of data partitions with an assigned node of the plurality of processing nodes. The recipient node can redirect the data request to the target node so that the target node can act on the target data partition in response to the data request.

摘要翻译： 多节点数据分区场景的接收节点可以直接从请求机器接收不被主节点处理与表相关的第一数据请求。 可以识别多个处理节点的目标节点来处理数据请求。 确定可以包括接收节点应用分区信息以确定数据请求应针对的多个数据分区的目标数据分区，并且将多个数据分区的每个数据分区与多个数据分配的分配节点相关联的映射信息 的处理节点。 接收方节点可以将数据请求重定向到目标节点，以便目标节点可以响应于数据请求而对目标数据分区进行动作。

公开(公告)号：US09977796B2

公开(公告)日：2018-05-22

申请号：US14453470

申请日：2014-08-06

申请人： Lars Fricke ,  Christian Bensberg

发明人： Lars Fricke ,  Christian Bensberg

IPC分类号： G06F17/30

CPC分类号： G06F17/30292 ,  G06F17/30312 ,  G06F17/30339 ,  G06F17/30501 ,  G06F17/30522 ,  G06F17/30584

摘要： A table creation request pertaining to a table in a database maintained on a multi-node data partitioning landscape that comprises a plurality of processing nodes can specify a number of partitions to be generated. At run time, a currently available number of processing nodes in the multi-node data partitioning landscape can be queried, and this currently available number of processing nodes can be compared with the specified number of partitions to be generated for the created table. The table can be generated with the specified number of partitions such that the generated partitions are located across the plurality of partitions according to a load balancing approach if the number of processing nodes equals the number of partitions to be generated or according to other information in the table request if the number of processing nodes does not equal the specified number of partitions.

公开(公告)号：US09779155B2

公开(公告)日：2017-10-03

申请号：US14283772

申请日：2014-05-21

申请人： Daniel Baeumges ,  Lars Fricke ,  Christian Bensberg

发明人： Daniel Baeumges ,  Lars Fricke ,  Christian Bensberg

IPC分类号： G06F17/30

CPC分类号： G06F17/30598 ,  G06F17/30091 ,  G06F17/30194 ,  G06F17/30221 ,  G06F17/30339 ,  G06F17/30345

摘要： A recipient node of a multi-node data partitioning landscape can receive, directly from a requesting machine without being handled by a master node, a first data request related to a table. A target node of a plurality of processing nodes can be identified to handle the data request. The determining can include the recipient node applying partitioning information to determine a target data partition of the plurality of data partitions to which the data request should be directed and mapping information associating each data partition of the plurality of data partitions with an assigned node of the plurality of processing nodes. The recipient node can redirect the data request to the target node so that the target node can act on the target data partition in response to the data request.

公开(公告)号：US20150149513A1

公开(公告)日：2015-05-28

申请号：US14090783

申请日：2013-11-26

申请人： Johannes Beigel ,  Christian Bensberg ,  Hans-Joerg Leu ,  Lars Fricke

发明人： Johannes Beigel ,  Christian Bensberg ,  Hans-Joerg Leu ,  Lars Fricke

IPC分类号： G06F17/30

CPC分类号： G06F17/30339

摘要： Tables in a distributed database can require redistribution, for example to provide improved collocation of tables or table partitions that require joining at a node of multiple nodes across which the distributed database is distributed. Based at least in part on a set of table redistribution parameters, a table redistribution plan can be generated to include redistribution of a table from a first node to a second node. The set of table redistribution parameters can include a grouping parameter indicating at least one other table with which the table should be collocated. The table redistribution plan can be executed to cause the moving of the table from the first node to the second node.

摘要翻译： 分布式数据库中的表可能需要重新分配，例如提供需要在分布式数据库分布的多个节点的节点上加入的表或表分区的改进的并置。 至少部分地基于一组表重新分配参数，可以生成表重新分发计划以包括将表从第一节点重新分配到第二节点。 该表再分配参数的集合可以包括指示至少一个其他表的分组参数，该表应与其并置。 可以执行表再分配计划以使表从第一节点移动到第二节点。

公开(公告)号：US20130166589A1

公开(公告)日：2013-06-27

申请号：US13336935

申请日：2011-12-23

申请人： Daniel Baeumges ,  Christian Bensberg ,  Lars Fricke

发明人： Daniel Baeumges ,  Christian Bensberg ,  Lars Fricke

IPC分类号： G06F17/30

CPC分类号： G06F17/30486 ,  G06F17/30424 ,  G06F17/30445 ,  G06F17/30451 ,  G06F17/30463 ,  G06F17/30477 ,  G06F17/30522

摘要： A dynamic split node defined within a calculation model can receive data being operated on by a calculation plan generated based on the calculation model. A partition specification can be applied to one or more reference columns in a table containing at least some of the received data. The applying can cause the table to be split such that a plurality of records in the table are partitioned according to the partition specification. A separate processing path can be set for each partition, and execution of the calculation plan can continue using the separate processing paths, each of which can be assigned to a processing node of a plurality of available processing nodes.

公开(公告)号：US20130159659A1

公开(公告)日：2013-06-20

申请号：US13330584

申请日：2011-12-19

申请人： Boris Gelman ,  Hualin Wang ,  Daniel Baeumges ,  Lars Fricke ,  Christian Bensberg

发明人： Boris Gelman ,  Hualin Wang ,  Daniel Baeumges ,  Lars Fricke ,  Christian Bensberg

IPC分类号： G06F12/00

CPC分类号： G06F16/278

摘要： Based on one or more first columns of a table partitioned at a first level over multiple first level partitions, a first partition criteria is evaluated for a data record. Each of the at least first level partitions is further partitioned into a same number of second-level partitions using a same second partitioning method for all first level partitions. One first level partition is identified for storage of the data record, for example by determining the one of the at least two data server processes using the first partition criteria and a first partitioning method that differs from the second partitioning method. Based on one or more second columns of the table, a second partition criteria is evaluated for the data record, and the data record is stored in one of the second-level partitions of the at least two first level partitions.

摘要翻译： 基于在多个第一级分区上在第一级分割的表的一个或多个第一列，针对数据记录评估第一分区标准。 所述至少一级分区中的每一个进一步被划分为相同数目的第二级分区，使用与所有第一级分区相同的第二分区方法。 识别用于存储数据记录的一个第一级分区，例如通过使用第一分区标准确定至少两个数据服务器进程之一，以及与第二分区方法不同的第一分区方法。 基于表的一个或多个第二列，针对数据记录评估第二分区准则，并且将数据记录存储在至少两个第一级分区的二级分区之一中。

公开(公告)号：US20130159265A1

公开(公告)日：2013-06-20

申请号：US13332215

申请日：2011-12-20

申请人： Thomas Peh ,  Wolfgang Stephan ,  Andreas Tonder ,  Lars Fricke ,  Christian Bensberg

发明人： Thomas Peh ,  Wolfgang Stephan ,  Andreas Tonder ,  Lars Fricke ,  Christian Bensberg

IPC分类号： G06F17/30

CPC分类号： G06F17/30584

摘要： An insertion of a record into a table that includes a primary key column and a second column that includes a global uniqueness constraint across all of a plurality of data partitions across which the table is split is initiated without checking that a value of the record in the second column is globally unique by contacting other partitions the one partition to which the record is to be added to. The insertion can be processed, at least in part by implementing a write lock on the one partition but without implementing a read lock on the other partitions. The write lock on the one partition can be released after the insertion is completed, after which the validity of the insertion can be verified, for example by examining the other parts and a delta partition corresponding to the table. The insertion can be undone if the insertion was not valid.

摘要翻译： 将记录插入到包括主键列和第二列的表中，该主列和第二列包括横跨所述表被分割的多个数据分区的全部唯一性约束，而不检查该表中的记录的值 第二列是全局唯一的，通过联系其他分区，将要添加记录的一个分区。 可以至少部分地通过在一个分区上实现写入锁定而不在其他分区上实现读取锁来处理该插入。 插入完成后，可以释放一个分区上的写锁定，之后可以验证插入的有效性，例如通过检查其他部分和对应于该表的增量分区。 如果插入无效，插入可以撤消。

公开(公告)号：US20150039588A1

公开(公告)日：2015-02-05

申请号：US14518593

申请日：2014-10-20

申请人： Daniel Baeumges ,  Christian Bensberg ,  Lars Fricke

发明人： Daniel Baeumges ,  Christian Bensberg ,  Lars Fricke

IPC分类号： G06F17/30

CPC分类号： G06F17/30486 ,  G06F17/30424 ,  G06F17/30445 ,  G06F17/30451 ,  G06F17/30463 ,  G06F17/30477 ,  G06F17/30522

摘要： A dynamic split node defined within a calculation model can receive data being operated on by a calculation plan generated based on the calculation model. A partition specification can be applied to one or more reference columns in a table containing at least some of the received data. The applying can cause the table to be split such that a plurality of records in the table are partitioned according to the partition specification. A separate processing path can be set for each partition, and execution of the calculation plan can continue using the separate processing paths, each of which can be assigned to a processing node of a plurality of available processing nodes.

摘要翻译： 在计算模型中定义的动态分割节点可以通过基于计算模型生成的计算计划来接收正在操作的数据。 分区规范可以应用于包含至少一些接收到的数据的表中的一个或多个参考列。 应用可以使表被拆分，使得根据分区规范对表中的多个记录进行分区。 可以为每个分区设置单独的处理路径，并且可以使用单独的处理路径继续执行计算计划，每个处理路径可被分配给多个可用处理节点的处理节点。

公开(公告)号：US08880565B2

公开(公告)日：2014-11-04

申请号：US13336942

申请日：2011-12-23

申请人： Lars Fricke ,  Christian Bensberg

发明人： Lars Fricke ,  Christian Bensberg

IPC分类号： G06F17/30

CPC分类号： G06F17/30292 ,  G06F17/30312 ,  G06F17/30339 ,  G06F17/30501 ,  G06F17/30522 ,  G06F17/30584

摘要： A table creation request pertaining to a table in a database maintained on a multi-node data partitioning landscape that comprises a plurality of processing nodes can specify a number of partitions to be generated. At run time, a currently available number of processing nodes in the multi-node data partitioning landscape can be queried, and this currently available number of processing nodes can be compared with the specified number of partitions to be generated for the created table. The table can be generated with the specified number of partitions such that the generated partitions are located across the plurality of partitions according to a load balancing approach if the number of processing nodes equals the number of partitions to be generated or according to other information in the table request if the number of processing nodes does not equal the specified number of partitions.

摘要翻译： 与维护在包含多个处理节点的多节点数据划分区域上的数据库中的表相关联的表创建请求可以指定要生成的分区的数量。 在运行时，可以查询多节点数据分区场景中当前可用数量的处理节点，并将此当前可用数量的处理节点与要为创建的表生成的指定数量的分区进行比较。 如果处理节点的数量等于要生成的分区的数量，或者根据其中的其他信息，则可以使用指定数量的分区生成表，使得生成的分区根据负载平衡方法位于多个分区之间 表请求如果处理节点的数量不等于指定的分区数。

公开(公告)号：US08868594B2

公开(公告)日：2014-10-21

申请号：US13336935

申请日：2011-12-23

申请人： Daniel Baeumges ,  Christian Bensberg ,  Lars Fricke

发明人： Daniel Baeumges ,  Christian Bensberg ,  Lars Fricke

IPC分类号： G06F17/30

CPC分类号： G06F17/30486 ,  G06F17/30424 ,  G06F17/30445 ,  G06F17/30451 ,  G06F17/30463 ,  G06F17/30477 ,  G06F17/30522

摘要： A dynamic split node defined within a calculation model can receive data being operated on by a calculation plan generated based on the calculation model. A partition specification can be applied to one or more reference columns in a table containing at least some of the received data. The applying can cause the table to be split such that a plurality of records in the table are partitioned according to the partition specification. A separate processing path can be set for each partition, and execution of the calculation plan can continue using the separate processing paths, each of which can be assigned to a processing node of a plurality of available processing nodes.

摘要翻译： 在计算模型中定义的动态分割节点可以通过基于计算模型生成的计算计划来接收正在操作的数据。 分区规范可以应用于包含至少一些接收到的数据的表中的一个或多个参考列。 应用可以使表被拆分，使得根据分区规范对表中的多个记录进行分区。 可以为每个分区设置单独的处理路径，并且可以使用单独的处理路径继续执行计算计划，每个处理路径可被分配给多个可用处理节点的处理节点。