The Community for Technology Leaders
2013 IEEE 29th International Conference on Data Engineering (ICDE) (2001)
Heidelberg, Germany
Apr. 2, 2001 to Apr. 6, 2001
ISBN: 0-7695-1001-9
pp: 0567
Sriram Padmanabhan , IBM T.J. Watson Research Center
Timothy Malkemus , IBM T.J. Watson Research Center
Ramesh Agarwal , IBM T.J. Watson Research Center
Anant Jhingran , IBM T.J. Watson Research Center
ABSTRACT
Abstract: Several recent papers have pointed out that database systems are not well tuned to take advantage of modern superscalar processor architectures. In particular, the Clocks-Per-Instruction (CPI) for rather simple database queries are quite poor compared to scientific kernels or SPEC benchmarks. The lack of performance of database systems has been attributed to poor utilization of caches and processor function units as well as higher branching penalties. In this paper, we argue that a block oriented processing strategy for database operations can lead to better utilization of the processors and caches generating significantly higher performance. We have implemented the block oriented processing technique for aggregation, expression evaluation, and sorting operations as a feature in the DB2 Universal Database system. We present results from representative queries on a 30 GB TPC-H database to show the value of this technique.
INDEX TERMS
CITATION
Sriram Padmanabhan, Timothy Malkemus, Ramesh Agarwal, Anant Jhingran, "Block Oriented Processing of Relational Database Operations in Modern Computer Architectures", 2013 IEEE 29th International Conference on Data Engineering (ICDE), vol. 00, no. , pp. 0567, 2001, doi:10.1109/ICDE.2001.914871
99 ms
(Ver )