论文部分内容阅读
为满足大坝安全监控程序对大量数据进行快速复杂计算的需求,缩短程序响应时间并减少程序对系统资源的占用,及时监控并预测影响大坝安全的突发状况,提出了一种利用Oracle数据库优化大坝监控系统的方法。借助Oracle的自定义函数功能,并结合大坝安全监控程序运算的特点,用SQL语言将程序计算嵌入数据库,然后再由程序呈现结果,实现数据计算过程的转移,减少了程序对数据库的读写访问次数,避免了重复计算,简化了程序代码的编写。运行结果表明,该方法有效提高了程序运算的速度和软件的可操作性。
In order to meet the need of fast and complex calculation of large amount of data by dam safety monitoring program, shorten the response time of the program and reduce the occupation of system resource by the program, and timely monitor and predict the emergency affecting the dam safety, Method of optimizing dam monitoring system. With the function of Oracle’s custom functions, combined with the characteristics of dam safety monitoring program operation, the program is embedded in the database using SQL language, and then the results are presented by the program to achieve the transfer of data calculation process, reducing the program’s read and write to the database The number of visits, to avoid double counting, simplifying the preparation of the program code. The running results show that this method effectively improves the speed of program operation and software operability.