skip to main content
10.1145/3357384.3358084acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
short-paper

Estimating the Number of Distinct Items in a Database by Sampling

Published:03 November 2019Publication History

ABSTRACT

Counting the number of distinct items in a dataset is a well known computational problem with numerous applications. Sometimes, exact counting is infeasible, and one must use some approximation method. One approach to approximation is to estimate the number of distinct items from a random sample. This approach is useful, for example, when the dataset is too big, or when only a sample is available, but not the entire data. Moreover, it can considerably speed up the computation. In statistics, this problem is known as the \em Unseen Species Problem. In this paper, we propose an estimation method for this problem, which is especially suitable for cases where the sample is much smaller than the entire set, and the number of repetitions of each item is relatively small. Our method is simple in comparison to known methods, and gives good enough estimates to make it useful in certain real life datasets that arise in data mining scenarios. We demonstrate our method on real data where the task at hand is to estimate the number of duplicate URLs.

References

  1. . Chung, M. L. Mortensen, C. Binnig, T. Kraska,Estimating the Impact of Unknown Unknowns on Aggregate Query Results,SIGMOD 2016, 861--876, 2016.Google ScholarGoogle Scholar
  2. . Efron and R. Thisted, Estimating the number of unseen species (How many words did Shakespeare know?) Biometrika 63(3), 435--447, 1976.Google ScholarGoogle Scholar
  3. . A. Fisher, A. S. Corbet, and C. B. Williams, The relation between the number of species and the number of individuals in a random sample of an animal population, Journal of Animal Ecology 12(1), 42--58, 1943.Google ScholarGoogle ScholarCross RefCross Ref
  4. . J. Good and G. H. Toulmin. The number of new species, and the increase in population coverage, when a sample is increased. Biometrika 43(1--2), 45--63, 1956.Google ScholarGoogle Scholar
  5. . M. Kane, J. Nelson, D. P. Woodruff. An Optimal Algorithm for the Distinct Elements Problem. Proceedings of the 29-th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems 41--52, 2010.Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. . Orlitsky, A. T. Suresh and Y. Wu, Optimal prediction of the number of unseen species, PNAS 113(47), 13283--13288, 2016. Proceedings of the SIGMOD Conference 2016.Google ScholarGoogle Scholar

Index Terms

  1. Estimating the Number of Distinct Items in a Database by Sampling

            Recommendations

            Comments

            Login options

            Check if you have access through your login credentials or your institution to get full access on this article.

            Sign in
            • Published in

              cover image ACM Conferences
              CIKM '19: Proceedings of the 28th ACM International Conference on Information and Knowledge Management
              November 2019
              3373 pages
              ISBN:9781450369763
              DOI:10.1145/3357384

              Copyright © 2019 ACM

              Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

              Publisher

              Association for Computing Machinery

              New York, NY, United States

              Publication History

              • Published: 3 November 2019

              Permissions

              Request permissions about this article.

              Request Permissions

              Check for updates

              Qualifiers

              • short-paper

              Acceptance Rates

              CIKM '19 Paper Acceptance Rate202of1,031submissions,20%Overall Acceptance Rate1,861of8,427submissions,22%

              Upcoming Conference

            • Article Metrics

              • Downloads (Last 12 months)3
              • Downloads (Last 6 weeks)1

              Other Metrics

            PDF Format

            View or Download as a PDF file.

            PDF

            eReader

            View online with eReader.

            eReader