高效能批發資訊分享熱線的建構

Abstract

近來，在花卉產業中，以資料倉儲技術為建構基礎的花卉批發資訊分享熱線已經受到重視與普，而這樣的普及也需求建構一個更有效率的資料倉儲系統。本論文提出五種建構方法來增進彰化花卉批發資訊分享熱線的效能。第一，將資料轉換服務系統以維度與衡量值為界，分別獨立，減少系統維修時的複雜度。第二，新增『星期』維度，讓使用者有多一個維度的分析空間。第三，結合雙主鍵的設計，解決沒有三階正規化資料的新增、更新的問題。第四，例外資料庫的設計，讓有瑕疵的資料能夠匯入，以待後續處理。第五，為了防止駭客攻擊及提升伺服器的效能，架設了硬體防火牆及更新伺服器主機。結合了上述五種建構方式，得到令人讚賞的結果，不但大大的改善系統效能，也減少了系統故障的次數。

Data warehouse based Wholesale Information Sharing Hotline (WISH) has become more popular in flower industry recently. Also this popularity requests to construct a more efficient data warehouse for satisfying more and more users crowded in on-line. In this thesis, five methods are proposed for improving the performance of data warehouse at Changhua Flower ‘Wholesale Market. First, the measured and dimensional data are transformed separately in Data Transformation Service (DTS) stage for reducing the diagnosis complexity in maintenance. Second, a “week” dimension is added for providing more service on-line. Third, compound and surrogate keys are designed in solving the update problem for input data coming from database without 3rd normal form. Fourth, an exception database is used to store unexpected input data for future processing. Fifth, better hardware and firewall are set up for preventing attacks from hackers. The combination of the proposed methods shows amazing research results not only for improving the performance but also reducing system failures.