Unlock instant, AI-driven research and patent intelligence for your innovation.

Conversion method and conversion apparatus for internal and external connections of non-standard SQL statement

A conversion device, a non-standard technology, applied in the database field, can solve problems such as the failure of the application program to run correctly, and achieve the effect of ensuring correctness

Active Publication Date: 2017-05-24
北京华胜信泰数据技术有限公司
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If no compatibility modification is made, the original application program will not run correctly after the database is transplanted

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
  • Conversion method and conversion apparatus for internal and external connections of non-standard SQL statement
  • Conversion method and conversion apparatus for internal and external connections of non-standard SQL statement
  • Conversion method and conversion apparatus for internal and external connections of non-standard SQL statement

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] In order to have a clearer understanding of the above objects, features and advantages of the present invention, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other.

[0035] In the following description, many specific details are set forth in order to fully understand the present invention. However, the present invention can also be implemented in other ways different from those described here. Therefore, the protection scope of the present invention is not limited by the specific details disclosed below. EXAMPLE LIMITATIONS.

[0036] figure 1 It shows a schematic flowchart of a conversion method of inner and outer joins of non-standard SQL statements according to an embodiment of the present invention.

[0037] like figur...

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 proposes a conversion method and a conversion apparatus for internal and external connections of a non-standard SQL statement. The conversion method comprises: finding out all first type expressions and all second type expressions in a filter tree in a syntax parsing tree of the non-standard SQL statement; generating a connection state tree node for each of the second type expressions; merging all of the connection state tree nodes to obtain a connection state tree; linking each of the first type expressions to the attributes of the connection state tree nodes on the connection state tree; and according to the connection state tree linked with the first type expressions, modifying the syntax parsing tree, and converting the internal connection of the non-standard SQL statement to the external connection. According to the technical scheme of the present invention, the internal connection of the non-standard SQL statement is converted to the equivalent external connection, so that the correctness for inquiring the statement after transplanting the database is ensured.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a conversion method for inner and outer connections of non-standard SQL statements and a conversion device for inner and outer connections of non-standard SQL statements. Background technique [0002] During the database migration process, some users used non-ANSI (American National Standards Institute, American National Standards Institute) standard syntax to write SQL (Structured Query Language, Structured Query Language) statements. The following will use non-ANSI standard syntax to write SQL statements Called a non-standard SQL statement. Due to the long history, users cannot modify and compile non-standard SQL statements again, which requires the subsequent database to be compatible with the syntax of the transplanted database. [0003] A special outer join syntax is supported in the Oracle database, for example: Select*from a,b wherea.c1=b.c1(+); where (+) is a new keywo...

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/24526
Inventor 杨永亮
Owner 北京华胜信泰数据技术有限公司