透過刀鋒伺服器及SSIS技術降低台灣花卉資料倉儲的維護成本

Abstract

本論文提出兩種方法來降低台灣花卉產業的資料倉儲的維護成本。第一種方法是以一台刀鋒伺服器取代許多傳統的電腦伺服器。對硬體方法來說，一個很明顯的改變是減少了系統的元件數目。這不僅使系統更可靠，也更容易進行空間佈署。又簡化的管理工作在本質上會降低維護成本。第二種方法是透過新軟體SQL Server 整合服務(SQL Server Integration Services, SSIS)取代傳統的資料轉換服務(Data Transformation Services, DTS)軟體。資料轉換服務和SSIS兩者皆是用於資訊系統中執行萃取、轉換、載入(Extract-Transform-Load, ETL)的軟體。相較於資料轉換服務，SSIS在ETL資料的處理及診斷能力上提供了更多的功能模組。SSIS的效能自然地降低了維護成本。為了彰顯此提案的可行性，本論文利用此二方法建立了一個小型的花卉資料倉儲。其研究結果可以觀察到維護成本的降低。

Two approaches to reducing the maintenance cost for the data warehouse of floral industry in Taiwan are proposed. One is to replace many traditional computer servers by a single blade server. An obvious change of this hardware approach is the reduction of system components. This makes not only the underlying system more reliable but also the space layout easier. Moreover simplified management tasks inherently reduce the maintenance cost. The other is to replace the legacy software Data Transformation Services (DTS) by the innovative software SQL Server Integration Services (SSIS). Both DTS and SSIS are software products used in information system for Extraction-Transformation-Loading (ETL) purpose. Compared with DTS, however, SSIS offers more functional modules for manipulation and diagnosing capability for ETL data. The effectiveness of SSIS makes the maintencnce cost down naturally. For showing the feasibility of the proposal, a pilot floral data warehouse has been implemented by both approaches together. The decreasing maintenance cost is observed in this research study.