Universal database conversion device

A conversion device and database technology, applied in the field of databases, can solve problems such as high cost of databases and databases, and achieve the effects of avoiding execution errors, improving efficiency, and reducing maintenance costs

Active Publication Date: 2021-12-14
浙江金惠科技有限公司
View PDF10 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The purpose of this application is to provide a universal database conversion device to overcome the problem of high cost in the creation of database and database maintenance 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
  • Universal database conversion device
  • Universal database conversion device
  • Universal database conversion device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, not to limit the present application.

[0031] This application provides a general-purpose database conversion device, the creation and maintenance of user databases, such as figure 1 shown, including:

[0032] Create a database module for receiving the edited database design file, call the analysis module to analyze the design statement in the database design file line by line and generate a corresponding SQL statement, execute the SQL statement to create a database object;

[0033] The analysis module is used to accept the calling of the database creation module and analyze the design statements in the database design file an...

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 universal database conversion device, which comprises a database creation module, an analysis module and a reverse module. The database creation module receives an edited database design file, calls the analysis module to analyze design statements in the database design file line by line and generates corresponding SQL statements, and executes the SQL statements to create a database object; the reverse module reversely generates the database design file from a target database. The device can be compatible with various database types, can be repeatedly executed when the database is created, can automatically judge whether a database object exists or not, and does not create existing database objects any more, so that execution errors are avoided. An instance database can be converted into a design document, and the original design is compared with a reversely generated document, so that the data standard implementation of each industry is further checked. Therefore, the efficiency of creating the database is improved, and the maintenance cost is also reduced.

Description

technical field [0001] The application belongs to the technical field of databases, and in particular relates to a general-purpose database conversion device. Background technique [0002] Some application software based on database operation may need to support multiple different database types. Common database types include ORACLE, DB2, MYSQL, SQLSERVER, etc. The development team usually completes the database design first, and creates a set of data structure creation statements for each database type. These codes have the same logic, but the syntax of different types of databases is different, so the creation of data structure statements needs to be maintained. . In the operation and maintenance process after going online, it is often necessary to expand or modify the database table structure. These codes are prone to inconsistencies, resulting in a large workload for software testing. Because the action of modifying the database structure is non-repeatable and requires...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/21G06F16/242G06F16/16
CPCG06F16/21G06F16/242G06F16/16Y02D10/00
Inventor 夏骏峰杨波
Owner 浙江金惠科技有限公司
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