{"id":"https://openalex.org/W3031486596","doi":"https://doi.org/10.1145/3318464.3389728","title":"MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates","display_name":"MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W3031486596","doi":"https://doi.org/10.1145/3318464.3389728","mag":"3031486596"},"language":"en","primary_location":{"id":"doi:10.1145/3318464.3389728","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3318464.3389728","pdf_url":null,"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":["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/A5077337307","display_name":"Sourav Sikdar","orcid":null},"institutions":[{"id":"https://openalex.org/I74775410","display_name":"Rice University","ror":"https://ror.org/008zs3103","country_code":"US","type":"education","lineage":["https://openalex.org/I74775410"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sourav Sikdar","raw_affiliation_strings":["Rice University, Houston, TX, USA"],"affiliations":[{"raw_affiliation_string":"Rice University, Houston, TX, USA","institution_ids":["https://openalex.org/I74775410"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5002518742","display_name":"Chris Jermaine","orcid":null},"institutions":[{"id":"https://openalex.org/I74775410","display_name":"Rice University","ror":"https://ror.org/008zs3103","country_code":"US","type":"education","lineage":["https://openalex.org/I74775410"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chris Jermaine","raw_affiliation_strings":["Rice University, Houston, TX, USA"],"affiliations":[{"raw_affiliation_string":"Rice University, Houston, TX, USA","institution_ids":["https://openalex.org/I74775410"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5077337307"],"corresponding_institution_ids":["https://openalex.org/I74775410"],"apc_list":null,"apc_paid":null,"fwci":0.6167,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.70296082,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"225","last_page":"240"},"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.9997000098228455,"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.9997000098228455,"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.9997000098228455,"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/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9957000017166138,"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/computer-science","display_name":"Computer science","score":0.8636442422866821},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.586084246635437},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.5655124187469482},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.5331931114196777},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.4825127124786377},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.48147502541542053},{"id":"https://openalex.org/keywords/scala","display_name":"Scala","score":0.4657037854194641},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4128355085849762},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.40486493706703186},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3853360414505005},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3042146563529968},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.204466313123703}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8636442422866821},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.586084246635437},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.5655124187469482},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.5331931114196777},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4825127124786377},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.48147502541542053},{"id":"https://openalex.org/C109701466","wikidata":"https://www.wikidata.org/wiki/Q460584","display_name":"Scala","level":3,"score":0.4657037854194641},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4128355085849762},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.40486493706703186},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3853360414505005},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3042146563529968},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.204466313123703}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3318464.3389728","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3318464.3389728","pdf_url":null,"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"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.6899999976158142,"id":"https://metadata.un.org/sdg/16"}],"awards":[{"id":"https://openalex.org/G2953811478","display_name":null,"funder_award_id":"1409543,1910803","funder_id":"https://openalex.org/F4320315254","funder_display_name":"Innovative Research Group Project of the National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320315254","display_name":"Innovative Research Group Project of the National Natural Science Foundation of China","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W1625390266","https://openalex.org/W1982092405","https://openalex.org/W1991271936","https://openalex.org/W1992560344","https://openalex.org/W1999689297","https://openalex.org/W2007069074","https://openalex.org/W2008365755","https://openalex.org/W2026966899","https://openalex.org/W2028145673","https://openalex.org/W2035463408","https://openalex.org/W2041563709","https://openalex.org/W2058991275","https://openalex.org/W2060883486","https://openalex.org/W2079806729","https://openalex.org/W2087909221","https://openalex.org/W2090066046","https://openalex.org/W2119567691","https://openalex.org/W2119885577","https://openalex.org/W2143452574","https://openalex.org/W2151251992","https://openalex.org/W2189465200","https://openalex.org/W2396309311","https://openalex.org/W2424452828","https://openalex.org/W2441695939","https://openalex.org/W2613907694","https://openalex.org/W2617941540","https://openalex.org/W2755385361","https://openalex.org/W2766000922","https://openalex.org/W2769903804","https://openalex.org/W2790625403","https://openalex.org/W2889503624","https://openalex.org/W2947571256","https://openalex.org/W2948177721","https://openalex.org/W2963741525","https://openalex.org/W2970148517","https://openalex.org/W2971045382","https://openalex.org/W3099158806","https://openalex.org/W3099273181","https://openalex.org/W3100925961","https://openalex.org/W4252265332","https://openalex.org/W4302442555","https://openalex.org/W6687322159"],"related_works":["https://openalex.org/W2763674625","https://openalex.org/W4252019479","https://openalex.org/W2337519567","https://openalex.org/W2548921709","https://openalex.org/W2558523485","https://openalex.org/W4379407450","https://openalex.org/W4252076541","https://openalex.org/W2620395718","https://openalex.org/W2905107896","https://openalex.org/W2898462483"],"abstract_inverted_index":{"User-defined":[0],"functions":[1],"(UDFs)":[2],"in":[3,19,139],"modern":[4,33],"SQL":[5],"database":[6,34,51],"systems":[7,12],"and":[8,94,103,136],"Big":[9,53],"Data":[10,54],"processing":[11],"such":[13,22],"as":[14,23,128,147],"Spark---that":[15],"offer":[16],"API":[17],"bindings":[18],"high-level":[20],"languages":[21],"Python":[24],"or":[25,52],"Scala---make":[26],"automatic":[27],"optimization":[28,36,122],"challenging.":[29],"The":[30],"foundation":[31],"of":[32,40,81,106,114],"query":[35,72],"is":[37,56],"the":[38,43,75,79,83,92,97,107,112,115,125,145],"collection":[39,138],"statistics":[41,62,90,110,137],"describing":[42],"data":[44],"to":[45,88,133],"be":[46],"processed,":[47],"but":[48],"when":[49],"a":[50,71,120,140,148],"computation":[55],"partially":[57],"obscured":[58],"by":[59,119,143],"UDFs,":[60,82,93],"good":[61],"are":[63],"often":[64],"unavailable.":[65],"In":[66,78],"this":[67],"paper,":[68],"we":[69],"describe":[70],"optimizer":[73,85],"called":[74],"Monsoon":[76,84,130],"optimizer.":[77],"presence":[80],"may":[86,101],"choose":[87],"collect":[89],"on":[91,111],"then":[95],"run":[96],"computation.":[98],"Or,":[99],"it":[100],"optimize":[102],"execute":[104],"part":[105],"plan,":[108,117],"collecting":[109],"result":[113],"partial":[116],"followed":[118],"re":[121],"step,":[123],"with":[124],"process":[126],"repeated":[127],"needed.":[129],"decides":[131],"how":[132],"interleave":[134],"execution":[135],"principled":[141],"fashion":[142],"formalizing":[144],"problem":[146],"Markov":[149],"decision":[150],"process.":[151]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2021,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}