Self-join size estimation in large-scale distributed data systems

Pitoura, T. and Triantafillou, P. (2008) Self-join size estimation in large-scale distributed data systems. In: 24th International Conference on Data Engineering (ICDE 2008), Cancun, Mexico, 7-12 Apr 2008, (doi: 10.1109/ICDE.2008.4497485)

Abstract

In this work we tackle the open problem of self-join size (SJS) estimation in a large-scale distributed data system, where tuples of a relation are distributed over data nodes which comprise an overlay network. Our contributions include adaptations of five well-known SJS estimation centralized techniques (coined sequential, cross-sampling, adaptive, bifocal, and sample-count) to the network environment and a novel technique which is based on the use of the Gini coefficient. We develop analyses showing how Gini estimations can lead to estimations of the underlying Zipfian or power-law value distributions. We further contribute distributed sampling algorithms that can estimate accurately and efficiently the Gini coefficient. Finally, we provide detailed experimental evidence testifying for the claimed increased accuracy, precision, and efficiency of the proposed SJS estimation method, compared to the other methods. The proposed approach is the only one to ensure high efficiency, precision, and accuracy regardless of the skew of the underlying data.

• Item Type: Conference Proceedings
• Additional Information: ISBN: 9781424418367
• Status: Published
• Refereed: Yes
• Glasgow Author(s) Enlighten ID: Triantafillou, Professor Peter
• Authors: Pitoura, T., and Triantafillou, P.
• College/School: College of Science and Engineering > School of Computing Science