1. You are Here：

标题: 透过刀锋伺服器及SSIS技术降低台湾花卉资料仓储的维护成本
Reducing the Maintenance Cost of the Flower Data Warehouse in Taiwan through Blade Server and SSIS Technologies
作者: 張弘
Chang, Hung
梁高榮
Liang, Gau-Rong
工業工程與管理學系
关键字: 资料仓储;维护成本;刀锋伺服器;SSIS整合服务;花卉产业;Data Warehouse;Maintenance Cost;Blade Server;SQL Server Integration Services;Floral Industry
公开日期: 2011
摘要: 本论文提出两种方法来降低台湾花卉产业的资料仓储的维护成本。第一种方法是以一台刀锋伺服器取代许多传统的电脑伺服器。对硬体方法来说，一个很明显的改变是减少了系统的元件数目。这不仅使系统更可靠，也更容易进行空间布署。又简化的管理工作在本质上会降低维护成本。第二种方法是透过新软体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.
URI: http://140.113.39.130/cdrfb3/record/nctu/#GT079933519
http://hdl.handle.net/11536/50083
显示于类别：Thesis


Related Contents
Loading...