摘要
为了满足电力系统仿真软件中的Oracle数据库对数据快速存取的要求,提出了一种基于OCL(Oracle Class Library)技术访问Oracle数据库的方法。详细介绍了OCL技术的特点。和普遍使用的ADO数据库访问技术相比,OCL技术在大批量数据的存储和读取方面具有优越性,数据库开销小,数据的读取和写入速度快。通过分析OCL的数据加载机制,对传统的OCL直接路径加载方法进行改进。当将大批量的数据频繁地导入到数据库时,改进的直接路径加载方法减少了冗余操作,数据的加载速度更快,较好地满足了电力系统仿真的实时性要求。最后给出仿真算例和部分程序代码。
In order to meet the requirements of fast access of Oracle database in power system simulation software, a method based on OCL（Oracle Class Library）technology is presented in this paper. The characters of OCL are introduced detailedly. Compared with prevalent ADO technology, OCL has superiority when mass data is needed writing and reading, and the overhead of database is low while the access speed is fast. By analyzing the load mechanism of OCL, the conventional direct path load method of OCL is proved. When mass data needs writing to database continually, the improved direct path load method reduces the redundancy so as to speed up the load speed, and it can meet the real time requirements of power system simulation. At last, a simulation example and partial codes are provided.
出处
《电力系统保护与控制》
EI
CSCD
北大核心
2009年第9期53-56,共4页
Power System Protection and Control
