Case Study of the Medical Decision-Making System ETL Abnormalities Processing Procedure

Abstract:

The primary purpose of this research is to resolve the problem of ETL operation failure in execution of ETL (Extraction, Transformation and Loading) by the medical decision-making system due to data content, system factors and defective program design, thereby affect online daily operation of the application system and even customer complaint. This research first research and develop how to record in database, whether successful or not, the number of ETL file conversion program (including tool and self-wrote PL/SQL program) execution process, data status, and execution time; followed by designing control mechanism and write Script for voluminous table restoration for automatic execution by the system; afterwards followed by research and develop system automatic execution of restoration to stop only the affected application programs of the table and design a restoration mechanism. Lastly, through verification, this R&D result would correctly restore the data and table required by ETL procedure.

• Periodical: Advanced Materials Research (Volumes 433-440)
• Pages: 894-899
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.433-440.894
• Online since: January 2012
• Authors: Hui Chen Tsai, Kuo Chung Lin, Ching Long Yeh
• Keywords: ETL, Medical Decision-Making System, Restoration Mechanism

References

[1] W. H. Inmon: Building the Data Warehouse, 2nd Ed., Wiley Compute Publishing, New York. (1996).

[2] W. H. Inmon: Using the Data Warehouse, Wiley , New York. (1994).

[3] R. Kimball: The Data Warehouse toolkit, Wiley Computer Publishing, New York. (1996).

[4] R. Kimball: Data Warehouse Design Solutions, Wiley Computer Publishing, New York. (1998).

[5] S. Chaudhuri and U. Dayal: An Overview of Data Warehousing and OLAP Technology, ACM SIGMOD Record, Vol. 26 (1997), pp.65-74.

DOI: 10.1145/248603.248616

[6] T. J. Teorey, Database Modeling and Design: The Fundamental Principles, 2nd Edition. San Francisco, CA: Morgan Kaufmann, (1994).

[7] S. F. Lin, Data Warehousing Design and Construction – the Case Study for a Garment Company, Master Thesis, Department of Computer Science and Engineering, Tatung University, Taipei, Taiwan. (2005).

[8] L. S. Hau, Supports for Decision Making Using Data Warehousing – By Example of Managing Criminal Data of Alien Workers, Master Thesis, Department of Information Management, Central Police University, Taoyuan, Taiwan. (2001).

[9] Y. M. Hung, A Generic Architecture for Active Data Warehouse Systems, Master Thesis, Department of Computer Science and Engineering, Tatung University, Taipei, Taiwan. (2000).

[10] C. H. Lin: The attention of construction material warehousing matters, Intelligent Times Record, Vol. 224 (1999), pp.94-99.

[11] C. H. Lin: Perspective material warehousing, Intelligent Times Record, Vol. 222 (1999), pp.98-103.

[12] Y. C. Chen, A Research on Building and Managing of Data Warehouse in Knowledge Management–Using K Company as Examples, Master Thesis, Department of Business Management, Da-Yeh University, Changhua, Taiwan. (2001).

[13] D. C. Ten and H. G. Chen: Management information system theory science and technology practice and application, Kings Information Publishers. (2003).