SQL script generation method and device

A script generation and scripting technology, which is applied in the field of database processing, can solve problems such as heavy workload, error-prone SQL scripts, and difficulty for users to obtain, so as to reduce errors and improve writing efficiency

Inactive Publication Date: 2019-05-21
BANK OF CHINA
View PDF7 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when it is necessary to change a large amount of information on the data tables of the application system, such as performing batch maintenance on newly created data tables, or performing operations such as updating, deleting, and retrieving large amounts of data in the data tables, it is necessary to manually write a large number of, SQL scripts to perform operations on different data
The above-mentioned process of writing SQL scripts brings a huge workload, which not only consumes a lot of time for the writers, but also the SQL scripts written by humans are prone to errors, making it difficult for users to obtain the desired results

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
  • SQL script generation method and device
  • SQL script generation method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0011] In order to make the purpose, technical solutions, and advantages of the embodiments of the present application clearer, the embodiments of the present application will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments of the application and their descriptions are used to explain the application, but not to limit the application.

[0012] The terms "including" and "having" and any variations thereof mentioned in the description of the present application are intended to cover non-exclusive inclusion. For example, a process, method, system, product or device comprising a series of steps or units is not limited to the listed steps or units, but optionally also includes other unlisted steps or units, or optionally also includes Other steps or elements inherent to the process, method, product or apparatus are included.

[0013] It should be noted that, in the embodiments of the present application, words suc...

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 an SQL script generation method and device. The method comprises the steps of obtaining to-be-processed data; determining a processing mode corresponding to the to-be-processeddata and an application target data table; And according to the SQL script template corresponding to the processing mode and the to-be-processed data, generating an SQL script for processing the target data table. According to the method and the device, the SQL script compiling efficiency can be improved, and meanwhile, the SQL script compiling error rate is reduced.

Description

technical field [0001] The present application relates to the technical field of database processing, in particular to a structured query language (StructuredQuery Language, SQL) script generation method and device. Background technique [0002] When maintaining the application system, the background data is often added, deleted, updated, and queried. At this time, it is necessary to manually prepare a structured query language (Structured Query Language, SQL) script to run in the background, so as to obtain the required information of the user. result. However, when it is necessary to change a large amount of information on the data tables of the application system, such as performing batch maintenance on newly created data tables, or performing operations such as updating, deleting, and retrieving large amounts of data in the data tables, it is necessary to manually write a large number of, SQL scripts that perform operations on different data. The above-mentioned proces...

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/242
Inventor 王和燕黄鸿滨周畅
Owner BANK OF CHINA
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