loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
17th International Conference on Data Engineering (ICDE'01)
Block Oriented Processing of Relational Database Operations in Modern Computer Architectures
Heidelberg, Germany
April 02-April 06
ISBN: 0-7695-1001-9
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.
Citation:
Sriram Padmanabhan, Timothy Malkemus, Ramesh Agarwal, Anant Jhingran, "Block Oriented Processing of Relational Database Operations in Modern Computer Architectures," icde, pp.0567, 17th International Conference on Data Engineering (ICDE'01), 2001
Usage of this product signifies your acceptance of the Terms of Use.