Supercharge Your Innovation With Domain-Expert AI Agents!

SQL instruction generation method and system

A technology of instruction generation and expression, applied in the field of data processing, can solve the problems of bloated tools and increase the difficulty of using tools, and achieve the effect of simple use, expressiveness, and simple and convenient writing

Inactive Publication Date: 2020-03-06
MICRO DREAM TECHTRONIC NETWORK TECH CHINACO
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, perfect tools always provide basic operations of the database and also encapsulate various functions, which leads to bloated tools and increases the difficulty of using the tools themselves.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0019] Considering that in our development, the use of database operation tools is more to automatically generate SQL and simplify basic database operations. In order to return to the essence of things and liberate from the complicated use of existing database operation tools, we continue to explore, Finally, a set of simple and feasible database SQL generation protocol was formed, which was applied to actual development and passed the strict online test.

[0...

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 embodiment of the invention provides an SQL instruction generation method and system, and the method comprises the steps: receiving a query instruction, and analyzing the query instruction to obtain an input instruction and an output instruction; analyzing the input instructions line by line in sequence, for each line of input instructions, determining resource types in the instructions according to segmentation keywords set in the line of instructions, calling corresponding processing engines according to the resource types, obtaining corresponding data information from corresponding databases based on the called processing engines, and storing the data information in corresponding data sets; and after each line of input instruction is processed, analyzing the output instruction, combining data information in each data set and outputting the combined data information. According to the technical scheme, a universal and standard SQL instruction generation language format is provided, common data storage services can be effectively inquired, and result sets are merged and then returned.

Description

technical field [0001] The invention belongs to the field of data processing, and in particular relates to a method and a system for generating an SQL instruction. Background technique [0002] In Internet web development, the most frequently dealt with data processing is database operation. In order to simplify database operations, many web frameworks provide some useful tools for database operations, or ORM tools. Especially in the Java Web world, the most famous ones are Hibernate and MyBatis. However, perfect tools always provide basic database operations and also encapsulate various functions, which leads to bloated tools and increases the difficulty of using the tools themselves. In fact, many times what we need is just a small and powerful database operation tool. Contents of the invention [0003] The embodiment of the present invention provides a method and system for generating an SQL command, which realizes the SQL command query operation of the database thro...

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): G06F16/242G06F16/2455
CPCG06F16/2445G06F16/2455
Inventor 刘邦彭冬
Owner MICRO DREAM TECHTRONIC NETWORK TECH CHINACO
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com