Table creation for partitioned tables

摘要

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.

主权项

1. A computer program product comprising a non-transitory machine-readable storage medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
receiving a table creation request pertaining to a created table in a database maintained on a multi-node data partitioning landscape that comprises a master node and a plurality of processing nodes, the plurality of processing nodes being controlled by the master node, the table creation request comprising a parameter specifying a number of partitions to be generated for the created table; querying a database controller for a currently available number of available processing nodes in the multi-node data partitioning landscape; comparing the currently available number of available processing nodes with the specified number of partitions to be generated for the created table; generating a plurality of data partitions for the created table according to the specified number of partitions, the generating further comprising: locating the generated plurality of data partitions across the available processing nodes according to a predetermined data load balancing partitioning specification to maximize even distribution of data in the created table if the currently available number of available processing nodes equals the specified number of partitions to be generated, and locating the generated plurality of data partitions across the available processing nodes according to other information in the table request creation if the currently available number of available processing nodes does not equal the specified number of partitions to be generated, the other information comprising semantic information regarding relationships between data in the generated plurality of data partitions and data in data partitions of at least one other table in the database, the locating according to the other information resulting in semantically related partitions of at least two tables in the database being collocated together, such that respective first data partitions of first and second tables in the database are located on a first of the currently available processing nodes, and respective second data partitions of the first and second tables are located on a second of the currently plurality of processing nodes; and storing partitioning information and mapping information associating each generated data partition of the generated plurality of data partitions in a metadata repository accessible to the master node and the plurality of processing nodes.