Database expansion method and device and readable medium

A technology of database and master database, which is applied in database indexing, structured data retrieval, error detection of redundant data in computing, etc., can solve problems such as data transplantation, and achieve the effect of expansion processing

Pending Publication Date: 2019-05-03
CHINA UNIONPAY
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database expansion method and device and readable medium
  • Database expansion method and device and readable medium
  • Database expansion method and device and readable medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The database expansion method, device and readable medium provided by the embodiments of the present invention are used to realize the expansion of the database without data transplantation.

[0035] The preferred embodiments of the present invention will be described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described here are only used to illustrate and explain the present invention, and are not intended to limit the present invention, and in the absence of conflict, the present invention The embodiments and the features in the embodiments can be combined with each other.

[0036] To facilitate understanding of the present invention, in the technical terms involved in the present invention:

[0037] 1. Virtual card is a virtual small card set up under the credit card account. It mainly completes online and other non-face-to-face transaction operations based on the card number, validity period, and verif...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F11/14
Inventor 史桂枝刘宾伍剑钊傅宜生窦逸辛
Owner CHINA UNIONPAY
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products