The method of realizing the automatic generation tool of database sql query statement by using random algorithm

A query statement generation and query statement technology, applied in the database field, can solve problems such as inability to include sql query functions and OLAP statements, test case omissions, etc., to achieve the effects of improving test quality, increasing breadth and depth, and saving time

Active Publication Date: 2021-08-31
福建星瑞格软件有限公司
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the sql statements generated by existing sql query statement automatic generation tools only have simple main query statements, and simple sql statements cannot contain all sql query functions and OLAP statements. Therefore, it is easy to cause test case failures. omit

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
  • The method of realizing the automatic generation tool of database sql query statement by using random algorithm
  • The method of realizing the automatic generation tool of database sql query statement by using random algorithm

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] see figure 1 and figure 2 Shown, a kind of method of the present invention utilizes random algorithm to realize the automatic generation tool of database sql query statement, described method needs to provide query total generation module (being query_spec total generation module), and described query total generation module comprises select generation module (select_list generation module), from generation module (i.e. from_clause generation module) and condition generation module (i.e. condition_clause generation module); the select generation module includes a select subquery unit (i.e. select_list subquery unit) and a funcall unit comprising function and column information , the from generation module includes a from sub-query unit (ie from_clause sub-query unit) and joined_table units including various table information, and the condition generation module includes a condition sub-query unit (ie condition_clause sub-query unit) and various sentence The bool_term ...

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 present invention utilizes random algorithm to realize the method for database sql query statement automatic generation tool, comprises S1, carries out query statement generation from query general generation module; S2, executes select generation module, utilizes random algorithm to select randomly, if select select sub-query unit , start to regenerate from S1, if the funcall unit is selected, enter S3; S3, execute the from generation module, use random algorithm to select randomly, if select the from subquery unit, start to regenerate from S1, if select the joined_table unit, enter S4; S4 1. Execute the condition generation module, use a random algorithm to randomly select, if the condition sub-query unit is selected, it will be regenerated from S1, if the bool_term unit is selected, enter S5; S5, nest and splice all query statements into a complete sql query statement and output. The invention can realize the automatic generation of multi-layer nested sql query statements, and can improve the manufacturing efficiency of complex sql.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method for realizing a tool for automatically generating database sql query statements by using a random algorithm. Background technique [0002] Database (Database) is a warehouse that organizes, stores and manages data according to the data structure. It was produced more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management It is no longer just storing and managing data, but has transformed into various data management methods required by users. [0003] In recent years, with the development of big data, there are more and more types of databases, the syntax and usage of SQL are also different, and the requirements for functions and performance are getting higher and higher. The tool for automatically generating sql query statements is a tool that is often used when testing database functions and performance. ...

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 Patents(China)
IPC IPC(8): G06F16/242
CPCG06F16/2433
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

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