{"id":"https://openalex.org/W7204485643","doi":"https://doi.org/10.3390/app16178512","title":"PolyFuseQL: A Unified Middleware for Polyglot Persistence Using the Strategy Design Pattern and Apache Spark Federation","display_name":"PolyFuseQL: A Unified Middleware for Polyglot Persistence Using the Strategy Design Pattern and Apache Spark Federation","publication_year":2026,"publication_date":"2026-08-27","ids":{"openalex":"https://openalex.org/W7204485643","doi":"https://doi.org/10.3390/app16178512"},"language":"en","primary_location":{"id":"doi:10.3390/app16178512","doi":"https://doi.org/10.3390/app16178512","is_oa":true,"landing_page_url":"https://doi.org/10.3390/app16178512","pdf_url":null,"source":{"id":"https://openalex.org/S4210205812","display_name":"Applied Sciences","issn_l":"2076-3417","issn":["2076-3417"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","doaj","norway-1","oarl","poland-100","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Applied Sciences","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.3390/app16178512","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5099025819","display_name":"Andres Andrade-Cabrera","orcid":"https://orcid.org/0009-0002-5080-9126","observed_orcids":["https://orcid.org/0009-0002-5080-9126"]},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":true,"raw_author_name":"Andres Andrade-Cabrera","raw_affiliation_strings":["Departamento de Ciencias de la Computaci\u00f3n, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador"],"raw_orcid":"https://orcid.org/0009-0002-5080-9126","affiliations":[{"raw_affiliation_string":"Departamento de Ciencias de la Computaci\u00f3n, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador","institution_ids":["https://openalex.org/I70764802"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031836050","display_name":"Diana Mart\u00ednez-Mosquera","orcid":"https://orcid.org/0000-0002-0573-8640","observed_orcids":["https://orcid.org/0000-0002-0573-8640"]},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Diana Martinez-Mosquera","raw_affiliation_strings":["Departamento de Ciencias de la Computaci\u00f3n, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador"],"raw_orcid":"https://orcid.org/0000-0002-0573-8640","affiliations":[{"raw_affiliation_string":"Departamento de Ciencias de la Computaci\u00f3n, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador","institution_ids":["https://openalex.org/I70764802"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048578074","display_name":"Iv\u00e1n Carrera","orcid":"https://orcid.org/0000-0003-4337-7433","observed_orcids":["https://orcid.org/0000-0003-4337-7433"]},"institutions":[{"id":"https://openalex.org/I70764802","display_name":"National Polytechnic School","ror":"https://ror.org/01gb99w41","country_code":"EC","type":"education","lineage":["https://openalex.org/I70764802"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Ivan Carrera","raw_affiliation_strings":["Departamento de Ciencias de la Computaci\u00f3n, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador"],"raw_orcid":"https://orcid.org/0000-0003-4337-7433","affiliations":[{"raw_affiliation_string":"Departamento de Ciencias de la Computaci\u00f3n, Escuela Polit\u00e9cnica Nacional, Quito 170525, Ecuador","institution_ids":["https://openalex.org/I70764802"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5099025819"],"corresponding_institution_ids":["https://openalex.org/I70764802"],"apc_list":{"value":2400,"currency":"CHF","value_usd":2896},"apc_paid":{"value":2400,"currency":"CHF","value_usd":2896},"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"16","issue":"17","first_page":"8512","last_page":"8512"},"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.9980000257492065,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9980000257492065,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.0010000000474974513,"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/T14280","display_name":"Big Data Technologies and Applications","score":9.999999747378752e-05,"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/polyglot-persistence","display_name":"polyglot persistence","score":0.9649999737739563},{"id":"https://openalex.org/keywords/sql-translation","display_name":"SQL translation","score":0.796999990940094},{"id":"https://openalex.org/keywords/middleware","display_name":"middleware","score":0.5410000085830688},{"id":"https://openalex.org/keywords/nosql-databases","display_name":"NoSQL databases","score":0.9229999780654907},{"id":"https://openalex.org/keywords/query-routing","display_name":"query routing","score":0.6000000238418579},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.597000002861023},{"id":"https://openalex.org/keywords/analytical-queries","display_name":"analytical queries","score":0.36899998784065247},{"id":"https://openalex.org/keywords/postgresql","display_name":"PostgreSQL","score":0.4309999942779541},{"id":"https://openalex.org/keywords/mongodb","display_name":"MongoDB","score":0.7580000162124634},{"id":"https://openalex.org/keywords/cassandra","display_name":"Cassandra","score":0.7910000085830688},{"id":"https://openalex.org/keywords/neo4j","display_name":"Neo4j","score":0.9610000252723694},{"id":"https://openalex.org/keywords/redis","display_name":"Redis","score":0.9929999709129333}],"concepts":[{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.932699978351593},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8514999747276306},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7444999814033508},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.6973000168800354},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5139999985694885},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.4878000020980835},{"id":"https://openalex.org/C169468491","wikidata":"https://www.wikidata.org/wiki/Q146923","display_name":"Middleware (distributed applications)","level":2,"score":0.4814999997615814},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.439300000667572},{"id":"https://openalex.org/C2780239667","wikidata":"https://www.wikidata.org/wiki/Q2102850","display_name":"Polyglot","level":2,"score":0.42980000376701355},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.41620001196861267},{"id":"https://openalex.org/C74172769","wikidata":"https://www.wikidata.org/wiki/Q1446839","display_name":"Routing (electronic design automation)","level":2,"score":0.38100001215934753},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.36039999127388},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.34779998660087585},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.34279999136924744},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.328900009393692},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.28850001096725464},{"id":"https://openalex.org/C2780154230","wikidata":"https://www.wikidata.org/wiki/Q513420","display_name":"Undo","level":2,"score":0.28790000081062317},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.2842999994754791},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.28049999475479126},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.2648000121116638},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.25929999351501465},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.2572999894618988},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.257099986076355},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2500999867916107}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.3390/app16178512","doi":"https://doi.org/10.3390/app16178512","is_oa":true,"landing_page_url":"https://doi.org/10.3390/app16178512","pdf_url":null,"source":{"id":"https://openalex.org/S4210205812","display_name":"Applied Sciences","issn_l":"2076-3417","issn":["2076-3417"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","doaj","norway-1","oarl","poland-100","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Applied Sciences","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:3d77c420c0c6485089bf601706ad3fc2","doi":null,"is_oa":false,"landing_page_url":"https://doaj.org/article/3d77c420c0c6485089bf601706ad3fc2","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Applied Sciences, Vol 16, Iss 17, p 8512 (2026)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.3390/app16178512","doi":"https://doi.org/10.3390/app16178512","is_oa":true,"landing_page_url":"https://doi.org/10.3390/app16178512","pdf_url":null,"source":{"id":"https://openalex.org/S4210205812","display_name":"Applied Sciences","issn_l":"2076-3417","issn":["2076-3417"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","doaj","norway-1","oarl","poland-100","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Applied Sciences","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320327633","display_name":"Escuela Polit\u00e9cnica Nacional","ror":"https://ror.org/01gb99w41"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W1985229168","https://openalex.org/W2041106018","https://openalex.org/W2136922540","https://openalex.org/W2299839756","https://openalex.org/W2305812381","https://openalex.org/W2320763633","https://openalex.org/W2541390744","https://openalex.org/W2949762319","https://openalex.org/W2982059824","https://openalex.org/W2982676286","https://openalex.org/W3007949707","https://openalex.org/W3021358426","https://openalex.org/W4321448324"],"related_works":["https://openalex.org/W3154176944","https://openalex.org/W7219231490","https://openalex.org/W4283661741","https://openalex.org/W4413862406","https://openalex.org/W6911573880","https://openalex.org/W3089606276","https://openalex.org/W4401287548","https://openalex.org/W2883159378","https://openalex.org/W2054848463","https://openalex.org/W7219479698"],"abstract_inverted_index":{"Modern":[0],"applications":[1],"rely":[2],"on":[3,194],"diverse":[4,105,233],"database":[5,36],"types":[6],"to":[7,18,38,98,101,114,126,139,143,153,175,186,232],"store":[8],"information":[9],"efficiently,":[10],"but":[11],"interacting":[12],"with":[13,104],"these":[14],"systems":[15,106],"requires":[16],"developers":[17,100],"master":[19],"multiple":[20],"specialized":[21],"query":[22,49],"languages.":[23],"This":[24],"fragments":[25],"development,":[26],"as":[27,80,191],"engineers":[28],"must":[29],"write":[30,115],"complex":[31,150,188],"custom":[32],"code":[33],"for":[34,65,85,220],"each":[35],"just":[37],"retrieve":[39],"routine":[40],"data.":[41],"While":[42],"existing":[43],"big-data":[44],"tools":[45],"offer":[46],"a":[47,75,81,154,203,227],"unified":[48],"language,":[50],"they":[51],"force":[52],"all":[53],"data":[54,209],"requests":[55,137],"through":[56],"heavy":[57],"processing":[58,205],"engines,":[59],"degrading":[60],"the":[61,112,128,140,161,216],"fast":[62],"performance":[63,163],"required":[64],"everyday":[66],"tasks.":[67,223],"To":[68],"address":[69],"this":[70],"problem,":[71],"we":[72],"introduce":[73],"PolyFuseQL,":[74],"smart":[76],"routing":[77,149],"layer":[78],"acting":[79],"universal":[82],"SQL":[83,124,230],"translator":[84],"five":[86],"popular":[87],"databases":[88,142,196,235],"(PostgreSQL,":[89],"Redis,":[90],"Neo4j,":[91],"MongoDB,":[92],"and":[93,134],"Cassandra).":[94],"Our":[95],"objective":[96],"is":[97],"allow":[99],"communicate":[102],"transparently":[103],"using":[107],"standard":[108,123],"SQL,":[109],"completely":[110],"avoiding":[111],"need":[113],"specific":[116],"NoSQL":[117,195,234],"logic.":[118],"Methodologically,":[119],"PolyFuseQL":[120,170,225],"dynamically":[121],"evaluates":[122],"queries":[125,152],"determine":[127],"optimal":[129],"execution":[130],"path.":[131],"It":[132],"translates":[133],"sends":[135],"simple":[136,176],"directly":[138],"native":[141,199],"ensure":[144],"high":[145],"speed":[146],"while":[147],"seamlessly":[148],"analytical":[151,222],"powerful":[155],"Apache":[156],"Spark":[157],"engine.":[158],"We":[159],"evaluated":[160],"system\u2019s":[162],"across":[164],"varying":[165],"workloads.":[166],"Results":[167],"indicate":[168],"that":[169,197],"adds":[171],"almost":[172],"no":[173],"delay":[174,206],"queries,":[177],"preserving":[178],"sub-millisecond":[179],"response":[180],"times.":[181],"Concurrently,":[182],"it":[183],"enables":[184],"users":[185],"execute":[187],"operations,":[189],"such":[190],"eight-table":[192],"joins,":[193],"lack":[198],"relational":[200],"support.":[201],"Although":[202],"fixed":[204],"during":[207],"initial":[208],"translation":[210],"slightly":[211],"limits":[212],"absolute":[213],"hardware":[214],"scaling,":[215],"system":[217],"scales":[218],"reliably":[219],"medium-sized":[221],"Ultimately,":[224],"provides":[226],"unified,":[228],"easy-to-use":[229],"interface":[231],"without":[236],"sacrificing":[237],"operational":[238],"speed.":[239]},"counts_by_year":[],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2026-08-28T00:00:00"}