Robust and efficient algorithms for rank join evaluation

In the rank join problem we are given a relational join R1 1 R2 and a function that assigns numeric scores to the join tuples, and the goal is to return the tuples with the highest score. This problem lies at the core of processing top-k SQL queries, and recent studies have introduced specialized operators that solve the rank join problem by accessing only a subset of the input tuples. A desirable property for such operators is instance-optimality, i.e., their I/O cost should remain within a factor of the optimal for different inputs. However, a recent theoretical study has shown that existing rank join operators are not instance-optimal even though they have been shown to perform well empirically. The same study proposed the PBRJRR FR operator that was proved to be instance-optimal, but its performance was not tested empirically and in fact it was hinted that its complexity can be high. Thus, the following important question is raised: Is it possible to design a rank join operator th...

• Type: Conference
• Year: 2009
• Where: SIGMOD
• Authors: Jonathan Finger, Neoklis Polyzotis
• Keywords: Database, PBRJRR FR Operator, Rank Join Operators, Rank Join Problem, SIGMOD 2009