期刊文献+

基于OCI和对象池技术的跨平台Oracle数据源管理中间件的实现 被引量:2

Implementation of Cross-platform Oracle Data Source Management Middleware Based on OCI and Object Pool Technology
下载PDF
导出
摘要 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
关键词 Oracle数据库接口 对象池 数据源 中间件 OCI object pool data source middle aware
  • 相关文献

参考文献4

二级参考文献11

共引文献11

同被引文献20

引证文献2

二级引证文献5

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部