On workload characterization of relational database environments

Author

Yu, Philip S. ; Chen, Ming-Syan ; Heiss, Hans-Ulrich ; Lee, Sukho

Author_Institution

IBM Thomas J. Watson Res. Center, Yorktown Heights, NY, USA

Volume

18

Issue

4

fYear

1992

fDate

4/1/1992 12:00:00 AM

Firstpage

347

Lastpage

355

Abstract

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

Keywords

DP management; database theory; query languages; relational databases; systems analysis; DB2 environment; REDWAR; SQL; benchmark workload; database catalog; design tradeoffs; relational database workload analyzer; run-time behavior; structured query language; views; Data analysis; Database systems; Delay; Hardware; Image databases; Production systems; Relational databases; Runtime; Software design; Transaction databases;

fLanguage

English

Journal_Title

Software Engineering, IEEE Transactions on

Publisher

ieee

ISSN

0098-5589

Type

jour

DOI

10.1109/32.129222

Filename

129222