Distinct Counting With a Self-Learning Bitmap

DOI10.1198/JASA.2011.AP10217zbMATH Open1229.62158arXiv1107.1697OpenAlexW1965575862MaRDI QIDQ3111182

Author name not available (Why is that?)

Publication date: 18 January 2012

Published in: (Search for Journal in Brave)

Abstract: Counting the number of distinct elements (cardinality) in a dataset is a fundamental problem in database management. In recent years, due to many of its modern applications, there has been significant interest to address the distinct counting problem in a data stream setting, where each incoming data can be seen only once and cannot be stored for long periods of time. Many probabilistic approaches based on either sampling or sketching have been proposed in the computer science literature, that only require limited computing and memory resources. However, the performances of these methods are not scale-invariant, in the sense that their relative root mean square estimation errors (RRMSE) depend on the unknown cardinalities. This is not desirable in many applications where cardinalities can be very dynamic or inhomogeneous and many cardinalities need to be estimated. In this paper, we develop a novel approach, called self-learning bitmap (S-bitmap) that is scale-invariant for cardinalities in a specified range. S-bitmap uses a binary vector whose entries are updated from 0 to 1 by an adaptive sampling process for inferring the unknown cardinality, where the sampling rates are reduced sequentially as more and more entries change from 0 to 1. We prove rigorously that the S-bitmap estimate is not only unbiased but scale-invariant. We demonstrate that to achieve a small RRMSE value of $epsilon$ or less, our approach requires significantly less memory and consumes similar or less operations than state-of-the-art methods for many common practice cardinality scales. Both simulation and experimental studies are reported.

Full work available at URL: https://arxiv.org/abs/1107.1697

zbMATH Keywords

No records found.

Mathematics Subject Classification ID

No records found.

This page was built for publication: Distinct Counting With a Self-Learning Bitmap

Report a bug (only for logged in users!)Click here to report a bug for this page (MaRDI item Q3111182)