Building a Decision Support Tool for Taiwan’s National Health Insurance Data – An Application to Fractures Study

  • Chien-Lung Chan
  • Phan Dinh Van
  • Nan-Ping Yang
Conference paper
Part of the Smart Innovation, Systems and Technologies book series (SIST, volume 15)


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.


Decision support system Data warehouse Taiwan’s National Health Insurance Data Data transfer SQL Server 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    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)CrossRefGoogle Scholar
  2. 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
  3. 3.
    Lin, Y.J., Tian, W.H.: Urbanization and the utilization of outpatient services under National. Health Policy 103, 236–243 (2011)CrossRefGoogle Scholar
  4. 4.
    Malinowski, E., Zimányi, E., et al.: Advanced Data Warehouse Design: From conventional to spatial and temporal applications. Springer, Heidelberg (2008)MATHGoogle Scholar
  5. 5.
    Rainardi, V.: Building a Data Warehouse: With Examples in SQL Server. Springer, New York (2008)Google Scholar
  6. 6.
    Widom, J.: Research Problems in Data Warehousing. In: CIKM Conference on Information and Knowledge Management, pp. 25–30. ACM, Baltimore (1995)Google Scholar
  7. 7.
    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)CrossRefGoogle Scholar
  8. 8.
    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)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2012

Authors and Affiliations

  • Chien-Lung Chan
    • 1
  • Phan Dinh Van
    • 2
  • Nan-Ping Yang
    • 3
  1. 1.Department of Information Management, College of InformaticsYuan Ze UniversityTaoyuanTaiwan
  2. 2.Community Health Research Center & Institute of Public HealthNational Yang-Ming UniversityTaipeiTaiwan
  3. 3.Department of Medical Research & Department of Orthopedic SurgeryTaoyuan General Hospital, Department of HealthTaoyuanTaiwan

Personalised recommendations