https://scholars.lib.ntu.edu.tw/handle/123456789/631057
標題: | On Workload Characterization of Relational Database Environments | 作者: | Yu, Philip S. Heiss, Hans Ulrich Lee, Sukho MING-SYAN CHEN |
公開日期: | 1-一月-1990 | 來源出版物: | 16th International Computer Measurement Group Conference, CMG 1990 | 摘要: | As relational database systems become increasingly popular, there is a clear need to better understand the workload so systems can be designed or tuned more effectively. A REIational Database Workload AnalyzeR (REDWAR) is developed to characterize the workload in a DB2 environment. This is applied to study a production DB2 system where an SQL trace for a two hour interval and an image copy of the database catalog were obtained. The results of the workload study are summarized. Here we focus on the structure and complexity of SQL statements, the makeup and run-time behavior of transactions/queries, and the composition of relations and views. This provides the necessary information needed to build a benchmark workload to study database design trade-offs. |
URI: | https://scholars.lib.ntu.edu.tw/handle/123456789/631057 |
顯示於: | 電機工程學系 |
在 IR 系統中的文件,除了特別指名其著作權條款之外,均受到著作權保護,並且保留所有的權利。