SQL (Structured Query Language) statement parsing method and device

An analysis method and a technology of sentences, which are applied in the computer field, can solve problems such as the inability to realize routine data calculation tasks, the inability to change data partitions, and the inability to modify semantics.

Active Publication Date: 2018-07-31
TENCENT TECH (SHENZHEN) CO LTD
View PDF9 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the prior art, the semantics of the SQL statement cannot be modified, and the selected data p...

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) statement parsing method and device
  • SQL (Structured Query Language) statement parsing method and device
  • SQL (Structured Query Language) statement parsing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] 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.

[0029] The terms "first", "second", "third", "fourth", etc. (if any) in the description and claims of the present invention and the above drawings are used to distinguish similar objects and not necessarily Describe a specific order or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances such that the embodiments of the invention described herein are, for example, capable of practice in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having", as well as any variations thereof, are intended to cover a non-exclusive inclusion, for example, a process, method, syste...

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 (Structured Query Language) statement parsing method, and is used for enabling the semantics of the SQL statement to change along with the change of time or other factors so as to realize the routinized and periodic execution of a data calculation task. The method of the embodiment of the invention comprises the following steps that: receiving a target SQL statement, wherein the grammatical structure of the target SQL statement meets a first grammatical rule; according to the grammatical structure, determining a selection mode corresponding to the target SQL statement; according to the selection mode, determining partition identification corresponding to the target SQL statement; and calling partition data corresponding to the partition identification, and executing a command corresponding to the target SQL statement. The embodiment of the invention also discloses an SQL statement parsing device, and is used for enabling the semantics ofthe SQL statement to change along with the change of time or other factors so as to realize the routinized and periodic execution of the data calculation task.

Description

technical field [0001] The present application relates to the field of computers, in particular to a SQL statement parsing method and device. Background technique [0002] Structured Query Language (Structured Query Language, SQL) is a special-purpose programming language, a database query and programming language, used to access data and query, update and manage relational database systems. [0003] In the prior art, after the user submits the SQL statement in the editor, the statement will be passed to the parser, and then the SQL statement will be parsed into an abstract syntax tree, and then the abstract syntax tree will be submitted to the executor for execution. After execution, the result is returned to the user. In this process, once the SQL statement edited by the user is submitted, the semantics of the SQL statement in the subsequent process cannot be modified. [0004] However, for some big data computing platforms, the demand is to use the data of the previous ...

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 TENCENT TECH (SHENZHEN) 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