OPTIMIZATION OF A PLURALITY OF TABLE PROCESSING OPERATIONS IN A MASSIVE PARALLEL PROCESSING ENVIRONMENT

摘要

A computer-implemented method for partitioning data for a query operation of one table of the database system is provided. The computer-implemented method comprises estimating a value distribution of the attribute in the result table based on a first value distribution of the attribute in the first column of the first table. The computer-implemented method further comprises determining boundaries for partitioning ranges of the attribute, based on the estimated value distribution, wherein the partitioning ranges correspond to a same number of rows of the result table. The computer-implemented method further comprises partitioning the first table with processing nodes of the query operation, based on the determined boundaries of partitioning ranges.

主权项

1. A computer-implemented method for partitioning data for a query operation in a database system, the query operation involving a first table having an attribute in a first column and resulting in a result table, the computer-implemented method comprising:
estimating a value distribution of the attribute in the result table based on a first value distribution of the attribute in the first column of the first table;
determining boundaries for partitioning ranges of the attribute, based on the estimated value distribution, wherein the partitioning ranges correspond to a same number of rows of the result table; andpartitioning the first table with processing nodes of the query operation, based on the determined boundaries of partitioning ranges.