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

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

作　　者：俞建峰 沈影超[2] 周波凯 陈晓[2] 王强 顾云峰[2] 

机构地区：[1]江苏省常熟市兴隆社区卫生服务中心,215500 [2]南京中医药大学附属常熟医院

出　　处：《中国全科医学》2012年第1期26-28,共3页Chinese General Practice

基　　金：江苏省苏州市科技局2010年度科研课题<农村原发性骨质疏松症社区-综合医院"治未病"管理模型构建和生存质量评价>(sysd2010031)

摘　　要：目的面向骨质疏松社区干预,研究远程管理系统及进行数据仓库系统设计。方法将数据仓库的基本原理和方法与骨质疏松社区干预相结合,面向社区内骨质疏松高危人群,采用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.

关 键 词：社区 骨质疏松 数据仓库 远程管理 

分 类 号：R197[医药卫生—卫生事业管理]