Random sampling techniques for space efficient online computation of order statistics of large datasets
In a recent paper [MRL98], we had described a general framework for single pass approximate quantile finding algorithms. This framework included several known algorithms as special cases. We had identified a new algorithm, within the framework, which had a significantly smaller requirement for main...
Gespeichert in:
Veröffentlicht in: | SIGMOD record 1999-06, Vol.28 (2), p.251-262 |
---|---|
Hauptverfasser: | , , |
Format: | Artikel |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
container_end_page | 262 |
---|---|
container_issue | 2 |
container_start_page | 251 |
container_title | SIGMOD record |
container_volume | 28 |
creator | Manku, Gurmeet Singh Rajagopalan, Sridhar Lindsay, Bruce G. |
description | In a recent paper [MRL98], we had described a general framework for single pass approximate quantile finding algorithms. This framework included several known algorithms as special cases. We had identified a new algorithm, within the framework, which had a significantly smaller requirement for main memory than other known algorithms. In this paper, we address two issues left open in our earlier paper. First, all known and space efficient algorithms for approximate quantile finding require advance knowledge of the length of the input sequence. Many important database applications employing quantiles cannot provide this information. In this paper, we present a novel non-uniform random sampling scheme and an extension of our framework. Together, they form the basis of a new algorithm which computes approximate quantiles without knowing the input sequence length. Second, if the desired quantile is an extreme value (e.g., within the top 1% of the elements), the space requirements of currently known algorithms are overly pessimistic. We provide a simple algorithm which estimates extreme values using less space than required by the earlier more general technique for computing all quantiles. Our principal observation here is that random sampling is quantifiably better when estimating extreme values than is the case with the median. |
doi_str_mv | 10.1145/304181.304204 |
format | Article |
fullrecord | <record><control><sourceid>proquest_cross</sourceid><recordid>TN_cdi_proquest_miscellaneous_29463374</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>29463374</sourcerecordid><originalsourceid>FETCH-LOGICAL-a2384-68197156d3f4baff1e274b067a87459f1c9ccf504fafec3f7a6253b90541fcbf3</originalsourceid><addsrcrecordid>eNo90E1LxDAQBuAgCq6rRw_ecvLWNWmSfhxl8QsWBNFzmWZn1kjb1CR78N_bUvE0w8zDwLyMXUuxkVKbOyW0rORmKrnQJ2wla60yUylzylZCFnMvqnN2EeOXEJMsxIod3mDY-55H6MfODQee0H4O7vuIkZMPPI5gkSORsw6HxP0wKeTW9-MxQXJ-4J64D3uc7DyIydk4zzoIB-R7SBAxxUt2RtBFvPqra_bx-PC-fc52r08v2_tdBrmqdFZUsi6lKfaKdAtEEvNSt6IooSq1qUna2loyQhMQWkUlFLlRbS2MlmRbUmt2u9wdg5-fSE3vosWugwH9MTZ5rQulSj3BbIE2-BgDUjMG10P4aaRo5jibJc5miXPyN4sH2__Tv90v2clxaQ</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>29463374</pqid></control><display><type>article</type><title>Random sampling techniques for space efficient online computation of order statistics of large datasets</title><source>ACM Digital Library Complete</source><creator>Manku, Gurmeet Singh ; Rajagopalan, Sridhar ; Lindsay, Bruce G.</creator><creatorcontrib>Manku, Gurmeet Singh ; Rajagopalan, Sridhar ; Lindsay, Bruce G.</creatorcontrib><description>In a recent paper [MRL98], we had described a general framework for single pass approximate quantile finding algorithms. This framework included several known algorithms as special cases. We had identified a new algorithm, within the framework, which had a significantly smaller requirement for main memory than other known algorithms. In this paper, we address two issues left open in our earlier paper. First, all known and space efficient algorithms for approximate quantile finding require advance knowledge of the length of the input sequence. Many important database applications employing quantiles cannot provide this information. In this paper, we present a novel non-uniform random sampling scheme and an extension of our framework. Together, they form the basis of a new algorithm which computes approximate quantiles without knowing the input sequence length. Second, if the desired quantile is an extreme value (e.g., within the top 1% of the elements), the space requirements of currently known algorithms are overly pessimistic. We provide a simple algorithm which estimates extreme values using less space than required by the earlier more general technique for computing all quantiles. Our principal observation here is that random sampling is quantifiably better when estimating extreme values than is the case with the median.</description><identifier>ISSN: 0163-5808</identifier><identifier>EISSN: 1943-5835</identifier><identifier>DOI: 10.1145/304181.304204</identifier><language>eng</language><publisher>New York, NY, USA: ACM</publisher><subject>Concurrency ; Data management systems ; Database management system engines ; Database query processing ; Database query processing and optimization (theory) ; Database theory ; Discrete mathematics ; Graph theory ; Information systems ; Mathematics of computing ; Models of computation ; Parallel computing models ; Probability and statistics ; Theory and algorithms for application domains ; Theory of computation</subject><ispartof>SIGMOD record, 1999-06, Vol.28 (2), p.251-262</ispartof><rights>ACM</rights><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-a2384-68197156d3f4baff1e274b067a87459f1c9ccf504fafec3f7a6253b90541fcbf3</citedby><cites>FETCH-LOGICAL-a2384-68197156d3f4baff1e274b067a87459f1c9ccf504fafec3f7a6253b90541fcbf3</cites></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://dl.acm.org/doi/pdf/10.1145/304181.304204$$EPDF$$P50$$Gacm$$H</linktopdf><link.rule.ids>314,776,780,2275,27902,27903,40174,75973</link.rule.ids></links><search><creatorcontrib>Manku, Gurmeet Singh</creatorcontrib><creatorcontrib>Rajagopalan, Sridhar</creatorcontrib><creatorcontrib>Lindsay, Bruce G.</creatorcontrib><title>Random sampling techniques for space efficient online computation of order statistics of large datasets</title><title>SIGMOD record</title><addtitle>ACM SIGMOD</addtitle><description>In a recent paper [MRL98], we had described a general framework for single pass approximate quantile finding algorithms. This framework included several known algorithms as special cases. We had identified a new algorithm, within the framework, which had a significantly smaller requirement for main memory than other known algorithms. In this paper, we address two issues left open in our earlier paper. First, all known and space efficient algorithms for approximate quantile finding require advance knowledge of the length of the input sequence. Many important database applications employing quantiles cannot provide this information. In this paper, we present a novel non-uniform random sampling scheme and an extension of our framework. Together, they form the basis of a new algorithm which computes approximate quantiles without knowing the input sequence length. Second, if the desired quantile is an extreme value (e.g., within the top 1% of the elements), the space requirements of currently known algorithms are overly pessimistic. We provide a simple algorithm which estimates extreme values using less space than required by the earlier more general technique for computing all quantiles. Our principal observation here is that random sampling is quantifiably better when estimating extreme values than is the case with the median.</description><subject>Concurrency</subject><subject>Data management systems</subject><subject>Database management system engines</subject><subject>Database query processing</subject><subject>Database query processing and optimization (theory)</subject><subject>Database theory</subject><subject>Discrete mathematics</subject><subject>Graph theory</subject><subject>Information systems</subject><subject>Mathematics of computing</subject><subject>Models of computation</subject><subject>Parallel computing models</subject><subject>Probability and statistics</subject><subject>Theory and algorithms for application domains</subject><subject>Theory of computation</subject><issn>0163-5808</issn><issn>1943-5835</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>1999</creationdate><recordtype>article</recordtype><recordid>eNo90E1LxDAQBuAgCq6rRw_ecvLWNWmSfhxl8QsWBNFzmWZn1kjb1CR78N_bUvE0w8zDwLyMXUuxkVKbOyW0rORmKrnQJ2wla60yUylzylZCFnMvqnN2EeOXEJMsxIod3mDY-55H6MfODQee0H4O7vuIkZMPPI5gkSORsw6HxP0wKeTW9-MxQXJ-4J64D3uc7DyIydk4zzoIB-R7SBAxxUt2RtBFvPqra_bx-PC-fc52r08v2_tdBrmqdFZUsi6lKfaKdAtEEvNSt6IooSq1qUna2loyQhMQWkUlFLlRbS2MlmRbUmt2u9wdg5-fSE3vosWugwH9MTZ5rQulSj3BbIE2-BgDUjMG10P4aaRo5jibJc5miXPyN4sH2__Tv90v2clxaQ</recordid><startdate>19990601</startdate><enddate>19990601</enddate><creator>Manku, Gurmeet Singh</creator><creator>Rajagopalan, Sridhar</creator><creator>Lindsay, Bruce G.</creator><general>ACM</general><scope>AAYXX</scope><scope>CITATION</scope><scope>7SC</scope><scope>8FD</scope><scope>JQ2</scope><scope>L7M</scope><scope>L~C</scope><scope>L~D</scope></search><sort><creationdate>19990601</creationdate><title>Random sampling techniques for space efficient online computation of order statistics of large datasets</title><author>Manku, Gurmeet Singh ; Rajagopalan, Sridhar ; Lindsay, Bruce G.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-a2384-68197156d3f4baff1e274b067a87459f1c9ccf504fafec3f7a6253b90541fcbf3</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>1999</creationdate><topic>Concurrency</topic><topic>Data management systems</topic><topic>Database management system engines</topic><topic>Database query processing</topic><topic>Database query processing and optimization (theory)</topic><topic>Database theory</topic><topic>Discrete mathematics</topic><topic>Graph theory</topic><topic>Information systems</topic><topic>Mathematics of computing</topic><topic>Models of computation</topic><topic>Parallel computing models</topic><topic>Probability and statistics</topic><topic>Theory and algorithms for application domains</topic><topic>Theory of computation</topic><toplevel>online_resources</toplevel><creatorcontrib>Manku, Gurmeet Singh</creatorcontrib><creatorcontrib>Rajagopalan, Sridhar</creatorcontrib><creatorcontrib>Lindsay, Bruce G.</creatorcontrib><collection>CrossRef</collection><collection>Computer and Information Systems Abstracts</collection><collection>Technology Research Database</collection><collection>ProQuest Computer Science Collection</collection><collection>Advanced Technologies Database with Aerospace</collection><collection>Computer and Information Systems Abstracts Academic</collection><collection>Computer and Information Systems Abstracts Professional</collection><jtitle>SIGMOD record</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Manku, Gurmeet Singh</au><au>Rajagopalan, Sridhar</au><au>Lindsay, Bruce G.</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Random sampling techniques for space efficient online computation of order statistics of large datasets</atitle><jtitle>SIGMOD record</jtitle><stitle>ACM SIGMOD</stitle><date>1999-06-01</date><risdate>1999</risdate><volume>28</volume><issue>2</issue><spage>251</spage><epage>262</epage><pages>251-262</pages><issn>0163-5808</issn><eissn>1943-5835</eissn><abstract>In a recent paper [MRL98], we had described a general framework for single pass approximate quantile finding algorithms. This framework included several known algorithms as special cases. We had identified a new algorithm, within the framework, which had a significantly smaller requirement for main memory than other known algorithms. In this paper, we address two issues left open in our earlier paper. First, all known and space efficient algorithms for approximate quantile finding require advance knowledge of the length of the input sequence. Many important database applications employing quantiles cannot provide this information. In this paper, we present a novel non-uniform random sampling scheme and an extension of our framework. Together, they form the basis of a new algorithm which computes approximate quantiles without knowing the input sequence length. Second, if the desired quantile is an extreme value (e.g., within the top 1% of the elements), the space requirements of currently known algorithms are overly pessimistic. We provide a simple algorithm which estimates extreme values using less space than required by the earlier more general technique for computing all quantiles. Our principal observation here is that random sampling is quantifiably better when estimating extreme values than is the case with the median.</abstract><cop>New York, NY, USA</cop><pub>ACM</pub><doi>10.1145/304181.304204</doi><tpages>12</tpages><oa>free_for_read</oa></addata></record> |
fulltext | fulltext |
identifier | ISSN: 0163-5808 |
ispartof | SIGMOD record, 1999-06, Vol.28 (2), p.251-262 |
issn | 0163-5808 1943-5835 |
language | eng |
recordid | cdi_proquest_miscellaneous_29463374 |
source | ACM Digital Library Complete |
subjects | Concurrency Data management systems Database management system engines Database query processing Database query processing and optimization (theory) Database theory Discrete mathematics Graph theory Information systems Mathematics of computing Models of computation Parallel computing models Probability and statistics Theory and algorithms for application domains Theory of computation |
title | Random sampling techniques for space efficient online computation of order statistics of large datasets |
url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-27T10%3A00%3A12IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_cross&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Random%20sampling%20techniques%20for%20space%20efficient%20online%20computation%20of%20order%20statistics%20of%20large%20datasets&rft.jtitle=SIGMOD%20record&rft.au=Manku,%20Gurmeet%20Singh&rft.date=1999-06-01&rft.volume=28&rft.issue=2&rft.spage=251&rft.epage=262&rft.pages=251-262&rft.issn=0163-5808&rft.eissn=1943-5835&rft_id=info:doi/10.1145/304181.304204&rft_dat=%3Cproquest_cross%3E29463374%3C/proquest_cross%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_pqid=29463374&rft_id=info:pmid/&rfr_iscdi=true |