Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/3452021.3458323acmconferencesArticle/Chapter ViewAbstractPublication PagespodsConference Proceedingsconference-collections
research-article
Open access

Relative Error Streaming Quantiles

Published: 20 June 2021 Publication History
  • Get Citation Alerts
  • Abstract

    Approximating ranks, quantiles, and distributions over streaming data is a central task in data analysis and monitoring. Given a stream of n items from a data universe U equipped with a total order, the task is to compute a sketch (data structure) of size poly (log(n), 1/ε). Given the sketch and a query item y ∈ U, one should be able to approximate its rank in the stream, i.e., the number of stream elements smaller than or equal to y. Most works to date focused on additive ε n error approximation, culminating in the KLL sketch that achieved optimal asymptotic behavior. This paper investigates multiplicative (1±ε)$-error approximations to the rank. Practical motivation for multiplicative error stems from demands to understand the tails of distributions, and hence for sketches to be more accurate near extreme values. The most space-efficient algorithms due to prior work store either O(log(ε2 n)/ε2) or O(log3(ε n)/ε) universe items. This paper presents a randomized algorithm storing O(log1.5 (ε n)/ε) items, which is within an O(√log(ε n)) factor of optimal. The algorithm does not require prior knowledge of the stream length and is fully mergeable, rendering it suitable for parallel and distributed computing environments.

    Supplementary Material

    MP4 File (PODS21-pods050.mp4)
    Presentation video briefly introducing paper "Relative Error Streaming Quantiles".

    References

    [1]
    Pankaj K Agarwal, Graham Cormode, Zengfeng Huang, Jeff M Phillips, Zhewei Wei, and Ke Yi. Mergeable summaries. ACM Transactions on Database Systems (TODS), 38(4):26, 2013.
    [2]
    Rakesh Agrawal and Arun Swami. A one-pass space-efficient algorithm for finding quantiles. In Proc. 7th Intl. Conf. Management of Data (COMAD-95), Pune, India, 1995.
    [3]
    Arvind Arasu and Gurmeet Singh Manku. Approximate counts and quantiles over sliding windows. In Proceedings of the 23rd ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, PODS '04, pages 286--296. ACM, 2004.
    [4]
    Graham Cormode, Flip Korn, S. Muthukrishnan, and Divesh Srivastava. Effective computation of biased quantiles over data streams. In Proceedings of the 21st International Conference on Data Engineering, ICDE '05, pages 20--31, Washington, DC, USA, 2005. IEEE Computer Society.
    [5]
    Graham Cormode, Flip Korn, S Muthukrishnan, and Divesh Srivastava. Space-and time-efficient deterministic algorithms for biased quantiles over data streams. In Proceedings of the 25th ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, PODS '06, pages 263--272. ACM, 2006.
    [6]
    Graham Cormode and Pavel Veselý. A tight lower bound for comparison-based quantile summaries. In Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems, PODS'20, page 81--93, New York, NY, USA, 2020. ACM.
    [7]
    Ted Dunning and Otmar Ertl. Computing extremely accurate quantiles using t-digests. CoRR, abs/1902.04023, 2019.
    [8]
    David Felber and Rafail Ostrovsky. A randomized online quantile summary in O(1/epsilon * log(1/epsilon)) words. In Approximation, Randomization, and Combinatorial Optimization. Algorithms and Techniques (APPROX/RANDOM 2015), volume 40 of Leibniz International Proceedings in Informatics (LIPIcs), pages 775--785, Dagstuhl, Germany, 2015. Schloss Dagstuhl--Leibniz-Zentrum fuer Informatik.
    [9]
    Sumit Ganguly. A nearly optimal and deterministic summary structure for update data streams. arXiv preprint cs/0701020, 2007.
    [10]
    Michael Greenwald and Sanjeev Khanna. Space-efficient online computation of quantile summaries. In ACM SIGMOD Record, volume 30, pages 58--66. ACM, 2001.
    [11]
    Anupam Gupta and Francis X. Zane. Counting inversions in lists. In Proceedings of the 14th Annual ACM-SIAM Symposium on Discrete Algorithms, SODA '03, pages 253--254, Philadelphia, PA, USA, 2003. Society for Industrial and Applied Mathematics.
    [12]
    Zohar Karnin, Kevin Lang, and Edo Liberty. Optimal quantile approximation in streams. In Proceedings of the 57th Annual Symposium on Foundations of Computer Science (FOCS '16), pages 71--78. IEEE, 2016.
    [13]
    Ge Luo, Lu Wang, Ke Yi, and Graham Cormode. Quantiles over data streams: Experimental comparisons, new analyses, and further improvements. The VLDB Journal, 25(4):449--472, August 2016.
    [14]
    Gurmeet Singh Manku, Sridhar Rajagopalan, and Bruce G Lindsay. Approximate medians and other quantiles in one pass and with limited memory. In ACM SIGMOD Record, volume 27, pages 426--435. ACM, 1998.
    [15]
    Gurmeet Singh Manku, Sridhar Rajagopalan, and Bruce G Lindsay. Random sampling techniques for space efficient online computation of order statistics of large datasets. In ACM SIGMOD Record, volume 28, pages 251--262. ACM, 1999.
    [16]
    Charles Masson, Jee E. Rim, and Homin K. Lee. DDSketch: A fast and fully-mergeable quantile sketch with relative-error guarantees. PVLDB, 12(12):2195--2205, 2019.
    [17]
    J Ian Munro and Michael S Paterson. Selection and sorting with limited storage. Theoretical computer science, 12(3):315--323, 1980.
    [18]
    Ira Pohl. A minimum storage algorithm for computing the median. IBM TJ Watson Research Center, 1969.
    [19]
    Viswanath Poosala, Venkatesh Ganti, and Yannis E. Ioannidis. Approximate query answering using histograms. IEEE Data Eng. Bull., 22(4):5--14, 1999.
    [20]
    Lee Rhodes, Kevin Lang, Alexander Saydakov, Edo Liberty, and Justin Thaler. DataSketches: A library of stochastic streaming algorithms. Open source software: https://datasketches.apache.org/, 2013.
    [21]
    Nisheeth Shrivastava, Chiranjeeb Buragohain, Divyakant Agrawal, and Subhash Suri. Medians and beyond: new aggregation techniques for sensor networks. In Proceedings of the 2nd international conference on Embedded networked sensor systems, pages 239--249. ACM, 2004.
    [22]
    Gil Tene. How NOT to measure latency. https://www.youtube.com/watch?v=lJ8ydIuPFeU, 2015.
    [23]
    Qi Zhang and Wei Wang. An efficient algorithm for approximate biased quantile computation in data streams. In Proceedings of the 16th ACM conference on Conference on information and knowledge management, pages 1023--1026, 2007.
    [24]
    Ying Zhang, Xuemin Lin, Jian Xu, Flip Korn, and Wei Wang. Space-efficient relative error order sketch over data streams. In Proceedings of the 22nd International Conference on Data Engineering (ICDE'06), pages 51--51. IEEE, 2006.

    Cited By

    View all
    • (2024)Simple & Optimal Quantile Sketch: Combining Greenwald-Khanna with Khanna-GreenwaldProceedings of the ACM on Management of Data10.1145/36516102:2(1-25)Online publication date: 14-May-2024
    • (2024)Determining Exact Quantiles with Randomized SummariesProceedings of the ACM on Management of Data10.1145/36392802:1(1-26)Online publication date: 26-Mar-2024
    • (2023)CORE-Sketch: On Exact Computation of Median Absolute Deviation with Limited SpaceProceedings of the VLDB Endowment10.14778/3611479.361149116:11(2832-2844)Online publication date: 1-Jul-2023
    • Show More Cited By

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    PODS'21: Proceedings of the 40th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems
    June 2021
    440 pages
    ISBN:9781450383813
    DOI:10.1145/3452021
    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]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 20 June 2021

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. quantiles
    2. streaming algorithms

    Qualifiers

    • Research-article

    Funding Sources

    Conference

    SIGMOD/PODS '21
    Sponsor:

    Acceptance Rates

    Overall Acceptance Rate 642 of 2,707 submissions, 24%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)204
    • Downloads (Last 6 weeks)24

    Other Metrics

    Citations

    Cited By

    View all
    • (2024)Simple & Optimal Quantile Sketch: Combining Greenwald-Khanna with Khanna-GreenwaldProceedings of the ACM on Management of Data10.1145/36516102:2(1-25)Online publication date: 14-May-2024
    • (2024)Determining Exact Quantiles with Randomized SummariesProceedings of the ACM on Management of Data10.1145/36392802:1(1-26)Online publication date: 26-Mar-2024
    • (2023)CORE-Sketch: On Exact Computation of Median Absolute Deviation with Limited SpaceProceedings of the VLDB Endowment10.14778/3611479.361149116:11(2832-2844)Online publication date: 1-Jul-2023
    • (2023)Together is Better: Heavy Hitters Quantile EstimationProceedings of the ACM on Management of Data10.1145/35889371:1(1-25)Online publication date: 30-May-2023
    • (2023)Online Data Drift Detection for Anomaly Detection Services based on Deep Learning towards Multivariate Time Series2023 IEEE 23rd International Conference on Software Quality, Reliability, and Security (QRS)10.1109/QRS60937.2023.00011(1-11)Online publication date: 22-Oct-2023
    • (2022)Technical PerspectiveACM SIGMOD Record10.1145/3542700.354271651:1(68-68)Online publication date: 1-Jun-2022
    • (2022)Current Trends in Data SummariesACM SIGMOD Record10.1145/3516431.351643350:4(6-15)Online publication date: 31-Jan-2022
    • (2022) Deterministic, Fast and Accurate Solution of the Heavy Hitters q -Tail Latencies Problem IEEE Access10.1109/ACCESS.2022.321239310(106386-106399)Online publication date: 2022
    • (2021) Asymmetric scale functions for t -digests Journal of Statistical Computation and Simulation10.1080/00949655.2021.193652392:1(191-210)Online publication date: 1-Jul-2021

    View Options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Get Access

    Login options

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media