現今的物件導向資料庫績效評估存在著許多的缺失。1.針對特定的應用領域，其測試工作量模型並無法代表使用者的需求。2.針對特定的資料模型，主要在衡量資料庫設計之技巧及效能。3.測試資料庫綱目變得複雜，測試運算變得繁多，使用者欲自行建立績效評估十分不容易。為了解決以上的問題，本研究擬使用物件導向系統分析的方法作為使用者建構工作量模型的工具，經過一、工作量需求分析階段。二、工作量規則描述階段。三、績效評估的測試階段。最後發展出一個用以測試物件導向資料庫的績效評估環境。由於測試之資料庫綱目與測試運算均是從使用者之需求著手，將使得測試之工作量對使用者而言，更具一致性、代表性與正確性，測試所得之數據與使用者更具相關性。另一方面，為了驗證所提出理論的可行性，我們發展了工作量模型產生器之雛型系統，使用者只須使用視覺化的圖形符號來編輯其工作量模型，系統即會產生工作量模型之規格描述，作為建構績效評估系統之進一步應用。在物件導向資料庫的應用範圍愈來愈廣泛、資料庫之資料量日益龐大的未來，以使用者需求為導向之績效評估將會是未來績效評估之發展方向。 / Existing object-oriented database benchmarks have the following drawbacks 1.They are designed to apply to specific domains, so the workload models of theirs are unable to fully represent user requirements 2.They are designed to apply to the specific data model, and their main intentions are to measure the techniques and therefore performance of database design. 3.As the database schemes are more complex and test operations are more myriad, it will be harder and harder for users intending to implement the benchmark according to the benchmark specification. In order to resolve the above problems, this thesis tries to model user's workload with system analysis methods. After 1.workload requirement analysis phase. 2.workload requirement specification phase 3.benchmark experiment phase, we will develop a benchmark application program used to benchmark the OODBMS. Because our benchmark database schemes and operations are derived from the user requirements, the workload will be more consistent, more representative and more accurate and the result will be more meaningful to users. In order to validate the theory we propose, we develop a prototype of the workload generator. After users have finished editing their workload model with visual graphic notations, the system will output workload specifications, which will be used in the later phase. As the application domain of OODBMS are more diverse and database are more huge, the trend of benchmarks is toward user requirement driven in the future.

本研究以使用者需求導向為設計原則，提出了建構物件與物件關聯資料庫工作量產生器的發展方式，以解決(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.

由於網路科技的進步 ,導致系統所需的資料不再只儲存於同一地點 , 面對分散式和主從式資料庫系統的使用日益頻繁 ,再加上現今的物件導向資料庫績效評估存在著許多的缺失包括 : 1.針對特定的應用領域 2. 針對特定的資料模型 3.測試資料庫綱目變得複雜 , 運算變得繁多 4.無法真實測出使用者應用領域的效能 .為了解決以上的問題 ,本研究擬使用物件導向系統分析方法作為使用者建構工作量模型的工具 , 發展出一個使用者需求導向的物件導向資料庫績效評估工作量模式。 另一方面 , 為了驗證所提出理論的可行性 , 我們發展了工作量模型規格書產生器的雛型系統 , 使用者只須使用視覺化的圖形符號來編輯其工作量模型 , 系統即會產生工作量模型的規格描述 , 作為建構績效評估系統之進一步開發 .在網路科技與物件導向資料庫的應用範圍愈來愈廣 , 資料日益龐大與型態日益複雜的未來 , 以使用者需求為導向的績效評估將是未來物件導向資料庫的績效評估之發展方向。 / As the improving of network technology, the data of database is no more stored on the same site. So the distributed database system is more and more popular. Existing object-oriented database benchmarks have the following drawbacks:1.They are designed to the specific domains , so the workload models of theirs are unable to fully reprent user requirements . 2. They are designed to the specific data models , and their intentions are to measure the techniques and performance of database design . 3.As the database schemes are more complicated and test operations are more myriad , it will be harder and harder for users to implement the benchmark. 4.They can not really measure the performance on the specific domains of users. In order to resolve the above problems , this thesis tries to model user's requirements workload using system analysis method . Because our database benchmark schemes and operations are derived from the user's requirements , the workload will be more consistent , more representative and more accurate and the result will be useful and meaningful to user . In order to apply the model we propose , we develop the prototype of the workload specification generator . After users have finished editing their workload model with the visual graphic notations , the system will generate workload specifications which will be used in the later phase . As the application domain of OODBMS are diverse and databases are huge , the trend of benchmarks is toward user requirement orientation in the future .