Invention Grant
- Patent Title: Run-time SQL language translation
- Patent Title (中): 运行时SQL语言翻译
-
Application No.: US13831794Application Date: 2013-03-15
-
Publication No.: US09582500B2Publication Date: 2017-02-28
- Inventor: Barry McGillin , Dermot O'neill , Robert Pang , Chandrasekharan Iyer , Kristopher Rice
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F17/28

Abstract:
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.
Public/Granted literature
- US20140280259A1 RUN-TIME SQL LANGUAGE TRANSLATION Public/Granted day:2014-09-18
Information query