Check patentability & draft patents in minutes with Patsnap Eureka AI!

Functional SQL query method and device supporting dynamic variables, equipment and medium

A technology of dynamic variables and query methods, applied in the computer field, can solve problems such as poor flexibility, inability to support dynamic variable functions, and difficult expansion, etc., to achieve the effect of improving flexibility and convenience

Pending Publication Date: 2020-11-24
福建亿能达信息技术股份有限公司
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the current SQL query statement cannot support dynamic variable functions, is not easy to expand, has poor flexibility, and cannot provide more diverse and more accurate query services for fields such as smart medical systems. Therefore, it also provides an opportunity for the generation of the present invention

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
  • Functional SQL query method and device supporting dynamic variables, equipment and medium
  • Functional SQL query method and device supporting dynamic variables, equipment and medium
  • Functional SQL query method and device supporting dynamic variables, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0050] Such as Figure 1 to Figure 6 As shown, the present embodiment provides a functional SQL query method supporting dynamic variables, comprising the following steps:

[0051] S1, passing the formula of the functional SQL containing dynamic variables to the script parameter extractor, extracting the parameter head flag, the parameter body flag and the parameter body content from the formula by the script parameter extractor and passing it to the script parameter parser, wherein The dynamic variable of exists in the parameter body content;

[0052] Specific as figure 2 As shown, in the new style of SQL, three parameter head signs are defined as '$', '@', '#' and two parameter body signs are '[]', '{}', dynamic variables use ' ! {variable name}' form. The script parameter extractor will read and collect the header flag and body flag in the new-style SQL according to the flag, and then pass the collected header flag and body flag content to the script parameter parser fo...

Embodiment 2

[0080] Such as Image 6 As shown, a kind of functional SQL query device that supports dynamic variables is provided in the present embodiment, comprising:

[0081] The script parameter extractor is used to pass the formula of functional SQL containing dynamic variables to the script parameter extractor, and the parameter header flag, parameter body flag and parameter body content are extracted from the formula by the script parameter extractor and passed to the script parameter parser, where dynamic variables exist in parameter body content;

[0082] The script parameter parser is used for receiving the content sent by the script parameter extractor, parsing the parameter body mark, parsing the type of the parameter header mark and performing the following classification processing on the dynamic variable:

[0083] When the type of the parameter header flag is analyzed to be a single-parameter value type, the parameter body content is obtained, and the dynamic variable value ...

Embodiment 3

[0099] This embodiment provides an electronic device, such as Figure 7 As shown, it includes a memory, a processor, and a computer program stored in the memory and operable on the processor. When the processor executes the computer program, any implementation manner in Embodiment 1 can be realized.

[0100] Since the electronic device introduced in this embodiment is the device used to implement the method in Embodiment 1 of this application, based on the method described in Embodiment 1 of this application, those skilled in the art can understand the electronic device of this embodiment. Specific implementation methods and various variations thereof, so how the electronic device implements the method in the embodiment of the present application will not be described in detail here. As long as those skilled in the art implement the equipment adopted by the method in the embodiment of the application, they all belong to the intended protection scope of the application.

[010...

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 provides a functional SQL query method and device supporting dynamic variables, equipment and a medium. The method comprises the following steps: S1, transmitting a formula of a functional SQL (Structured Query Language) containing a dynamic variable to a script parameter extractor to extract a parameter head mark, a parameter body mark and parameter body content containing the dynamic variable, and transmitting the parameter head mark, the parameter body mark and the parameter body content to a script parameter parser; S2, when the script parameter parser receives the content sent by the script parameter extractor, matching a parameter header mark, parsing a parameter body mark, parsing the type of the parameter header mark, and performing classification replacement processing on a dynamic variable to obtain sql fragments corresponding to a formula; and S3, backfilling the sql fragment is into the SQL through a script generator, so that an SQL query language capable of being directly executed by the database is generated, and an SQL query result can be obtained after the SQL query language is directly executed by the database. According to the method, capability expansion is carried out on the basis of an original SQL, and functions and dynamic variables are combined, so that SQL query is more flexible, diversified and accurate, and expansion is easy.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a functional SQL query method, device, equipment and medium supporting dynamic variables. Background technique [0002] With the rapid development of the Internet, the number of people using the Internet is increasing, the scope of application is becoming wider and wider, and the amount of data generated every day is also growing explosively. The era of big data and cloud computing was born. However, these technologies all rely heavily on databases and query languages. Larger amounts of data and richer data types pose greater challenges to database data type support and query languages. For example, in the context of the vigorous development of smart medical care, the electronic medical record system under the medical system requires more accurate statistics and analysis of monthly and annual patient recovery time, consumption amount and other information. The patient self-se...

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/242G16H50/70
CPCG06F16/242G06F16/2448G16H50/70Y02D10/00
Inventor 黄家昌林鑫杨辉邱道椿
Owner 福建亿能达信息技术股份有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com