论文部分内容阅读
随着管道完整性管理系统不断地推广与应用,系统的数据量和用户访问量与日剧增,数据库性能已逐渐成为制约系统性能提升的瓶颈之一。为了提高管道完整性管理系统的性能,缩短系统反应时间,节省网络带宽资源,针对管道完整性管理系统并发性强、数据量大、业务逻辑复杂的特点,提出了一套基于索引、高效SQL、存储过程算法、物化视图的数据库优化策略。实际应用效果表明:管道完整性数据库优化策略使系统运行效率平均提升60%,为中国石油管道完整性管理的数据维护与管理提供了有效的技术保障。
With the continuous promotion and application of the pipeline integrity management system, the data volume and user traffic of the system have been increasing rapidly with the increase of the database. Database performance has gradually become one of the bottlenecks restricting the system performance. In order to improve the performance of pipeline integrity management system, shorten system response time and save network bandwidth resources, aiming at the characteristics of pipeline integrity management system such as high concurrency, large data volume and complicated business logic, a set of index- Stored procedure algorithm, materialized view database optimization strategy The practical application results show that the database optimization strategy of pipeline integrity improves the operating efficiency of the system by an average of 60%, which provides an effective technical guarantee for the data maintenance and management of China Petroleum Pipeline Integrity Management.