MySQL数据仓库在骨质疏松社区-综合医院互动管理模型中应用及在线分析的实现

MySQL Data Warehouse Technology in Osteoporos Community Health Information Management System and On -line Analysis Processing

虽然针对糖尿病、高血压病等疾病已经有多项健康教育模式的建立和研究,但是,针对农村原发性骨质疏松症(Osteo poros,OP)的预防这个重大社会问题,社区-综合医院互动管理模型的建立还在尝试阶段。OP是一个具有明确的病理生理、社会心理和经济后果的健康问题。我们将数据仓库的基本原理和方法与骨质疏松社区干预相结合,面向社区内骨质疏松高危人群构建了专门的数据仓库。以数据仓库运行为核心探索社区-综合医院互动管理模型的实现,同时对数据进行在线分析OLAP(on-Line analysis processing),实现单一维度分析和多个维度的组合分析功能,通过在实践中的数据积累可以为下一步开展有针对性的社区健康干预做准备。

Although for diabetes, high blood pressure disease epidemic has a range of health education mode and the establishment of research, but in rural primary osteoporosis（OP）prevention Osteoporos, the serious social problem, community -general hospital interaction management model has also tried to stage. OP is one who has a clear pathological physiology, social psychology, and economic consequences of health problems. We will data warehouse and the basic principle and method of osteoporosis community intervention, and the combination of facing community of osteoporosis in high-risk groups constructs specialized data warehouse. In data warehouse operation as core explore community-general hospital interaction management model, and the realization of the data online Analysis On- Line（OLAP）Analysis, realize may order single dimension Analysis and DuoGe dimension Analysis, through the combination of function in the practice of the data can be accumulated in for the next step in targeted community health interventions for preparation.