{"id":"https://openalex.org/W4404990218","doi":"https://doi.org/10.48550/arxiv.2411.17915","title":"Stochastic SketchRefine: Scaling In-Database Decision-Making under Uncertainty to Millions of Tuples","display_name":"Stochastic SketchRefine: Scaling In-Database Decision-Making under Uncertainty to Millions of Tuples","publication_year":2024,"publication_date":"2024-11-26","ids":{"openalex":"https://openalex.org/W4404990218","doi":"https://doi.org/10.48550/arxiv.2411.17915"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2411.17915","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2411.17915","pdf_url":"https://arxiv.org/pdf/2411.17915","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2411.17915","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5055514521","display_name":"Riddho Ridwanul Haque","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Haque, Riddho R.","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058307425","display_name":"Anh Mai","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mai, Anh L.","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072749095","display_name":"Matteo Brucato","orcid":"https://orcid.org/0000-0003-2730-6432"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Brucato, Matteo","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044418740","display_name":"Azza Abouzied","orcid":"https://orcid.org/0000-0003-4273-2536"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Abouzied, Azza","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090729930","display_name":"Peter J. Haas","orcid":"https://orcid.org/0000-0001-5694-3065"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Haas, Peter J.","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5019048013","display_name":"Alexandra Meliou","orcid":"https://orcid.org/0000-0001-7346-6002"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Meliou, Alexandra","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5055514521"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9545000195503235,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9545000195503235,"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/T11106","display_name":"Data Management and Algorithms","score":0.9139000177383423,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.8471807241439819},{"id":"https://openalex.org/keywords/scaling","display_name":"Scaling","score":0.6470689177513123},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5717868804931641},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5031909346580505},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.22879868745803833},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.09686368703842163}],"concepts":[{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.8471807241439819},{"id":"https://openalex.org/C99844830","wikidata":"https://www.wikidata.org/wiki/Q102441924","display_name":"Scaling","level":2,"score":0.6470689177513123},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5717868804931641},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5031909346580505},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.22879868745803833},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.09686368703842163},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2411.17915","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2411.17915","pdf_url":"https://arxiv.org/pdf/2411.17915","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2411.17915","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2411.17915","pdf_url":null,"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2411.17915","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2411.17915","pdf_url":"https://arxiv.org/pdf/2411.17915","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[{"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/G4687535830","display_name":"III: SMALL: Scalable In-Database Prescriptive Analytics for Dynamic Environments","funder_award_id":"2211918","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"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/F4320330069","display_name":"Tamkeen","ror":null}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4404990218.pdf","grobid_xml":"https://content.openalex.org/works/W4404990218.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W4245395944","https://openalex.org/W2143551613","https://openalex.org/W2138823233","https://openalex.org/W1979740464","https://openalex.org/W2143345456","https://openalex.org/W1789991335","https://openalex.org/W2562731034"],"abstract_inverted_index":{"Decision":[0],"making":[1],"under":[2],"uncertainty":[3],"often":[4],"requires":[5],"choosing":[6],"packages,":[7],"or":[8,40],"bags":[9],"of":[10,43,47,63,74,93,102,133,167,170,205,221,228],"tuples,":[11,50],"that":[12,192],"collectively":[13],"optimize":[14],"expected":[15],"outcomes":[16],"while":[17],"limiting":[18],"risks.":[19],"Processing":[20],"Stochastic":[21,185,214],"Package":[22],"Queries":[23],"(SPQs)":[24],"involves":[25],"solving":[26],"very":[27],"large":[28,115,196],"optimization":[29,76,95,198],"problems":[30],"on":[31,114],"uncertain":[32],"data.":[33],"Monte":[34],"Carlo":[35],"methods":[36,81],"create":[37],"numerous":[38],"scenarios,":[39],"sample":[41],"realizations":[42],"the":[44,49,72,75,87,90,94,100,105,125,168,226,229],"stochastic":[45,118,197],"attributes":[46,119],"all":[48],"and":[51,70,89,179,189,213],"generate":[52],"packages":[53,218],"with":[54,84,99,120],"optimal":[55],"objective":[56],"values":[57],"across":[58],"these":[59,174],"scenarios.":[60],"The":[61],"number":[62,101,169],"scenarios":[64,171],"needed":[65],"for":[66],"accurate":[67],"approximation":[68],"-":[69,82],"hence":[71],"size":[73,164],"problem":[77,96,199],"when":[78],"using":[79],"prior":[80],"increases":[83,97],"variance":[85],"in":[86,104,219],"data,":[88],"search":[91],"space":[92],"exponentially":[98],"tuples":[103],"relation.":[106],"Existing":[107],"solvers":[108],"take":[109],"hours":[110],"to":[111,128,146],"process":[112],"SPQs":[113,157],"relations":[116],"containing":[117],"high":[121,148],"variance.":[122],"Besides":[123],"enriching":[124],"SPaQL":[126],"language":[127],"capture":[129],"a":[130,187,195],"broader":[131],"class":[132],"risk":[134],"specifications,":[135],"we":[136,150,183],"make":[137],"two":[138],"fundamental":[139],"contributions":[140],"towards":[141],"scalable":[142],"SPQ":[143],"processing.":[144],"First,":[145],"handle":[147],"variance,":[149],"propose":[151,184],"risk-constraint":[152],"linearization":[153],"(RCL),":[154],"which":[155],"converts":[156],"into":[158,200],"Integer":[159],"Linear":[160],"Programs":[161],"(ILPs)":[162],"whose":[163],"is":[165],"independent":[166],"used.":[172],"Solving":[173],"ILPs":[175],"gives":[176],"us":[177],"feasible":[178],"near-optimal":[180],"packages.":[181],"Second,":[182],"SketchRefine,":[186],"divide":[188],"conquer":[190],"framework":[191],"breaks":[193],"down":[194],"subproblems":[201],"involving":[202],"smaller":[203],"subsets":[204],"tuples.":[206],"Our":[207],"experiments":[208],"show":[209],"that,":[210],"together,":[211],"RCL":[212],"SketchRefine":[215],"produce":[216],"high-quality":[217],"orders":[220],"magnitude":[222],"lower":[223],"runtime":[224],"than":[225],"state":[227],"art.":[230]},"counts_by_year":[],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}