SQL workflow processing method and device, electronic equipment and storage medium

A processing method and workflow technology, applied in digital data processing, special data processing applications, database design/maintenance, etc., can solve problems such as wasting service resources, redundant SQL statements, and affecting SQL workflow execution performance, and achieve The effect of improving accuracy and efficiency, reducing waste, and reducing service pressure

Pending Publication Date: 2021-02-09
XIAN UNIVIEW INFORMATION TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, due to subjective factors among developers, the step modules of different business logic splits are not the same, resulting in redundant SQL statements in workflow execution, affecting the execution performance of SQL workflow, wasting service resources, etc.

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
  • SQL workflow processing method and device, electronic equipment and storage medium
  • SQL workflow processing method and device, electronic equipment and storage medium
  • SQL workflow processing method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0034] figure 1 It is a flow chart of the SQL workflow processing method in Embodiment 1 of the present invention, and this embodiment is applicable to the situation of determining whether redundant SQL exists in the SQL workflow. The method can be executed by an SQL workflow processing device, which can be implemented in the form of software and / or hardware, and can be configured in an electronic device, for example, the electronic device can be a device with communication and computing capabilities such as a background server. Such as figure 1 As shown, the method specifically includes:

[0035] Step 101, acquiring SQL statement information in the node.

[0036] Wherein, the SQL workflow includes at least two nodes, and each node includes at least one SQL statement. Each node completes a split sub-business logic in the complex business logic. For example, use the workflow scheduling method to split the complex business logic according to the steps, write the corresponding...

Embodiment 2

[0087] image 3 It is a flowchart of the SQL workflow processing method in the second embodiment of the present invention, and the second embodiment is further optimized on the basis of the first embodiment. Such as image 3 As shown, the method includes:

[0088] Step 301, acquiring SQL statement information in a node.

[0089] Step 302, perform parallel extraction processing on the SQL statement in the node and / or the node according to the SQL statement information in the node.

[0090] Among them, the extraction steps of parallel extraction processing are as follows:

[0091] Determine the independent SQL statement according to the SQL statement information in the target node, and establish a new node according to the independent SQL statement; wherein, the dependency of the new node is determined according to the target node;

[0092] According to the SQL statement information in the nodes, it is determined whether there is a submission relationship between the nodes t...

Embodiment 3

[0126] Figure 4 It is a schematic structural diagram of the SQL workflow processing device in Embodiment 3 of the present invention, and this embodiment is applicable to the situation of determining whether redundant SQL exists in the SQL workflow. Such as Figure 4 As shown, the device includes:

[0127] An information acquisition module 410, configured to acquire SQL statement information in the node;

[0128] The first processing module 420 is configured to, if it is determined according to the SQL statement information that the target SQL statement satisfies the preset merging condition, perform merging processing on the target SQL statement to obtain the processed SQL workflow, so as to realize the same Combination of bloodline SQL statements;

[0129] The second processing module 430 is used to determine that the target SQL statement satisfies the preset intermediate table deletion condition according to the SQL statement information, then perform deletion processing...

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 embodiment of the invention discloses an SQL workflow processing method and device, electronic equipment and a storage medium. The method comprises the steps of obtaining SQL statement informationin a node; if it is determined that a target SQL statement meets a preset merging condition according to the SQL statement information, performing merging processing on the target SQL statement to obtain a processed SQL workflow so as to realize merging of SQL statements with the same blood relationship in the node; or, if it is determined that the target SQL statement meets a preset intermediatetable deletion condition according to the SQL statement information, executing deletion processing on the target SQL statement to obtain a processed SQL workflow so as to delete the SQL statement ofthe intermediate table in the node. According to the embodiment of the invention, redundant jobs generated by artificial subjective factor design in the SQL workflow are reduced, the waste of serviceresources is reduced to the greatest extent, the execution accuracy and efficiency of the SQL workflow are further improved, and the pressure of a server is reduced.

Description

technical field [0001] The embodiment of the present invention relates to the technical field of business processing, and in particular to a SQL workflow processing method, device, electronic device and storage medium. Background technique [0002] As a structured query language, SQL has been widely used. However, in the face of complex business logic, the cost of writing SQL statements that meet the corresponding business is relatively high, and the final SQL statement that meets the business is often more complex, resulting in problems such as low operating efficiency and high performance consumption. [0003] A workflow-based approach can be used to split complex business logic into steps, write corresponding SQL jobs according to the split steps, and finally schedule and execute SQL jobs according to dependencies. SQL workflow is to implement a relatively complex business logic, split the business into multiple sub-parts, and then automatically execute the sub-parts acc...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242G06F16/21
CPCG06F16/211G06F16/2433
Inventor 张蕾
Owner XIAN UNIVIEW INFORMATION TECH CO LTD
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