{"id":"https://openalex.org/W4294904087","doi":"https://doi.org/10.14778/3547305.3547328","title":"YeSQL","display_name":"YeSQL","publication_year":2022,"publication_date":"2022-06-01","ids":{"openalex":"https://openalex.org/W4294904087","doi":"https://doi.org/10.14778/3547305.3547328"},"language":"en","primary_location":{"id":"doi:10.14778/3547305.3547328","is_oa":true,"landing_page_url":"https://doi.org/10.14778/3547305.3547328","pdf_url":"https://dl.acm.org/doi/pdf/10.14778/3547305.3547328","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":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.14778/3547305.3547328","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5036614082","display_name":"Yannis Foufoulas","orcid":"https://orcid.org/0000-0002-2785-946X"},"institutions":[{"id":"https://openalex.org/I72702400","display_name":"Athens State University","ror":"https://ror.org/01zx16v02","country_code":"US","type":"education","lineage":["https://openalex.org/I72702400"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Yannis Foufoulas","raw_affiliation_strings":["U. of Athens"],"affiliations":[{"raw_affiliation_string":"U. of Athens","institution_ids":["https://openalex.org/I72702400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072082268","display_name":"Alkis Simitsis","orcid":"https://orcid.org/0009-0006-6078-5323"},"institutions":[{"id":"https://openalex.org/I4210156054","display_name":"Athena Research and Innovation Center In Information Communication & Knowledge Technologies","ror":"https://ror.org/0576by029","country_code":"GR","type":"facility","lineage":["https://openalex.org/I4210156054"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Alkis Simitsis","raw_affiliation_strings":["Athena Research Center"],"affiliations":[{"raw_affiliation_string":"Athena Research Center","institution_ids":["https://openalex.org/I4210156054"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010758512","display_name":"Lefteris Stamatogiannakis","orcid":null},"institutions":[{"id":"https://openalex.org/I200777214","display_name":"National and Kapodistrian University of Athens","ror":"https://ror.org/04gnjpq42","country_code":"GR","type":"education","lineage":["https://openalex.org/I200777214"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Lefteris Stamatogiannakis","raw_affiliation_strings":["University of Athens"],"affiliations":[{"raw_affiliation_string":"University of Athens","institution_ids":["https://openalex.org/I200777214"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5084870386","display_name":"Yannis Ioannidis","orcid":"https://orcid.org/0000-0002-1705-8247"},"institutions":[{"id":"https://openalex.org/I72702400","display_name":"Athens State University","ror":"https://ror.org/01zx16v02","country_code":"US","type":"education","lineage":["https://openalex.org/I72702400"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yannis Ioannidis","raw_affiliation_strings":["U. of Athens"],"affiliations":[{"raw_affiliation_string":"U. of Athens","institution_ids":["https://openalex.org/I72702400"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5036614082"],"corresponding_institution_ids":["https://openalex.org/I72702400"],"apc_list":null,"apc_paid":null,"fwci":5.7572,"has_fulltext":false,"cited_by_count":19,"citation_normalized_percentile":{"value":0.96286729,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"15","issue":"10","first_page":"2270","last_page":"2283"},"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.9988999962806702,"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.9988999962806702,"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.9980000257492065,"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/T11719","display_name":"Data Quality and Management","score":0.9929999709129333,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8547146320343018},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.5899471044540405},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.42340517044067383},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.423096239566803}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8547146320343018},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.5899471044540405},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.42340517044067383},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.423096239566803}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3547305.3547328","is_oa":true,"landing_page_url":"https://doi.org/10.14778/3547305.3547328","pdf_url":"https://dl.acm.org/doi/pdf/10.14778/3547305.3547328","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":{"id":"doi:10.14778/3547305.3547328","is_oa":true,"landing_page_url":"https://doi.org/10.14778/3547305.3547328","pdf_url":"https://dl.acm.org/doi/pdf/10.14778/3547305.3547328","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"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4294904087.pdf","grobid_xml":"https://content.openalex.org/works/W4294904087.grobid-xml"},"referenced_works_count":22,"referenced_works":["https://openalex.org/W1013051822","https://openalex.org/W1585509108","https://openalex.org/W2049594497","https://openalex.org/W2102729946","https://openalex.org/W2104266030","https://openalex.org/W2245493112","https://openalex.org/W2294745660","https://openalex.org/W2349672813","https://openalex.org/W2416799949","https://openalex.org/W2753880770","https://openalex.org/W2757475250","https://openalex.org/W2808927133","https://openalex.org/W2888965704","https://openalex.org/W2896817295","https://openalex.org/W2897173745","https://openalex.org/W2908675229","https://openalex.org/W2912774529","https://openalex.org/W3085921543","https://openalex.org/W3164278511","https://openalex.org/W3175890395","https://openalex.org/W4244768633","https://openalex.org/W4294904087"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2341492732","https://openalex.org/W3187193180","https://openalex.org/W106542691","https://openalex.org/W4287027380","https://openalex.org/W1699080303","https://openalex.org/W4297799326","https://openalex.org/W3116064965","https://openalex.org/W2207495067","https://openalex.org/W1906486629"],"abstract_inverted_index":{"The":[0],"diversity":[1],"and":[2,20,49,65,124,136,142,155,159,172,179,195],"complexity":[3],"of":[4,14,56,116,121,132,138,157,164],"modern":[5],"data":[6,45,47],"management":[7],"applications":[8],"have":[9,34],"led":[10],"to":[11,86,184,192],"the":[12,15,59,153,169,173],"extension":[13,76],"relational":[16,66,105,170],"paradigm":[17],"with":[18,77,82,90,104,145],"syntactic":[19],"semantic":[21],"support":[22,80],"for":[23],"User-Defined":[24],"Functions":[25],"(UDFs).":[26],"Although":[27],"well-established":[28],"in":[29,37,186],"traditional":[30],"DBMS":[31],"settings,":[32],"UDFs":[33,57,101],"become":[35],"central":[36],"many":[38],"application":[39],"contexts":[40],"as":[41,44,107],"well,":[42],"such":[43],"science,":[46],"analytics,":[48],"edge":[50],"computing.":[51],"Still,":[52],"a":[53,83,146],"critical":[54],"limitation":[55],"is":[58],"impedance":[60],"mismatch":[61],"between":[62,168],"their":[63],"evaluation":[64],"processing.":[67],"In":[68],"this":[69],"paper,":[70],"we":[71],"present":[72],"YeSQL,":[73],"an":[74],"SQL":[75],"rich":[78],"UDF":[79],"along":[81],"pluggable":[84],"architecture":[85],"easily":[87],"integrate":[88],"it":[89],"either":[91],"server-based":[92],"or":[93,110],"embedded":[94],"database":[95,147],"engines.":[96],"YeSQL":[97,117,158],"currently":[98],"supports":[99],"Python":[100,133,174],"fully":[102],"integrated":[103],"queries":[106],"scalar,":[108],"aggregator,":[109],"table":[111],"functions.":[112],"Key":[113],"novel":[114],"characteristics":[115],"include":[118],"easy":[119],"implementation":[120,197],"complex":[122],"algorithms":[123],"several":[125],"performance":[126],"enhancements,":[127],"including":[128],"tracing":[129],"JIT":[130],"compilation":[131],"UDFs,":[134,139,141],"parallelism":[135],"fusion":[137],"stateful":[140],"seamless":[143],"integration":[144],"engine.":[148],"Our":[149],"experimental":[150],"analysis":[151],"showcases":[152],"usability":[154],"expressiveness":[156],"demonstrates":[160],"that":[161],"our":[162],"techniques":[163],"minimizing":[165],"context":[166],"switching":[167],"engine":[171],"VM":[175],"are":[176],"very":[177],"effective":[178],"achieve":[180],"significant":[181],"speedups":[182],"up":[183],"68x":[185],"common,":[187],"practical":[188],"use":[189],"cases":[190],"compared":[191],"earlier":[193],"approaches":[194],"alternative":[196],"choices.":[198]},"counts_by_year":[{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2022-09-07T00:00:00"}