SQL sentence generation method and system

A statement and language technology, applied in the field of SQL statement generation methods and systems, can solve problems such as low efficiency, inability to quickly form SQL statements in batches, hinder the application of SQL statements, etc., and achieve the effect of improving writing efficiency

Inactive Publication Date: 2010-03-17
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 30 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The inventor found in the process of realizing the present invention that the efficiency of this manual writing of SQL statements is too low, and it cannot quickly form batches of SQL statements required for programming, business applications, report query and other environments, which seriously hinders the development of SQL statements. application

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 sentence generation method and system
  • SQL sentence generation method and system
  • SQL sentence generation method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] In order for those skilled in the art to further understand the features and technical contents of the present invention, please refer to the following detailed description and accompanying drawings of the present invention. The accompanying drawings are provided for reference and illustration only, and are not intended to limit the present invention.

[0043] The technical solutions of the present invention will be described below in conjunction with the drawings and embodiments.

[0044] refer to figure 1 , is a flowchart of a method for generating an SQL statement according to an embodiment of the present invention.

[0045] The method can include:

[0046] Step 101, setting description items of fields and tables.

[0047] In this step, the description of the database entity is unified by setting the field description table item and the table description table item, so as to provide conditions for subsequent automatic, fast, and batch generation of SQL statements. ...

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 provides an SQL sentence generation method and a system. The SQL sentence generation method comprises the following steps: setting a descriptive table entry of the fields and tables; filling in the descriptive information corresponding to the descriptive table entry to generate a data dictionary; and generating the SQL sentences according to the data dictionary and the structure query language (SQL) sentence generation rules. In the embodiment of the invention, unified descriptive entry is set firstly, and descriptive information is filled, thus providing a possibility for realizing the purpose of the invention; and then according to the SQL sentence generation rules, the application data dictionary is set into a template of the SQL sentence, thus realizing automatic and rapid generation of the SQL sentence in a large scale, and improving the compiling efficiency of the SQL sentence.

Description

technical field [0001] The invention relates to the technical field of database processing, in particular to a method and system for generating SQL statements. Background technique [0002] With the rapid development of computer technology, the related application of database is more and more extensive. However, when the database accumulates more and more data and the correlation of data becomes more and more complex, how to conveniently and quickly query and manage the database has become an important research topic for various enterprise manufacturers. In this environment, the operation of various databases Language came into being. [0003] SQL (Structured Query Language, Structured Query Language) is a database query and programming language for accessing data and querying, updating and managing relational database systems. [0004] SQL is a high-level non-procedural programming language that allows users to work on high-level data structures. Different database syste...

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): G06F17/30
Inventor 邹俊
Owner KINGDEE SOFTWARE(CHINA) CO LTD
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