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

Objective: To investigate the remote management system of osteoporosis community intervention and design the data warehouse. Materials and 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 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, as well as large quantities of original research data and preliminary health statistic results.