Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Datta, A., Thomas, H.: The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses. Decision Support Systems 27(3), 289–301 (1999)
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)
Lin, Y.J., Tian, W.H.: Urbanization and the utilization of outpatient services under National. Health Policy 103, 236–243 (2011)
Malinowski, E., Zimányi, E., et al.: Advanced Data Warehouse Design: From conventional to spatial and temporal applications. Springer, Heidelberg (2008)
Rainardi, V.: Building a Data Warehouse: With Examples in SQL Server. Springer, New York (2008)
Widom, J.: Research Problems in Data Warehousing. In: CIKM Conference on Information and Knowledge Management, pp. 25–30. ACM, Baltimore (1995)
Yang, N.P., Chan, C.L., Yu, I.L., Lee, C.Y., Chou, P.: Estimated prevalence of orthopaedic fractures in Taiwan-Across-sectional study based on nationwide insurance data. Injury, Int. J. Care Injured 41(12), 1266–1272 (2010)
Yang, N.P., Chen, H.C., Phan, D.V., Yu, I.L., Chan, C.L., Chou Renn, J.H.: Epidemiological survey of orthopedic joint dislocations based on nationwide insurance data in Taiwan, 2000-2005. BMC Musculoskeletal Disorders 12(1), 253–260 (2011)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chan, CL., Van, P.D., Yang, NP. (2012). Building a Decision Support Tool for Taiwan’s National Health Insurance Data – An Application to Fractures Study. In: Watada, J., Watanabe, T., Phillips-Wren, G., Howlett, R., Jain, L. (eds) Intelligent Decision Technologies. Smart Innovation, Systems and Technologies, vol 15. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-29977-3_41
Download citation
DOI: https://doi.org/10.1007/978-3-642-29977-3_41
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-29976-6
Online ISBN: 978-3-642-29977-3
eBook Packages: EngineeringEngineering (R0)