臺灣博碩士論文加值系統

在現今全球劇烈競爭的經濟環境中，不論是哪個企業，都比過去面臨了更為艱難的經營挑戰與經營環境。再加上知識經濟時代的來臨，使得所有企業越來越重視企業內部資訊的管理及運用，因此資料倉儲已然成為企業最好的解決方案。不過，隨著資料倉儲的當紅，投入者眾，資料倉儲存在著各家對結構面與流程面定義不同的問題，不僅讓軟體的建置成本增加，產品功能的不完善也使得軟體開發人員必須不斷的調整及修改軟體，更對企業的經營造成負面影響。
本研究主要目的是協助定義出資料倉儲開發的架構式模型，此模型能夠充份地提供開發時所需的資訊，使開發人員更容易瞭解及掌握整個資料倉儲的建構。在這個模型中，對於資料倉儲中之結構元素，結構元素之操作，及其結構元素間之連結、互動行為皆有詳細的描述。架構式的結構觀點及流程觀點，經由結構與流程合一的觀念，提供開發人員在資料倉儲開發中所需之資訊。這個模型提供了結構元素操作時所產生互動行為的資訊，可以讓開發人員對資料倉儲做適當的調整。
本論文可以分為三個部份：(1)架構式方法之理論基礎。(2)架構式模型之步驟說明。(3)提出一個新的架構式資料倉儲模型。本研究的貢獻除了定義出資料倉儲的結構元素，結構元素之操作，及其結構元素間之連結、互動行為，更提出架構式資料倉儲模型讓軟體開發人員能依據企業的需求建構出資料倉儲。後續研究方面，架構式資料倉儲的實作、測試與建構成本及成本效能等尚有其他值得進一步討論的空間。此外資料倉儲中所包含的商業智慧、資料超市、資料挖掘、線上分析處理等軟體建構，均可以為後續研究的發展方向。

關鍵詞：資料倉儲，架構式資料倉儲，結構與流程合一，架構式模型。

The global economic environment nowadays becomes so competitive, all enterprises suffer a challenging and confronting adversity. Due to the knowledge economy era, all enterprises need to emphasize the internal information management and application. Therefore, the Data Warehousing (DW) turns into the best solution for an enterprise. As each enterprise has different structure and behavior views, the DW definition is required to adapt to the enterprise environment. To resolve this problem, an enterprise must increase the business cost, and system managers are demanded to modify the programs repeatedly.
Our research aims to assist the DW by defining a model of Architecture-Oriented Data Warehousing Framework (AODWF) which helps analyze and design the software with ease. The AODWF is to describe the structure and behavior in one unity. Using this approach of structure and behavior in one unity, developers would devise and adjust the DW more flexible and adaptable.
This thesis distinguishes into three parts. The first part is to introduce the architecture theory. The second part is to explain how to build up an architecture model. The third part is to propose the AODWF. Inside the thesis, DW structure elements, operations, and structure and behavior in one unity are elaborated. Also, using AODWF assists system developers to construct the DW for an enterprise. In the future, we would further our efforts on the implementation, testing, cost and performance management of the AODWF. The DW contains other software, for example, Business Intelligent, Data Mart, Data Mining and On-line analysis processing, etc. We may construct these software using the architecture model, too.
Key words：Data Warehousing, Architecture-Oriented Data Warehousing, Structure and Behavior in One Unity, Architecture Model.

論文提要..........................................................................................................................II
學位論文審定書..............................................................................................................III
碩士論文授權書..............................................................................................................IV
致謝辭..............................................................................................................................V
中文摘要..........................................................................................................................VI
Abstract...........................................................................................................................VII
表目錄..............................................................................................................................X
圖目錄..............................................................................................................................XI
第一章 緒論....................................................................................................................1
第一節 研究背景.....................................................................................................1
第二節 研究動機.....................................................................................................2
第三節 研究目的.....................................................................................................2
第四節 論文架構.....................................................................................................3
第二章 文獻探討............................................................................................................4
第一節 資料倉儲.....................................................................................................4
第二節 商業智慧...................................................................................................15
第三節 資料超市...................................................................................................17
第四節 資料探勘...................................................................................................18
第五節 線上分析處理...........................................................................................20
第六節 資料模式技術(Data Modeling Techniques).............................................22
第七節 架構學.......................................................................................................24
第三章 研究方法............................................................................................................31
第一節 研究步驟...................................................................................................31
第二節 研究方法與限制.......................................................................................32
第四章 架構式資料倉儲................................................................................................33
第一節 架構式資料倉儲塑模原則(AODWF)描述與說明..................................33
第二節 AODWF 建構資料倉儲結構元素..........................................................39
第三節 AODWF 建構資料倉儲結構元素操作..................................................42
第四節 AODWF 建構資料倉儲結構流程合一圖...............................................47
第五節 AODWF 建構資料倉儲互動行為流程的順序圖..................................49
第六節 架構式資料倉儲的優點...........................................................................60
第五章 架構式資料倉儲之優勢....................................................................................61
第一節 非架構式資料倉儲建置方式...................................................................61
第二節 架構式資料倉儲與非架構式資料倉儲比較...........................................63
第六章 結論與建議........................................................................................................67
第一節 結論...........................................................................................................67
第二節 研究貢獻...................................................................................................68
第三節 後續研究與建議.......................................................................................68
參考文獻..........................................................................................................................69
一、中文部分.........................................................................................................69
二、英文部分.........................................................................................................70

