Unlock instant, AI-driven research and patent intelligence for your innovation.

Database-based SQL code generation method and system

A code generation and database technology, applied in the field of electronic information, can solve problems such as different code quality, different development experience, and different development efficiency, and achieve the effect of lowering threshold requirements, improving maintainability, and ensuring consistency

Active Publication Date: 2018-12-18
GUANGDONG ESHORE TECH
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In actual development, each business department of the enterprise will propose its own statistical analysis requirements. After the requirements are analyzed, they will be submitted to different developers for development. Due to the different development experience and development capabilities of different developers, the development of The efficiency is not the same, and the quality of the developed code is also different
Moreover, developers will code according to their own preferences. The code styles developed by different developers are different, resulting in poor maintainability of subsequent codes. Everyone will only maintain the code they write.

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-based SQL code generation method and system
  • Database-based SQL code generation method and system
  • Database-based SQL code generation method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] In order to illustrate the idea and purpose of the present invention, the present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0052] refer to Figure 1-Figure 3 , propose a specific embodiment of the present invention, a kind of database-based SQL code generation method comprises the following steps:

[0053] S10. Setting configuration information.

[0054] S20. Send configuration information to the development framework.

[0055] S30. Assemble a corresponding SQL statement according to the configuration information, and generate a corresponding publishing function.

[0056] S40. Execute the corresponding release function, and perform data integration, label calculation, data summary, and index calculation processing on the source data in sequence according to the configuration information carried by the release function.

[0057] For step S10, set the configuration information, set the configura...

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-based SQL code generation method and system. The method comprises the following steps: setting configuration information; sending configuration information to the development framework; according to the configuration information, assembling the corresponding SQL statements and generating the corresponding publishing functions. According to the configuration information, the corresponding execution code is generated, which effectively improves the quality of the code, unifies the style of the code, improves the maintainability of the code, and effectively reduces the threshold requirements of the developer ability; through the automatic configuration, the consistency of the source data and the production process is ensured, avoiding the problem that the source data is arranged manually and disjointed with the actual production.

Description

technical field [0001] The invention relates to the technical field of electronic information, in particular to a database-based SQL code generation method and system. Background technique [0002] At present, a large number of enterprises have many IT systems, and the data models and data standards of each system are not uniform. However, personnel at all levels of the enterprise need to quickly grasp the business status of the enterprise in order to conduct business analysis and precise marketing. This requires enterprises to build their own data centers and unify Collect and aggregate the source data of various business systems of the enterprise, and perform logical processing such as label calculation, data integration, and summary to generate multi-dimensional query models and fixed analysis reports that meet the needs of application analysis. [0003] However, the construction of the data center requires a lot of database development work. At present, it is basically r...

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): G06F8/30
CPCG06F8/31
Inventor 徐少强余虎韦子朝张郭强赖守义余超杰
Owner GUANGDONG ESHORE TECH