摘要
Oracle提供基于TCP/IP协议的Oracle数据库接口(Oracle Call Interface;OCI),允许用户使用SQL、PL/SQL脚本对数据库进行CRUD操作。每次增删改查需要建立一次TCP会话,频繁地新建与关闭TCP连接会降低程序的运行效率。面向对象程序设计中,对象池技术通过预先创建一定数量的对象,可以提升程序运行时的效率。文章基于OCI和对象池技术,运用C++实现了Oracle数据库连接池,并基于此实现跨平台的Oracle数据源管理中间件,提供了单一的数据访问接口,降低了编程复杂度,支持多线程数据访问,提升了数据访问效率,并且应用到某大型信息系统客户端和服务端系统的设计中,取得了良好的效果。
Oracle provides TCP/IP protocol based OCI(Oracle Call Interface)which allows users to do CRUD operation by executing SQL、PL/SQL scripts.Each crud operation requires a TCP session to be established,frequently set up and close TCP connections will reduce the program runtime efficiency.In object-oriented programming,object pool technology is used to improve the program runtime efficiency by creating a certain number of objects in advance.In this paper,the oracle database connection pool is designed in C++language based on OCI and object pool technology.A cross-platform Oracle Data Source management middleware which provides a uniform interface to reduce programming complexity and supports multithread data access to improve data access efficiency is realized.And it was applied to design client and server software of a large information system and acquires a good effect.
作者
章邢
王敏
Zhang Xing;Wang Min(The 28th Research Institute of China Electronics Technology Group Corporation,Nanjing 210007,China)
出处
《信息化研究》
2018年第4期67-73,共7页
INFORMATIZATION RESEARCH