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

MySQL based SQL parser and parsing method thereof

An analytical method and a parser technology, applied in the direction of instruments, special data processing applications, electrical digital data processing, etc., can solve problems such as unrealizable, unsupported MySQL, complexity of data analysis process, etc.

Inactive Publication Date: 2016-07-20
GUANGZHOU PINWEI SOFTWARE
View PDF4 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] A MySQL-based SQL parser and its parsing method provided by the embodiments of the present invention solve the problem that the current lexical and grammatical analysis tools do not support MySQL-specific SQL statements and cannot expand their functions through annotations. Analyzing technical issues of process complexity

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
  • MySQL based SQL parser and parsing method thereof
  • MySQL based SQL parser and parsing method thereof
  • MySQL based SQL parser and parsing method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] A MySQL-based SQL parser and its parsing method provided by the embodiments of the present invention solve the problem that the current lexical and grammatical analysis tools do not support MySQL-specific SQL statements and cannot expand their functions through annotations. Analyzing the technical aspects of the complexity of the process.

[0042] In order to make the purpose, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the following The described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present inv...

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 a MySQL based SQL parser and a parsing method thereof.The technical problem that existing lexical and syntactic analysis tools do not support unique SQL statements of MySQL and cannot achieve the function of expanding the MySQL through annotations and accordingly the complexity of the data analysis process is caused is solved.The MySQL based SQL parser comprises a lexical analyzer, a syntactic analyzer and a syntactic tree analyzer, wherein the lexical analyzer conducts MySQL language lexical analysis on acquired character streams, outputs token flows corresponding to MySQL languages to the syntactic analyzer for syntactic segment analysis corresponding to the MySQL languages and outputs syntactic trees corresponding to syntactic segments to the syntactic tree analyzer for analysis.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a MySQL-based SQL parser and a parsing method thereof. Background technique [0002] SQL, Structured Query Language (Structured Query Language) referred to as SQL (pronunciation: / eskju el / "S-Q-L"), is a special-purpose programming language, a database query and programming language for accessing data and querying, updating, and managing relational database systems; it is also the extension of a database script file. Structured Query Language is a high-level non-procedural programming language that allows users to work on high-level data structures. It does not require the user to specify the data storage method, nor does it require the user to understand the specific data storage method, so different database systems with completely different underlying structures can use the same structured query language as the interface for data input and management. Structured query lan...

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): G06F17/30
CPCG06F16/284
Inventor 王震张学诚朱振
Owner GUANGZHOU PINWEI SOFTWARE
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