The Community for Technology Leaders
RSS Icon
Subscribe
Long Beach, CA, USA
Mar. 1, 2010 to Mar. 6, 2010
ISBN: 978-1-4244-5445-7
pp: 1018-1024
Yu Xu , Teradata, San Diego, USA
Pekka Kostamaa , Teradata, El Segundo, USA
ABSTRACT
Large enterprises have been relying on parallel database management systems (PDBMS) to process their ever-increasing data volume and complex queries. Business intelligence tools used by enterprises frequently generate a large number of outer joins and require high performance from the underlying database systems. A common type of outer joins in business applications is the small-large table outer join studied in this paper where one table is relatively small and the other is large. We present an efficient and easy to implement algorithm called DER (Duplication and Efficient Redistribution) for small and large table outer joins. Our experimental results show that the DER algorithm significantly speeds up query elapsed time and scales linearly.
CITATION
Yu Xu, Pekka Kostamaa, "A new algorithm for small-large table outer joins in parallel DBMS", ICDE, 2010, 2013 IEEE 29th International Conference on Data Engineering (ICDE), 2013 IEEE 29th International Conference on Data Engineering (ICDE) 2010, pp. 1018-1024, doi:10.1109/ICDE.2010.5447835
27 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool