Relational database query method and device supporting dynamic parameters

Abstract

The invention discloses a relational database query method and device supporting dynamic parameters. The method comprises the steps of carrying out registration on a newly-added data source, and configuring corresponding related information; carrying out dynamic query to transmit dynamic parameters wanted by a user; carrying out result query on the configured data source parameters and query statement parameters by the program; recording the query time and enabling a result to fall into the database; and storing the user query data in a fixed data address for visual preview. According to the invention, dynamic target database query is carried out by configuring query conditions for dynamic parameter pairs, service functions are modularized and parameterized, and the process is visualized, so that the functions are used in the working and production processes, the working efficiency can be greatly improved, the whole process is visualized and standardized, version management is easy, the threshold for users to use and the complexity of data processing are reduced, and dynamic data query can be completed in any environment and any database.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a relational database query method and device supporting dynamic parameters. Background technique [0002] In the existing technology, the traditional database cannot perform dynamic query, and the query conditions are relatively fixed. To query the database, it is often necessary to clearly specify all parameters, specify the correct data source, and confirm the query command to perform the query. The data source conditions will bring some additional workload, and make adaptations to various situations, thereby reducing work efficiency. [0003] At present, there is no clear solution on the market. Basically, it needs to be processed in code, and depends on known data conditions. It cannot be intelligent and flexible, and lacks support for large data platforms. Contents of the invention [0004] Aiming at the above-mentioned technical problems in the related art, the presen...

AI Technical Summary

Problems solved by technology

[0002] In the existing technology, the traditional database cannot perform dynamic query, and the query conditions are relatively fixed. To query the database, it is often necessary to clearly specify all parameters, specify the correct data source, and confirm the query command to perform the query. The data source conditions will bring some additional workload, and make adaptations to various situations, thereby reducing work efficiency

[0003] At present, there is no clear solution on the market. Basically, it needs to be processed in code, and depends on known data conditions. It cannot be intelligent and flexible, and lacks support for large data platforms.

Images