loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
16th Symposium on Computer Architecture and High Performance Computing (SBAC-PAD'04)
Improving Server Performance on Transaction Processing Workloads by Enhanced Data Placement
Foz do Igua?u, PR - Brazil
October 27-October 29
ISBN: 0-7695-2240-8
Juan Rubio, The University of Texas at Austin
Charles Lefurgy, IBM Austin Research Lab, Austin, TX
Lizy K. John, The University of Texas at Austin
Modern servers access large volumes of data while running commercial workloads. The data is typically spread among several storage devices (e.g. disks). Carefully placing the data across the storage devices can minimize costly remote accesses and improve performance.
We propose the use of simulated annealing to arrive at an effective layout of data on disk. The proposed technique considers the configuration of the system and the cost of data movement. An initial layout globally optimized across all queries, shows speedups of up to 13% for a group of DSS queries and up to 6% for selected OLTP queries.
This technique can be re-applied at run-time to further improve performance beyond the initial, globally optimized data layout. This scheme monitors architecture parameters to prevent optimizations of multiple operations to conflict with each other. Such a dynamic reorganization results in speedups of up to 23% for the DSS queries and up to 10% for the OLTP queries.
Citation:
Juan Rubio, Charles Lefurgy, Lizy K. John, "Improving Server Performance on Transaction Processing Workloads by Enhanced Data Placement," sbac-pad, pp.84-91, 16th Symposium on Computer Architecture and High Performance Computing (SBAC-PAD'04), 2004
Usage of this product signifies your acceptance of the Terms of Use.