Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

SQL (Structured Query Language) sentence processing system based on cloud computing

A technology for processing systems and statements, applied in the field of database processing, can solve problems such as large memory and CPU usage of the system, slow running speed, task execution failure, etc., to optimize CPU and memory, reduce traffic consumption, and improve running speed Effect

Inactive Publication Date: 2015-03-04
DINGLI COMM
View PDF3 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Currently, in the sql statement system that supports cloud computing, for submitting more than 2 query SQL statements in batches at the same time, each SQL statement is executed separately, and the same expression and statement in the SQL statement are not shared and merged, resulting in multiple SQL statements. When the statements are executed at the same time, the memory and CPU usage of the system will increase sharply, and the running speed will be slower than when a single SQL is executed sequentially. Some systems will directly cause insufficient memory and other phenomena, resulting in task execution failure.

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 (Structured Query Language) sentence processing system based on cloud computing
  • SQL (Structured Query Language) sentence processing system based on cloud computing
  • SQL (Structured Query Language) sentence processing system based on cloud computing

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0030] refer to figure 1 As shown, the preferred embodiment of the present invention provides a kind of SQL statement processing system based on cloud computing, comprising:

[0031] Compile the parser, which is used to convert the text of the received SQL statement or stored procedure into the corresponding atomic object;

[0032] The merge optimizer is used to traverse the atomic objects of each SQL statement, and extract the atomic objects with the same content as a common atomic object;

[0033] The execution monitor is used to receive the atomic objects processed by the merging optimizer, assign independent executable components to each atomic object, and obtain calculation results by running the executable components.

[0034] There are many kinds of data sources containing SQL statements, including relational databases, hadoop, hbase, hypertable, etc. In order to adapt to reading and writing different data sources and data formats (including files or binary, etc.), the...

Embodiment 2

[0045] This preferred embodiment is illustrated by specific examples to further explain the present invention.

[0046] Take the two SQL statements submitted in batches as an example:

[0047] SQL1: select a,(a+b) as c, count(*) from t where a+b > 0 group by a, (a+b);

[0048] SQL2: select (a+b) as c, count(*) from t where a+b + d > 100 group by (a+b).

[0049] refer to figure 2 As shown, first, by compiling the parser, each sql statement is decomposed into a syntax tree, and the branch nodes are decomposed into atomic objects (fields, table names, functions, grouping objects) with the smallest granularity. The decomposed results are shown in the figure content. Taking SQL1 as an example, after decomposition, a, (a+b) as c are field objects, count(*) is a function object, and a+b in (a+b) as c is field objects a, b and operation The combination of object +, the table object is t, the search condition is a+b > 0, and the condition a+b > 0 is also the combination of field o...

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) sentence processing system based on cloud computing. The SQL sentence processing system comprises a compiling resolver, a combination optimizer, an executive monitor and a data adapter, wherein the compiling resolver is used for converting a received SQL sentence or a text in a storage process to a corresponding atom object; the combination optimizer is used for traversing the atom object of each SQL sentence and extracting the atom objects with the same content as a public atom object; the executive monitor is used for receiving the atom objects processed by the combination optimizer, distributing an independent executable component for each atom object and obtaining a computed result through operation of the executable component; the data adapter comprises a data input adapter and a data output adapter, the data input adapter is used for reading data from different data sources and transmitting the data to the compiling resolver; the data output adapter is used for writing the computed result generated by the executive monitor into the corresponding data source. According to the SQL sentence processing system, the SQL sentence processing speed is improved, a CPU (Central Processing Unit) and an internal storage are optimized, and the flow consumption is reduced.

Description

technical field [0001] The invention relates to the field of database processing, in particular to a cloud computing-based SQL statement processing system. Background technique [0002] Currently, in the sql statement system that supports cloud computing, for submitting more than 2 query SQL statements in batches at the same time, each SQL statement is executed separately, and the same expression and statement in the SQL statement are not shared and merged, resulting in multiple SQL statements. When the statements are executed at the same time, the memory and CPU usage of the system will increase sharply, and the running speed will be slower than that of a single SQL statement executed sequentially. In some systems, insufficient memory will be directly caused, resulting in task execution failure. Contents of the invention [0003] In order to solve the above problems, the object of the present invention is to provide a cloud computing-based SQL statement processing system...

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): G06F17/30
CPCG06F16/24534
Inventor 别志铭张健明张勇鹏王旭王礼吴楠
Owner DINGLI COMM
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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