TABLE PLACEMENT IN DISTRIBUTED DATABASES

摘要

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.

主权项

1. A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
identifying a node type of a plurality of distributed nodes to which a table to be added to a distributed database should be assigned, the identifying comprising applying a set of placement rules defined for the table, the distributed database comprising a plurality of tables located on the plurality of distributed nodes; determining whether the table should be partitioned into more than one partition, the determining comprising applying the set of placement rules; obtaining a table group name associated with the table; and storing the table in the distributed database on at least one node of the plurality of nodes as one or more partitions according to the identified node type, the determining of whether to partition the table, and the obtained group name.