完整後設資料紀錄
DC 欄位語言
dc.contributor.author許耿豪en_US
dc.contributor.authorKeng-Hao Hsuen_US
dc.contributor.author梁高榮en_US
dc.contributor.authorGau-Rong Liangen_US
dc.date.accessioned2014-12-12T02:48:11Z-
dc.date.available2014-12-12T02:48:11Z-
dc.date.issued2004en_US
dc.identifier.urihttp://140.113.39.130/cdrfb3/record/nctu/#GT009233546en_US
dc.identifier.urihttp://hdl.handle.net/11536/77118-
dc.description.abstract拍賣時段與花卉底價對於切花拍賣價格有何影響?這是在花卉批發市場中經常被提及的兩個問題。而問題的答案涉及從一給定的資料庫中多項複雜的交易資料處理。舉例來說,要驗證時段與底價對花卉拍賣價格的影響必須透過各種維度的上捲、下挖、切丁、切片以及資料的篩選、排序等動作。本論文基於減少對交易資料複雜的處理,根據已有的資料庫建置一線上分析處理系統(OLAP)。建構的過程包含三個步驟;第一步為設計三階正規化綱要整合已存在的資料;第二步透過資料庫綱要轉化為雪花綱要圖建立一資料超市;第三步為透過資料超市產生一超方體供線上分析處理系統使用。驗證花卉拍賣價格與時段、底價有何關聯所需的資料便可輕鬆的線上分析處理系統取得。本論文中不僅僅架構了線上分析處理系統,更透過統計軟體分析對在時段與底價影響下切花拍賣價格的變化。zh_TW
dc.description.abstractWhat are the timing and reserve price effects to the price of auctioned cut flowers? These are two frequently asked questions in flower wholesale marketplaces. Answering both questions involves many complicated manipulations of transactional data from a given database. For example, the hypothesis may be tested under various dimensions with level roll-up/drill-down, category slicing/dicing, data screening and sorting, etc. In this thesis, an On-Line Analytical Processing (OLAP) system constructed from the given database is proposed for reducing the complexity of the manipulation problem for transactional data. The construction procedure consists of three steps. First it is to design a 3rd normal form database schema for integrating consistent data. Second the database schema is transformed into a snowflake schema for building a data mart. Third a hypercube is generated from the data mart for the OLAP use. Then price-related hypotheses under the timing and reserve price effects can be easily tested with the data from the OLAP system. As a result, this thesis not only constructs the OLAP system but also tests many hypothesis for evaluating the timing and reserve price effects to the price of auctioned cut flowers.en_US
dc.language.isozh_TWen_US
dc.subject價格分析zh_TW
dc.subject花卉拍賣zh_TW
dc.subject線上分析處理zh_TW
dc.subject底價影響zh_TW
dc.subject時段影響zh_TW
dc.subjectPrice Analysisen_US
dc.subjectAuctioned Floweren_US
dc.subjectOn-Line Analytical Process, OLAPen_US
dc.subjectReserve Price Effecten_US
dc.subjectTiming Effecten_US
dc.title在時段與底價影響下進行線上分析處理導向的切花拍賣價格分析zh_TW
dc.titleOLAP Based Price Analysis of Auctioned Cut Flowers under Timing and Reserve Price Effectsen_US
dc.typeThesisen_US
dc.contributor.department工業工程與管理學系zh_TW
顯示於類別:畢業論文


文件中的檔案:

  1. 354601.pdf
  2. 354602.pdf
  3. 354603.pdf
  4. 354604.pdf
  5. 354605.pdf
  6. 354606.pdf
  7. 354607.pdf
  8. 354608.pdf
  9. 354609.pdf
  10. 354610.pdf
  11. 354611.pdf

若為 zip 檔案,請下載檔案解壓縮後,用瀏覽器開啟資料夾中的 index.html 瀏覽全文。