Database table partitioning method and device, computer equipment and storage medium

Abstract

The invention discloses a database table partitioning method and device, computer equipment and a storage medium. The method comprises the steps of obtaining a first data index used for establishing amain partition in a database table and a first quantity of the first data index; analyzing a preset code list associated with the first data index to obtain an analysis result, and extracting an index code from the analysis result; establishing a first number of main partitions in the database table, associating the main partitions with the first data indexes in a one-to-one correspondence manner, and establishing a first sub-partition under the main partitions in the database table; establishing a second sub-partition under the first sub-partition; and in one main partition, sequentially splicing the second sub-partitions to the main partition according to the sequence of the establishment time of the second sub-partitions in the main partition to obtain a partitioned database table. According to the invention, data partitioning can be carried out on the database table, and the overall data processing capability of the database table is improved.

Description

technical field [0001] The present invention relates to the field of data storage, in particular to a database table partition method, device, computer equipment and storage medium. Background technique [0002] At present, the operation and implementation of many projects need to use a large amount of data in the fact table, and the data in the fact table is constantly increasing dynamically. At this time, a good storage method is needed to store the above-mentioned data in a classified manner. At present, Oracle provides the function of automatically creating partitions for the above-mentioned fact table, which can automatically expand the partition by day, that is, a partition with day as the partition unit will be automatically created every day, but the above-mentioned solution of Oracle has the following defects: First, the establishment of partitions There will be a lot of scripting languages, which will make it difficult for technicians to sort out; second, the name ...

AI Technical Summary

Problems solved by technology

At present, Oracle provides the function of automatically creating partitions for the above-mentioned fact table, which can automatically expand the partition by day, that is, a partition with day as the partition unit will be automatically created every day, but the above-mentioned solution of Oracle has the following defects: First, the establishment of partitions There will be a lot of scripting languages, which will make it difficult for technicians to sort out; second, the name of the partition is fixed, and you cannot specify a partition name with special meaning, which is inconvenient to identify and understand; third, it does not support composite partitions, resulting in Data scalability is poor

Images