{"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","alternate_titles":[],"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","doi":"https://doi.org/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":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"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"},"parent_works":[],"lineage":["https://openalex.org/W3029651391"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"bronze","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,"observed_orcids":[]},"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":"Matteo Brucato","raw_affiliation_strings":["University of Massachusetts Amherst, Amherst, MA, USA"],"raw_orcid":null,"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,"observed_orcids":[]},"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"],"raw_orcid":null,"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,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I120250893","display_name":"New York University Abu Dhabi","ror":"https://ror.org/00e5k0821","country_code":"AE","type":"education","lineage":["https://openalex.org/I120250893","https://openalex.org/I57206974"]}],"countries":["AE"],"is_corresponding":false,"raw_author_name":"Azza Abouzied","raw_affiliation_strings":["New York University Abu Dhabi, Abu Dhabi, UAE"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"New York University Abu Dhabi, Abu Dhabi, UAE","institution_ids":["https://openalex.org/I120250893"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Peter J. Haas","orcid":null,"observed_orcids":[]},"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"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5019048013","display_name":"Alexandra Meliou","orcid":"https://orcid.org/0000-0001-7346-6002","observed_orcids":["https://orcid.org/0000-0001-7346-6002"]},"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"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7969,"has_fulltext":true,"cited_by_count":11,"citation_normalized_percentile":{"value":0.68681197,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":97},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9810000061988831,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9810000061988831,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11106","display_name":"Data Management and Algorithms","score":0.016699999570846558,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11413","display_name":"Risk and Portfolio Optimization","score":0.00039999998989515007,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/probabilistic-databases","display_name":"probabilistic databases","score":0.9829999804496765},{"id":"https://openalex.org/keywords/data-uncertainty","display_name":"data uncertainty","score":0.7059999704360962},{"id":"https://openalex.org/keywords/stochastic-optimization","display_name":"stochastic optimization","score":0.6800000071525574},{"id":"https://openalex.org/keywords/decision-making-under-uncertainty","display_name":"decision making under uncertainty","score":0.871999979019165},{"id":"https://openalex.org/keywords/sql-extension","display_name":"SQL extension","score":0.5740000009536743},{"id":"https://openalex.org/keywords/convergence-acceleration","display_name":"convergence acceleration","score":0.5809999704360962}],"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":3,"locations":[{"id":"doi:10.1145/3318464.3389765","doi":"https://doi.org/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":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"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","doi":null,"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":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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"},{"id":"doi:10.48550/arxiv.2103.06784","doi":"https://doi.org/10.48550/arxiv.2103.06784","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2103.06784","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.1145/3318464.3389765","doi":"https://doi.org/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":{"id":"https://openalex.org/S4393915683","display_name":"ACM SIGMOD International Conference on Management of Data (SIGMOD)","issn_l":"0730-8078","issn":["0730-8078"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"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":[],"study_designs":[],"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/G3288531224","display_name":null,"funder_award_id":"CG001","funder_id":"https://openalex.org/F4320330069","funder_display_name":"Tamkeen"},{"id":"https://openalex.org/G7970244442","display_name":"EAGER: In-Database Prescriptive Analytics under Uncertainty","funder_award_id":"1943971","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"}],"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":"https://ror.org/0377apf83"},{"id":"https://openalex.org/F4320330069","display_name":"Tamkeen","ror":"https://ror.org/00bqpz325"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3029651391.pdf","grobid_xml":"https://content.openalex.org/works/W3029651391.grobid-xml"},"referenced_works_count":51,"referenced_works":["https://openalex.org/W88909337","https://openalex.org/W649930599","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/W2005316625","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/W2104371886","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/W2170703677","https://openalex.org/W2204898024","https://openalex.org/W2294586855","https://openalex.org/W2322524800","https://openalex.org/W2338322935","https://openalex.org/W2406551241","https://openalex.org/W2460718840","https://openalex.org/W2481731143","https://openalex.org/W2742900359","https://openalex.org/W2765539780","https://openalex.org/W2767279681","https://openalex.org/W2790380176","https://openalex.org/W2912722627","https://openalex.org/W3026401746","https://openalex.org/W3106992008","https://openalex.org/W4211035117","https://openalex.org/W4248846162","https://openalex.org/W4250913065","https://openalex.org/W4255007865","https://openalex.org/W4300260142","https://openalex.org/W4300306656","https://openalex.org/W4302377426","https://openalex.org/W6680971561","https://openalex.org/W6844880484","https://openalex.org/W6996567491"],"related_works":["https://openalex.org/W4414041780","https://openalex.org/W3081626970","https://openalex.org/W2599036750","https://openalex.org/W2519235990","https://openalex.org/W2295864763","https://openalex.org/W1992585497","https://openalex.org/W2615139629","https://openalex.org/W4248846162","https://openalex.org/W2765539780"],"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]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3029651391","counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2020-06-05T00:00:00"}
