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

Database processing method, database processing system and storage medium

A processing method and database technology, applied in the computer field, can solve problems such as inability to parse

Pending Publication Date: 2022-02-18
YONYOU NETWORK TECH
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] The SQL (Structured Query Language) parsers on the market are basically based on SQL syntax analysis. There is no problem in parsing standard SQL statements. unresolvable problem

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
  • Database processing method, database processing system and storage medium
  • Database processing method, database processing system and storage medium
  • Database processing method, database processing system and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0043] figure 1 It shows one of the schematic flowcharts of the database processing method of the embodiment of the present invention. Wherein, the database processing method includes:

[0044] Step 102, obtaining the original SQL statement of the database to be converted;

[0045] Step 104, converting the original SQL statement into a custom expression;

[0046] Step 106, analyzing the custom expression to obtain the target SQL statement of the target database.

[0047]The database processing method provided in this embodiment can obtain the target SQL statement of the target database by obtaining the original SQL statement of the database to be converted, converting the original SQL statement into a custom expression, and parsing the custom expression. Through the database processing method of the present invention, the SQL statement can be regarded as a long series of expressions for calculation, and the SQL of different databases can be translated and processed using a ...

Embodiment 2

[0049] figure 2 The second schematic flow diagram showing the database processing method of the embodiment of the present invention. Wherein, the database processing method includes:

[0050] Step 202, obtaining the original SQL statement of the database to be converted;

[0051] Step 204, replace the preset symbols in the original SQL statement according to the user-defined operator and / or the first user-defined function to obtain a user-defined expression;

[0052] Step 206, analyzing the custom expression to obtain the target SQL statement of the target database.

[0053] In this embodiment, when the original SQL statement is converted into a custom expression, the original SQL statement is preprocessed according to the custom operator and / or the first custom function, and the preset symbols in the original SQL statement are replaced for the custom operator and / or the first custom function. In the embodiment of the present invention, by customizing operators and functi...

Embodiment 3

[0055] On the basis of the second embodiment, further, the preset symbols include spaces and / or brackets.

[0056] In this embodiment, the preset symbols include, but are not limited to: spaces and / brackets. Through the embodiment of the present invention, the SQL statement can be regarded as a long series of expressions for calculation, which saves the step of syntax analysis, and is superior to the SQL conversion tool with syntax analysis in terms of compatibility. At the same time, any part of SQL can be partially translated, and any level of nesting between functions is supported.

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 provides a database processing method, a database processing system and a storage medium. The database processing method comprises the steps of obtaining an original SQL statement of a to-be-converted database; converting the original SQL statement into a user-defined expression; and analyzing the user-defined expression to obtain a target SQL statement of the target database. According to the database processing method provided by the invention, the target SQL statement of the target database can be obtained by obtaining the original SQL statement of the to-be-converted database, converting the original SQL statement into the user-defined expression and analyzing the user-defined expression. By means of the database processing method, the SQL statement can be regarded as a long string expression for calculation, SQL of different databases is translated through unified logic by customizing operators and functions, the problems generated by analysis of a large number of SQL are avoided, and the translation function of the complex SQL statement is successfully achieved.

Description

technical field [0001] The present invention relates to the technical field of computers, in particular, to a database processing method, a database processing system and a storage medium. Background technique [0002] The SQL (Structured Query Language) parsers on the market are basically based on SQL syntax analysis. There is no problem in parsing standard SQL statements. Unresolvable problem. Contents of the invention [0003] The present invention aims to solve at least one of the technical problems existing in the prior art. [0004] Therefore, the first aspect of the present invention is to propose a database processing method. [0005] A second aspect of the present invention is to propose a database processing system. [0006] A third aspect of the present invention is to propose a database processing system. [0007] A fourth aspect of the present invention is to propose a storage medium. [0008] In view of this, according to one aspect of the present 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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242G06F16/2452G06F16/22
CPCG06F16/2433G06F16/2452G06F16/2291
Inventor 马锡滕
Owner YONYOU NETWORK TECH
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