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
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/IDEAS.2005.24
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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||