Design of Heterogeneous Database Universal Interface Based on OCI and ODBC
Huang Dong · Computer Technology and Development · 2007
The character of ODBC and OCI database calling level interface is analyzed in the paper.At the same time,to solve the share of heterogeneous database,a method of database application program linking database is provided,that is universal database calling level interface(UDB CLI).Firstly,the position of UDB CLI module in the system is mentioned,secondly analyzes the material functions of this module and introduces three layers of this module in design,then summarizes the advantages of the UDB CLI module.Encapsulated with ODBC and OCI,the UDB CLI can not only interconnect the heterogeneous database but also improve the performance of the system.By communicating with the heterogeneous database by calling a series of database functions,the UDB interface is universal,simple,extensible and can be optimized.