Data partitioning method for data routing

Abstract

The invention discloses a data partitioning method for data routing. The method comprises the following steps: generating a corresponding user unique identifier through a user service number, and using the user unique identificer for identifying a database where corresponding data is located and a data partition through employing different segmented sequences; storing the corresponding data in thecorresponding database and data partition according to the user service number or the user unique identifier; and in the data routing process, according to the user service number or the user uniqueidentifier carried in the routing value, calculating to obtain the database and the data partition where the corresponding data is located. According to the technical scheme, the corresponding database and data partition can be obtained through calculation without conversion, so the data routing speed is increased, the data of the same city can be further routed to the data instances of differentdata partitions, and the problem that the database instances are unbalanced is solved.

Description

technical field [0001] The invention relates to the technical field of data routing, in particular to a data partitioning method for data routing. Background technique [0002] The commonly used data partitioning algorithms are as follows: [0003] 1. Partition by range, the partition field is generally an integer. [0004] 2. Partition according to the enumeration value, each enumeration value is an independent partition. [0005] 3. Partition according to hash, do hash for a certain field, and then partition according to the enumeration value obtained by hash. [0006] With the development of business and technology, a certain partition or routing technology alone cannot meet the needs of the business. Here is a mobile business scenario: [0007] Generally, a mobile province is an independent system, and due to factors such as the population and business development of various cities, the amount of business carried out is uneven. Generally, the economy of the provincial...

AI Technical Summary

Problems solved by technology

[0012] Aiming at at least one of the above problems, the present invention provides a data partition method for data routing, by using the user service number to generate a corresponding user unique identifier to identify the database and data partition where the corresponding data is located, Therefore, in the process of data routing, according to the user's unique identifier or user service number carried by the routing value, the corresponding database and data partition can be calculated without conversion, which speeds up the data routing speed, and furthermore, the data of the same city can be routed to different The data instance of the data partition solves the problem of unbalanced database instances

Images