建構物件與物件關聯資料庫工作量產生器

• Main Authors: 黃敏男, Huang, Min-Nan
• Language: 中文
• Published: 國立政治大學
• Subjects: 物件導向資料庫; 物件關聯資料庫; 資料庫績效評估; Object-Oriented Database (OODB); Object-Relational Database (ORDB); Database Benchmark; SQL3; ODMG
• Online Access: http://thesis.lib.nccu.edu.tw/cgi-bin/cdrfb3/gsweb.cgi?o=dstdcdr&i=sid=%22A2002002106%22.

本研究以使用者需求導向為設計原則，提出了建構物件與物件關聯資料庫工作量產生器的發展方式，以解決(1)一般績效評估標準規格因只針對特定應用領域，而無法周詳考慮到使用者的特定需求問題；(2)廠商所發展的工作量產生器則因為可能針對其產品的特定領域作設計與測試，而失去了公正性之問題。我們的目地就是希望能以此資料庫工作量產生器的設計方式使測試資料庫效能的工作量，對使用者而言更具一致性、代表性與正確性，如此測試之結果對使用者而言才能更具意義。 我們首先分析SQL3與ODMG標準，以此構成物件關聯與物件導向資料庫之一般化的工作量模式。然後，再著手以使用者需求導向為原則，設計工作量產生器的運作方式。最後，我們實際發展了工作量產生器的雛形系統，以讓使用者能真正依其需求建立工作量並實際作績效測試，並提供給欲建構物件與物件關聯資料庫工作量產生器的人員作參考。 === 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. Firstly, we analyze the SQL3 and ODMG standards to compose the ORDBs' and OODBs' generalized Workload Models. Then, we design our Workload Generator form the perspective of the user's requirements. Finally, we develop the Workload Generator's prototype system, it can allow users to create Workload according to their actual requirements and really do the benchmark test, and furthermore can provide a reference resource to the people who want to develop ORDB and OODB Workload Generator.