Method and device for intelligently generating query statements

Through the method of intelligently generating query statements, configuring data sources and determining the syntax tree of reports, the cumbersome problem of manually configuring different database syntax rules in the existing technology is solved, and efficient DMPBI report configuration and query is achieved.

CN113886417BActive Publication Date: 2025-03-25BEIJING DEEPZERO TECH CO LTD
1 Cites 0 Cited by

Patent Information

Application Number
CN202111130420.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-09-26
Publication Date
2025-03-25
Estimated Expiration
2041-09-26

AI Technical Summary

Technical Problem

In the prior art, syntax rules for different databases need to be manually configured manually, resulting in cumbersome configuration and a deeper database operation foundation, making it difficult to efficiently implement the DMPBI report function.

Method used

By configuring the data source and determining the syntax tree of the report, query statements that support queries are generated based on the characteristic data of the data source, and the method of intelligently generating query statements is realized.

Benefits of technology

It reduces staff configuration costs, improves configuration efficiency, automates the configuration of DMPBI report engine, and solves the cumbersome problems of manual configuration.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

The present invention discloses a method and device for intelligently generating query statements. The method includes: configuring a data source; determining a syntax tree of a report; generating a query statement supporting querying the data source according to the configured data source and the syntax tree of the report, and according to the characteristic data of the data source. The present invention solves the technical problem of manually configuring the corresponding DMPBI report engine configuration with different syntaxes in the related art to realize the DMPBI report function.
Need to check novelty before this filing date? Find Prior Art