Database splitting method and device

Abstract

The invention discloses a database splitting method and device, which can be used in the technical field of big data, and the method comprises the following steps: receiving first data information; determining a self-increasing primary key corresponding to the service primary key of the first data information according to the service primary key of the first data information and a mapping relationship between the service primary key and the self-increasing primary key; according to a self-increasing primary key corresponding to a service primary key of the first data information and a mapping relationship between the self-increasing primary key and a sub-library and sub-table rule, determining a database position corresponding to the self-increasing primary key corresponding to the service primary key of the first data information; and storing the first data information into a database position corresponding to the self-increasing primary key corresponding to the service primary key of the first data information. When newly added data information needs to be stored into the table, the original data information does not need to be redistributed, the newly added data information is distributed to the corresponding database table in a self-increasing mode, the database table dividing efficiency can be improved, and the processing flow can be simplified.

Description

technical field [0001] The invention relates to the technical field of big data, in particular to a method and a device for database and table subdivision. Background technique [0002] This section is intended to provide a background or context to embodiments of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] In real life, the amount of data in the database is not necessarily controllable. When the database is not divided into databases and tables, as time grows and the system business volume continues to grow, the tables in the database will become more and more The more, the larger the amount of data in the table, and correspondingly, the overhead of data manipulation, addition, deletion, modification and query will also increase; moreover, the resources of the server are limited, and ultimately the amount of data carried by the database, Data processing capabilities will encou...

AI Technical Summary

Problems solved by technology

The existing database sub-table and sub-library schemes have two schemes: vertical segmentation and horizontal segmentation. When new data needs to be stored in the table, both the original data and the new data need to be redistributed, and the corresponding data will be allocated to the corresponding database. table, the processing process is complicated, the processing efficiency is very low, and a lot of manpower and material resources are consumed

Images