學術產出-學位論文
文章檢視/開啟
書目匯出
-
題名 建構物件與物件關聯資料庫工作量產生器
Toward a Generalized Object-Oriented and Object-Relational Database Workload Generator作者 黃敏男
Huang, Min-Nan貢獻者 諶家蘭
Seng, Jia-Lang
黃敏男
Huang, Min-Nan關鍵詞 物件導向資料庫
物件關聯資料庫
資料庫績效評估
Object-Oriented Database (OODB)
Object-Relational Database (ORDB)
Database Benchmark
SQL3
ODMG日期 2000 上傳時間 31-三月-2016 15:43:29 (UTC+8) 摘要 本研究以使用者需求導向為設計原則,提出了建構物件與物件關聯資料庫工作量產生器的發展方式,以解決(1)一般績效評估標準規格因只針對特定應用領域,而無法周詳考慮到使用者的特定需求問題;(2)廠商所發展的工作量產生器則因為可能針對其產品的特定領域作設計與測試,而失去了公正性之問題。我們的目地就是希望能以此資料庫工作量產生器的設計方式使測試資料庫效能的工作量,對使用者而言更具一致性、代表性與正確性,如此測試之結果對使用者而言才能更具意義。
This thesis provides a method of establishing Object-Oriented and Object-Relational Database Workload Generator, and this method is designed from the perspective of the user`s requirements for addressing two problems: (1) the benchmark standards are generally designed to specific domains, so they are unable think comprehensively users` special requirements. (2) the database workload generators that developed by database providers may lose justice, because they might be designed to their products` special domain. Our purpose is that hope this method can make the Workload more consistent, more representative and more accurate and the test result will be more meaningful to users.參考文獻 1. 方相宜,「主從式物件導向資料庫系統績效評估工作量模式之研究」,國立政治大學資訊管理研究所碩士論文,民國八十八年六月。 2. 韋凱忠,「物件網際網路資料庫系統中介模式之研究」,國立政治大學資訊管理研究所碩士論文,民國八十七年六月。 3. 許致順,「物件導向資料庫系統績效評估方法之研究—以系統分析方法為主之工作量模式」,國立政治大學資訊管理研究所碩士論文,民國八十七年六月。 4. 程文成,「網際網路資料庫系統績效評估方法之研究—以電子商務為例」,國立政治大學資訊管理研究所碩士論文,民國八十七年六月。 5. 薛涵文,「個人電腦上物件導向資料庫之績效評估」,國立交通大學資訊科學研究所碩士論文,民國八十四年六月。 6. 韓先良,「分散式關聯資料庫系統績效評估工作量模式之研究」,國立政治大學資訊管理研究所碩士論文,民國八十八年六月。 7. Anderson, T., A. Berre, M. Mallison, H. Porter and B. Schneider,“The HyperModel Benchmark,”Proceedings of the 2nd International Conference on Extended Database Technology, March 1990, pp. 317-331. 8. Barry, Doug,“ODMG 2.0: A Standard for Object Storage,” Component Strategies, July 1998. 9. Barry, Douglas and David Jordan, “ODMG: The Industry Standard for Java Object Storage,” Component Strategies, September 1998. 10. Carey, M. J., D. J. DeWitt and J. F. Naughton, “The OO7 Benchmark,” Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, May 1993, pp. 12-21. 11. Carey, M.J., D.J. DeWitt, J.F. Naughton, M. Asgarian, P. Brown, J.E. Gehrke and D.N. Shah, “The BUCKY object-relational benchmark,” Proceedings of the ACM SIGMOD International Conference on Management of Data, Tucson, Arizona, May 1997, pp. 135-146. 12. Cattell, R. G. G. and J. Skeen, “Engineering Database Benchmark,” ACM Transactions on Database Systems, 17(1): 1-31, March 1992. 13. Cattell, R. G. G., “An Engineering Database Benchmark,” appears in The Benchmark Handbook for Database and Transaction Processing Systems, Ed. by Jim Gray, Morgan Kaufmann, Inc., 1993, pp. 397-434. 14. Cattell, R. G. G., Object Data Management: Object Oriented and Extended Relational Database System, Addison Wesley Publishing Company, Inc., 1994. 15. Cattell, Rick and Douglas Barry, ODMG 2.0: An Overview, Dr. Dobb`s Sourcebook, September/October 1997. 16. Chaudhri, A.B., “Object database management systems: an overview,” BCS OOPS Newsletter, No. 18 (Summer 93), pp. 6-15. 17. Chaudhri, A.B. and N. Revell, “Benchmarking object databases: past, present & future,” Proceedings of the Seminar on Object-Oriented Databases: Realising their Potential and Interoperability with RDBMS, London, UK, May 1994, pp. 166-183. 18. Date, C.J. and Hugh Darwen, A Guide to the SQL Standard, 4th ed., Reading, Mass.: Addison-Wesley, 1997. 19. Davis, Judith R., “Extended Relational DBMSs: The Technology, Part 1,” DBMS, June 1997(1). 20. Davis, Judith R., “Universial Servers: The Players, Part 2,” DBMS, July 1997(2). 21. DeWitt, D. J., P. Futtersack, D. Maier and F. Velez, “A Study of Three Alternative Workstation Server Architectures for Object-Oriented Database Systems,” Proceedings of the 16th International Conference on Very Large Data Bases, August 1990, pp.107-121. 22. Eisenberg, Aufsatz A. and J. Melton, “SQL:1999, formerly known as SQL3,” ACM SIGMOD Record, 1999 (1), March 1999. 23. Fortier, Paul J., SQL-3: Implementing the Object-Relational Database, McGraw-Hill, 1999. 24. Gray, J. N., The Benchmark Handbook for Database and Transaction Processing Systems, Ed., Morgan Kaufmann, Inc., 1993. 25. Jepson, Brian, “What`s Inside the ODMG-93 Standard?,” DBMS, July 1997. 26. Khoshafian, S. and Abcdus, R., Object orientation: concepts, languages, databases, user interfaces, John Wiley & Sons, New York, 1990. 27. Kim, W., “Introduction to object-oriented databases,” MIT Press, Cambridge, MA, 1990. 28. King, Nelson H., “The Object Database Goes Online,” DBMS, January 1997. 29. King, Nelson H., “Java in the Database Server,” DBMS, June 1998. 30. King, Nelson H., “ODBMS: Now or Never,” DBMS, July 1998. 31. Mattos, N. M. and J. Melton, “An Overview of the Emerging Third-Generation SQL Standard (Tutorial),” SIGMOD Conference, 1995, p.468. 32. Melton, J. and A. Simon, “Understanding the New SQL:A Complete Guide,” San Mateo, CA: Morgan Kaufman, 1992. 33. Melton and Jim, “SQL Language Summary,” Computing Surveys, Vol. 28(1), 1996, pp.141-143. 34. Sawyer, T., “Doing Your Own Benchmark,” appears in The Benchmark Handbook for Database Transaction Processing System, Ed. by Jim Gray, Morgan Kaufmann, Inc., 1993, pp.543-562. 35. Seng, J. L., S. B. Yao and A. R. Hevner, “Requirements-Driven Database Systems Benchmark Methodology,” dissertation submitted to the Faculty of the Graduate School of the University of Maryland in partial fulfillment of the requirements for the degree of Doctor of Philosophy, 1994. 36. Zorn, B.G. and A.B. Chaudhri, “Object database behavior, benchmarks, and performance,” Addendum to the Proceedings of the ACM International Conference on Object-Oriented Programming Systems, Languages, and Applications (OOPSLA `95), Austin, Texas, October 1995, pp. 159-163. [http1] http://web.ansi.org [http2] http://www.iso.ch [http3] http://www.odmg.org [http4] http://www.benchmarkresources.com/handbook/ 描述 碩士
國立政治大學
資訊管理學系
87356014資料來源 http://thesis.lib.nccu.edu.tw/record/#A2002002106 資料類型 thesis dc.contributor.advisor 諶家蘭 zh_TW dc.contributor.advisor Seng, Jia-Lang en_US dc.contributor.author (作者) 黃敏男 zh_TW dc.contributor.author (作者) Huang, Min-Nan en_US dc.creator (作者) 黃敏男 zh_TW dc.creator (作者) Huang, Min-Nan en_US dc.date (日期) 2000 en_US dc.date.accessioned 31-三月-2016 15:43:29 (UTC+8) - dc.date.available 31-三月-2016 15:43:29 (UTC+8) - dc.date.issued (上傳時間) 31-三月-2016 15:43:29 (UTC+8) - dc.identifier (其他 識別碼) A2002002106 en_US dc.identifier.uri (URI) http://nccur.lib.nccu.edu.tw/handle/140.119/83306 - dc.description (描述) 碩士 zh_TW dc.description (描述) 國立政治大學 zh_TW dc.description (描述) 資訊管理學系 zh_TW dc.description (描述) 87356014 zh_TW dc.description.abstract (摘要) 本研究以使用者需求導向為設計原則,提出了建構物件與物件關聯資料庫工作量產生器的發展方式,以解決(1)一般績效評估標準規格因只針對特定應用領域,而無法周詳考慮到使用者的特定需求問題;(2)廠商所發展的工作量產生器則因為可能針對其產品的特定領域作設計與測試,而失去了公正性之問題。我們的目地就是希望能以此資料庫工作量產生器的設計方式使測試資料庫效能的工作量,對使用者而言更具一致性、代表性與正確性,如此測試之結果對使用者而言才能更具意義。 zh_TW dc.description.abstract (摘要) This thesis provides a method of establishing Object-Oriented and Object-Relational Database Workload Generator, and this method is designed from the perspective of the user`s requirements for addressing two problems: (1) the benchmark standards are generally designed to specific domains, so they are unable think comprehensively users` special requirements. (2) the database workload generators that developed by database providers may lose justice, because they might be designed to their products` special domain. Our purpose is that hope this method can make the Workload more consistent, more representative and more accurate and the test result will be more meaningful to users. en_US dc.description.tableofcontents 封面頁 證明書 致謝詞 論文摘要 目錄 表目錄 圖目錄 第一章 緒 論 一、 研究動機 二、 研究問題 三、 研究目的 四、 研究流程 第二章 文獻探討 一、 物件關聯資料庫與物件導向資料庫的定義 (一) 物件關聯資料庫 (二) 物件導向資料庫 二、 績效評估與物件導向資料庫之績效評估 (一) OO1 績效評估 (二) HyperModel績效評估 (三) OO7 績效評估 (四) BUCKY 績效評估 三、 SQL3標準 (一) 簡介 (二) 資料定義 (三) 資料操作 (四) SQL Bindings 四、 ODMG標準 (一) 物件模式 (二) 物件定義語言 (三) 物件查詢語言 (四) 語言的繫結 五、 SQL3與ODMG之比較 第三章 研究方法與研究架構 一、 研究架構 二、 工作量模式分析階段 (一) 物件關聯資料庫工作量模式 (二) 物件導向資料庫工作量模式 三、 工作量產生器建構與實驗階段 (一) 物件產生器 (二) 交易產生器 (三) 交易排程器 (四) 測試驅動器 第四章 系統實作 一、 總覽 二、 系統架構與功能 (一) 物件產生器 (二) 交易產生器 (三) 交易排程器 (四) 測試驅動器 (五) 測試結果蒐集器 三、 探討物件導向資料庫工作量產生器之建構方式 (一) Jasmine 簡介 (二) 物件模式 (三) 定義語言方面 (四) 操作語言方面 (五) Language Bindings (六) 小結 第五章 結論與未來研究方向 一、 結論 二、 研究貢獻 三、 未來研究方向 參考文獻 zh_TW dc.source.uri (資料來源) http://thesis.lib.nccu.edu.tw/record/#A2002002106 en_US dc.subject (關鍵詞) 物件導向資料庫 zh_TW dc.subject (關鍵詞) 物件關聯資料庫 zh_TW dc.subject (關鍵詞) 資料庫績效評估 zh_TW dc.subject (關鍵詞) Object-Oriented Database (OODB) en_US dc.subject (關鍵詞) Object-Relational Database (ORDB) en_US dc.subject (關鍵詞) Database Benchmark en_US dc.subject (關鍵詞) SQL3 en_US dc.subject (關鍵詞) ODMG en_US dc.title (題名) 建構物件與物件關聯資料庫工作量產生器 zh_TW dc.title (題名) Toward a Generalized Object-Oriented and Object-Relational Database Workload Generator en_US dc.type (資料類型) thesis en_US dc.relation.reference (參考文獻) 1. 方相宜,「主從式物件導向資料庫系統績效評估工作量模式之研究」,國立政治大學資訊管理研究所碩士論文,民國八十八年六月。 2. 韋凱忠,「物件網際網路資料庫系統中介模式之研究」,國立政治大學資訊管理研究所碩士論文,民國八十七年六月。 3. 許致順,「物件導向資料庫系統績效評估方法之研究—以系統分析方法為主之工作量模式」,國立政治大學資訊管理研究所碩士論文,民國八十七年六月。 4. 程文成,「網際網路資料庫系統績效評估方法之研究—以電子商務為例」,國立政治大學資訊管理研究所碩士論文,民國八十七年六月。 5. 薛涵文,「個人電腦上物件導向資料庫之績效評估」,國立交通大學資訊科學研究所碩士論文,民國八十四年六月。 6. 韓先良,「分散式關聯資料庫系統績效評估工作量模式之研究」,國立政治大學資訊管理研究所碩士論文,民國八十八年六月。 7. Anderson, T., A. Berre, M. Mallison, H. Porter and B. Schneider,“The HyperModel Benchmark,”Proceedings of the 2nd International Conference on Extended Database Technology, March 1990, pp. 317-331. 8. Barry, Doug,“ODMG 2.0: A Standard for Object Storage,” Component Strategies, July 1998. 9. Barry, Douglas and David Jordan, “ODMG: The Industry Standard for Java Object Storage,” Component Strategies, September 1998. 10. Carey, M. J., D. J. DeWitt and J. F. Naughton, “The OO7 Benchmark,” Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, May 1993, pp. 12-21. 11. Carey, M.J., D.J. DeWitt, J.F. Naughton, M. Asgarian, P. Brown, J.E. Gehrke and D.N. Shah, “The BUCKY object-relational benchmark,” Proceedings of the ACM SIGMOD International Conference on Management of Data, Tucson, Arizona, May 1997, pp. 135-146. 12. Cattell, R. G. G. and J. Skeen, “Engineering Database Benchmark,” ACM Transactions on Database Systems, 17(1): 1-31, March 1992. 13. Cattell, R. G. G., “An Engineering Database Benchmark,” appears in The Benchmark Handbook for Database and Transaction Processing Systems, Ed. by Jim Gray, Morgan Kaufmann, Inc., 1993, pp. 397-434. 14. Cattell, R. G. G., Object Data Management: Object Oriented and Extended Relational Database System, Addison Wesley Publishing Company, Inc., 1994. 15. Cattell, Rick and Douglas Barry, ODMG 2.0: An Overview, Dr. Dobb`s Sourcebook, September/October 1997. 16. Chaudhri, A.B., “Object database management systems: an overview,” BCS OOPS Newsletter, No. 18 (Summer 93), pp. 6-15. 17. Chaudhri, A.B. and N. Revell, “Benchmarking object databases: past, present & future,” Proceedings of the Seminar on Object-Oriented Databases: Realising their Potential and Interoperability with RDBMS, London, UK, May 1994, pp. 166-183. 18. Date, C.J. and Hugh Darwen, A Guide to the SQL Standard, 4th ed., Reading, Mass.: Addison-Wesley, 1997. 19. Davis, Judith R., “Extended Relational DBMSs: The Technology, Part 1,” DBMS, June 1997(1). 20. Davis, Judith R., “Universial Servers: The Players, Part 2,” DBMS, July 1997(2). 21. DeWitt, D. J., P. Futtersack, D. Maier and F. Velez, “A Study of Three Alternative Workstation Server Architectures for Object-Oriented Database Systems,” Proceedings of the 16th International Conference on Very Large Data Bases, August 1990, pp.107-121. 22. Eisenberg, Aufsatz A. and J. Melton, “SQL:1999, formerly known as SQL3,” ACM SIGMOD Record, 1999 (1), March 1999. 23. Fortier, Paul J., SQL-3: Implementing the Object-Relational Database, McGraw-Hill, 1999. 24. Gray, J. N., The Benchmark Handbook for Database and Transaction Processing Systems, Ed., Morgan Kaufmann, Inc., 1993. 25. Jepson, Brian, “What`s Inside the ODMG-93 Standard?,” DBMS, July 1997. 26. Khoshafian, S. and Abcdus, R., Object orientation: concepts, languages, databases, user interfaces, John Wiley & Sons, New York, 1990. 27. Kim, W., “Introduction to object-oriented databases,” MIT Press, Cambridge, MA, 1990. 28. King, Nelson H., “The Object Database Goes Online,” DBMS, January 1997. 29. King, Nelson H., “Java in the Database Server,” DBMS, June 1998. 30. King, Nelson H., “ODBMS: Now or Never,” DBMS, July 1998. 31. Mattos, N. M. and J. Melton, “An Overview of the Emerging Third-Generation SQL Standard (Tutorial),” SIGMOD Conference, 1995, p.468. 32. Melton, J. and A. Simon, “Understanding the New SQL:A Complete Guide,” San Mateo, CA: Morgan Kaufman, 1992. 33. Melton and Jim, “SQL Language Summary,” Computing Surveys, Vol. 28(1), 1996, pp.141-143. 34. Sawyer, T., “Doing Your Own Benchmark,” appears in The Benchmark Handbook for Database Transaction Processing System, Ed. by Jim Gray, Morgan Kaufmann, Inc., 1993, pp.543-562. 35. Seng, J. L., S. B. Yao and A. R. Hevner, “Requirements-Driven Database Systems Benchmark Methodology,” dissertation submitted to the Faculty of the Graduate School of the University of Maryland in partial fulfillment of the requirements for the degree of Doctor of Philosophy, 1994. 36. Zorn, B.G. and A.B. Chaudhri, “Object database behavior, benchmarks, and performance,” Addendum to the Proceedings of the ACM International Conference on Object-Oriented Programming Systems, Languages, and Applications (OOPSLA `95), Austin, Texas, October 1995, pp. 159-163. [http1] http://web.ansi.org [http2] http://www.iso.ch [http3] http://www.odmg.org [http4] http://www.benchmarkresources.com/handbook/ zh_TW