Database fragmentation method and device, electronic equipment and readable storage medium

Abstract

The invention discloses a database fragmentation method and device, electronic equipment and a readable storage medium, and belongs to the field of electronic equipment. The method comprises the following steps: firstly, determining a target data table on each node database, and determining a first fragment configuration parameter and a second fragment configuration parameter; performing iterative segmentation on a first interval in the target data table based on a first preset fragmentation strategy to obtain N first alternative fragments; for each first alternative fragment, dividing a second interval in the first alternative fragment according to a second preset fragment strategy to obtain M second alternative fragments; and finally, classifying the N * M second alternative fragments, and determining a target interval in the target data table so as to segment according to the target interval to obtain a target fragment in the node database. In this way, the difference of the data storage amount on each target fragment can be reduced to a certain extent, and then the situation that a machine is blocked when data is read due to the fact that too much data is stored on an individual fragment can be avoided.

Description

technical field [0001] The application belongs to the technical field of electronic equipment, and in particular relates to a database fragmentation method, device, electronic equipment and a readable storage medium. Background technique [0002] With the rapid development of electronic technology and the higher and higher requirements for data storage, it is more and more common to use multi-node databases to store data, and the storage capacity in the database is also increasing. In order to facilitate the management of data stored in the database, the database is often fragmented, that is, each node database contains multiple fragments, and each fragment stores several data. [0003] In the prior art, the method for sharding the database is often to directly perform slicing according to all the data stored in the database, and obtain multiple shards in the database according to the slicing results. However, this segmentation method is relatively simple, so that when read...

AI Technical Summary

Problems solved by technology

However, this segmentation method is relatively simple, so that when reading data on the shards, the time required may be inconsistent, thus affecting the reading efficiency on the database

Images