通过OCI封装类实现数据库的快速访问

Achieve High-speed Access to a Database by Wrapping Oracle Call Interface within a Class

基于Oracle海量数据库的大型应用开发对系统响应时间提出了越来越高的要求,如何有效地提高Oracle数据库的访问效率,减少系统等待时间成为一个研究热点。介绍一种数据库访问方法OCI(Oracle Call Interface),并通过分析和对比ODBC、JDBC和Pro*C/C++的实现原理,表明OCI在访问Oracle数据库上性能优越性。通过C++类封装OCI,可实现多平台应用系统快速访问Oracle数据库。该类(接口)不仅克服了直接使用OCI过于复杂、不可重用等缺点,同时具有效率高,代码可读性、易维护性和可重用性增强等优点。

As the demand for a shorter response time in the development of large applications based on oracle mass database,how to shorter the response time and effectively access an oracle database become a hot research topic.Firstly Oracle Call Interface（OCI）,a method of accessing an oracle database is instroduced,and the implementing mechanism of ODBC,JDBC,Pro＊C/C＋＋ and OCI are compared to show the better performance of OCI on accessing an oracle database.Then presenting a way of wrapping OCI in C＋＋ class,it can achieve high-speed access to an oracle database within multi-platform application system.The interface get over the disadvantage,such as the complexity of adopting OCI,less repeated used and so on,and also improve the readability,maintenance and repeated used of source code.