Characterization of the data access behavior for TPC-C traces

Authors:
R. Bonilla-Lucas;P. Plachta;A. Sachedina;D. Jimenez-Gonzalez;C. Zuzarte;J.-L. Larriba-Pey
Affiliations:
DAC-CIRI, Univ. Politecnica de Catalunya, Barcelona, Spain;Dept. of Comput. Sci., Purdue Univ., West Lafayette, IN, USA;Dept. of Electr. & Comput. Eng., Michigan Technol. Univ., Houghton, MI, USA;Dept. of Electr. & Comput. Eng., Rochester Univ., NY, USA;Dept. of Electr. & Comput. Eng., Rochester Univ., NY, USA;Comput. & Inf. Sci., Ohio State Univ., Columbus, OH, USA
Venue:
ISPASS '04 Proceedings of the 2004 IEEE International Symposium on Performance Analysis of Systems and Software
Year:
2004

Citing 0
Cited 2

Design of flash-based DBMS: an in-page logging approach

Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Application of Queueing Network Models in the Performance Evaluation of Database Designs

Electronic Notes in Theoretical Computer Science (ENTCS)

Quantified Score

Hi-index	0.00

Visualization

Abstract

In this paper, we look into the characteristics of the reference stream of TPC-C workloads from the buffer pool point of view. We analyze a trace coming from DB2 UDB version 8.1 fix pack 4 and compare it to a trace from DB2 UDB version 8.1 GA. We perform three types of analysis. A static analysis of the number of reads and writes for index and data pages. We conclude that index pages receive less references than data pages by are more frequently accessed individually. Then, we analyze how DB2 processes access those pages. Index pages have more references than data pages when accessed by more than one process. Finally, we understand the accesses along the life of a page. We conclude that there is a significant burstiness in the reference stream, where, each burst is caused by one process.