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

Database modification SQL generation method and system, storage medium, and computer device

A database and data technology, applied in the field of data processing, can solve the problems of cumbersome operation and low efficiency, and achieve the effect of wide application range, high efficiency and easy operation

Inactive Publication Date: 2018-04-10
GUANGZHOU SHIRUI ELECTRONICS +1
View PDF4 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] For this reason, an embodiment of the present invention proposes a database modification SQL generation method to solve the problems of cumbersome operation and low efficiency in the prior art

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 modification SQL generation method and system, storage medium, and computer device
  • Database modification SQL generation method and system, storage medium, and computer device
  • Database modification SQL generation method and system, storage medium, and computer device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0045] see figure 1 , the database modification SQL generation method that an embodiment of the present invention proposes, it is characterized in that, described method comprises:

[0046] S101. Analyze the source database and the target database respectively, so as to respectively obtain the source table data structure corresponding to the...

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 modification SQL (Structured Query Language) generation method and system, a storage medium, and a computer device. The method includes: analyzing a source databaseand a target database so as to acquire a source table data structure corresponding to the source database and a target table data structure corresponding to the target database respectively, wherein the source table data structure and the target table data structure include field data and index data; performing comparison analysis on the field data and the index data in the same class in the source table data structure and the target table data structure respectively so as to generate corresponding differential SQLs; and summarizing all the differential SQLs so as to generating a target modification SQL. The invention can solve the problem of complex operations and low efficiency in the prior art.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database modification SQL generation method, system, storage medium and computer equipment. Background technique [0002] With the development of science and technology, various application software, including PC-side application software and mobile-side application software, have become inaccessible products for people to live, work and study. [0003] When the software is upgraded, it is necessary to collect the DDL (Data Definition Language, DDL for short) modification of the database before and after the upgrade, so as to generate the modified SQL (Structured Query Language, SQL for short). [0004] In the prior art, most of them are performed manually. When the fields or indexes in the database are modified, the modified SQL needs to be manually written, which is cumbersome and inefficient. Although there is currently a kind of software, DBComparer, which can achi...

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
CPCG06F16/2433G06F16/2453
Inventor 林锡鑫
Owner GUANGZHOU SHIRUI ELECTRONICS
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com