Using Data Warehouse to Discover the Relation between TW-DRG and Pharmacology

Abstract:

This research explores the relation between TW-DRG and pharmacological information by using the concept of data warehouse as a basis. It is hoped to assist doctors, under the condition that patients’ rights will not be affected, to replace the high-priced pharmaceuticals with the pharmaceuticals which are low-priced yet with the same pharmacological and pharmacodynamic effects, in order to reduce the medication cost in medical institutions and hospitals. From this result, we learn that the differences among doctors’ medication habits can be offered to hospitals and doctors for policy analysis on medication. Also, doctors can make appropriate adjustments in medication acts and find out the replaceable pharmaceuticals so that the pharmaceutical cost can be lowered.

• Periodical: Key Engineering Materials (Volumes 474-476)
• Pages: 938-942
• DOI: https://doi.org/10.4028/www.scientific.net/KEM.474-476.938
• Online since: April 2011
• Authors: Chih Sheng Chen, Guan Yu Chen, Jing Wun Hong, Ji Rou Jhang, Jia Yi Liou, Syuan Zih Wu
• Keywords: Data Warehouse (DW), MDC, Pharmacological Cost, Pharmacology, TW-DRG

References

[1] Bureau of National Health Insurance(2008). Tw-DRG general payment. Retrieved from http: /www. nhi. gov. tw/webdata/AttachFiles/Attach_9015_1_Tw-DRG general payment. doc.

[2] Bureau of National Health Insurance(2008). Tw-DRG paid programming instructions. Retrieved from http: /www. nhi. gov. tw/webdata/AttachFiles/Attach_9015_1_Tw-DRG paid programming instructions _(960201). doc.

[3] Devlin, B. A., and Murphy, P. T. (1998). An architecture for a business and information system. IBM Systems Journal, 27(1), pp.60-80.

[4] Gardner, S. R. (1998). Building the Data Warehouse. Communications of the ACM, 41(9), pp.52-60.

[5] Hoven, J. V. D. (1998). Data Warehousing: Bringing It All Together. Information System Management, pp.92-95.

[6] Kimball, R., Reeves, L., Ross, M., and Thornthwaite, W., The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses, N.Y.: John Wiley & Sons, Inc., (1998).

[7] Lee, C. H. (2007). Study of an Architecture-Oriented Database Warehousing (Unpublished master's thesis). National Sun Yat-sen University, Kaohsiung, Taiwan.

[8] Lin, L. C. (2005). The changes analysis of the respiratory system disease pattern in the hospital of the east district area of Taiwan during Taiwan's DRGs weight announcemen (Unpublished master's thesis). Tzu Chi University, Hualien, Taiwan.

DOI: 10.17140/ooj-1-101

[9] Murtaza, A. (1998). A framework for developing enterprise data warehouses. Information Systems Management, pp.21-26.

DOI: 10.1201/1078/43186.15.4.19980901/31147.4

[10] Paulraj Ponniah (2002). Data warehousing fundamentals, 2nd Edition. Hoboken, NJ: Wiley.

[11] Richard Koch (1997). The 80/20 Principle. London, England: Nicholas Brealey Publishing.

[12] Watson, Hugh J., Annino, David A., Wixom, Barbara H., Avery, K. Liddell, and Rutherford, Mathew, (2001). Current Practices in Data Warehousing. Information Systems Management, pp.47-55.

DOI: 10.1201/1078/43194.18.1.20010101/31264.6

[13] Wei, H. M. (2004). Quality of Claim Management in Healthcare Organizations：A Study on the Consistency of ICD Coding in a Medical Center (Unpublished master's thesis). National Yang-Ming University, Taipei, Taiwan.

[14] Wu, H. W. (2003). Establishment of Data Warehouse in Hospital Executive Information Systems－ A Case Study of the Self-management in a Regional Hospital (Unpublished master's thesis). Providence University, Taichung, Taiwan.