An Effective Approach for Constructing Wholesale Information

碩士 === 國立交通大學 === 工業工程與管理系所 === 92 === 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 thes...

Full description

Bibliographic Details
Main Author: 陳楓凱
Other Authors: 梁高榮
Format: Others
Language:zh-TW
Published: 2004
Online Access:http://ndltd.ncl.edu.tw/handle/55695782383885314770
id ndltd-TW-092NCTU5031032
record_format oai_dc
spelling ndltd-TW-092NCTU50310322015-10-13T13:04:21Z http://ndltd.ncl.edu.tw/handle/55695782383885314770 An Effective Approach for Constructing Wholesale Information 高效能批發資訊分享熱線的建構 陳楓凱 碩士 國立交通大學 工業工程與管理系所 92 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. 梁高榮 2004 學位論文 ; thesis 100 zh-TW
collection NDLTD
language zh-TW
format Others
sources NDLTD
description 碩士 === 國立交通大學 === 工業工程與管理系所 === 92 === 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.
author2 梁高榮
author_facet 梁高榮
陳楓凱
author 陳楓凱
spellingShingle 陳楓凱
An Effective Approach for Constructing Wholesale Information
author_sort 陳楓凱
title An Effective Approach for Constructing Wholesale Information
title_short An Effective Approach for Constructing Wholesale Information
title_full An Effective Approach for Constructing Wholesale Information
title_fullStr An Effective Approach for Constructing Wholesale Information
title_full_unstemmed An Effective Approach for Constructing Wholesale Information
title_sort effective approach for constructing wholesale information
publishDate 2004
url http://ndltd.ncl.edu.tw/handle/55695782383885314770
work_keys_str_mv AT chénfēngkǎi aneffectiveapproachforconstructingwholesaleinformation
AT chénfēngkǎi gāoxiàonéngpīfāzīxùnfēnxiǎngrèxiàndejiàngòu
AT chénfēngkǎi effectiveapproachforconstructingwholesaleinformation
_version_ 1717729643287543808