Method and device for merging and migrating data tables in database

A data table and database technology, applied in the database field, can solve problems such as inability to fully guarantee data accuracy and affect the normal operation and user experience of the database system, and achieve the effect of improving service availability, ensuring normal operation, and improving results

Pending Publication Date: 2021-05-04
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The existing technical solutions cannot fully guarantee the correctness of the data transferred to the new data table. If there is a problem with the data in the new data table, the problem cannot be found and repaired in time because the old data table is removed or the data is no longer updated. , in extreme cases, it may be necessary to re-transfer the data, which will affect the normal operation of the database system and the user experience

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
  • Method and device for merging and migrating data tables in database
  • Method and device for merging and migrating data tables in database
  • Method and device for merging and migrating data tables in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some, not all, embodiments of the application. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0054] The terms "first", "second", "third", "fourth", etc. (if any) in the description and claims of the present invention and the above drawings are used to distinguish similar objects, and not necessarily Used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such that the embodiments of the invention described herein, for example, can be practiced in sequences other than those illustrated or described ...

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 method and device for merging and migrating data tables in a database. The method specifically comprises steps of obtaining the data of at least one first data table in the database, and transferring the data of the at least one first data table to a second data table, the first data table being a migration source data table, and the second data table being a migration target data table; performing write operation verification on the second data table, and respectively writing data acquired from the business layer into the first data table and the second data table; if the write operation verification succeeds, continuing to execute; performing read operation verification on the second data table, reading data from the second data table and feeding back the data to the business layer; if the read operation verification succeeds, deleting the first data table to complete data table merging migration. The method is advantaged in that the effect of verifying the transferred data can be improved, the risk of data problem occurrence is reduced, and service availability of the database is ensured.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for merging and migrating data tables in a database. Background technique [0002] Usually, due to the unreasonable initial design of the data tables in the database, the data of the same business type is stored in different data tables. For example, the data of a certain type of commodity can be stored in the A-type commodity data table and the B-type commodity data respectively. Table, when you need to query a piece of data, you need to traverse and query each data table, that is, both the A-type product data table and the B-type product data table must be queried, so that the system query logic is complicated, and the development and maintenance costs are too high , two consecutive data accesses increase the access pressure of the database, and the network overhead also leads to a decrease in interface response performance, which may affect the normal ope...

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
IPC IPC(8): G06F16/21G06F16/22G06F16/23
CPCG06F16/214G06F16/2282G06F16/2365
Inventor 刘帮
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap