公开(公告)号：US20210232586A1

公开(公告)日：2021-07-29

申请号：US17207512

申请日：2021-03-19

Applicant: SAP SE

Inventor： Hans-Joerg Leu ,  Christian Bensberg ,  Johannes Beigel ,  Jochen Becker ,  Carsten Mueller

IPC: G06F16/2455 ,  G06F16/27 ,  G06F16/23

Abstract: 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.

公开(公告)号：US10984002B2

公开(公告)日：2021-04-20

申请号：US16245520

申请日：2019-01-11

Applicant: SAP SE

Inventor： Hans-Joerg Leu ,  Christian Bensberg ,  Johannes Beigel ,  Jochen Becker ,  Carsten Mueller

IPC: G06F16/2455 ,  G06F16/27 ,  G06F16/23

Abstract: 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.

公开(公告)号：US20190146972A1

公开(公告)日：2019-05-16

申请号：US16245520

申请日：2019-01-11

Applicant: SAP SE

Inventor： Hans-Joerg Leu ,  Christian Bensberg ,  Johannes Beigel ,  Jochen Becker ,  Carsten Mueller

IPC: G06F16/2455 ,  G06F16/27 ,  G06F16/23

Abstract: 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.

公开(公告)号：US09639567B2

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

申请号：US15164335

申请日：2016-05-25

Applicant: SAP SE

Inventor： Yong Sik Lee ,  Jaeyoung Choi ,  Jin Young Kook ,  Jochen Becker ,  Alexander Boehm

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/3033 ,  G06F17/30424 ,  G06F17/30486 ,  G06F17/30498 ,  G06F17/3056

Abstract: A system includes determination of a value identifier for each value of a first table, based on a data dictionary of a second table, generation of a hash function, the hash function mapping, for each row of the first table, one or more value identifiers of one or more columns of the row to a pointer to the row, application of the hash function to one or more value identifiers of a row of a second table, determination of whether the output of the hash function is a valid hash, and, if it is determined that the output of the hash function is a valid hash, determination that the row of the second table is associated with the first table.

公开(公告)号：US20160267084A1

公开(公告)日：2016-09-15

申请号：US15164335

申请日：2016-05-25

Applicant: SAP SE

Inventor： Yong Sik Lee ,  Jaeyoung Choi ,  Jin Young Kook ,  Jochen Becker ,  Alexander Boehm

IPC: G06F17/30

CPC classification number: G06F17/3033 ,  G06F17/30424 ,  G06F17/30486 ,  G06F17/30498 ,  G06F17/3056

Abstract: A system includes determination of a value identifier for each value of a first table, based on a data dictionary of a second table, generation of a hash function, the hash function mapping, for each row of the first table, one or more value identifiers of one or more columns of the row to a pointer to the row, application of the hash function to one or more value identifiers of a row of a second table, determination of whether the output of the hash function is a valid hash, and, if it is determined that the output of the hash function is a valid hash, determination that the row of the second table is associated with the first table.

公开(公告)号：US11550791B2

公开(公告)日：2023-01-10

申请号：US17207512

申请日：2021-03-19

Applicant: SAP SE

Inventor： Hans-Joerg Leu ,  Christian Bensberg ,  Johannes Beigel ,  Jochen Becker ,  Carsten Mueller

IPC: G06F16/2455 ,  G06F16/27 ,  G06F16/23

Abstract: 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.

公开(公告)号：US10223420B2

公开(公告)日：2019-03-05

申请号：US15160771

申请日：2016-05-20

Applicant: SAP SE

Inventor： Hans-Joerg Leu ,  Christian Bensberg ,  Johannes Beigel ,  Jochen Becker ,  Carsten Mueller

IPC: G06F17/30

Abstract: 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.

公开(公告)号：US20160267141A1

公开(公告)日：2016-09-15

申请号：US15160771

申请日：2016-05-20

Applicant: SAP SE

Inventor： Hans-Joerg Leu ,  Christian Bensberg ,  Johannes Beigel ,  Jochen Becker ,  Carsten Mueller

IPC: G06F17/30

CPC classification number: G06F17/30486 ,  G06F17/30371 ,  G06F17/30575

Abstract: 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.

Abstract translation: 可以通过应用为表定义的一组放置规则来识别要分配要添加到分布式数据库的表的多个分布式节点的节点类型。 还可以应用这套放置规则来确定表是否应该被分割成多个分区。 可以获得与表相关联的表组名称，并与节点类型一起使用并确定是否划分表以将表在多个节点中的至少一个节点上存储在分布式数据库中作为一个或多个分区 。