THE STRATEGY TO INSERT MASSIVE DATA INTO DATABASE QUICKLY IN H9000 SYSTEM
The Data to be stored in Large and medium-sized system are usually very great.The size may be hundreds or even thousands gigabytes，and the record hum in database may climb up to hundreds of millions.The real-time capability of the system required may be very strict.Some system demands all data be written in one second or even faster.How to insert massive data into database faster，so as to meet the requirement of system capability，is the key point.This paper shows a good way to solve the question，which was achieved during the implementation of H9000 SCADA system for right bank of the Three Gorges Project.The paper consists of three main parts. In the first part，the author describes the function requirement of the system first，then analyzes the data size and record row Bum.based on the analysis， the author optimizes the database table structure，so as to improve the capacity of database.In the second part，two method to access the oracle database are described.One is PRO*C，the other is OCI(ORACLE CALL INTERFACE)，which shows more agility than the former one and is chosen as programing tool in this system.In the last part，the strategy to insert massive data into database quickly is described detailly.The key technology isbind array variable， which is supported by oracle database.Using this method，thousands rows of records can be insert into oracle in one transaction，which costs only several second or less.Thebind array variablecan improve the inserting speed 36 times than traditional way，and achieves remarkable effect.
H9000 OCI Massive Data Historical Database Right Bank of the Three Gorges Proiect
Yang Yeping Wang Zhenying Meilin
Department of Automation of China Institute of Water Resources and Hydropower Research，Beijing 100038
国际会议
High-level International Forum on Water Resources and Hydropower(第一届国际水利水电高层论坛)
北京
英文
334-338
2008-10-17（万方平台首次上网日期，不代表论文的发表时间）