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.
Cite this paper
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.
 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.
 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.
 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.
 Stolba, N. (2007) Towards a sustainable data warehouse approach for evidence-based heathcare. PhD Thesis, Vienna University of Technology, Vienna.
 Wang, H.X., Wang, H.L. and Li, F.H. (2011) Application of nursing information system. Postgraduate Medical Journal, 24, 72-74.
 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.
 Yang, J.Q. and Jiang, X.Y. (2005) Risk factors and their assessment of osteoporosis. Journal of Fujian Medicine University, 39, 237-239.
 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.
 Zhao, L., Xin, Z.Q. and Yu, W.Z. (2009) Clinic use of information management system of osteoporosis patient. Modern Hospital, 9, 142-144.
 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.
 Pan, X.Y. (2010) Survey data analysis for health needs of urban community. Chinese Communication Doctors, 12, 165.