公开(公告)号：US09582500B2

公开(公告)日：2017-02-28

申请号：US13831794

申请日：2013-03-15

Applicant: Oracle International Corporation

Inventor： Barry McGillin ,  Dermot O'neill ,  Robert Pang ,  Chandrasekharan Iyer ,  Kristopher Rice

IPC: G06F17/30 ,  G06F17/28

CPC classification number: G06F17/2863 ,  G06F17/30427

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.

Abstract translation: 用于数据库应用程序迁移的方法，系统和计算机程序产品。 该方法在执行外部应用程序时开始，外部应用程序发出与本地数据库系统的SQL方言不兼容的外部SQL方言的SQL语句。 在本地数据库系统的SQL解析器接收到外部SQL语句之前，该系统配置通信会话以拦截外部SQL语句; 而外国应用程序正在等待查询结果时，系统将外来方言查询语句转换为与本机数据库系统兼容的本地SQL。 该方法还执行将返回代码从本地数据库系统转换为与外部应用程序兼容的返回码。 配置数据库会话连接包括建立翻译配置文件，将外语方言SQL转换为本地SQL，并将本机SQL查询返回码转换为外来方言返回码。

公开(公告)号：US20140280259A1

公开(公告)日：2014-09-18

申请号：US13831794

申请日：2013-03-15

Applicant: Oracle International Corporation

Inventor： Barry McGillin ,  Dermot O'neill ,  Robert Pang ,  Chandrasekharan Iyer ,  Kristopher Rice

IPC: G06F17/30 ,  G06F17/28

CPC classification number: G06F17/2863 ,  G06F17/30427

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.

Abstract translation: 用于数据库应用程序迁移的方法，系统和计算机程序产品。 该方法在执行外部应用程序时开始，外部应用程序发出与本地数据库系统的SQL方言不兼容的外部SQL方言的SQL语句。 在本地数据库系统的SQL解析器接收到外部SQL语句之前，该系统配置通信会话以拦截外部SQL语句; 而外国应用程序正在等待查询结果时，系统将外来方言查询语句转换为与本机数据库系统兼容的本机SQL。 该方法还执行将返回代码从本地数据库系统转换为与外部应用程序兼容的返回码。 配置数据库会话连接包括建立翻译配置文件，将外语方言SQL转换为本地SQL，并将本机SQL查询返回码转换为外来方言返回码。