论文部分内容阅读
目的利用传染病日常监测数据通过T-SQL语言生成传染病统计报表。方法采用案例驱动方法解析如何使用数据库T-SQL语言强大功能来实现传染病统计报表的创建。结果编制以合肥市、芜湖市及其行政区为例的具有通用性的传染病统计程序代码,所有SQL代码在MS SQL SERVER 2008数据库平台测试通过。结论 T-SQL语言适合公共卫生日常数据的管理和统计分析,特别是在更接近原始数据的层面上开展数据管理具有灵活性和易用性。
Objective To use the daily monitoring data of infectious diseases to generate infectious disease statistics report by T-SQL language. The method uses case-driven method to resolve how to use database T-SQL language powerful function to create infectious disease statistics report. Results The epidemiological program code of epidemic diseases with the example of Hefei, Wuhu and its administrative regions was compiled and all the SQL codes were tested on MS SQL Server 2008 database platform. Conclusion The T-SQL language is suitable for the management and statistical analysis of daily public health data, especially for data management at a level closer to the original data.