This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
2004 IEEE International Symposium on Performance Analysis of Systems and Software (ISPASS'04)
Characterization of the data access behavior for TPC-C traces
Austin, TX, USA
March 10-March 12
ISBN: 0-7803-8385-0
ASCII Text
x 
 
R. Bonilla-Lucas, P. Plachta, A. Sachedina, D. Jimenez-Gonzalez, C. Zuzarte, J.-L. Larriba-Pey, "Characterization of the data access behavior for TPC-C traces," Performance Analysis of Systems and Software, IEEE International Symmposium on, pp. 115-122, 2004 IEEE International Symposium on Performance Analysis of Systems and Software (ISPASS'04), 2004.
 
 
BibTex
x
 
@article{ 10.1109/ISPASS.2004.1291363,
author = {R. Bonilla-Lucas and P. Plachta and A. Sachedina and D. Jimenez-Gonzalez and C. Zuzarte and J.-L. Larriba-Pey},
title = {Characterization of the data access behavior for TPC-C traces},
journal ={Performance Analysis of Systems and Software, IEEE International Symmposium on},
volume = {0},
year = {2004},
isbn = {0-7803-8385-0},
pages = {115-122},
doi = {http://doi.ieeecomputersociety.org/10.1109/ISPASS.2004.1291363},
publisher = {IEEE Computer Society},
address = {Los Alamitos, CA, USA},
}
 
 
RefWorks Procite/RefMan/Endnote
x 
 
TY - CONF
JO - Performance Analysis of Systems and Software, IEEE International Symmposium on
TI - Characterization of the data access behavior for TPC-C traces
SN - 0-7803-8385-0
SP115
EP122
A1 - R. Bonilla-Lucas,
A1 - P. Plachta,
A1 - A. Sachedina,
A1 - D. Jimenez-Gonzalez,
A1 - C. Zuzarte,
A1 - J.-L. Larriba-Pey,
PY - 2004
VL - 0
JA - Performance Analysis of Systems and Software, IEEE International Symmposium on
ER -
 
R. Bonilla-Lucas, DAC-CIRI, Univ. Politecnica de Catalunya, Barcelona, Spain
P. Plachta, Dept. of Comput. Sci., Purdue Univ., West Lafayette, IN, USA
A. Sachedina, Dept. of Electr. & Comput. Eng., Michigan Technol. Univ., Houghton, MI, USA
D. Jimenez-Gonzalez, Dept. of Electr. & Comput. Eng., Rochester Univ., NY, USA
C. Zuzarte, Dept. of Electr. & Comput. Eng., Rochester Univ., NY, USA
J.-L. Larriba-Pey, Comput. & Inf. Sci., Ohio State Univ., Columbus, OH, USA
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.
Citation:
R. Bonilla-Lucas, P. Plachta, A. Sachedina, D. Jimenez-Gonzalez, C. Zuzarte, J.-L. Larriba-Pey, "Characterization of the data access behavior for TPC-C traces," ispass, pp.115-122, 2004 IEEE International Symposium on Performance Analysis of Systems and Software (ISPASS'04), 2004
Usage of this product signifies your acceptance of the Terms of Use.