System and method of connecting legacy database applications and new database systems

• US 8,407,237 B1
• Filed: 12/20/2011
• Issued: 03/26/2013
• Est. Priority Date: 12/20/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Kudryavtsev, Vladimir, Fu, Nenghong
• Primary Examiner(s): Beausoliel, Jr., Robert
• Assistant Examiner(s): Arjomandi, Noosha
• Application Number:
  US13/331,838
• Time in Patent Office: 462 Days
• Field of Search: 707/999.1, 707/762, 707/803
• US Class Current: 707/762
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

A system and method of connecting legacy database applications and new database systems. The method includes parsing SQL scripts by a connector program. In this manner, the legacy application system does not have to be replaced to work with the new database system.

Claims

1. A computer-implemented method of connecting legacy database applications and new database systems, comprising:

storing, by an application server, a legacy database application, wherein the legacy database application is configured to interface with a legacy database system, wherein the legacy database application includes a plurality of SQL (structured query language) scripts, and wherein the plurality of SQL scripts are written in an open SQL format;

implementing, by the application server, a configuration table and a shared memory area;

receiving, by the application server, a selected SQL script, selection parameters, and a database parameter, wherein the selected SQL script is one of the plurality of SQL scripts, and wherein the database parameter indicates one of the legacy database system and a new database system;

storing, by the application server in the configuration table, the selected SQL script, the selection parameters and an identifier, wherein the identifier uniquely identifies the selected SQL script and the selection parameters;

connecting, by a connector program, to the application server when the database parameter indicates the new database system;

reading, by the connector program, the selected SQL script and the selection parameters according to the identifier;

processing, by the connector program, the selected SQL script to generate a parsed SQL script, wherein the processing parses the open SQL format to a new format, wherein the new format is used by the new database system;

executing, by the connector program, the parsed SQL script using the selection parameters to extract data from the new database system;

writing, by the connector program, the data from the new database system into the shared memory area using the identifier; and

displaying, by the application server, the data from the new database system in the shared memory area according to the identifier.

2. The method of claim 1, further comprising:

connecting, by the application server, to the legacy database system when the database parameter indicates the legacy database system.

3. The method of claim 1, further comprising:

connecting, by the application server, to the legacy database system when the database parameter indicates the legacy database system;

executing, by the application server, the selected SQL script using the selection parameters to extract second data from the legacy database system.

4. The method of claim 1, further comprising:

connecting, by the application server, to the legacy database system when the database parameter indicates the legacy database system;

executing, by the application server, the selected SQL script using the selection parameters to extract second data from the legacy database system; and

writing, by the application server, the second data from the legacy database system into the shared memory area using the identifier.

5. The method of claim 1, further comprising:

communicating, by the application server to the connector program, that the selected SQL script and the identifier have been stored in the configuration table.

6. The method of claim 1, wherein the new database system has an Open Database Connectivity (ODBC) interface.

7. The method of claim 1, wherein the new database system has a Java™

Database Connectivity (JDBC) interface.

8. The method of claim 1, wherein the data from the new database system is displayed to a first user, further comprising:

displaying, by the application server, the data from the new database system in the shared memory area to a second user according to the identifier, without again extracting the data from the new database system.

9. A system for connecting legacy database applications and new database systems, comprising:

an application server that is configured to store a legacy database application, wherein the legacy database application is configured to interface with a legacy database system, wherein the legacy database application includes a plurality of SQL (structured query language) scripts, and wherein the plurality of SQL scripts are written in an open SQL format;

a new database system, wherein the application server is configured to operate with the legacy database system but not the new database system; and

a connector program,

wherein the application server is configured to implement a configuration table and a shared memory area,

wherein the application server is configured to receive a selected SQL script, selection parameters, and a database parameter, wherein the selected SQL script is one of the plurality of SQL scripts, and wherein the database parameter indicates one of the legacy database system and the new database system,

wherein the application server is configured to store, in the configuration table, the selected SQL script, the selection parameters and an identifier, wherein the identifier uniquely identifies the selected SQL script and the selection parameters,

wherein the connector program is configured to connect to the application server when the database parameter indicates the new database system,

wherein the connector program is configured to read the selected SQL script and the selection parameters according to the identifier,

