利用資料倉儲和J2ME技術設計花卉供應鏈系統的行動決策支援裝置

Abstract

花卉批發資訊分享熱線是利用資料倉儲和J2ME技術在花卉供應鏈上所建構的行動決策系統。系統上的資料流可分為三種狀態，擷取，正規化與應用。對資料擷取而言，是透過網際網路從台北花市收集資料；對正規化而言，是透過各種資料轉換將資料儲存到三階正規化資料庫，並利用來建構資料倉儲；對應用而言，本論文建構了四大模組。首先是使用者可直接從系統中獲得批發市場的資訊；其二可利用網路基礎的線上分析功能來觀察花卉交易的統計資訊；第三是批發市場可利用資料倉儲來進行到貨量控制；最後供應人可利用連結到系統的行動電話，來進行投資組合決策。本論文實作花卉批發資訊分享熱線，試以建立完整的現代化花卉供應鏈。

Data warehouse and J2ME techniques are proposed for constructing a mobile decision support system entitled flower Wholesale Information Sharing Hotline (flower-WISH) in flower supply chain. The data flows in flower-WISH are classified into three stages: acquisition, normalization, and application. At the acquisition stage, the data are collected from Taipei Flowers Auction Co., Ltd. through Internet. At the normalization stage, the data are stored in a 3rd normal form database through several data transformations. Then the database is used for constructing a data warehouse. At the application stage, four specific modules are developed. First, any user can retrieve the flower marketing information from flower-WISH directly. Second, the statistics of flower trading can be observed from the Internet-based On-Line Analytical Process (OLAP). Third, the wholesale market can monitor and control the arrival flower volume from the data warehouse. Fourth, the suppliers can make the portfolio decision using a mobile phone whenever the phone is connected to the flower-WISH.