Java存储过程在异构数据库访问中的应用

异构数据服务技术主要用于实现跨数据平台的数据共享。提出了一种在Oracle数据库上采用Java存储过程来实现异构数据服务技术,由数据提供者开发用于共享源数据资源的Java类,数据使用者负责在目的数据库上将Java类部署为Java存储过程。这种技术体现出以数据提供者为主导的特征,容易将各种异构数据资源无缝接入到Oracle数据库中。实践证明,这种技术具有更安全可控及符合业务应用特征的优点。

Data Conversion Among Different Databases Under an Integrated Network Environment

Method for data conversion of heterogeneous DBMS's in the integrated network environment is introduced. The technical approach used can perform data conversion of heterogeneous databases located on different nodes of the network, such as Oracle, Sybase, Informix, MS SQL Server, SQL Anywhere and Foxpro. The conversion system adopts the Client/Server architecture and provides visual integrated interface for users.