一、中文部分
[1] 林羿分，全球商業智慧市場發展現況，資策會資訊市場情報中心，April 2005。
[2] 張文明，架構導向之產銷管理探討，中山學資訊管理學系碩士論文，2004
[3] 陳世雄，架構式商業智慧軟體之研究，中山學資訊管理學系碩士論文，2005
[4] 游濬遠 ，異質性分析在商業智慧之應用--以流通業及製造業為例，台北科技大
學，商業自動化與管理研究所碩士論文，2003
[5] 遠擎管理顧問公司, 電子化企業經理人報告，商業智慧經理人手冊，遠擎管理
顧問公司，第32 期，民國91 年4 月
[6] 楊琇媛，利用資料倉儲與資料探勘技術於招生策略與學生特質分析之研究，中
原大學資訊管理學系碩士論文，2003
[7] 顏建南，企業策略架構模型之研究，中山學資訊管理學系碩士論文，2006
[8] 蘇隄, 企業建構資料倉儲的六項關鍵議題, 電子化企業經理人報告-電腦電話整
合是課服中心與資料倉儲, 第7 期, 頁31-35, 2000。
二、英文部分
[9] Arun Sen and Atish P. Sinha, A Comparision of Data Warehousing Methodologies,
COMMUNICATIONS OF THE ACM, March 2005/Vol. 48, No. 3
[10] CIO Insight, The Future of I.T.: What''s on Tap for 2007 and Beyond, January 16,
2007
[11] Frawley, W, J. et al. (Eds) , Knowledge discovery in databases :an overview, Menlo
Park , CA:AAAI Press/The MIT Press, 1991.
[12] Han, J., & Kamber, M.(2001). Data Mining: Concept and Techniques.
MorganKaufmann.
[13] Hoven, J. V. D., Data Warehousing: Bringing It All Together, Information System
Management, Spring 1998, pp.92-95.
[14] J. Han, M. Kamber, Data Mining Concepts and Techniques, Morgan Kaufmaun,
2001.
[15] 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.
[16] Matteo Golfarelli, Stefano Rizzi, Designing the Data Warehousing: Key Steps and
Crucial Issues, Journal of Computer Science and Information Management, Vol. 2,
No. 3, 1999.
[17] Michael J. A. Berry, Gordon Linoff, Data Mining Techniques for Marketing, Sale,
and Customer Support, Wiley, 1997
[18] Paulraj Ponniah, Data warehousing fundamentals, Wiley, 2001.
[19] Peter Eeles, The benefits of software architecting, 2006.
[20] S. Chaudhuri and U. Dayal, An overview of data warehouse and OLAP technology,
ACM SIGMOD Record, pp. 65-74, 1997.
71
[21] Stefano Rizzi,Jens Lechtenborger, Alberto and Juan Trujillo. Research in Data
Warehouse Modeling and Design: Dead or Alive? , DOLAP’06, November
10,2006,Arlington, Virginia,USA.
[22] Surajit Chaudhuri and Umesh Dayal, An overview of data warehousing and OLAP
technology, ACM SIGMOD Record, 26(1),March 1997.
[23] Tho Manh Nguyen, Sense & Response Service Architecture An Approach towards a
Real-time Business Intelligence Solution and its use for a Fraud Detection
Application, DOLAP’05, November 4–5, 2005, Bremen, Germany.
[24] Watson, Hugh J., Annino, David A., Wixom, Barbara H., Avery, K. Liddell, and
Rutherford, Mathew, Current Practices in Data Warehousing, Imformation Systems
Management, Winter 2001, pp.47-55.
[25] W.H. Inmon and C. Kelley, Rdb/VMS: Developing the Data Warehouse, QED
Publishing Group, Boston, Massachussetts, 1993.
[26] W.H. Inmon and R.D Hackathorn, Using the Data Warehouse, Wely-QED,1994.