Welcome!
To use the personalized features of this site, please log in or register.
If you have forgotten your username or password, we can help.
|
 |
Plug&Join: An Easy-To-Use Generic Algorithm for Efficiently Processing Equi and Non-equi Joins
| |
|
Plug&Join: An Easy-To-Use Generic Algorithm for Efficiently Processing Equi and Non-equi Joins
Jochen van den Bercken7 , Martin Schneider7 and Bernhard Seeger7 
| (7) |
Department of Mathematics and Computer Science, University of Marburg, Hans-Meerwein-Straße, 35032 Marburg, Germany |
Abstract
This paper presents Plug&Join, a new generic algorithm for efficiently processing a broad class of different join types in
extensible database systems. Depending on the join predicate Plug&Join is called with a suitable type of index structure as
a parameter. If the inner relation fits in memory, the algorithm builds a memory resident index of the desired type on the
inner relation and probes all tuples of the outer relation against the index. Otherwise, a memory resident index is created
by sampling the inner relation. The index is then used as a partitioning function for both relations.
In order to demonstrate the flexibility of Plug&Join, we present how to implement equi joins, spatial joins and subset joins
by using memory resident B+-trees, R-trees and S-trees, respectively. Moreover, results obtained from different experiments
for the spatial join show that Plug&Join is competitive to special- purpose methods like the Partition Based Spatial-Merge
Join algorithm.
Fulltext Preview (Small, Large)
 References secured to subscribers.
|
|
|
|
|
|