Supercharge Your Innovation With Domain-Expert AI Agents!

SQL statement processing method and apparatus and server

A processing method and technology of a processing device, which are applied in the field of data processing, can solve the problems of spending a lot of time and energy, errors, and easy occurrence, and achieve the effects of improving conversion efficiency, being convenient to use, and reducing error rates.

Inactive Publication Date: 2016-02-17
FOUNDER INFORMATION IND HLDG
View PDF3 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The disadvantages of the prior art are: for users who are accustomed to using SQL, it takes a lot of time and effort to learn and master a new query language; moreover, existing SQL statements are converted into relational data Query statements are manually completed by database operators. In this way, a large number of statement conversions cannot be achieved, and corresponding syntax and semantic conversion errors are prone to occur during the conversion process.

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 processing method and apparatus and server
  • SQL statement processing method and apparatus and server
  • SQL statement processing method and apparatus and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] In order to make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be described clearly and completely in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of the embodiments of the present invention, not all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

[0035] A flow chart of a SQL statement processing method such as figure 1 As shown, the method includes:

[0036] Step 100. Obtain the SQL statement to be converted;

[0037] Step 101. Parse the acquired SQL statement to generate a first syntax tree;

[0038] Step 102. Convert the first syntax tree to a non-SQL second syntax tree, the sem...

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 present invention provides an SQL statement processing method and apparatus and a server. The method comprises: acquiring a to-be-converted SQL statement; analyzing the obtained SQL statement to generate a first syntax tree; converting the first syntax tree into a non-SQL second syntax tree, wherein semantics of the second syntax tree is the same as that of the first syntax; and traversing the second syntax tree to obtain a non-SQL statement corresponding to the second syntax tree. According to the SQL statement processing method and apparatus and the server provided by the present invention, an SQL statement is converted into a non-SQL statement by conversion of a syntax tree without the need for manual conversion, thereby lowering the error-rate of the conversion process, and improving the SQL statement conversion efficiency.

Description

Technical field [0001] The invention relates to the field of data processing, in particular to a method, device and server for processing SQL statements. Background technique [0002] XML database management system (XMLDBMS) is a new type of database management system (DBMS) that has developed rapidly in recent years. The data it uses to store and retrieve is XML documents. XML data is a kind of non-relational data, and its retrieval and update are completed by standard XQuery and XQueryUpdate. The data in relational databases such as SQL cannot be directly used in XMLDBMS. It is necessary to convert SQL statements into XQuery statements before they can be used in XMLDBMS and for users to query. [0003] The disadvantage of the existing technology is that for users who are accustomed to using SQL, it takes a lot of time and effort to learn and master the use of a new query language; moreover, the existing SQL statements are converted into relational data. The query statement is m...

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
Inventor 李浩彭川王博邓光超
Owner FOUNDER INFORMATION IND HLDG
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