面向气象Web应用的数据库访问性能优化及应用

Performance Optimization and Application of Accessing Database Oriented Meteorological Web Applications

Web应用已经成为提供气象互联网服务的重要手段。省级及以下气象信息业务面临着信息基础设施性能不高和气象类数据随时间急剧增长的问题,该问题严重影响气象Web应用数据库的ORM访问性能。论文设计了一种基于一致性Hash算法和笛卡尔积的数据表记录压缩优化方法。考虑到静态语言ORM框架使用的复杂性,论文提供了一种基于动态语言Python Django框架访问优化后数据库的方法。实验表明该优化方法提升了气象Web应用访问数据库的性能。论文将该优化方法应用到江西省区域站数据直传运维保障系统开发中,对各省气象Web应用的开发具有一定的参考意义。

Web application is important means for providing meteorological internet service.The meteorological information business of provincial level and below faces two problems.One problem is low performance of information infrastructure,the other problem is that data records increase rapidly as time goes by.Those problems can degrade the ORM access performance of meteoro⁃logical Web database.One compress optimization method for data table in meteorological Web database is designed based on consis⁃tent hashing algorithm and Cartesian Products.In consideration of the complexity of using static language ORM,a method is provid⁃ed,which is used to access database after optimization based on dynamic language Python Django.The result of experiments shows that the optimization method can improve the access performance of data table.The method has been applied to develop Jiangxi pro⁃vincial operation and maintenance support system for regional station data direct transmition.This implementation is significant for other provinces to develop meteorological Web application.