Check patentability & draft patents in minutes with Patsnap Eureka AI!

DDL statement analysis method and device, computer equipment and storage medium

A parsing method and a technique of parsing grammar, which are applied in the field of parsing grammar of sentences, can solve the problems of low accuracy and low efficiency of parsing DDL sentences

Pending Publication Date: 2021-09-28
WEIKUN (SHANGHAI) TECH SERVICE CO LTD
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The main purpose of this application is to provide a DDL sentence parsing method, device, computer equipment and storage medium, aiming to solve the problem of low accuracy and low efficiency of the current DDL sentence parsing

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
  • DDL statement analysis method and device, computer equipment and storage medium
  • DDL statement analysis method and device, computer equipment and storage medium
  • DDL statement analysis method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0042] refer to figure 1 , the embodiment of the present application provides a method for parsing a DDL sentence, including steps S10-S50. The detailed description of each step of the method for parsing a DDL sentence is as follows.

[0043] S10. Obtain a DDL statement.

[0044] This embodiment is applied to the recognition scene of DDL statement. DDL statement is a data definition language, which is usually used in the initial stage of establishing a table. DDL statement is used to create, modify, and delete tables, views, indexes, constraints, etc., including create ,...

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 relates to the field of statement grammar analysis, and discloses a DDL statement analysis method and device, computer equipment and a storage medium. The method comprises the steps: obtaining a DDL statement; identifying each independent unit of the DDL statement, and obtaining words contained in the DDL statement, with the words being the minimum independent unit in the DDL statement; constructing tree nodes according to the words, and constructing a grammar analysis tree based on the tree nodes; traversing the grammar analysis tree, determining the type of the words according to a grammar rule, and determining structured information of the DDL statement according to the type of the words; and determining the execution meaning of the DDL statement according to the structured information of the DDL statement. According to the method and the device, the analysis efficiency and accuracy of the DDL statement can be improved.

Description

technical field [0001] The present application relates to the field of sentence grammar analysis, in particular to a DDL sentence analysis method, device, computer equipment and storage medium. Background technique [0002] With the rapid development of the Internet, in the process of SQL parsing, we are faced with the problems and difficulties of DDL (Data Definition Language, database schema definition language) statement parsing. DDL is usually used in the initial stage of table creation. Currently, for DDL statements, it is currently used Mycat (a database middleware written based on the Java language) performs analysis, but Mycat does not provide a special processor for analysis processing, but uses a unified service method for analysis processing. First, it judges the SQL type of the DDL statement, and then according to different types The accuracy and efficiency of sentence parsing are not high when parsing is performed with a preset template. Contents of the invent...

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): G06F16/242G06F8/41
CPCG06F16/2433G06F8/427G06F8/425
Inventor 王英杰
Owner WEIKUN (SHANGHAI) TECH SERVICE CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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