{"id":"https://openalex.org/W3081626970","doi":"https://doi.org/10.14778/3415478.3415499","title":"sPaQLTooLs","display_name":"sPaQLTooLs","publication_year":2020,"publication_date":"2020-08-01","ids":{"openalex":"https://openalex.org/W3081626970","doi":"https://doi.org/10.14778/3415478.3415499","mag":"3081626970"},"language":"en","primary_location":{"id":"doi:10.14778/3415478.3415499","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3415478.3415499","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5072749095","display_name":"Matteo Brucato","orcid":"https://orcid.org/0000-0003-2730-6432"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Matteo Brucato","raw_affiliation_strings":["University of Massachusetts"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075026385","display_name":"Miro Mannino","orcid":"https://orcid.org/0000-0001-7738-1815"},"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":"Miro Mannino","raw_affiliation_strings":["NYU Abu Dhabi"],"affiliations":[{"raw_affiliation_string":"NYU Abu Dhabi","institution_ids":["https://openalex.org/I120250893"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044418740","display_name":"Azza Abouzied","orcid":"https://orcid.org/0000-0003-4273-2536"},"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":["NYU Abu Dhabi"],"affiliations":[{"raw_affiliation_string":"NYU Abu Dhabi","institution_ids":["https://openalex.org/I120250893"]}]},{"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":"Peter J. Haas","raw_affiliation_strings":["University of Massachusetts"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts","institution_ids":[]}]},{"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":"Alexandra Meliou","raw_affiliation_strings":["University of Massachusetts"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5072749095"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.12682666,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":"13","issue":"12","first_page":"2881","last_page":"2884"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11413","display_name":"Risk and Portfolio Optimization","score":0.9952999949455261,"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"}},"topics":[{"id":"https://openalex.org/T11413","display_name":"Risk and Portfolio Optimization","score":0.9952999949455261,"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"}},{"id":"https://openalex.org/T11801","display_name":"Reservoir Engineering and Simulation Methods","score":0.97079998254776,"subfield":{"id":"https://openalex.org/subfields/2212","display_name":"Ocean Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"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.9693999886512756,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7268372774124146},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6357755661010742},{"id":"https://openalex.org/keywords/solver","display_name":"Solver","score":0.6293342113494873},{"id":"https://openalex.org/keywords/workflow","display_name":"Workflow","score":0.5806822776794434},{"id":"https://openalex.org/keywords/portfolio-optimization","display_name":"Portfolio optimization","score":0.5382731556892395},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.5295957922935486},{"id":"https://openalex.org/keywords/stochastic-optimization","display_name":"Stochastic optimization","score":0.529490053653717},{"id":"https://openalex.org/keywords/stochastic-programming","display_name":"Stochastic programming","score":0.5013489723205566},{"id":"https://openalex.org/keywords/project-portfolio-management","display_name":"Project portfolio management","score":0.4942898750305176},{"id":"https://openalex.org/keywords/robust-optimization","display_name":"Robust optimization","score":0.45852792263031006},{"id":"https://openalex.org/keywords/optimization-problem","display_name":"Optimization problem","score":0.42683759331703186},{"id":"https://openalex.org/keywords/portfolio","display_name":"Portfolio","score":0.42274945974349976},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.19406333565711975},{"id":"https://openalex.org/keywords/project-management","display_name":"Project management","score":0.19241246581077576},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.16030851006507874},{"id":"https://openalex.org/keywords/finance","display_name":"Finance","score":0.15240365266799927},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.10669249296188354}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7268372774124146},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6357755661010742},{"id":"https://openalex.org/C2778770139","wikidata":"https://www.wikidata.org/wiki/Q1966904","display_name":"Solver","level":2,"score":0.6293342113494873},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.5806822776794434},{"id":"https://openalex.org/C202655437","wikidata":"https://www.wikidata.org/wiki/Q7231728","display_name":"Portfolio optimization","level":3,"score":0.5382731556892395},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.5295957922935486},{"id":"https://openalex.org/C194387892","wikidata":"https://www.wikidata.org/wiki/Q1747770","display_name":"Stochastic optimization","level":2,"score":0.529490053653717},{"id":"https://openalex.org/C137631369","wikidata":"https://www.wikidata.org/wiki/Q7617831","display_name":"Stochastic programming","level":2,"score":0.5013489723205566},{"id":"https://openalex.org/C74510933","wikidata":"https://www.wikidata.org/wiki/Q1936145","display_name":"Project portfolio management","level":3,"score":0.4942898750305176},{"id":"https://openalex.org/C193254401","wikidata":"https://www.wikidata.org/wiki/Q2160088","display_name":"Robust optimization","level":2,"score":0.45852792263031006},{"id":"https://openalex.org/C137836250","wikidata":"https://www.wikidata.org/wiki/Q984063","display_name":"Optimization problem","level":2,"score":0.42683759331703186},{"id":"https://openalex.org/C2780821815","wikidata":"https://www.wikidata.org/wiki/Q5340806","display_name":"Portfolio","level":2,"score":0.42274945974349976},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.19406333565711975},{"id":"https://openalex.org/C15952604","wikidata":"https://www.wikidata.org/wiki/Q179012","display_name":"Project management","level":2,"score":0.19241246581077576},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.16030851006507874},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.15240365266799927},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10669249296188354},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3415478.3415499","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3415478.3415499","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.41999998688697815,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W2083545691","https://openalex.org/W2130767905","https://openalex.org/W2143514150","https://openalex.org/W2144810465","https://openalex.org/W2150461219","https://openalex.org/W2159309155","https://openalex.org/W2294586855","https://openalex.org/W2406551241","https://openalex.org/W2765539780","https://openalex.org/W2767279681","https://openalex.org/W3029651391","https://openalex.org/W3133869037"],"related_works":["https://openalex.org/W4293570283","https://openalex.org/W193468460","https://openalex.org/W4210800239","https://openalex.org/W2390830226","https://openalex.org/W3149055374","https://openalex.org/W2552756754","https://openalex.org/W1984862813","https://openalex.org/W3212504317","https://openalex.org/W4286859058","https://openalex.org/W2040533142"],"abstract_inverted_index":{"Everyone":[0],"needs":[1],"to":[2,21,60,117,159],"make":[3],"decisions":[4],"under":[5],"uncertainty":[6,76],"and":[7,25,56,127,164,191,207],"with":[8,32,174],"limited":[9],"resources,":[10],"e.g.,":[11],"an":[12,22],"investor":[13],"who":[14],"is":[15,35,38,111],"building":[16],"a":[17,26,39,72,86,106,122,139,155,166],"stock":[18,54,196],"portfolio":[19],"subject":[20],"investment":[23],"budget":[24],"bounded":[27],"risk":[28],"tolerance.":[29],"Doing":[30],"this":[31,58,178],"current":[33,65],"technology":[34],"hard.":[36],"There":[37],"disconnect":[40],"between":[41],"software":[42],"tools":[43],"for":[44,124,170],"data":[45,101],"management,":[46],"stochastic":[47,82,144,161],"predictive":[48,162],"modeling":[49],"(e.g.,":[50],"simulation":[51],"of":[52,75,98,109,130,142,154,187,218],"future":[53],"prices),":[55],"optimization;":[57],"leads":[59],"cumbersome":[61],"analytical":[62],"workflows.":[63],"Moreover,":[64],"methods":[66],"do":[67],"not":[68],"scale.":[69],"To":[70],"handle":[71],"broad":[73],"class":[74],"models,":[77,163],"analysts":[78],"approximate":[79],"the":[80,99,115,180,185],"original":[81],"optimization":[83,89,132,145],"problem":[84,90],"by":[85],"large":[87,104],"deterministic":[88],"that":[91],"incorporates":[92],"many":[93],"\"scenarios\",":[94],"i.e.,":[95],"sample":[96],"realizations":[97],"uncertain":[100],"values.":[102],"For":[103],"problems,":[105],"huge":[107],"number":[108],"scenarios":[110],"required,":[112],"often":[113],"causing":[114],"solver":[116],"fail.":[118],"We":[119,199],"demonstrate":[120,202],"sPaQLTooLs,":[121],"system":[123],"in-database":[125],"specification":[126,141],"scalable":[128],"solution":[129],"constrained":[131,143],"problems.":[133],"The":[134],"key":[135],"ingredients":[136],"are":[137],"(i)":[138],"database-oriented":[140],"problems":[146],"as":[147],"\"stochastic":[148],"package":[149],"queries\"":[150],"(SPQs),":[151],"(ii)":[152],"use":[153],"Monte":[156],"Carlo":[157],"database":[158],"incorporate":[160],"(iii)":[165],"new":[167],"SummarySearch":[168,204],"algorithm":[169],"scalably":[171],"solving":[172],"SPQs":[173],"approximation":[175],"guarantees.":[176],"In":[177],"demonstration,":[179],"attendees":[181],"will":[182,200],"experience":[183],"first-hand":[184],"difficulty":[186],"manually":[188],"constructing":[189],"feasible":[190],"high-quality":[192],"portfolios,":[193,214],"using":[194],"real-world":[195],"market":[197],"data.":[198],"then":[201],"how":[203],"can":[205],"easily":[206],"efficiently":[208],"help":[209],"them":[210],"find":[211],"very":[212],"good":[213],"while":[215],"being":[216],"orders":[217],"magnitude":[219],"faster":[220],"than":[221],"prior":[222],"methods.":[223]},"counts_by_year":[{"year":2024,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2020-09-08T00:00:00"}