Apr. 2, 2001 to Apr. 6, 2001
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: 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.
Sriram Padmanabhan, Timothy Malkemus, Ramesh Agarwal, Anant Jhingran, "Block Oriented Processing of Relational Database Operations in Modern Computer Architectures", ICDE, 2001, 2013 IEEE 29th International Conference on Data Engineering (ICDE), 2013 IEEE 29th International Conference on Data Engineering (ICDE) 2001, pp. 0567, doi:10.1109/ICDE.2001.914871