{"id":"https://openalex.org/W4297796094","doi":"https://doi.org/10.1145/3548785.3548800","title":"Multi-objective query optimization in Spark SQL","display_name":"Multi-objective query optimization in Spark SQL","publication_year":2022,"publication_date":"2022-08-22","ids":{"openalex":"https://openalex.org/W4297796094","doi":"https://doi.org/10.1145/3548785.3548800"},"language":"en","primary_location":{"id":"doi:10.1145/3548785.3548800","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3548785.3548800","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 26th International Database Engineered Applications Symposium","raw_type":"proceedings-article"},"type":"preprint","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/A5009916313","display_name":"Michail Georgoulakis Misegiannis","orcid":null},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Michail Georgoulakis Misegiannis","raw_affiliation_strings":["Dept. of Electrical and Computer Engineering, National Technical University of Athens, Greece"],"affiliations":[{"raw_affiliation_string":"Dept. of Electrical and Computer Engineering, National Technical University of Athens, Greece","institution_ids":["https://openalex.org/I174458059"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064711656","display_name":"Vasiliki Kantere","orcid":null},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Vasiliki (Verena) Kantere","raw_affiliation_strings":["Dept. of Electrical and Computer Engineering, National Technical University of Athens, Greece"],"affiliations":[{"raw_affiliation_string":"Dept. of Electrical and Computer Engineering, National Technical University of Athens, Greece","institution_ids":["https://openalex.org/I174458059"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023360779","display_name":"Laurent d\u2019Orazio","orcid":"https://orcid.org/0000-0001-8614-1848"},"institutions":[{"id":"https://openalex.org/I56067802","display_name":"Universit\u00e9 de Rennes","ror":"https://ror.org/015m7wh34","country_code":"FR","type":"education","lineage":["https://openalex.org/I56067802"]},{"id":"https://openalex.org/I2802519937","display_name":"Institut de Recherche en Informatique et Syst\u00e8mes Al\u00e9atoires","ror":"https://ror.org/00myn0z94","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I1326498283","https://openalex.org/I205703379","https://openalex.org/I2802204017","https://openalex.org/I2802519937","https://openalex.org/I28221208","https://openalex.org/I4210127572","https://openalex.org/I4210159245","https://openalex.org/I56067802"]},{"id":"https://openalex.org/I1294671590","display_name":"Centre National de la Recherche Scientifique","ror":"https://ror.org/02feahw73","country_code":"FR","type":"government","lineage":["https://openalex.org/I1294671590"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Laurent d'Orazio","raw_affiliation_strings":["CNRS, IRISA, University of Rennes I, France"],"affiliations":[{"raw_affiliation_string":"CNRS, IRISA, University of Rennes I, France","institution_ids":["https://openalex.org/I56067802","https://openalex.org/I2802519937","https://openalex.org/I1294671590"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5009916313"],"corresponding_institution_ids":["https://openalex.org/I174458059"],"apc_list":null,"apc_paid":null,"fwci":1.13997333,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.80048551,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"70","last_page":"74"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998000264167786,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9980999827384949,"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.9939000010490417,"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/query-optimization","display_name":"Query optimization","score":0.8796844482421875},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.86241614818573},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.8102221488952637},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.7191494703292847},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6984682083129883},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.6139664053916931},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6112518906593323},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.6005542278289795},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5834842920303345},{"id":"https://openalex.org/keywords/rdf-query-language","display_name":"RDF query language","score":0.5782498121261597},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.5035144686698914},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.4950219988822937},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4867427349090576},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.4741708040237427},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.42900320887565613},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.20468637347221375},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.17508691549301147},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.14023825526237488},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08797112107276917}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.8796844482421875},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.86241614818573},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.8102221488952637},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.7191494703292847},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6984682083129883},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.6139664053916931},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6112518906593323},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.6005542278289795},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5834842920303345},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.5782498121261597},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.5035144686698914},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.4950219988822937},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4867427349090576},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.4741708040237427},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.42900320887565613},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.20468637347221375},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.17508691549301147},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.14023825526237488},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08797112107276917}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3548785.3548800","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3548785.3548800","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 26th International Database Engineered Applications Symposium","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5299999713897705,"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W2038412523","https://openalex.org/W2119558533","https://openalex.org/W2396309311","https://openalex.org/W2751653612","https://openalex.org/W2757075534","https://openalex.org/W2810302553","https://openalex.org/W2949560933","https://openalex.org/W3032560301","https://openalex.org/W3108370358","https://openalex.org/W3133029391","https://openalex.org/W3184147211","https://openalex.org/W3208930906","https://openalex.org/W4320410106"],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W2970853428","https://openalex.org/W2130043461","https://openalex.org/W3125756434","https://openalex.org/W2353434938","https://openalex.org/W2955368753","https://openalex.org/W906795786","https://openalex.org/W2538384344","https://openalex.org/W2401447141","https://openalex.org/W253824326"],"abstract_inverted_index":{"Query":[0],"optimization":[1,11,86],"is":[2,73,154,162],"a":[3,17,55,74,94,109,138],"challenging":[4],"process":[5,48],"of":[6,20,49,96,103,116,120,128,144],"DBMSs.":[7],"When":[8],"tackling":[9],"query":[10,25,53,68,85,118,129,146],"in":[12,81,87],"the":[13,47,59,82,100,114,117,142],"cloud,":[14],"there":[15],"exists":[16],"simultaneous":[18],"need":[19],"providing":[21],"an":[22,31,63,159],"optimal":[23,32,52],"physical":[24],"execution":[26,69,130],"plan,":[27],"as":[28,30,135,137],"well":[29,136],"resource":[33,42],"configuration":[34],"among":[35],"available":[36],"ones.":[37],"Cloud":[38],"computing":[39],"features":[40],"like":[41],"elasticity":[43],"and":[44,132,148,156,158],"pricing":[45],"make":[46],"finding":[50],"this":[51],"plan":[54],"multi-objective":[56,110],"problem,":[57],"with":[58],"monetary":[60,133],"cost":[61,111,152],"being":[62],"equally":[64],"important":[65],"factor":[66],"to":[67,99,124,164],"time.":[70],"Apache":[71,121],"Spark":[72],"popular":[75],"choice":[76],"for":[77,113,140],"managing":[78],"big":[79],"data":[80],"cloud.":[83],"However,":[84],"its":[88,104,166],"SQL":[89],"module":[90],"(Spark":[91],"SQL)":[92],"involves":[93],"number":[95],"limitations":[97],"due":[98],"rule-based":[101],"nature":[102],"optimizer,":[105],"Catalyst.":[106],"We":[107],"propose":[108],"model":[112,153],"extension":[115],"optimizer":[119],"Spark,":[122],"aiming":[123],"minimize":[125],"both":[126],"objectives":[127],"time":[131],"cost,":[134],"methodology":[139],"exploring":[141],"space":[143],"Pareto-optimal":[145],"plans":[147],"selecting":[149],"one.":[150],"The":[151],"implemented":[155],"tuned,":[157],"experimental":[160],"study":[161],"conducted":[163],"validate":[165],"accuracy.":[167]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}