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

Apparatus for generating upgrade SQL script

A technology of script and generation department, applied in the field of database upgrade, can solve the problems of low efficiency of manually writing SQL scripts for database upgrade and reducing project development cost, etc.

Active Publication Date: 2015-10-07
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF7 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] Aiming at the shortcoming of the low efficiency of manually writing database upgrade SQL scripts in software development projects, the inventor of the present invention proposes to develop a general software engine device that quickly generates database upgrade SQL scripts based on the baseline version. Software developers can use this software engine device to By connecting the baseline version database and the target version database at the same time, according to the database dictionary comparison and the SQL grammar rule engine provided by the engine device, quickly generate database upgrade SQL scripts and database table structure difference reports, thereby greatly improving the writing of SQL scripts for database upgrades in software development projects Efficiency, greatly reducing project development costs

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
  • Apparatus for generating upgrade SQL script
  • Apparatus for generating upgrade SQL script
  • Apparatus for generating upgrade SQL script

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] According to the present invention, a device for generating an upgrade SQL script is provided.

[0020] An SQL script is a DDL (Data Definition Language, Data Definition Language) statement sequence of a relational database.

[0021] refer to figure 2 , the device of the present invention includes two parts: a configuration client 201, such as a visualized configuration client, and a generating part 202 for generating difference analysis reports and upgrading SQL scripts.

[0022] The configuration client 201 is used to enable the user to configure the database data source, including selecting a database type, and specifying a baseline version database and a target version database.

[0023] Configuring the database data source includes selecting the database type, such as database product name (such as Oracle or MySQL) and its version number, so that the generation part 202 selects the matching definition rule for analysis and processing; and specifies the baseline v...

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 present invention provides an apparatus for generating an upgrade SQL script, comprising: a configuration client, wherein the configuration client is provided for a user to configure a database data source, comprising selecting a database type and designating a baseline version database and a destination version database; and a generating part, configured to separately convert a data dictionary of the baseline version database and a data dictionary of the destination version database into a corresponding database object according to a predefined rule and according to a call request of the configuration client, compare a difference between the database object of the baseline version database and the database object of the destination version database, to generate a difference analysis report, and generate an upgrade SQL script according to the difference analysis report and according to a corresponding SQL grammar rule definition.

Description

technical field [0001] The invention relates to database upgrading, in particular to an engine device and method for rapidly generating an upgrading script of a relational database based on a baseline version. Background technique [0002] Database upgrades often consume a lot of time and cost, especially when the database upgrade changes greatly and there are many baseline versions to be upgraded in the production environment, how to quickly and accurately upgrade the databases of different baseline versions in the production environment to the latest version Frequently encountered problems in projects. [0003] There are two commonly used database upgrade solutions: [0004] (1) Rebuilding the database: Rebuilding the database refers to re-deploying a new database environment in the production environment. First, back up the core business data in the production environment database data table, and then use the latest version of the database SQL script to rebuild the produ...

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

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