Method and device for establishing data table, and electronic equipment

Abstract

The invention provides a method and a device for establishing a data table, and electronic equipment. The method comprises the following steps: creating at least one first-level partition of a target data table according to a preset first-level partition dimension; for each first-level partition, obtaining a preset second-level partition dimension of the first-level partition, and creating at least one second-level partition on the first-level partition based on the second-level partition dimension, wherein if the number of the first-level partitions is multiple, the second-level partition dimensions preset by all the first-level partitions are different; and based on the at least one first-level partition and the second-level partition corresponding to each first-level partition, establishing the target data table. In the mode, when the data table is established, the second-level partition processing of different partition dimensions is performed for each created first-level partition, so that the second-level partition corresponding to each first-level partition can store the data based on different data dimensions, the partition mode of the multi-level partitions is flexible, the business requirements that the data is richer and more complex are met, and the use feeling of the user is improved.

Description

Technical field [0001] Technical Field The present invention relates to databases, in particular, it relates to a method for establishing a data table, device and electronic equipment. Background technique [0002] Distributed Database partition table refers generally, in accordance with certain rules database and a table is split into a plurality of different partitions, each partition physical storage, so that the data table may store more data, It also can improve the efficiency of data queries. In the related art, most of the data table distributed database support fixed dimension split multi-stage resolution, e.g., below a partition using the same split two dimensions to obtain a plurality of partitions, for example, range partitioning mode using creating a plurality of partitions, split two ways to create a plurality of partitions for each of the two partition using a hash partitioning. But with the development of business, data needs to be stored will be more abundant, the...

AI Technical Summary

Problems solved by technology

However, with the development of business, the data that needs to be stored will become more abundant. This splitting method usually cannot meet the business needs of more abundant data, which will affect the user's use.

Images