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

1. 发明授权

US09830346B2 Table redistribution in distributed databases 有权
公开(公告)号：US09830346B2
公开(公告)日：2017-11-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.

2. 发明申请

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

3. 发明授权

US09372907B2 Table placement in distributed databases 有权
标题翻译：分布式数据库中的表放置
公开(公告)号：US09372907B2
公开(公告)日：2016-06-21
申请号：US14090799
申请日：2013-11-26
申请人： Hans-Joerg Leu , Christian Bensberg , Johannes Beigel , Jochen Becker , Carsten Mueller
发明人： Hans-Joerg Leu , Christian Bensberg , Johannes Beigel , Jochen Becker , Carsten Mueller
IPC分类号： G06F17/30
CPC分类号： G06F17/30486 , G06F17/30371 , G06F17/30575
摘要： A node type of a plurality of distributed nodes to which a table to be added to a distributed database should be assigned can be identified by applying a set of placement rules defined for the table. The set of placement rules can also be applied to determine whether the table should be partitioned into more than one partition. A table group name associated with the table can be obtained and used in conjunction with the node type and determination of whether to partition the table to store the table in the distributed database on at least one node of the plurality of nodes as one or more partitions.
摘要翻译：可以通过应用为表定义的一组放置规则来识别要分配要添加到分布式数据库的表的多个分布式节点的节点类型。还可以应用这套放置规则来确定表是否应该被分割成多个分区。可以获得与表相关联的表组名称，并与节点类型一起使用并确定是否划分表以将表在多个节点中的至少一个节点上存储在分布式数据库中作为一个或多个分区。

4. 发明申请

US20150149509A1 TABLE PLACEMENT IN DISTRIBUTED DATABASES 有权
标题翻译：分布式数据库中的表格
公开(公告)号：US20150149509A1
公开(公告)日：2015-05-28
申请号：US14090799
申请日：2013-11-26
申请人： Hans-Joerg Leu , Christian Bensberg , Johannes Beigel , Jochen Becker , Carsten Mueller
发明人： Hans-Joerg Leu , Christian Bensberg , Johannes Beigel , Jochen Becker , Carsten Mueller
IPC分类号： G06F17/30
CPC分类号： G06F17/30486 , G06F17/30371 , G06F17/30575
摘要： A node type of a plurality of distributed nodes to which a table to be added to a distributed database should be assigned can be identified by applying a set of placement rules defined for the table. The set of placement rules can also be applied to determine whether the table should be partitioned into more than one partition. A table group name associated with the table can be obtained and used in conjunction with the node type and determination of whether to partition the table to store the table in the distributed database on at least one node of the plurality of nodes as one or more partitions.
摘要翻译：可以通过应用为表定义的一组放置规则来识别要分配要添加到分布式数据库的表的多个分布式节点的节点类型。还可以应用这套放置规则来确定表是否应该被分割成多个分区。可以获得与表相关联的表组名称，并与节点类型一起使用并确定是否划分表以将表在多个节点中的至少一个节点上存储在分布式数据库中作为一个或多个分区。

5. 发明授权

US09223829B2 Interdistinct operator 有权
标题翻译：区分运算符
公开(公告)号：US09223829B2
公开(公告)日：2015-12-29
申请号：US12982767
申请日：2010-12-30
申请人： Franz Faerber , Christian Bensberg , Lars Fricke
发明人： Franz Faerber , Christian Bensberg , Lars Fricke
IPC分类号： G06F17/30
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.
摘要翻译：公开了一种用于在并行计算环境的共享存储器的多个表上执行不同操作的计算机实现的系统和方法。在多个表的每个表上执行不同的操作，每个不同的操作消除来自每个表的重复数据，执行创建表对和不同结果的层次，不同的结果包括每个表的减少的行集合。检测每个缩小的行集上的复制以完成多个表上的不同操作。

6. 发明申请

US20150242400A1 Database Table Re-Partitioning Using Trigger-Based Capture and Replay 审中-公开
标题翻译：使用基于触发的捕获和重放的数据库表重新分区
公开(公告)号：US20150242400A1
公开(公告)日：2015-08-27
申请号：US14188543
申请日：2014-02-24
申请人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
发明人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
IPC分类号： G06F17/30
CPC分类号： G06F17/30339
摘要： Partitioning of a source table of a database to a target table is initiated. Thereafter, a replay table is generated that is populated with triggers for database operations performed on the source table for subsequent replay for the target partitions. Data is later moved (e.g., asynchronously moved, etc.) from the source table to the target table. The database operations are replayed on the target table T subsequent to the moving of the data using the replay table. In addition, the source table is dropped when all of the data has been moved to the target table and there are no operations requiring replay. Related apparatus, systems, techniques and articles are also described.
摘要翻译：启动将数据库的源表分区到目标表。此后，生成重播表，其中填充有用于在源表上执行的数据库操作的触发器，用于目标分区的后续重放。数据稍后从源表移动到目标表（例如异步移动等）。在使用重放表移动数据之后，在目标表T上重播数据库操作。此外，当所有数据已被移动到目标表并且没有需要重放的操作时，源表被删除。还描述了相关设备，系统，技术和物品。

7. 发明授权

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

8. 发明授权

US10146834B2 Split processing paths for a database calculation engine 有权
公开(公告)号：US10146834B2
公开(公告)日：2018-12-04
申请号：US14518593
申请日：2014-10-20
申请人： Daniel Baeumges , Christian Bensberg , Lars Fricke
发明人： Daniel Baeumges , Christian Bensberg , Lars Fricke
IPC分类号： G06F17/30
摘要： 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.

9. 发明授权

US10055440B2 Database table re-partitioning using trigger-based capture and replay 有权
公开(公告)号：US10055440B2
公开(公告)日：2018-08-21
申请号：US14188543
申请日：2014-02-24
申请人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
发明人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
IPC分类号： G06F17/30
CPC分类号： G06F16/2282
摘要： Partitioning of a source table of a database to a target table is initiated. Thereafter, a replay table is generated that is populated with triggers for database operations performed on the source table for subsequent replay for the target partitions. Data is later moved (e.g., asynchronously moved, etc.) from the source table to the target table. The database operations are replayed on the target table T subsequent to the moving of the data using the replay table. In addition, the source table is dropped when all of the data has been moved to the target table and there are no operations requiring replay. Related apparatus, systems, techniques and articles are also described.

10. 发明授权

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

热门服务

关于我们

友情链接

联系方式