空气污染人群健康影响监测信息系统在线统计分析功能的设计与实现

Design and implementation of online statistical analysis function in information system of air pollution and health impact monitoring

目的实现空气污染人群健康影响监测信息系统的在线统计分析功能,实时获取数据分析信息。方法采用描述性统计方法并结合后续时间序列分析、多元回归分析,利用SQL语言和可视化工具,基于数据库软件在监测系统中实现在线统计分析。结果在线生成空气污染暴露和人群健康数据的基础统计表和汇总统计表;在线生成数据趋势图并通过连接数据库进行交互;在线生成可直接导入R语言、SAS或SPSS软件进行分析的对接表。结论空气污染人群健康影响监测信息系统可实现在线统计分析功能,为使用者提供实时的数据分析结果。

Objective To implement the online statistical analysis function in information system of air pollution and health impact monitoring,and obtain the data analysis information real-time. Methods Using the descriptive statistical method as well as time-series analysis and multivariate regression analysis,SQL language and visual tools to implement online statistical analysis based on database software. Results Generate basic statistical tables and summary tables of air pollution exposure and health impact data online; Generate tendency charts of each data part online and proceed interaction connecting to database; Generate butting sheets which can lead to R,SAS and SPSS directly online. Conclusion The information system air pollution and health impact monitoring implements the statistical analysis function online,which can provide real-time analysis result to its users.