wherein the connector program is configured to process the selected SQL script to generate a parsed SQL script, wherein the processing parses the open SQL format to a new format, wherein the new format is used by the new database system,

wherein the connector program is configured to execute the parsed SQL script using the selection parameters to extract data from the new database system,

wherein the connector program is configured to write the data from the new database system into the shared memory area using the identifier, and

wherein the application server is configured to display the data from the new database system in the shared memory area according to the identifier.

10. The system of claim 9, wherein the application server is configured to connect to the legacy database system when the database parameter indicates the legacy database system.

11. The system of claim 9, wherein the application server is configured to connect to the legacy database system when the database parameter indicates the legacy database system;

and

wherein the application server is configured to execute the selected SQL script using the selection parameters to extract second data from the legacy database system.

12. The system of claim 9, wherein the application server is configured to connect to the legacy database system when the database parameter indicates the legacy database system;

wherein the application server is configured to execute the selected SQL script using the selection parameters to extract second data from the legacy database system; and

wherein the application server is configured to write the second data from the legacy database system into the shared memory area using the identifier.

13. The system of claim 9, wherein the application server is configured to communicate, to the connector program, that the selected SQL script and the identifier have been stored in the configuration table.

14. The system of claim 9, wherein the data from the new database system is displayed to a first user;

and

wherein the application server is configured to display the data from the new database system in the shared memory area to a second user according to the identifier, without again extracting the data from the new database system.

15. A non-transitory computer readable medium storing instructions to control a computer system for connecting legacy database applications and new database systems, comprising:

an application server component that is configured to control an application server to store a legacy database application, wherein the legacy database application is configured to interface with a legacy database system, wherein the legacy database application includes a plurality of SQL (structured query language) scripts, and wherein the plurality of SQL scripts are written in an open SQL format; and

a connector program component,

wherein the application server component is configured to control the application server to operate with the legacy database system but not a new database system,

wherein the application server component is configured to control the application server to implement a configuration table and a shared memory area,

wherein the application server component is configured to control the application server to receive a selected SQL script, selection parameters, and a database parameter, wherein the selected SQL script is one of the plurality of SQL scripts, and wherein the database parameter indicates one of the legacy database system and the new database system,

wherein the application server component is configured to control the application server to store, in the configuration table, the selected SQL script, the selection parameters and an identifier, wherein the identifier uniquely identifies the selected SQL script and the selection parameters;

wherein the connector program component is configured to control the connector program to connect to the application server when the database parameter indicates the new database system,

wherein the connector program component is configured to control the connector program to read the selected SQL script and the selection parameters according to the identifier,

wherein the connector program component is configured to control the connector program to process the selected SQL script to generate a parsed SQL script, wherein the processing parses the open SQL format to a new format, wherein the new format is used by the new database system,

wherein the connector program component is configured to control the connector program to execute the parsed SQL script using the selection parameters to extract data from the new database system,

wherein the connector program component is configured to control the connector program to write the data from the new database system into the shared memory area using the identifier, and

wherein the application server component is configured to control the application server to display the data from the new database system in the shared memory area according to the identifier.

16. The non-transitory computer readable medium of claim 15, wherein the application server component is configured to connect to the legacy database system when the database parameter indicates the legacy database system.

17. The non-transitory computer readable medium of claim 15, wherein the application server component is configured to connect to the legacy database system when the database parameter indicates the legacy database system;

and

wherein the application server component is configured to execute the selected SQL script using the selection parameters to extract second data from the legacy database system.

18. The non-transitory computer readable medium of claim 15, wherein the application server component is configured to connect to the legacy database system when the database parameter indicates the legacy database system;

wherein the application server component is configured to execute the selected SQL script using the selection parameters to extract second data from the legacy database system; and

wherein the application server component is configured to write the second data from the legacy database system into the shared memory area using the identifier.

19. The non-transitory computer readable medium of claim 15, wherein the application server component is configured to communicate, to the connector program component, that the selected SQL script and the identifier have been stored in the configuration table.

20. The non-transitory computer readable medium of claim 15, wherein the data from the new database system is displayed to a first user;

and

wherein the application server component is configured to display the data from the new database system in the shared memory area to a second user according to the identifier, without again extracting the data from the new database system.