利用資料整合平台建構自動化資料倉儲系統

資料倉儲系統的目的在於整合分散在企業中的資料，提供各種商業智慧系統或是OLAP分析工具進行分析時所需要的資料，讓決策者能夠得到有效的決策輔助資訊。在高度競爭的市場下為了創造更多的利潤，企業不能依靠單一銷售據點，因此跨國的多據點銷售模式隨之誕生。本研究以連鎖3C跨國零售業者為研究對象，該企業由於銷售據點的分散，使得企業面臨資料分散、不一致、缺乏即時性等問題。由於決策資訊的不完整，導致決策者決策上的錯誤。基於這些原因，本研究利用Oracle資料庫系統的特性，建立一個以提升資料整合速度及效能的資料整合平台，本論文同時建構一個適用於高階主管資訊系統的資料倉儲。這個資料倉儲系統能夠自動偵測資料異動、資料複製、整合分散式的資料庫，完成一個即時的資訊系統。

關鍵字

分散式資料庫、資料整合、資料倉儲、觸發程式、商業智慧

並列摘要

The purpose of data warehouse is to integrate all the data distributed over the enterprise, provide the decision makers with various business intelligence systems or OLAP tool to analyze the required data, and with the effective decision information. At the highly competitive markets and to create more profits, enterprises can't depend on single selling site, and therefore multiple selling sites organization across multiple nations are thereupon created. This research is based on the enterprise of 3C franchises across nations, which is composed of so scattered retail branches at the disperse locations that the enterprise face the distributed, inconsistent, lacking in-time data, and etc. The enterprise will make a mistake in decision making due to the incomplete data. Based on the reasons mentioned above, this research will build an integrated data base system platform to enhance the speed and accuracy of information, and implement a EIS data warehouse by using the characteristic of Oracle database. This implemented data warehouse system will provide the enterprise with automatically detecting data transaction, automatic data duplication, integrating distributed data base, and the complete real time information system.

並列關鍵字

Distributed Database, Integrated Database, Data warehouse, Trig Programming, Business Intelligence

參考文獻

1. Azwina M. Yusof,” An on-line Purchasing and Decision Support System for Distributed Retail Chain Stores”, Proceedings of the 6th international conference on Electronic commerce, 2005, pp.187 - 195.

6. Corporation, 1993.

7. Charles Dye, “Oracle Distributed Systems”, New York: O’REILLY, 1999.

10. Hoven, J. V. D., “Data Warehousing: Bringing It All Together,” Information System Management, spring 1998, pp.92-95.

11. I-Ling Yen, R. Paul and Kinji Mori., "Toward Intimated Methods for Hi&-Assurance Systems," IEEE Computer, vol. 31-4, 1998, pp.32-34.

國際替代計量

利用資料整合平台建構自動化資料倉儲系統

未授權

主題瀏覽