醫院經營面臨了制度的急劇改變，經營效率和競爭優勢攸關著其生存的成敗，如何維繫其永續發展及提升醫療品質因應時代的變遷端賴有效的策略擬定。商業智慧（Business Intelligence，BI）的導入提供了決策者有效的策略方針，而資料倉儲（Data Warehouse，DW）的整合資訊，提供了企業商業智慧中最重要的核心基礎。與應用平衡計分卡（Balanced Score Card，BSC）具體擬定的組織目標、績效相結合，支援高階主管決策系統、決策支援系統、資料探勘等領域的應用，協助決策者解讀非結構化資訊，為其制定企業策略方針提供有效價值之參考。建構資料倉儲的過程，充分展現了多項資訊技術的整合應用，任一環節的技術，均關係著資料倉儲的成敗。
　　本研究探討醫療資料倉儲的建構方法，以實務應用與未來發展為首要考量。採用Tom（1996）所提的螺旋型生命週期開發方法，以平衡計分卡財務、顧客、內部流程及學習與成長等四個構面為分析指標，規劃醫療資料倉儲所需的主題目標、設計實體關連表格的星狀綱要（Star schema）；並透過萃取/轉換/載入（Extract-Transform-Load，ETL）機制，定時從線上醫院資訊系統萃取資料，經過轉換與清理等處理後，載入資料倉儲。最後，利用線上分析處理工具，以多維度的方式呈現平衡計分卡的指標，展現資料倉儲的效率。在本研究的系統實作中提供了圖表化的介面、資料向下鑽取、資料向上匯合、燈號控制等功能，藉以加強異常資訊的警示，讓決策者可以在第一時間掌握最新狀況，做出最佳決策。

　　Facing the changes of the structures and systems, hospitals have to develop strategies to improve their effectiveness to increase the competitiveness. To maintain the sustainability and improve the quality of services, hospitals need good strategies. The “business intelligence” is an effective tool for policy makers in hospitals. The integrated information of the data warehouse is the core of the business intelligence. However, the construction of a data warehouse relies on the integration of multiple information techniques. It must follow the organizational goals and performance, which are developed by the application of the balanced score card. In addition, a data warehouse must be developed to support the decision-making systems of the executives and data mining.
　　The research focuses on how to construct a medical data warehouse, which is practical and sustainable. There are four characteristics of the medical data warehouse the research proposes. First, the construction of the medical data warehouse is inspired by the idea of the spiral life cycle. Second, the medical data warehouse follows the four dimensions, finance, customers, internal processes, and learning and growth, suggested by the balanced score card. The programmers further develop object-oriented relationship database to collect data to fit in the four dimensions. Third, the system adopts the extract-transform-load mechanism. It frequently retrieves data from the internal information system of the hospitals, processes and converts the data, and transfers them to the data warehouse. Finally, the medical data warehouse uses the online analytical tools to demonstrate the indicators derived from the balanced score card. More importantly, the medical data warehouse provides a graphical interface to show the data retrieving and the data integration. It also includes the signal control to warn the users when the data warehouse encounters the extraordinary information.

中文部份
[1] 中央健康保險局，”全民健保財務現金收支分析”， http://www.nhi.gov.tw/01intro/statistic/work9401.pdf , 2005
[2] 王河清、童超塵，”運用平衡計分卡建構新策略管理制度-以醫療產業為例”，醫院，第34卷，第4期，第7-15頁，2001
[3] 陳朝智，”化資料為決策、商業智慧點石成金”，資訊與電腦，第258期，第16-23頁，2002
[4] 黃永吉，”醫院建構平衡計分卡之研究－以雲林縣某地區教學醫院為例”，雲林科技大學工業工程與管理研究所碩士論文，2002
[5] 賴威齊，”以平衡計分卡為基礎建構網際網路環境下之醫院高階主管資訊系統及其實證研究”，國立清華大學工業工程與工程管理學系碩士論文，2002
[6] 吳姝蒨，”商業智慧的應用面向與導入關鍵要素”，電子化企業經理人報告，第32期，第12-22頁，2002
[7] 欒斌，”商業智慧的三大手法”，經濟部商業現代化雙月刊，第50期，第34-38頁，2002
[8] 蘇隄，”企業建構資料倉儲的六項關鍵議題”，電子化企業經理人報告，第7期，第31-36頁，2000
[9] 李卓翰，”資料倉儲理論與實務”，學貫，第3-7頁，2003
[10] 葉秀經，”平衡計分卡展效益”，能力雜誌，第114期，第114-120頁，2004
[11] 朱道凱譯，”平衡計分卡：資訊時代的策略管理工具”，臉譜出版，第47-48頁，2003
[12] 陳依蘋，”平衡計分卡運用與趨勢－創始人Robert Kaplan來台演講內容精要”，會計月刊，第224期，第68-82頁，2004
[13] 黃彩玉，“以平衡計分卡建立學齡前兒童氣喘照護評量”，國防醫學院護理研究所，2002
[14] 林佳靜，”醫院對平衡計分卡之認知與現況分析”，國立陽明大學醫務管理研究所，2002

英文部份
[15] Robert S. Kaplan & David P. Norton, “The Balanced Scorecard- Measures that Drive Performance”, Harvard Business Review, Jan-Feb 1992.
[16] C. J. White, “The Business Intelligence Software Solution”，Database Associates International, Inc., Version 3, March 1999
[17] W. H. Inmon, “Building the Data Warehouse”, New York: John Wiley& Sons, 1993.
[18] R. Kimball, M. Ross and W. Thornthwaite, “The Data Warehouse Lifecycle Toolkit,” NewYork: John Wiley & Sons, Inc., 1998.
[19] R. Elmasri and S. B. Navathe, “Fundamentals of Database System”, USA : Addison-Wesley, Third Ed., 2000.
[20] Robert S. Kaplan & David P. Norton, ”Using the Balanced Scorecard as a Strategic Management System”，Harvard Business Review，Jan-Feb 1996，p.76
[21] Turban, McLean, Wetherbe, “Information Technology for Management: Making Connections for Strategic Advantage “, John Wiley & Sons, Inc, NewYork, 1999.
[22] J. Han and M. Kamber, “Data Mining: Concepts and Techniques, San Francisco: Morgan Kaufmann Publishers”, 2000.
[23] Jake Sturm, “Data Warehousing with Microsoft SQL Server 7.0: Technological Reference,” Microsoft Press, 1999.