{"id":"https://openalex.org/W3047022047","doi":"https://doi.org/10.1145/3397537.3397566","title":"Towards dynamic SQL compilation in Apache Spark","display_name":"Towards dynamic SQL compilation in Apache Spark","publication_year":2020,"publication_date":"2020-03-23","ids":{"openalex":"https://openalex.org/W3047022047","doi":"https://doi.org/10.1145/3397537.3397566","mag":"3047022047"},"language":"en","primary_location":{"id":"doi:10.1145/3397537.3397566","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3397537.3397566","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Conference Companion of the 4th International Conference on Art, Science, and Engineering of Programming","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://zenodo.org/record/7784734","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5077028131","display_name":"Filippo Schiavio","orcid":"https://orcid.org/0000-0001-9023-0720"},"institutions":[{"id":"https://openalex.org/I57201433","display_name":"Universit\u00e0 della Svizzera italiana","ror":"https://ror.org/03c4atk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I57201433"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Filippo Schiavio","raw_affiliation_strings":["USI Lugano, Switzerland"],"affiliations":[{"raw_affiliation_string":"USI Lugano, Switzerland","institution_ids":["https://openalex.org/I57201433"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025674223","display_name":"Daniele Bonetta","orcid":"https://orcid.org/0000-0001-7633-4224"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Daniele Bonetta","raw_affiliation_strings":["Oracle Labs, USA"],"affiliations":[{"raw_affiliation_string":"Oracle Labs, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5074152163","display_name":"Walter Binder","orcid":"https://orcid.org/0000-0002-2477-2182"},"institutions":[{"id":"https://openalex.org/I57201433","display_name":"Universit\u00e0 della Svizzera italiana","ror":"https://ror.org/03c4atk17","country_code":"CH","type":"education","lineage":["https://openalex.org/I57201433"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Walter Binder","raw_affiliation_strings":["USI Lugano, Switzerland"],"affiliations":[{"raw_affiliation_string":"USI Lugano, Switzerland","institution_ids":["https://openalex.org/I57201433"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5077028131"],"corresponding_institution_ids":["https://openalex.org/I57201433"],"apc_list":null,"apc_paid":null,"fwci":0.3084,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.60602907,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":93,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"46","last_page":"49"},"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.9995999932289124,"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.9995999932289124,"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.9973000288009644,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9950000047683716,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/computer-science","display_name":"Computer science","score":0.8528791666030884},{"id":"https://openalex.org/keywords/serialization","display_name":"Serialization","score":0.8234947919845581},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.8139703869819641},{"id":"https://openalex.org/keywords/json","display_name":"JSON","score":0.7400516271591187},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.686363697052002},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.586270272731781},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.5761682391166687},{"id":"https://openalex.org/keywords/scala","display_name":"Scala","score":0.5678797364234924},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.5088115334510803},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49668198823928833},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4776797890663147},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.4525552988052368},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.42837047576904297},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.3705649971961975},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.31896767020225525},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.19918382167816162},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07743969559669495}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8528791666030884},{"id":"https://openalex.org/C52723943","wikidata":"https://www.wikidata.org/wiki/Q1127410","display_name":"Serialization","level":2,"score":0.8234947919845581},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.8139703869819641},{"id":"https://openalex.org/C2780416260","wikidata":"https://www.wikidata.org/wiki/Q2063","display_name":"JSON","level":2,"score":0.7400516271591187},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.686363697052002},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.586270272731781},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.5761682391166687},{"id":"https://openalex.org/C109701466","wikidata":"https://www.wikidata.org/wiki/Q460584","display_name":"Scala","level":3,"score":0.5678797364234924},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.5088115334510803},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49668198823928833},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4776797890663147},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.4525552988052368},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.42837047576904297},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.3705649971961975},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.31896767020225525},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.19918382167816162},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07743969559669495},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3397537.3397566","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3397537.3397566","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Conference Companion of the 4th International Conference on Art, Science, and Engineering of Programming","raw_type":"proceedings-article"},{"id":"pmh:oai:zenodo.org:7784734","is_oa":true,"landing_page_url":"https://zenodo.org/record/7784734","pdf_url":"https://zenodo.org/record/7784734","source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/conferencePaper"}],"best_oa_location":{"id":"pmh:oai:zenodo.org:7784734","is_oa":true,"landing_page_url":"https://zenodo.org/record/7784734","pdf_url":"https://zenodo.org/record/7784734","source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/conferencePaper"},"sustainable_development_goals":[{"score":0.5899999737739563,"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3047022047.pdf"},"referenced_works_count":15,"referenced_works":["https://openalex.org/W135863099","https://openalex.org/W1521148341","https://openalex.org/W2038412523","https://openalex.org/W2069902027","https://openalex.org/W2094789240","https://openalex.org/W2116129553","https://openalex.org/W2131975293","https://openalex.org/W2153329411","https://openalex.org/W2566979091","https://openalex.org/W2619959750","https://openalex.org/W2752005949","https://openalex.org/W2889015391","https://openalex.org/W3008469065","https://openalex.org/W3012053272","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W4233053650","https://openalex.org/W123897255","https://openalex.org/W2565405999","https://openalex.org/W2970173331","https://openalex.org/W4221141422","https://openalex.org/W2613281757","https://openalex.org/W2148399583","https://openalex.org/W4221138323","https://openalex.org/W2288038496","https://openalex.org/W2500307848"],"abstract_inverted_index":{"Big-data":[0],"systems":[1],"have":[2],"gained":[3],"significant":[4,47],"momentum,":[5],"and":[6],"Apache":[7],"Spark":[8,18],"is":[9],"becoming":[10],"a":[11,32],"de-facto":[12],"standard":[13],"for":[14],"modern":[15],"data":[16,35,52,69],"analytics.":[17],"relies":[19],"on":[20,31,67],"code":[21,43],"generation":[22,44],"to":[23,51],"optimize":[24],"the":[25],"execution":[26],"performance":[27,58],"of":[28,34],"SQL":[29],"queries":[30],"variety":[33],"sources.":[36],"Despite":[37],"its":[38],"already":[39],"efficient":[40],"runtime,":[41],"Spark's":[42],"suffers":[45],"from":[46],"runtime":[48],"overheads":[49],"related":[50],"de-serialization":[53],"during":[54],"query":[55],"execution.":[56],"Such":[57],"penalty":[59],"can":[60],"be":[61],"significant,":[62],"especially":[63],"when":[64],"applications":[65],"operate":[66],"human-readable":[68],"formats":[70],"such":[71],"as":[72],"CSV":[73],"or":[74],"JSON.":[75]},"counts_by_year":[{"year":2021,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}