Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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 manually query, compare the database table structure, and manually write SQL statements, the synchronization efficiency of the database table structure is low and the error rate is high

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

Embodiment Construction

[0036] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0037] The inventors of the present invention have found that the existing database table structure synchronization method has the following defects: first, the problem of inconsistent database table structure may be discovered after adverse effects occur, that is, the discovery of the problem has a lag; Comparing the database table structure takes a long time and is ineff...

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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products