面向骨质疏松社区干预的远程管理系统及数据仓库系统设计

Remote Management System of Osteoporosis Community Intervention and Design of Data Warehouse

目的面向骨质疏松社区干预,研究远程管理系统及进行数据仓库系统设计。方法将数据仓库的基本原理和方法与骨质疏松社区干预相结合,面向社区内骨质疏松高危人群,采用PHP作为开发工具,构建MySQL 4.5关系型数据库,实现基于WEB的B/S模式远程管理系统。结果系统适用于社区卫生服务中心、各级医院骨质疏松专科门诊和卫生行政部门,提供了数据管理、数据查询、在线分析等功能。结论实现了分别为卫生行政管理者提供决策依据和支持,为社区卫生服务中心提供居民健康信息和干预建议,为综合医院的骨质疏松专科医师提供患者随访资料、大量原始科研数据和初步的卫生统计结果等功能。

Objective To investigate the remote management system of osteoporosis community intervention and design the data warehouse.Methods The basic principles and methods of Data Warehouse were applied to the osteoporosis community intervention to build the MySQL 4.5 relational database using PHP as the development tool.A web-based B/S Model remote management system was established for the high risk population of osteoporosis in the community.Results The system can be used for data management,data query,online analysis,etc.in community health service center,specialist outpatient for osteoporosis and health administration sectors.Conclusion The remote management system and data warehouse can provide guidance for policy-making of health administrators,residents′ health information and intervention suggestions for general practitioners in community health service centers,patients′ follow-up information for osteoporosis specialists in general hospitals,as well as large quantities of original research data and preliminary health statistic results.