The Community for Technology Leaders
RSS Icon
Subscribe
Issue No.04 - April (1992 vol.18)
pp: 347-355
ABSTRACT
<p>A relational database workload analyzer (REDWAR) is developed to characterize the workload in a DB2 environment. This is applied to study a production DB2 system where a structured query language (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. The structure and complexity of SQL statements, the makeup and run-time behavior of transactions/queries, and the composition of relations and views are discussed. The results obtained provide the important information needed to build a benchmark workload to evaluate the alternative design tradeoffs of database systems.</p>
INDEX TERMS
relational database workload analyzer; REDWAR; DB2 environment; structured query language; database catalog; SQL; run-time behavior; views; benchmark workload; design tradeoffs; database theory; DP management; query languages; relational databases; systems analysis
CITATION
P.S. Yu, M.-S. Chen, H.-U. Heiss, S. Lee, "On Workload Characterization of Relational Database Environments", IEEE Transactions on Software Engineering, vol.18, no. 4, pp. 347-355, April 1992, doi:10.1109/32.129222
17 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool