By Topic

Data locality characterization of OLTP applications and its effects on cache performance

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

3 Author(s)
Zhang Jing ; Comput. Coll., Nat. Univ. of Defense Technol., Changsha, China ; Deng Lin ; Dou Yong

Online transaction processing (OLTP) is an important commercial application with intensive memory access. With increasing gap between processor and memory speeds, cache performance associated with data locality is the critical performance factor for OLTP applications. While OLTP applications have been shown to have significant data locality, data locality characterization and its effects on cache performance is still an open question. This paper presents a detailed study of typical OLTP queries from TPC-C. We identify a set of working sets by analysis of reuse in query processing. Based on performance experiments on typical OLTP queries with simulated system, we find cache performance is mainly impacted by critical working set that are caused by fundamental structures required to access tuples in relations. We also find that the critical working set is slightly affected by application parameters.

Published in:

Advanced Computer Theory and Engineering (ICACTE), 2010 3rd International Conference on  (Volume:3 )

Date of Conference:

20-22 Aug. 2010