一种基于Oracle的数据存储优化方法

Research and optimize on Inserting batch data into Oracle

介绍了Oracle的应用程序接口OCI,分析了SQL的执行过程。针对常规数据存储方法在海量数据存储和系统并发用户较多时效率低下的问题,定义一种简洁的数据结构,创建存储过程并完成对SQL信息的压缩。对比优化前后的实验数据,可以发现此方法能显著提高Oracle的数据存储效率。

To improve the efficiency of inserting batch data into Oracle, at first analyze the routine way, and then be sure of the goal which is to be optimized. Use the process in Oracle, and then define data structure as parameter to transfer information between application and process in Oracle. At last, by contrast of two experiments we get the conclusion that using process and data structure is more effective than the routine way.