SQL statement dynamic analysis method

An analysis method and sentence technology, applied in the field of big data, can solve the problems of high pressure on the data server and cumbersome extraction process, etc.

Pending Publication Date: 2019-10-22
北京首汽智行科技有限公司
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the process of building a big data platform, the data in the business relational database needs to be completely imported into the data warehouse, and various complex SQL statements need to be written during the extraction process to avoid extracting useless business data, which makes the extraction process cumbersome , the pressure on the data server is high

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 statement dynamic analysis method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The present invention will be specifically introduced below in conjunction with the accompanying drawings and specific embodiments.

[0019] refer to figure 1 , the SQL statement dynamic parsing method that the embodiment of the present invention provides comprises the following steps:

[0020] S101. Obtain a where query condition statement in the SQL statement, and generate a query condition statement set.

[0021] S102, respectively judge whether the parameter carried by each where query condition statement in the query condition statement set is empty.

[0022] S103, if not, use a recursive algorithm to encapsulate the obtained where query condition statement into a function module.

[0023] Wherein, this step realizes the decoupling of the where query condition statement in the SQL statement from the SQL statement.

[0024] S104. Execute the function module to obtain corresponding first data.

[0025] S105. Execute the SQL statement to obtain the corresponding s...

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 an SQL (Structured Query Language) statement dynamic analysis method, relates to the technical field of big data, and aims to simplify an SQL writing process and reduce the pressure of a data server by dynamically analyzing query conditions in an SQL without analysis of a database server.

Description

technical field [0001] The invention relates to the technical field of big data, in particular to a method for dynamically parsing SQL statements. Background technique [0002] In the process of building a big data platform, the data in the business relational database needs to be completely imported into the data warehouse, and various complex SQL statements need to be written during the extraction process to avoid extracting useless business data, which makes the extraction process cumbersome , the pressure on the data server is high. Contents of the invention [0003] In order to solve the deficiencies in the prior art, the embodiment of the present invention provides a dynamic parsing method for SQL statements, the method comprising the following steps: [0004] Obtain the where query conditional statement in the SQL statement, and generate a set of query conditional statements; [0005] Respectively judge whether the parameter carried by each where query condition s...

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 & AuthorityApplications(China)
IPC IPC(8): G06F16/242G06F16/28
CPCG06F16/2433G06F16/283
Inventor闫守臣
Owner北京首汽智行科技有限公司