Characterization of TPC-H queries for a column-oriented database on a dual-core amd athlon processor

Pranav Vaidya, Jaehwan (John) Lee
2008 Proceeding of the 17th ACM conference on Information and knowledge mining - CIKM '08  
Column-oriented databases are reported to perform orders of magnitude faster than traditional row-oriented databases for Decision Support System (DSS) workloads. However, there have been few investigations on the detailed hardware characterization of DSS benchmarks namely TPC-H for column-oriented databases. In this paper, we characterize the performance of the TPC-H benchmark for a popular column-oriented database called MonetDB running on a dual-core AMD Athlon machine. Specifically, we
more » ... e the performance of key microarchitectural components and provide very detailed analysis of the execution time breakdown of Mon-etDB during the execution of TPC-H queries. We analyze in detail the nature of the various stalls namely cache stalls, branch misprediction stalls and resource stalls in order to identify the causes of these performance impediments in column-oriented databases. We then indicate possible research directions to minimize these stalls in column-oriented databases. Finally, we compare our results with published results on the characterization of TPC-H for row-oriented databases. As opposed to the previous approaches that used system-level monitoring, we used thread-level monitoring of database threads to study the performance of the database alone in isolation from the rest of the system. This enabled us to characterize the performance of databases independent of any other executing processes.
doi:10.1145/1458082.1458306 dblp:conf/cikm/VaidyaL08 fatcat:6lkdj6vfnrhdnnrqmfjbvp7zbe