Relational database query method and device supporting dynamic parameters

A dynamic parameter and dynamic query technology, applied in the computer field, can solve problems such as inability to achieve intelligence and flexibility, lower work efficiency, and fixed query conditions

Pending Publication Date: 2021-05-04
北京睿企信息科技有限公司 +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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
  • Relational database query method and device supporting dynamic parameters
  • Relational database query method and device supporting dynamic parameters

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0012] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. All other embodiments obtained by persons of ordinary skill in the art based on the embodiments of the present invention belong to the protection scope of the present invention.

[0013] A method for querying a relational database supporting dynamic parameters according to an embodiment of the present invention includes: using different types of data sources as different api interfaces, registering as different modules on the data processing platform, and configuring different parameters;

[0014] When using dynamic query, the user generates different dynamic parameters in the upstream of the dynamic data query module according to different business logic, and passes th...

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 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...

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
IPC IPC(8): G06F16/25G06F16/2455G06F16/248
CPCG06F16/252G06F16/2455G06F16/248
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