{"id":"https://openalex.org/W2121722315","doi":"https://doi.org/10.1145/1807167.1807203","title":"Threshold query optimization for uncertain data","display_name":"Threshold query optimization for uncertain data","publication_year":2010,"publication_date":"2010-06-06","ids":{"openalex":"https://openalex.org/W2121722315","doi":"https://doi.org/10.1145/1807167.1807203","mag":"2121722315"},"language":"en","primary_location":{"id":"doi:10.1145/1807167.1807203","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1807167.1807203","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2010 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5055560792","display_name":"Yinian Qi","orcid":null},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Yinian Qi","raw_affiliation_strings":["Purdue University, West Lafayette, IN, USA"],"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN, USA","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103138961","display_name":"Rohit Jain","orcid":"https://orcid.org/0000-0002-6972-2330"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rohit Jain","raw_affiliation_strings":["Purdue University, West Lafayette, IN, USA"],"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN, USA","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002337940","display_name":"Sarvjeet Singh","orcid":"https://orcid.org/0000-0002-5578-5330"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]},{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sarvjeet Singh","raw_affiliation_strings":["Purdue University, West Lafayette, IN, and Google Inc., Mountain View, CA, USA"],"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN, and Google Inc., Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158","https://openalex.org/I219193219"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5006023930","display_name":"Sunil Prabhakar","orcid":"https://orcid.org/0000-0002-1224-3849"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sunil Prabhakar","raw_affiliation_strings":["Purdue University, West Lafayette, IN, USA"],"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN, USA","institution_ids":["https://openalex.org/I219193219"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5055560792"],"corresponding_institution_ids":["https://openalex.org/I219193219"],"apc_list":null,"apc_paid":null,"fwci":4.3963,"has_fulltext":false,"cited_by_count":31,"citation_normalized_percentile":{"value":0.95078115,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"315","last_page":"326"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.995199978351593,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7595838308334351},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7225415110588074},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.27511245012283325}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7595838308334351},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7225415110588074},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.27511245012283325}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1807167.1807203","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1807167.1807203","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2010 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.183.5630","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.183.5630","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.purdue.edu/homes/yqi/sigmod_yinian.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W1977848225","https://openalex.org/W1998792254","https://openalex.org/W2003571118","https://openalex.org/W2012730477","https://openalex.org/W2013333366","https://openalex.org/W2029138824","https://openalex.org/W2041763948","https://openalex.org/W2042502381","https://openalex.org/W2049199200","https://openalex.org/W2078686663","https://openalex.org/W2093584660","https://openalex.org/W2096219859","https://openalex.org/W2108009586","https://openalex.org/W2112070477","https://openalex.org/W2114157818","https://openalex.org/W2114258210","https://openalex.org/W2115986770","https://openalex.org/W2118462151","https://openalex.org/W2120825705","https://openalex.org/W2129955956","https://openalex.org/W2133246278","https://openalex.org/W2138414767","https://openalex.org/W2140237757","https://openalex.org/W2140757415","https://openalex.org/W2142909274","https://openalex.org/W2154709738","https://openalex.org/W2166916904","https://openalex.org/W2169275758","https://openalex.org/W6680722260","https://openalex.org/W6684648153"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2478288626","https://openalex.org/W2350741829","https://openalex.org/W2530322880","https://openalex.org/W1596801655"],"abstract_inverted_index":{"The":[0,60],"probabilistic":[1],"threshold":[2,26,126],"query":[3,20,98,103,131],"(PTQ)":[4],"is":[5,31,67,136],"one":[6,68],"of":[7,96],"the":[8,19,25,47,86,94,130,142],"most":[9],"common":[10],"queries":[11,53],"in":[12,34],"uncertain":[13,61],"databases,":[14],"where":[15],"all":[16],"results":[17],"satisfying":[18],"with":[21],"probabilities":[22],"that":[23,54,64,69,90],"meet":[24],"requirement":[27],"are":[28],"returned.":[29],"PTQ":[30,49,87,97],"used":[32],"widely":[33],"nearest-neighbor":[35],"queries,":[36,38,40],"range":[37],"ranking":[39],"etc.":[41],"In":[42],"this":[43],"paper,":[44],"we":[45,65],"investigate":[46],"general":[48,110],"for":[50,106,118],"arbitrary":[51,81],"SQL":[52],"involve":[55],"selections,":[56,119],"projections":[57,120],"and":[58,73,121,133],"joins.":[59,122],"database":[62],"model":[63],"use":[66],"combines":[70],"both":[71],"attribute":[72,82],"tuple":[74],"uncertainty":[75],"as":[76,78,113,115,144,146],"well":[77,114],"correlations":[79],"between":[80],"sets.":[83],"We":[84,108,123],"address":[85],"optimization":[88,111],"problem":[89],"aims":[91],"at":[92],"improving":[93],"efficiency":[95],"execution":[99],"by":[100],"enabling":[101],"alternative":[102],"plan":[104,132],"enumeration":[105],"optimization.":[107],"propose":[109],"rules":[112,116],"specifically":[117],"introduce":[124],"a":[125],"operator":[127],"(\u03c4-operator)":[128],"to":[129,139],"show":[134],"it":[135],"generally":[137],"desirable":[138],"push":[140],"down":[141],"\u03c4-operator":[143],"much":[145],"possible.":[147]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":2}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}