近年來在金融機構合併法實施及台灣加入世界貿易組織後，造成證券業前所未有的激烈競爭，尤其對本土中小型券商的影響最為廢大。面對證券市場的快速變化、同業競爭激烈，高階主管對資訊的需求已不再是一般固定格式報表所能夠滿足，報表的需求更多樣化，且時效性更為急迫。 資料倉儲之父Inmon (1990)提出資料倉儲，強調資料的整合性，以支援管理決策。資料倉儲將異質的交易性資料庫資料透過萃取、淨化、整合的作業後，再將資料載入資料倉儲。由於資料倉儲是保留大量歷史性資料，透過線上分析處理技術，資料可以多維度的方式呈現，以協助決策者深入了解與掌握問題。 本論文研究方向為個案證券公司導入資料倉儲過程回顧，研究範圍包括：個案背景源起、需求分析、系統分析與設計、開發過程的困難及應變對策、系統預期效益與實質效益的比較。研究結果可為證券業導入資料倉儲時的參考。冀望透過對個案公司資料倉儲實務運作與相關文獻理論的整理，來達到以下目的： 一、運用Immon所提出的資料倉儲理論，探討個案公司資料倉儲的規劃與建構。 二、描述資料倉儲建置過程的困難點及解決對策。 Owing to implementation of the Financial Institutions Merger Act and joint of WTO, the competition between stockbrokerages become more and more severe, especially for local small-medium stockbrokerages. Facing such kind of rapid change and competitions, fixed format report can no longer satisfy senior management. The requirements for reports are various, and also efficient in timing. Inmon (1990), proposed Data Warehouse, emphasized the integration of data to support management’s decision. Data Warehouse transfers different transaction data base via selection, filter and integration process and re-load the data to Data Warehouse. As Data Warehouse stores lots of historical records, through on line analysis, information can be shown in various ways to help the decision maker to know and monitor the issue more deeply. The treatise is focus at recall of implementation process of Data Warehouse for stockbrokerages. The scope includes: background of case study, analysis of requirement, system analysis and design, difficulties in developing process and solutions, comparison for expected advantages and real benefit. The result may be as a reference for stockbrokerages when installing Data Warehouse. By case study of the real operation of Data Warehouse and related documents, the purpose of the treatise is : 1. Using Immon’s Data Warehouse theory, to discuss the case company’s Data Warehouse plan and structure. 2. The difficulties in processing and solutions.
