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...
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 |