Web-based: A data warehouse on osteoporosis data warehouse in the osteoporosis community health information management system


Objective: To establish an interactive management model for community-oriented high-risk osteoporosis in conjunction with a rural community health service center. Materials and Methods: Toward multidimensional analysis of data, the system we developed combines basic principles of data warehouse technology oriented to the needs of community health services. This paper introduces the steps we took in constructing the data warehouse; the case presented here is that of a district community health management information system in Changshu, Jiangsu Province, China. For our data warehouse, we chose the MySQL 4.5 relational database, the Browser/Server, (B/S) model, and hypertext preprocessor as the development tools. Results: The system allowed online analysis processing and next-stage work preparation, and provided a platform for data management, data query, online analysis, etc., in community health service center, specialist outpatient for osteoporosis, and health administration sectors. Conclusion: The users of remote management system and data warehouse can include community health service centers, osteoporosis departments of hospitals, and health administration departments; provide reference for policymaking 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.


Share and Cite:

Wang, Q. and Shen, Y. (2013) Web-based: A data warehouse on osteoporosis data warehouse in the osteoporosis community health information management system. Journal of Biomedical Science and Engineering, 6, 1072-1076. doi: 10.4236/jbise.2013.611134.

Conflicts of Interest

The authors declare no conflicts of interest.


[1] Yang, S.Q., Wang, H.P., Guan, L.Z., Qu, L.Y. and Li, M.Q. (2008) Effect evaluation on health education for the elderly with high-risk potential of osteoporosis in Zhongguancun Community of Beijing. Chinese Journal of Health Education, 24, 593-595.
[2] Liu, Z.L., Huang, J.G. and Liu, Z.J. (2007) The discussion and analysis for the mechanism and prevention of osteoporosis in women after menopause. China Medical Her, 24, 157-158.
[3] Hu, R., Zhou, Z.M., Zhai, D.Y., Yue, X.Y., Xu, G.L. and Liu, X.F. (2010) Awareness of hypertension among ischemic stroke survivors in the community: Survey and analysis. Postgraduate Medical Journal, 23, 167-170.
[4] Stolba, N. (2007) Towards a sustainable data warehouse approach for evidence-based heathcare. PhD Thesis, Vienna University of Technology, Vienna.
[5] Wang, H.X., Wang, H.L. and Li, F.H. (2011) Application of nursing information system. Postgraduate Medical Journal, 24, 72-74.
[6] Zhang, J.X., Wang, X.L., Chang, S.F., Li, R., Wang, H.J. and Kan, X.L. (2010) Research and construction for data warehouse of TCM medical record in cold. Jiangsu Journal of Traditional Chinese Medicine, 42, 66-68.
[7] Yang, J.Q. and Jiang, X.Y. (2005) Risk factors and their assessment of osteoporosis. Journal of Fujian Medicine University, 39, 237-239.
[8] Chen, W.C., Han, Z.Z., Zhang, L. and Yang, J. (2008) Research on developing information system with new concept for community health services. Journal of Chinese General Practice, 11, 1414-1416.
[9] Zhao, L., Xin, Z.Q. and Yu, W.Z. (2009) Clinic use of information management system of osteoporosis patient. Modern Hospital, 9, 142-144.
[10] Yu, J.F., Shen, Y.C., Zhou, B.K., Chen, X., Wang, Q. and Gu, Y.F. (2012) Remote management system of osteoporosis community intervention and design of data warehouse. Journal of Chinese General Practice, 15, 26-28.
[11] Pan, X.Y. (2010) Survey data analysis for health needs of urban community. Chinese Communication Doctors, 12, 165.

Copyright © 2024 by authors and Scientific Research Publishing Inc.

Creative Commons License

This work and the related PDF file are licensed under a Creative Commons Attribution 4.0 International License.