Database table structure synchronization method and device, electronic device and storage medium

A technology of database and table structure, applied in the computer field, can solve the problems of hysteresis of investigation, low synchronization efficiency of database table structure, and high error rate, and achieve the effect of accurate generation

Active Publication Date: 2018-09-25
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF5 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

It can be seen that the troubleshooting of database table structure problems in the prior art has a lag
Moreover, due to the need for database operation and maintenance personnel to ma

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 table structure synchronization method and device, electronic device and storage medium
  • Database table structure synchronization method and device, electronic device and storage medium
  • Database table structure synchronization method and device, electronic device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0036] The following describes exemplary embodiments of the present invention with reference to the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and should be regarded as merely exemplary. Therefore, those of ordinary skill in the art should realize that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of the present invention. Likewise, for clarity and conciseness, descriptions of well-known functions and structures are omitted in the following description.

[0037] The inventor of the present invention found that the existing method for synchronizing the database table structure has the following defects: first, the problem of inconsistency in the database table structure may be discovered after adverse effects occur, that is, the discovery of the problem is lagging; second, manual manual Comparing the database table struc...

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 embodiment of the invention provides a database table structure synchronization method and device, an electronic device and a storage medium. Difference comparison results and sql sentences can beautomatically generated according to obtained database table information. The database table structure synchronization method comprises the steps that table structure information of a source databaseand a target database is obtained; according to the table structure information, difference comparison is automatically conducted on the source database and the target database according to the tablestructure information; sql sentences are automatically generated according to according to the difference comparison results. By adopting the above steps, the database table structure synchronizationefficiency of databases can be remarkably improved, and the error rate of sql sentence compiling can be reduced.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a method, device, electronic equipment and storage medium for synchronizing database table structures. Background technique [0002] In the case of e-commerce and other Internet companies using database table structure to store data, the design and modification of database table structure is often a very cumbersome project. In particular, with the increase of warehousing systems, e-commerce companies often make appropriate adjustments to the database table structure due to business needs. Over time, the table structure of the same table in different databases will be quite different, which will bring a lot of inconvenience to later business development. Therefore, it is imminent to compare and synchronize the table structures of different databases. [0003] In the prior art, it is often not known that the problem may be the inconsistency of the database table structure until...

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): G06F17/30
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