摘要
为满足大坝安全监控程序对大量数据进行快速复杂计算的需求,缩短程序响应时间并减少程序对系统资源的占用,及时监控并预测影响大坝安全的突发状况,提出了一种利用Oracle数据库优化大坝监控系统的方法。借助Oracle的自定义函数功能,并结合大坝安全监控程序运算的特点,用SQL语言将程序计算嵌入数据库,然后再由程序呈现结果,实现数据计算过程的转移,减少了程序对数据库的读写访问次数,避免了重复计算,简化了程序代码的编写。运行结果表明,该方法有效提高了程序运算的速度和软件的可操作性。
In order to meet fast and complex computational processing requirements of large quantities of data in dam safety monitoring programs,shorten the response time of programs,reduce the occupation of program system resources,monitor and forecast the emergency situation of dam safety in time,a method of optimizing dam monitoring system based Oracle database is presented.With the help of the Oracle's user-defined functions and the operation characteristics of the dam safety monitoring program,calculation procedures were completed by embedding them into Oracle with the SQL language.The results were obtained by the program to achieve the transfer of the data calculation process,which reduces the time of reading and writing,avoids unnecessary repeat computations and simplifies the programming code.Running results show that the method can effectively improve the speed of program operation and the operability of the software.
引文
[1]郭珉.ORACLE数据库SQL优化原则[J].计算机系统应用,2010,19(4):170-173,165.
[2]吴中如.大坝与坝基安全监控理论和方法及其应用[J].江苏科技信息,2005(12):1-6.
[3]石树刚,郑振楣.关系数据库[M].北京:清华大学出版社,1993.
[4]贾化萍.C/S与B/S结合模式的大坝安全监测信息管理系统研究[D].南京:河海大学,2006.
[5]刘志敏.Oracle数据库应用管理解决方案[M].北京:电子工业出版社,2002.
[6]斯琴巴图,张利峰,胡其吐.SQL技术与网络数据库开发详解[M].北京:清华大学出版社,2009.
[7]蔡丽.深入分析Oracle数据库的响应时间[J].中国科技信息,2015(12):94.