政大機構典藏-National Chengchi University Institutional Repository(NCCUR):Item 140.119/31084
English  |  正體中文  |  简体中文  |  Post-Print筆數 : 27 |  Items with full text/Total items : 113318/144297 (79%)
Visitors : 51105092      Online Users : 913
RC Version 6.0 © Powered By DSPACE, MIT. Enhanced by NTU Library IR team.
Scope Tips:
  • please add "double quotation mark" for query phrases to get precise results
  • please goto advance search for comprehansive author search
    •  Adv. Search
    Home ‧ Login ‧ Upload ‧ Help ‧ About ‧ Administer Goto mobile version
    政大典藏 > College of Commerce > Department of MIS > Theses >  Item 140.119/31084


    Please use this identifier to cite or link to this item: https://nccur.lib.nccu.edu.tw/handle/140.119/31084


    Title: 趨近一般化資料倉儲與資料探勘之效能評估模型
    Toward a More Generalized Benchmark Workload Model for Data Warehouse and Data Mining
    Authors: 邱士涵
    Chiu,Shih-Han
    Contributors: 諶家蘭
    季延平
    Seng,J.L.
    Chi,Y.P.
    邱士涵
    Chiu,Shih-Han
    Keywords: 資料倉儲
    資料探勘
    績效評估
    工作量模式
    data warehouse
    data mining
    performance evaluation
    benchmark
    workload model
    Date: 2006
    Issue Date: 2009-09-14 09:13:29 (UTC+8)
    Abstract: 隨著網際網路的發達以及資料庫技術的成熟，人們取得資料變得非常的容易，再加上許多網際網路的應用其實就是一個自動化的資料收集工具，資料量之大已幾近爆炸的程度。資料倉儲便是一種用來儲存大量歷史資料的資料庫，提供彙整或是統計的資訊，以提供決策使用的資訊技術。而資料探勘是從大量的資料當中把對於決策過程中有幫助的規則找出來，提供給管理人員做為決策的參考，開創新的商業契機。資料倉儲的效能表現對於使用者的工作效率有著深遠的影響。因此有些用以衡量與預測資料倉儲之效能與效率之工作量模式便孕育而生，一般稱之為績效評估工具，然而目前所公佈的一般資料倉儲績效評估工具是針對特定範圍領域建構出某些典型的領域規格，並沒有一個使用者需求導向的資料倉儲績效評估工具。在資料探勘方面，探勘結果的準確度比起資料探勘所花費的時間來得重要，目前卻沒有一個有效、使用者需求導向的工具來評估資料探勘結果的準確度。我們針對資料倉儲的效能評估以及資料探勘準確度評估，設計一個以使用者需求為導向的工作量模型，來評估資料倉儲與資料探勘工具。
    As growth of Internet and mature of database technology, people can get the data much easily than before. Many applications on Internet, in fact, are the tools of gather data automatically so that the amount of data is growing bigger and bigger. Data warehouse is one kind of database to store lots of historical data to offer statistical information for the information technology of decisions. Data mining is to find the useful rules for decisions from the amount of data to help the managers make decisions and create the new opportunities of business. The performance of data warehouse is import to user’s work efficiency. Therefore, there are some workload model arise to evaluate and predict the performance and efficiency of data warehouse called benchmark. However, the data warehouse specification announced these days are constructed to some typical domain specific, and the performance evaluation stand on synthetic workload. But, when the difference between the domain of data warehouse user applied and domain of performance evaluation tool is very large, the performance metric may different a lot to the result of benchmark tool. In data mining, the accuracy of mining result is important to business. The accuracy of mining result is more important than the time spend on data mining. However, there is no any useful tool to evaluate the accuracy of mining result and there is no any standard of performance criteria for data mining, either. We design a user requirement-oriented workload to evaluate performance of data warehouse and precision of data mining.
    Reference: 1.Inmon, W. H. (2002). Building the Data Warehouse, John Wiley & Sons, Inc., New York, NY.
    2.Berry, M. J. A., & Linoff, G. (1997). Data Mining Techniques: For Marketing, Sales, and Customer Support, John Wiley & Sons, Inc., New York, NY.
    3.Han, J., & Kamber, M. (2000). Data Mining Concepts and Techniques, Morgan Kaufmann.
    4.Fayyad, U. M., & Piatetsky-Shapiro, G., Smyth, P., & Uthurusamy, R. (1996). Advances in Knowledge Discovery and Data Mining. American Association for Artificial Intelligence, AAAAI/MIT Press.
    5.Jose, S., Transaction Processing Performance Council (2002), TPC BenchmarkTM H Standard Specification Revision 2.1.0, 1993 - 2002 Transaction Processing Performance Council.
    6.Jose, S., Transaction Processing Performance Council (2002), TPC BenchmarkTM R Standard Specification Revision 2.1.0, 1993 - 2002 Transaction Processing Performance Council.
    7.Jose, S., Transaction Processing Performance Council (1998), TPC BenchmarkTM D Standard Specification Revision 2.1, 1993 - 1998 Transaction Processing Performance Council.
    8.Frawley, W., Piatetsky-Shapiro, G., & Matheus C. (1992, Fall). Knowledge discovery in database: an overview. AI Magazine, 213-228.
    9.Grupe, F., & Owrang, M. M. O. (1997). Database Tools to Acquire Knowledge for Rule-Based Systems, Information Software and Technology 39(9), 607-616.
    10.Poess, M., & Floyd, C. (2000). New TPC Benchmarks for Decision Support and Web Commerce. ACM SIGMOD Record Volume 29(4), 64 – 71.
    11.Hackman, S. T., Frazelle, E. H., Griffin, P. M., Griffin, S. O., & Vlasta D. A. (2001). Benchmarking Warehousing and Distribution Operations: An Input-Output Approach. Journal of Productivity Analysis, 16, 79–100.
    12.Vassiliadis, P., Bouzeghoub, M., & Quiz, C. (2000). Towards Quality-oriented Data Warehouse Usage and Evolution. Information Systems 25(2), 89-l 15.
    13.Pei, J., Mao, R., Hu, K., & Zhu, H. (2002). Towards Data Mining Benchmarking: A Test Bed for Performance Study of Frequent Pattern Mining. Paper presented at the meeting of the ACM SIGMOD International Conference on Management of Data.
    14.Elnaffar, S., Martin, P., & Horman, R. (2002). Automatically Classifying Database. Paper presented at the meeting of the International Conference on Information and Knowledge Management.
    15.Leutenegger, S. T., & Dias, D. (1993). A Modeling Study of The TPC-C Benchmark. Paper presented at the meeting of the ACM SIGMOD International Conference on Management of Data.
    16.Gray, J. (1992). Database and Transaction Processing Benchmarks. Paper presented at the meeting of the ACM SIGMOD International Conference on Management of Data.
    17.Doppelhammer, J., Hoppler, T., Kemper, A., & Kossmann, D. (1997). Database Performance in The Real World TPC-D and SAP R/3. Paper presented at the meeting of the ACM SIGMOD International Conference on Management of Data.
    18.Poess, M., Smith, B., Kollar, L., & Larson, P. (2002). TPC-DS, Taking Decision Support Benchmarking to the Next Level. Paper presented at the meeting of the ACM SIGMOD International Conference on Management of Data.
    19.Bhashyam, R. (1996). TPC-D - The Challenges, Issues and Results. Paper presented at the meeting of the International Conference on Very Large Data Bases.
    20.Caruana, R. & NiculescuMizil, A. (2004, August). Data Mining in Metric Space: An Empirical Analysis of Supervised Learning Performance Criteria. Paper presented at the meeting of the ACM SIGKDD International Conference on Knowledge Discovery and Data Mining.
    21.Vieira, M., & Madeira, H. (2003). A Dependability Benchmark for OLTP Application Environments. Paper presented at the meeting of the International Conference on Very Large Data Bases.
    22.Zeller, B., & Kemper, A. (2004). Benchmarking SAP R/3 Archiving Scenarios. Paper presented at the meeting of the International Conference on Data Engineering.
    23.Wasserman, T. J., Martin, P., Skillicorn, D. B., & Rizvi, H. (2004), Business Intelligence: Developing a Characterization of Business Intelligence Workloads for Sizing New Database Systems. Paper presented at the meeting of the ACM international workshop on Data Warehousing and OLAP.
    24.Fu, L., & Hammer, J. (2000). CubiST: A New Algorithm for Improving the Performance of Ad-hoc OLAP Queries. Paper presented at the meeting of the ACM international workshop on Data Warehousing and OLAP.
    25.Poess, M., & Stephens, J. M. (2004). Generating Thousand Benchmark Queries in Seconds. Paper presented at the meeting of the International Conference on VLDB.
    26.Gupta, A., Davis, K. C., & Grommon-Litton, J. (2002). Performance Comparison of Property Map and Bitmap Indexing. Paper presented at the meeting of the ACM International Workshop on Data Warehousing and OLAP.
    27.Labio, W. J., Yang, J., Cui, Y., Garcia-Molina, H., & Widom, J. (2000). Performance Issues in Incremental Warehouse Maintenance, Paper presented at the meeting of the International Conference on VLDB.
    28.Performance Study of Microsoft Data Mining Algorithms, Retrieved December 12, 2005 from http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/dmperf.mspx
    29.Gartner (2004), Press Room, Quick Statistics. Retrieved June 1, 2004 from http://www.dataquest.com/press_gartner/quickstats/databases.html
    30.IDC (2004), Worldwide Data Warehousing Tools 2004 Vendor Shares, September 2005, Retrieved March, 20, 2006 from http://www.idc.com
    31.Gile, K. (2004), Forrester`s Business Technographics November 2004 North American And European Benchmark Study, Retrieved from March, 20, 2006 from http://www.forrester.com
    Description: 碩士
    國立政治大學
    資訊管理研究所
    93356038
    95
    Source URI: http://thesis.lib.nccu.edu.tw/record/#G0093356038
    Data Type: thesis
    Appears in Collections:[Department of MIS] Theses

    Files in This Item:

    File SizeFormat
    index.html0KbHTML2183View/Open


    All items in 政大典藏 are protected by copyright, with all rights reserved.


    社群 sharing

    著作權政策宣告 Copyright Announcement
    1.本網站之數位內容為國立政治大學所收錄之機構典藏，無償提供學術研究與公眾教育等公益性使用，惟仍請適度，合理使用本網站之內容，以尊重著作權人之權益。商業上之利用，則請先取得著作權人之授權。
    The digital content of this website is part of National Chengchi University Institutional Repository. It provides free access to academic research and public education for non-commercial use. Please utilize it in a proper and reasonable manner and respect the rights of copyright owners. For commercial use, please obtain authorization from the copyright owner in advance.

    2.本網站之製作，已盡力防止侵害著作權人之權益，如仍發現本網站之數位內容有侵害著作權人權益情事者，請權利人通知本網站維護人員(nccur@nccu.edu.tw)，維護人員將立即採取移除該數位著作等補救措施。
    NCCU Institutional Repository is made to protect the interests of copyright owners. If you believe that any material on the website infringes copyright, please contact our staff(nccur@nccu.edu.tw). We will remove the work from the repository and investigate your claim.
    DSpace Software Copyright © 2002-2004  MIT &  Hewlett-Packard  /   Enhanced by   NTU Library IR team Copyright ©   - Feedback