loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
9th International Database Engineering & Application Symposium (IDEAS'05)
Efficient Relational Joins with Arithmetic Constraints on Multiple Attributes
Montreal, Canada
July 25-July 27
ISBN: 0-7695-2404-4
Chuang Liu, University of Chicago
Lingyun Yang, University of Chicago
Ian Foster, Argonne National Lab
We introduce and study a new class of queries that we refer to as ACMA (arithmetic constraints on multiple attributes) queries. Such combinatorial queries require the simultaneous satisfaction of arithmetic constraints on three or more attributes from different relations, and thus often involve expensive multi-join operations. Building on techniques from constraint programming, we develop preprocessing methods, algorithms, and a new constrained join operator that allow ACMA queries to be evaluated efficiently within a conventional relational database engine. We present the results of a careful performance evaluation of both our new approach and the conventional nested-loop join algorithm. Measurements of tuples read, intermediate tuples generated, and execution time shows that our approach achieves superior performance for ACMA joins.
Citation:
Chuang Liu, Lingyun Yang, Ian Foster, "Efficient Relational Joins with Arithmetic Constraints on Multiple Attributes," ideas, pp.210-220, 9th International Database Engineering & Application Symposium (IDEAS'05), 2005
Usage of this product signifies your acceptance of the Terms of Use.