台灣花卉批發市場交易資訊流的標準化設計

Abstract

規模經濟是用以降低營運成本的一項重要因素。在本篇論文中，資訊流的標準化即是為了讓五家花卉批發市場達到經濟規模的目的。更精確地來說，本論文提出一套三階段程序作為設計標準化資訊流的手法。首先在資料蒐集階段，透過各批發市場原有的資料庫或作業流程IDEF0圖兩方面萃取花卉交易資訊。接著在正規化階段，交易資訊經由分解法或合成法達到三階正規化，然後以IDEF1X圖的形式呈現各市場的正規化模型。最後在標準化階段，本論文比較各家市場的正規化資料庫以設計一套適用於五家花卉批發市場的標準化與通用性資料庫系統。作為研究結果，本論文總結標準化交易資訊流系統在資料表、資料屬性及資料規格三方面的數量規格，除此之外亦將標準化的IDEF1X資料庫規格導入SQL Server 2000商業資料庫系統呈現此系統之可行性。

Economies of scale are an important factor for reducing operating cost. In this thesis, standardization of information flows is used for achieving the goal of economic scale for five flower wholesale marketplaces in Taiwan. More precisely a three-stage procedure is proposed for designing standardized information flows. At the data acquisition stage, the flower transactions are collected from the given legacy database or through IDEF0 diagrams for operations in each marketplace. At the normalization stage, transactions in the third normal form are generated using decomposition or synthesis algorithms. Next all the normal forms are represented by IDEF1X diagrams. At the standardization stage, all the IDEF1X diagrams are compared in order to generate a standard and universal one which can be compatibly used for all five flower wholesale marketplaces. As research results, the number of entities, attributes, and types of the standard information flows are summarized. Also the standard IDEF1X diagram has been used for implementing a commercial database named SQL Server 2000 to show its feasibility.