Visualized structured query language (SQL) condition tree establishing method and device

Abstract

The invention discloses a visualized structured query language (SQL) condition tree establishing method, comprising: judging whether each of SQL conditions to be established belongs to an attribute operation expression formula, using the conditions belonging to the attribute operation expression formula as first-layer leaf nodes, using the conditions which do not belong to the attribute operation expression formula as first-layer middle nodes, partitioning the conditions which do not belong to the attribute operation expression formula into more than one first sub-condition group according to an and / or relation, and so on till all conditions are dissolved into the attribute operation expression formula; and establishing a default condition group according to the SQL conditions to be established, using the default condition group as a root nodes, and establishing an SQL condition tree according to the determined middle nodes and leaf nodes on each layer. Furthermore, the SQL condition tree is showed in two columns of condition group names and an operation relation by an operation interface. The invention also discloses a visualized SQL condition tree establishing device.

Description

technical field [0001] The present invention relates to a business operation support technology in the communication field, in particular to a method and device for constructing a conditional tree of a visualized structured query language (Structured Query Language, SQL). Background technique [0002] With the development of information technology, the amount of information in enterprises is increasing day by day, and business systems are becoming more and more complex, so the requirements for data analysis are also getting higher and higher. Faced with the current increasingly complex data analysis requirements, analysts often need to design complex business analysis SQL, and there are usually the following problems in the design process: [0003] First, most business analysts do not have deep knowledge about databases, and cannot completely write SQL for complex businesses by hand; [0004] Second, from the perspective of security, it is often necessary to avoid business ...

AI Technical Summary

Problems solved by technology

[0005] Third, the existing data analysis products have certain deficiencies in terms of simplicity and understandability when constructing complex SQL

[0007] In addition, existing data analysis products in the industry, such as commercial cognos, bo, MicroStrategy, and open source Pentaho, SpagoBI, etc., simply list the conditions defined by users one by one when constructing SQL conditional statements for data analysis , using the default and (and) operation relationship to combine, when it is necessary to deal with the complex business data analysis requirements of arbitrary combinations of SQL conditions, there are deficiencies in ease of use and intuition

[0008] The Chinese patent application document with the application number 201110163280.4 discloses a method for generating complex SQL statements, which can be directly applied to the testing process of the database system, and can solve the problem of high error rate and low efficiency of manually writing combined keyword SQL statements

The application document uses SQL keywords, combined SQL statements and generation methods, and at the same time generates complex SQL according to the keywords specified by the user. Focusing on the method for users to construct complex SQL from a business perspective, there are still disadvantages such as unclear levels and incomprehensibility in the construction method and presentation method

Images