RUN-TIME SQL LANGUAGE TRANSLATION

摘要

A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system configures a communication session to intercept the foreign SQL statements before the foreign SQL statements are received by the SQL parser of the native database system; and, while the foreign application is waiting for query results, the system translates the foreign dialect query statements into native SQL compatible with the native database system. The method further performs translating a return code from the native database system into a return code compatible with the foreign application. Configuring the database session connection comprises establishing a translation profile to translate foreign dialect SQL into native SQL, and to translate native SQL query return codes into foreign dialect return codes.

主权项

1. A computer implemented method for run-time SQL language translation, the method comprising:
emitting, from an application, a query for execution, wherein the query is constructed in a foreign SQL dialect that is incompatible with the SQL dialect of a native database system; and performing real-time translation of the query from the foreign SQL dialect into a native SQL dialect, in which the query is intercepted to perform the translation, and wherein the query is translated prior to returning results of the query to the application.