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

11. 发明授权

US08868594B2 Split processing paths for a database calculation engine 有权
标题翻译：分割数据库计算引擎的处理路径
公开(公告)号：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.
摘要翻译：在计算模型中定义的动态分割节点可以通过基于计算模型生成的计算计划来接收正在操作的数据。分区规范可以应用于包含至少一些接收到的数据的表中的一个或多个参考列。应用可以使表被拆分，使得根据分区规范对表中的多个记录进行分区。可以为每个分区设置单独的处理路径，并且可以使用单独的处理路径继续执行计算计划，每个处理路径可被分配给多个可用处理节点的处理节点。

12. 发明申请

US20130166606A1 TABLE CREATION FOR PARTITIONED TABLES 有权
标题翻译：表格分割表
公开(公告)号：US20130166606A1
公开(公告)日：2013-06-27
申请号：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.
摘要翻译：与维护在包含多个处理节点的多节点数据划分区域上的数据库中的表相关联的表创建请求可以指定要生成的分区的数量。在运行时，可以查询多节点数据分区场景中当前可用数量的处理节点，并将此当前可用数量的处理节点与要为创建的表生成的指定数量的分区进行比较。如果处理节点的数量等于要生成的分区的数量，或者根据其中的其他信息，则可以使用指定数量的分区生成表，使得生成的分区根据负载平衡方法位于多个分区之间表请求如果处理节点的数量不等于指定的分区数。

13. 发明申请

US20120011133A1 Interdistinct Operator 有权
标题翻译：区分运算符
公开(公告)号：US20120011133A1
公开(公告)日：2012-01-12
申请号：US12982767
申请日：2010-12-30
申请人： Franz Faerber , Christian Bensberg , Lars Fricke
发明人： Franz Faerber , Christian Bensberg , Lars Fricke
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30466 , G06F17/3033 , G06F17/30445
摘要： A computer-implemented system and method for performing distinct operations on multiple tables of shared memory of parallel computing environments are disclosed. A distinct operation is executed on each table of a plurality of tables, each distinct operation eliminating duplicate data from each table, the executing creating a hierarchy of table pairs and distinct results, the distinct results comprising a reduced row set for each table. Duplicates on each reduced row set are detected to complete the distinct operation on the plurality of tables.
摘要翻译：公开了一种用于在并行计算环境的共享存储器的多个表上执行不同操作的计算机实现的系统和方法。在多个表的每个表上执行不同的操作，每个不同的操作消除来自每个表的重复数据，执行创建表对和不同结果的层次，不同的结果包括每个表的减少的行集合。检测每个缩小的行集上的复制以完成多个表上的不同操作。

14. 发明授权

US09977796B2 Table creation for partitioned tables 有权
公开(公告)号：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.

15. 发明授权

US09779155B2 Independent table nodes in parallelized database environments 有权
公开(公告)号：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.

16. 发明申请

US20150149513A1 TABLE REDISTRIBUTION IN DISTRIBUTED DATABASES 有权
标题翻译：分布式数据库中的表重新分配
公开(公告)号：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.
摘要翻译：分布式数据库中的表可能需要重新分配，例如提供需要在分布式数据库分布的多个节点的节点上加入的表或表分区的改进的并置。至少部分地基于一组表重新分配参数，可以生成表重新分发计划以包括将表从第一节点重新分配到第二节点。该表再分配参数的集合可以包括指示至少一个其他表的分组参数，该表应与其并置。可以执行表再分配计划以使表从第一节点移动到第二节点。

17. 发明申请

US20130166589A1 SPLIT PROCESSING PATHS FOR A DATABASE CALCULATION ENGINE 有权
公开(公告)号：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.

18. 发明申请

US20130159659A1 MULTI-LEVEL DATA PARTITIONING 审中-公开
标题翻译：多级数据分区
公开(公告)号：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.
摘要翻译：基于在多个第一级分区上在第一级分割的表的一个或多个第一列，针对数据记录评估第一分区标准。所述至少一级分区中的每一个进一步被划分为相同数目的第二级分区，使用与所有第一级分区相同的第二分区方法。识别用于存储数据记录的一个第一级分区，例如通过使用第一分区标准确定至少两个数据服务器进程之一，以及与第二分区方法不同的第一分区方法。基于表的一个或多个第二列，针对数据记录评估第二分区准则，并且将数据记录存储在至少两个第一级分区的二级分区之一中。

19. 发明申请

US20130159265A1 Parallel Uniqueness Checks for Partitioned Tables 有权
标题翻译：分区表的并行唯一性检查
公开(公告)号：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.
摘要翻译：将记录插入到包括主键列和第二列的表中，该主列和第二列包括横跨所述表被分割的多个数据分区的全部唯一性约束，而不检查该表中的记录的值第二列是全局唯一的，通过联系其他分区，将要添加记录的一个分区。可以至少部分地通过在一个分区上实现写入锁定而不在其他分区上实现读取锁来处理该插入。插入完成后，可以释放一个分区上的写锁定，之后可以验证插入的有效性，例如通过检查其他部分和对应于该表的增量分区。如果插入无效，插入可以撤消。

20. 发明授权

US10042910B2 Database table re-partitioning using two active partition specifications 有权
公开(公告)号：US10042910B2
公开(公告)日：2018-08-07
申请号：US14188541
申请日：2014-02-24
申请人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
发明人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
IPC分类号： G06F17/30
摘要： Partitioning of source partitions of a table of a database to target partitions is initiated. Thereafter, a transition partition specification is specified that identifies the source partitions and the target partitions. Data is then moved (e.g., asynchronously moved, etc.) from the source partitions to the target partitions. Concurrently with the moving of the data, operates are handled using the transition partition specification. Subsequently, the source partitions are dropped when all of the data has been moved to the target partitions and there are no open transactions accessing the source partitions. Related apparatus, systems, techniques and articles are also described.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式