Database expansion method and device and readable medium

Abstract

The invention discloses a database expansion method and device and a readable medium, and the method comprises the steps: obtaining a to-be-applied virtual card identifier after receiving a virtual card number application request; if it is determined that the virtual card number is not allocated to the virtual card represented by the virtual card identifier in history, allocating a virtual card number to the virtual card represented by the virtual card identifier; determining district information and a data table identifier for storing the virtual card number detail information for the distributed virtual card numbers according to the use frequency of a data table in the card data storage control table; and storing the virtual card number detail information into a data table correspondingto the data table identifier in a district data information base corresponding to the district information. By the adoption of the method, capacity expansion processing of the database is effectivelyachieved under the condition that data transfer is not needed.

Description

technical field [0001] The present invention relates to the technical field of business support, in particular to a database expansion method, device and readable medium. Background technique [0002] In the process of business promotion, there will be a phenomenon of issuing a large number of virtual cards for long-term use, and a large number of virtual cards need to be recorded in the database, so there is a high requirement for the storage capacity of the database. [0003] In order to improve the storage capacity of the database, in the existing database expansion schemes, it is inevitable to transplant the data, for example, by reserving the data table to be expanded to perform the whole table transplantation, or combining the fragmented fields with the non-fragmented The fields are stored in the main database and the standby database respectively. When expanding, the existing database is expanded based on the exponential multiple of 2, so as to facilitate the smooth p...

AI Technical Summary

Problems solved by technology

[0003] In order to improve the storage capacity of the database, in the existing database expansion scheme, it is inevitable to transplant the data, for example, by reserving the data table to be expanded to perform the whole table transplantation, or combining the fragmented fields with the non-fragmented The fields are stored in the main database and the standby database respectively. When expanding the capacity, the existing database is expanded based on the exponential multiple of 2, so as to facilitate the smooth progress of data migration. That is to say, the existing technology generally focuses on reducing the complexity of data migration during migration. , but there is still the problem of data migration

Images