PROCESSING SQL STATEMENT IN ALTERNATING MODES

• US 20170103106A1
• Filed: 08/12/2016
• Published: 04/13/2017
• Est. Priority Date: 10/07/2015
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kass, Eric
• Granted Patent: US 10,552,416 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/2433 Query languages
• CPC Class Codes: G06F 16/2455 Query execution

Abstract

A Processing method for processing SQL statements of different flavors by a database management system may be provided. The method comprises receiving SQL statements of different SQL flavors, parsing each received SQL statement for identifying an SQL flavor characteristic, tracking an SQL statement identifier of a related SQL PREPARE operation for determining the SQL flavor characteristic at subsequent DMBS operations, adapting a DBMS mode of the DBMS dynamically to the identified SQL flavor characteristic, adapting another received SQL statement to a DBMS mode of the database management system, and sending each of the adapted SQL statements to the DBMS for the SQL PREPARE operation under the adapted database management system mode.

Claims

1. A method for processing structured query language (SQL) statements of different flavors by a database management system, the method comprising:

receiving SQL statements of different structured query language (SQL) flavors from one source;

parsing each received SQL statement for identifying an SQL flavor characteristic of the received SQL statements;

tracking an SQL statement identifier of a related SQL PREPARE operation of the received SQL statements for determining the SQL flavor characteristic at subsequent database management system operations referencing the SQL statement identifier;

adapting a database management system mode of the database management system dynamically to the identified SQL flavor characteristic;

adapting another received SQL statement to a database management system mode of the database management system; and

sending each of the adapted SQL statements to the database management system for the SQL PREPARE operation under the adapted database management system mode.

2. The method of claim 1, further comprising:

issuing an OPEN CURSOR and/or an EXECUTE statement according to the database management system mode.

3. The method of claim 2, further comprising:

tracking an SQL cursor identifier of the SQL OPEN CURSOR operation for determining the SQL flavor characteristic at subsequent database management system operations referencing the SQL cursor identifier.

4. The method of claim 3, further comprising:

controlling the database management system mode based on the SQL language flavor characteristic associated with the SQL cursor identifier; and

issuing a FETCH or CLOSE CURSOR statement according to the mode.

5. The method of claim 3, further comprising:

intercepting a database COMMIT operation of the CURSOR.

6. The method of claim 1, wherein the adapting the received SQL statement to the database management system mode includes:

modifying the received SQL statement from a compatibility to a first database management system mode to a compatibility to a second database management system mode.

7. The method of claim 1, wherein the adapting a database management system mode includes:

changing the database management system mode corresponding to the identified SQL flavor characteristic of the received SQL statement.

8. The method of claim 1, wherein the method is executed by a database driver for the database management system.

9. The method of claim 1, wherein the parsing is performed using a left-right parsing method.

10. The method of claim 1, wherein the SQL flavor relates to a system naming mode or an SQL naming flavor.

19. The database management system of claim 1, wherein the SQL flavor relates to a system naming mode or an SQL naming flavor.

11. A database management system for processing structured query language (SQL) statements of different flavors, the database management system comprising:

a memory having a set of computer readable computer instructions;

a processor for executing the set of computer readable instructions;

a receiving unit adapted for receiving SQL statements of different structured query language (SQL) flavors from one source;

a parser module adapted for parsing each received SQL statement for identifying an SQL flavor characteristic of the received SQL statements;

a tracking unit adapted for tracking an SQL statement identifier of a related SQL PREPARE operation of the received SQL statements for determining the SQL flavor characteristic at subsequent relational database management system operations referencing the SQL statement identifier;

a first modifying unit adapted for adapting a relational database management system mode of the relational database management system dynamically to the identified SQL flavor characteristic;

a second modifying unit adapted adapting another received SQL statement to a relational database management system mode of the relational database management system; and

a sending unit adapted for sending each of the adapted SQL statements to the relational database management system for the SQL PREPARE operation under the adapted relational database management system mode.

12. The database management system of claim 11, further comprising:

an issuing unit adapted for issue an EXECUTE and OPEN CURSOR operation according to the relational database management system mode.

13. The database management system of claim 12, wherein the tracking unit is further adapted for tracking an SQL cursor identifier of the SQL OPEN CURSOR operation for determining the SQL flavor characteristic at subsequent relational database management system operations referencing the SQL cursor identifier.

14. The database management system of claim 13, wherein the database management system is further adapted for controlling the relational database management system mode based on the SQL language flavor characteristic associated with the SQL cursor identifier, and adapted for issuing a FETCH or CLOSE CURSOR operation according to the mode.

15. The database management system of claim 13, further adapted for intercepting a database COMMIT operation the CURSOR.

16. The database management system of claim 11, wherein the first adapting unit the received SQL statement to the relational database management system mode is further adapted for:

modifying the received SQL statement from a compatibility to a first relational database management system mode to a compatibility to a second relational database management system mode.

17. The database management system of claim 11, wherein the first adapting unit the relational database management system mode is further adapted for:

changing the relational database management system mode corresponding to the identified SQL flavor characteristic of the received SQL statement.

18. The database management system of claim 11, wherein the parser is a left-right parser.

20. A computer program product for processing structured query language (SQL) statements of different flavors, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:

receiving SQL statements of different structured query language (SQL) flavors from one source;

parsing each received SQL statement for identifying an SQL flavor characteristic of the received SQL statements;

tracking an SQL statement identifier of a related SQL PREPARE operation of the received SQL statements for determining the SQL flavor characteristic at subsequent relational database management system operations referencing the SQL statement identifier;

adapting a relational database management system mode of the relational database management system dynamically to the identified SQL flavor characteristic;

adapting another received SQL statement to a relational database management system mode of the relational database management system; and

sending each of the adapted SQL statements to the relational database management system for the SQL PREPARE operation under the adapted relational database management system mode.