TABLE REDISTRIBUTION IN DISTRIBUTED DATABASES

摘要

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.

主权项

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:
determining that a redistribution of a plurality of tables is required in a distributed in-memory database, the distributed in-memory database comprising a plurality of tables located on a plurality of distributed nodes; generating, based at least in part on a set of table redistribution parameters, a table redistribution plan comprising redistribution of a table of the plurality of tables, the set of table redistribution parameters comprising a grouping parameter indicating at least one other table with which the table should be collocated; and executing the table redistribution plan, the executing comprising moving the table from a first node of the plurality of distributed nodes to a second node of the plurality of distributed nodes.