This Article 
 Bibliographic References 
 Add to: 
On Workload Characterization of Relational Database Environments
April 1992 (vol. 18 no. 4)
pp. 347-355

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.

[1] C. J. Date,Relational Databases: Selected Writings. Reading, MA: Addison-Wesley, 1986.
[2] W. Alexander, T. W. Keller, and E. E. Boughter, "A workload characterization pipeline for models of parallel systems,"Performance Eval. Rev., vol. 15, no. 1, pp. 186-194, May 1989.
[3] R. B. Ashton, "DB2 workload analysis," inProc. Computer Measure. Group Conf., 1986, pp. 71-73.
[4] P. R. Chintamaneni and L. W. Dowdy, "Workload characterization and synthetic workload generation: an application study,"Comput. Syst. Sci. Eng., vol. 4, no. 4, pp. 205-215, Oct. 1989.
[5] D. Ferrari, "Workload characterization for tightly coupled and loosely coupled systems,"Perform. Eval. Rev., vol. 17, no. 1, pp. 210-211, May 1989.
[6] G. M. King, "Workload characterization," inProc. Computer Measure. Group Conf., 1986, pp. 789-801.
[7] P. Selinger,et al., "Access path selection in a relational data base system," inProc. 1979 ACM-SIGMOD Int. Conf. Management of Data, Boston, MA, June 1979.
[8] S. Christodoulakis, "Implications of certain assumptions in database performance evaluation,"ACM Trans. Database Syst.vol. 9, no. 2, pp. 163-186, June 1984.
[9] M. S. Lakshmi, and P. S. Yu, "Effectiveness of parallel joins,"IEEE Trans. Knowledge Data Eng., vol. 2, pp. 410-424, Dec. 1990.
[10] Y.-H. Lee, and P. S. Yu, "Adaptive selection of access plan and join methods," inProc. 13th Int. Computer Software and Appl. Conf., pp. 250-256, Sept. 1989.
[11] R. W. Horst and T. C. K. Chow, "An architecture for high volume transaction processing," inProc. 12th Int. Symp. on Computer Architecture(Boston), June 1985, pp. 240-245.
[12] C. J. Date,A Guide to DB2. Reading, MA: Addison-Wesley, 1988.
[13] "IBM Database 2 references," IBM Corp., Yorktown Heights, NY, SC26-4078, Nov. 16, 1991.
[14] "IBM system planning and administration guide," IBM Corp., Yorktown Heights, NY, SC26-4085, Nov. 16, 1991.
[15] D. J. Haderle and R. D. Jackson, "IBM Database 2 overview,"IBM Syst J., vol. 23, no. 2, pp. 112-125, 1984.
[16] "Database 2 performance monitor general information," IBM Corp., Yorktown Heights, NY, GH20-6856-01, Mar. 13, 1991.
[17] "Database 2 performance monitor: user's guide," IBM Corp., Yorktown Heights, NY, SH20-6857, Jan. 2, 1991.
[18] P. S. Yu, D. M. Dias, J. T. Robinson, B. R. Iyer, and D. W. Cornell, "Distributed concurrency control analysis for data sharing," inProc. Computer Measure. Group Conf., 1985, pp. 13-20.

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
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
Usage of this product signifies your acceptance of the Terms of Use.