SQL generating system and method

Abstract

The invention discloses a system and a method for generating structure query language, and aims to eliminate the limitation of relying on SQL sentence writing experience and solve the problem of unsatisfactory execution efficiency. A user can use the invention to generate SQL sentences through a graphic interface, so that the user can be helped to choose better SQL sentences, thereby realizing the technical efficiency of improving the writing efficiency of SQL sentence and the query efficiency of an information base.

Description

technical field [0001] The invention relates to a computer language generating system and method, in particular to a structured query language generating system and method. Background technique [0002] In recent years, with the vigorous development of network technology, database-related applications have sprung up, such as: e-commerce and online forums, etc. However, when the database gradually accumulates a large amount of data over time, and the data correlation becomes increasingly complex When you want to query the required data, you must use a more complex database query language. Therefore, how to generate complex database query language more conveniently, so as to reduce the reliance on experience in writing SQL statements, has become a topic that all manufacturers have devoted their efforts to. [0003] Generally speaking, database query languages ​​vary according to different types of databases, such as hierarchical databases, network databases, relational databa...

AI Technical Summary

Problems solved by technology

[0005] Although the above technologies can assist users to generate SQL statements, they cannot generate suitable SQL statements for different databases, and cannot generate multiple SQL statements that can achieve the same query purpose and perform performance tests to provide users with more efficient options. Therefore, the above techniques are not enough to solve the limitation of relying on the experience of writing SQL statements and the problem of poor execution performance

[0006] To sum up, it can be seen that the previous technology has long been limited by the experience of writing SQL statements, as well as the problem of poor execution performance. Therefore, it is necessary to propose improved technical means to solve this problem.

Images