|
Published Articles >> Table of Contents >> Abstract
14th Euromicro International Conference on Parallel, Distributed, and Network-Based Processing (PDP'06)
pp. 28--35
Dynamic out of Core Join Processing in Symmetric Multiprocessors
Josep Aguilar-Saborit, Universitat Politecnica de Catalunya
Victor Muntes-Mulero, Universitat Politecnica de Catalunya
Calisto Zuzarte, IBM Toronto Lab.
Adriana Zubiri, IBM Toronto Lab.
Josep-L. Larriba-Pey, Universitat Politecnica de Catalunya
Full Article Text:
 
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/PDP.2006.31
Send link to a friend
| Abstract |
|
The use of clusters of Symmetric Multiprocessor
(SMP) configurations in database processing has become
a key factor in allowing greater scalability. It
has also posed many challenges in the implementation
of one of the most costly operations within relational
algebra: the join operation. When massive data is involved,
usually the join cannot be performed in-memory
and is processed out of core. In this case, performance
depends on an effective use of the memory hierarchy,
such that I/O and memory contention are
minimized. In this paper we propose a parallel algorithm
for out of core join processing that dynamically
adapts its behavior to the resources available in the system.
We evaluate and compare our proposal against
other parallel approaches in a real SMP cluster in a major
commercial database, the IBMR® DB2R® Universal
Database™ product (DB2 UDB). Results show
that our proposal outperforms previous work significantly.
|
 Additional Information
|
Citation:
Josep Aguilar-Saborit, Victor Muntes-Mulero, Calisto Zuzarte, Adriana Zubiri, Josep-L. Larriba-Pey,
"Dynamic out of Core Join Processing in Symmetric Multiprocessors,"
pdp,
pp. 28--35,
14th Euromicro International Conference on Parallel, Distributed, and Network-Based Processing (PDP'06),
2006
|
|
