Building a Decision Support Tool for Taiwan’s National Health Insurance Data – An Application to Fractures Study
This study aims to construct a decision support tool for handling the Taiwan’s National Health Insurance data from the researchers’ perspectives. The National Health Research Institute (NHRI) provides data for researchers to conduct health related research by applications. Since the provided insurance data is in unstructured text, it is necessary to transfer those data into a data warehouse or data mart such as SQL Server. However, the data retrieval and synthesis are still very complicated through a number of complex SQL queries to export the final figures and tables. This causes a major problem for doctors, medical and insurance researchers who are not familiar with SQL Server. Therefore, this study proposes the tools to extract and save the data in SQL Server 2008, which facilitates the data synthesis. The tools not only support doctors, medical and insurance researchers to obtain the final analysis for nationwide epidemiology but also help them to make good decisions in building health care strategies.
KeywordsDecision support system Data warehouse Taiwan’s National Health Insurance Data Data transfer SQL Server
Unable to display preview. Download preview PDF.
- 2.Lee, Y.H., Hsu, Y.N., Yu, I.L., Phan, D.V., Chou, P., Chan, C.L., Yang, N.P.: Treatment incidence of and medical utilization for hospitalized subjects with pathologic fractures in Taiwan-Survey of the 2008 National Health Insurance Data. BMC Health Services Research 11(1), 230–236 (2011)CrossRefGoogle Scholar
- 5.Rainardi, V.: Building a Data Warehouse: With Examples in SQL Server. Springer, New York (2008)Google Scholar
- 6.Widom, J.: Research Problems in Data Warehousing. In: CIKM Conference on Information and Knowledge Management, pp. 25–30. ACM, Baltimore (1995)Google Scholar