{"id":"https://openalex.org/W3029651391","doi":"https://doi.org/10.1145/3318464.3389765","title":"Stochastic Package Queries in Probabilistic Databases","display_name":"Stochastic Package Queries in Probabilistic Databases","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W3029651391","doi":"https://doi.org/10.1145/3318464.3389765","mag":"3029651391"},"language":"en","primary_location":{"id":"doi:10.1145/3318464.3389765","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3318464.3389765","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389765","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389765","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Matteo Brucato","orcid":null},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Matteo Brucato","raw_affiliation_strings":["University of Massachusetts Amherst, Amherst, MA, USA"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Nishant Yadav","orcid":null},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Nishant Yadav","raw_affiliation_strings":["University of Massachusetts Amherst, Amherst, MA, USA"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Azza Abouzied","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Azza Abouzied","raw_affiliation_strings":["New York University Abu Dhabi, Abu Dhabi, UAE"],"affiliations":[{"raw_affiliation_string":"New York University Abu Dhabi, Abu Dhabi, UAE","institution_ids":[]}]},{"author_position":"middle","author":{"id":null,"display_name":"Peter J. Haas","orcid":null},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Peter J. Haas","raw_affiliation_strings":["University of Massachusetts Amherst, Amherst, MA, USA"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]},{"author_position":"last","author":{"id":null,"display_name":"Alexandra Meliou","orcid":null},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alexandra Meliou","raw_affiliation_strings":["University of Massachusetts Amherst, Amherst, MA, USA"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I24603500"],"apc_list":null,"apc_paid":null,"fwci":0.6086,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.65956476,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"269","last_page":"283"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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":0.9998999834060669,"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/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.9930999875068665,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.9926999807357788,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/solver","display_name":"Solver","score":0.6111000180244446},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.544700026512146},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5198000073432922},{"id":"https://openalex.org/keywords/probabilistic-logic","display_name":"Probabilistic logic","score":0.5127999782562256},{"id":"https://openalex.org/keywords/sequence","display_name":"Sequence (biology)","score":0.5055999755859375},{"id":"https://openalex.org/keywords/stochastic-programming","display_name":"Stochastic programming","score":0.48910000920295715},{"id":"https://openalex.org/keywords/stochastic-optimization","display_name":"Stochastic optimization","score":0.4878999888896942},{"id":"https://openalex.org/keywords/optimization-problem","display_name":"Optimization problem","score":0.4230000078678131}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7287999987602234},{"id":"https://openalex.org/C2778770139","wikidata":"https://www.wikidata.org/wiki/Q1966904","display_name":"Solver","level":2,"score":0.6111000180244446},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.544700026512146},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5198000073432922},{"id":"https://openalex.org/C49937458","wikidata":"https://www.wikidata.org/wiki/Q2599292","display_name":"Probabilistic logic","level":2,"score":0.5127999782562256},{"id":"https://openalex.org/C2778112365","wikidata":"https://www.wikidata.org/wiki/Q3511065","display_name":"Sequence (biology)","level":2,"score":0.5055999755859375},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.5006999969482422},{"id":"https://openalex.org/C137631369","wikidata":"https://www.wikidata.org/wiki/Q7617831","display_name":"Stochastic programming","level":2,"score":0.48910000920295715},{"id":"https://openalex.org/C194387892","wikidata":"https://www.wikidata.org/wiki/Q1747770","display_name":"Stochastic optimization","level":2,"score":0.4878999888896942},{"id":"https://openalex.org/C137836250","wikidata":"https://www.wikidata.org/wiki/Q984063","display_name":"Optimization problem","level":2,"score":0.4230000078678131},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.40720000863075256},{"id":"https://openalex.org/C19499675","wikidata":"https://www.wikidata.org/wiki/Q232207","display_name":"Monte Carlo method","level":2,"score":0.4002000093460083},{"id":"https://openalex.org/C2778865114","wikidata":"https://www.wikidata.org/wiki/Q7882489","display_name":"Uncertain data","level":2,"score":0.392300009727478},{"id":"https://openalex.org/C2777303404","wikidata":"https://www.wikidata.org/wiki/Q759757","display_name":"Convergence (economics)","level":2,"score":0.3874000012874603},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3783000111579895},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35429999232292175},{"id":"https://openalex.org/C174539288","wikidata":"https://www.wikidata.org/wiki/Q7246853","display_name":"Probabilistic database","level":4,"score":0.34790000319480896},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3357999920845032},{"id":"https://openalex.org/C58489278","wikidata":"https://www.wikidata.org/wiki/Q1172284","display_name":"Data set","level":2,"score":0.33070001006126404},{"id":"https://openalex.org/C41045048","wikidata":"https://www.wikidata.org/wiki/Q202843","display_name":"Linear programming","level":2,"score":0.32899999618530273},{"id":"https://openalex.org/C198531522","wikidata":"https://www.wikidata.org/wiki/Q485146","display_name":"Sample (material)","level":2,"score":0.3240000009536743},{"id":"https://openalex.org/C115988155","wikidata":"https://www.wikidata.org/wiki/Q3262192","display_name":"Decision problem","level":2,"score":0.2754000127315521},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.2721000015735626},{"id":"https://openalex.org/C55479107","wikidata":"https://www.wikidata.org/wiki/Q97663916","display_name":"Stochastic approximation","level":3,"score":0.2556000053882599},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2533000111579895}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3318464.3389765","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3318464.3389765","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389765","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2103.06784","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2103.06784","pdf_url":"https://arxiv.org/pdf/2103.06784","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/3318464.3389765","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3318464.3389765","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3318464.3389765","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1350433100","display_name":null,"funder_award_id":"CG001","funder_id":"https://openalex.org/F4320323915","funder_display_name":"Swiss Re"},{"id":"https://openalex.org/G1576246179","display_name":"CAREER: Reverse Data Management: Reverse-Engineering Data Transformations to Understand, Diagnose, and Manipulate Data","funder_award_id":"1453543","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2590317596","display_name":null,"funder_award_id":"IIS-1453543","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G3288531224","display_name":null,"funder_award_id":"CG001","funder_id":"https://openalex.org/F4320330069","funder_display_name":"Tamkeen"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8833531855","display_name":null,"funder_award_id":"CG001","funder_id":"https://openalex.org/F4320313203","funder_display_name":"New York University Abu Dhabi"},{"id":"https://openalex.org/G974757083","display_name":null,"funder_award_id":"Tamkeen","funder_id":"https://openalex.org/F4320313203","funder_display_name":"New York University Abu Dhabi"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320313203","display_name":"New York University Abu Dhabi","ror":"https://ror.org/00e5k0821"},{"id":"https://openalex.org/F4320323915","display_name":"Swiss Re","ror":null},{"id":"https://openalex.org/F4320330069","display_name":"Tamkeen","ror":null}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3029651391.pdf","grobid_xml":"https://content.openalex.org/works/W3029651391.grobid-xml"},"referenced_works_count":35,"referenced_works":["https://openalex.org/W88909337","https://openalex.org/W1931025732","https://openalex.org/W1968355947","https://openalex.org/W1981776996","https://openalex.org/W1983221302","https://openalex.org/W1989755892","https://openalex.org/W2000587848","https://openalex.org/W2009333953","https://openalex.org/W2066778083","https://openalex.org/W2078686663","https://openalex.org/W2083545691","https://openalex.org/W2086128349","https://openalex.org/W2099506495","https://openalex.org/W2099655235","https://openalex.org/W2117781171","https://openalex.org/W2123102196","https://openalex.org/W2130767905","https://openalex.org/W2143514150","https://openalex.org/W2144810465","https://openalex.org/W2150461219","https://openalex.org/W2150765347","https://openalex.org/W2153508518","https://openalex.org/W2159309155","https://openalex.org/W2204898024","https://openalex.org/W2406551241","https://openalex.org/W2481731143","https://openalex.org/W2742900359","https://openalex.org/W2765539780","https://openalex.org/W2767279681","https://openalex.org/W2790380176","https://openalex.org/W2914778962","https://openalex.org/W4250913065","https://openalex.org/W6680971561","https://openalex.org/W6844880484","https://openalex.org/W6996567491"],"related_works":[],"abstract_inverted_index":{"We":[0,48,133],"provide":[1,49,135],"methods":[2,50,83,193],"for":[3,51],"in-database":[4],"support":[5],"of":[6,21,32,105,118,129,142,156,164,188],"decision":[7,13],"making":[8],"under":[9],"uncertainty.":[10],"Many":[11],"important":[12],"problems":[14,66,158],"correspond":[15],"to":[16,63,123,144,170],"selecting":[17],"a":[18,24,30,53,93,115,136,146,154,171],"\"package\"":[19],"(bag":[20],"tuples":[22],"in":[23,40,61,77],"relational":[25],"database)":[26],"that":[27,98,167,183],"jointly":[28],"satisfy":[29],"set":[31],"constraints":[33],"while":[34],"minimizing":[35],"some":[36],"overall":[37],"\"cost\"":[38],"function;":[39],"most":[41],"real-world":[42],"problems,":[43],"the":[44,72,85,106,130,165],"data":[45,73,108],"is":[46,90,120],"uncertain.":[47],"specifying---via":[52],"SQL":[54],"extension---and":[55],"processing":[56],"stochastic":[57,78,87],"package":[58],"queries":[59],"(SPQS),":[60],"order":[62],"solve":[64,145],"optimization":[65,88,96],"over":[67,160],"uncertain":[68,107],"data,":[69],"right":[70],"where":[71,84],"resides.":[74],"Prior":[75],"work":[76],"programming":[79],"uses":[80],"Monte":[81],"Carlo":[82],"original":[86],"problem":[89,97],"approximated":[91],"by":[92],"large":[94,111,147],"deterministic":[95,148],"incorporates":[99],"many":[100],"\"scenarios\",":[101],"i.e.,":[102],"sample":[103],"realizations":[104],"values.":[109],"For":[110],"database":[112],"tables,":[113],"however,":[114],"huge":[116],"number":[117],"scenarios":[119,166],"required,":[121],"leading":[122],"poor":[124],"performance":[125],"and,":[126],"often,":[127],"failure":[128],"solver":[131],"software.":[132],"therefore":[134],"novel":[137],"\u00dfs":[138,184],"algorithm":[139],"that,":[140],"instead":[141],"trying":[143],"problem,":[149],"seamlessly":[150],"approximates":[151],"it":[152],"via":[153],"sequence":[155],"smaller":[157],"defined":[159],"carefully":[161],"crafted":[162],"\"summaries\"":[163],"accelerate":[168],"convergence":[169],"feasible":[172,196],"and":[173,197],"near-optimal":[174],"solution.":[175],"Experimental":[176],"results":[177],"on":[178],"our":[179],"prototype":[180],"system":[181],"show":[182],"can":[185],"be":[186],"orders":[187],"magnitude":[189],"faster":[190],"than":[191],"prior":[192],"at":[194],"finding":[195],"high-quality":[198],"packages.":[199]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2020-06-05T00:00:00"}