Reference Behaviour of the TPC-C Benchmark
Wenguang Wang, Richard B. Bunt · 2003
This report analyzes the reference behaviour of IBM DB2 running an On-line Transaction Processing benchmark TPC-C. Reference behaviour for different tables and different object types (data or index) is studied. The effect of the number of users is also examined. It is found that the correlated references exist in most tables. The period of correlated references is affected by the type of references to tables, type of objects (data or index), and number of users. It is also found that different tables exhibit different reference behaviour, which depends on how it is accessed by the applications. The data pages and index pages also exhibit different reference behaviour. The index pages of all tables have similar locality. Based on the reference behaviour of different tables and the data/index pages, the buffer pool can be effectively partitioned to group pages with similar properties into one partition. 1