{"id":"https://openalex.org/W7225453229","doi":"https://doi.org/10.1007/s10270-026-01436-z","title":"BLAST: a tool for bidirectional logics to SQL translation","display_name":"BLAST: a tool for bidirectional logics to SQL translation","publication_year":2026,"publication_date":"2026-11-07","ids":{"openalex":"https://openalex.org/W7225453229","doi":"https://doi.org/10.1007/s10270-026-01436-z"},"language":"en","primary_location":{"id":"doi:10.1007/s10270-026-01436-z","doi":"https://doi.org/10.1007/s10270-026-01436-z","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10270-026-01436-z","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10270-026-01436-z.pdf","source":{"id":"https://openalex.org/S64245694","display_name":"Software & Systems Modeling","issn_l":"1619-1366","issn":["1619-1366","1619-1374"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-b","jufo-3","norway-2","poland-70","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software and Systems Modeling","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s10270-026-01436-z.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5022042618","display_name":"Mart\u00ed S\u00e1nchez Juanola","orcid":"https://orcid.org/0009-0005-7390-7310","observed_orcids":["https://orcid.org/0009-0005-7390-7310"]},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Mart\u00ed Juanola","raw_affiliation_strings":["Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017299319","display_name":"Xavier Oriol","orcid":"https://orcid.org/0000-0002-8845-8504","observed_orcids":["https://orcid.org/0000-0002-8845-8504"]},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":true,"raw_author_name":"Xavier Oriol","raw_affiliation_strings":["Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074283335","display_name":"Jos\u00e9 Francisco Crespo","orcid":"https://orcid.org/0009-0007-3815-6480","observed_orcids":["https://orcid.org/0009-0007-3815-6480"]},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Francisco Crespo","raw_affiliation_strings":["Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085687963","display_name":"Ernest Teniente","orcid":"https://orcid.org/0000-0001-8890-9638","observed_orcids":["https://orcid.org/0000-0001-8890-9638"]},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Ernest Teniente","raw_affiliation_strings":["Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5017299319"],"corresponding_institution_ids":["https://openalex.org/I9617848"],"apc_list":{"value":3090,"currency":"USD","value_usd":3090},"apc_paid":{"value":3090,"currency":"USD","value_usd":3090},"fwci":0.0,"has_fulltext":true,"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":null,"issue":null,"first_page":null,"last_page":null},"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.7509999871253967,"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.7509999871253967,"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/T11450","display_name":"Model-Driven Software Engineering Techniques","score":0.1639000028371811,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.03189999982714653,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/sql-translation","display_name":"SQL translation","score":0.8169999718666077},{"id":"https://openalex.org/keywords/first-order-logic","display_name":"first-order logic","score":0.8209999799728394},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"relational calculus","score":0.8169999718666077},{"id":"https://openalex.org/keywords/datalog","display_name":"Datalog","score":0.9629999995231628},{"id":"https://openalex.org/keywords/bidirectional-translation","display_name":"bidirectional translation","score":0.8420000076293945},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"relational algebra","score":0.6179999709129333},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.5870000123977661},{"id":"https://openalex.org/keywords/query-containment","display_name":"query containment","score":0.9539999961853027},{"id":"https://openalex.org/keywords/views","display_name":"views","score":0.3019999861717224},{"id":"https://openalex.org/keywords/assertion","display_name":"assertion","score":0.5690000057220459},{"id":"https://openalex.org/keywords/derivation-rules","display_name":"derivation rules","score":0.7649999856948853},{"id":"https://openalex.org/keywords/logic-constraints","display_name":"logic constraints","score":0.8970000147819519},{"id":"https://openalex.org/keywords/metamodel","display_name":"meta-model","score":0.9380000233650208},{"id":"https://openalex.org/keywords/blast","display_name":"BLAST","score":0.6129999756813049}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7918999791145325},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.7409999966621399},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.691100001335144},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.5856000185012817},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5602999925613403},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5432000160217285},{"id":"https://openalex.org/C16739119","wikidata":"https://www.wikidata.org/wiki/Q5139948","display_name":"Codd's theorem","level":5,"score":0.5102999806404114},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.4909000098705292},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4896000027656555},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.429500013589859},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.39660000801086426},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.39489999413490295},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.3686999976634979},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3646000027656555},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.3580999970436096},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35429999232292175},{"id":"https://openalex.org/C37926939","wikidata":"https://www.wikidata.org/wiki/Q7449061","display_name":"Semantic equivalence","level":4,"score":0.3517000079154968},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.31049999594688416},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.304500013589859},{"id":"https://openalex.org/C102993220","wikidata":"https://www.wikidata.org/wiki/Q387196","display_name":"Description logic","level":2,"score":0.30329999327659607},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.30160000920295715},{"id":"https://openalex.org/C73301696","wikidata":"https://www.wikidata.org/wiki/Q5469984","display_name":"Formalism (music)","level":3,"score":0.3003999888896942},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.289000004529953},{"id":"https://openalex.org/C195818886","wikidata":"https://www.wikidata.org/wiki/Q5421724","display_name":"Expressive power","level":2,"score":0.2849000096321106},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.2800000011920929},{"id":"https://openalex.org/C117667704","wikidata":"https://www.wikidata.org/wiki/Q2011708","display_name":"Object Query Language","level":5,"score":0.26759999990463257},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2535000145435333}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s10270-026-01436-z","doi":"https://doi.org/10.1007/s10270-026-01436-z","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10270-026-01436-z","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10270-026-01436-z.pdf","source":{"id":"https://openalex.org/S64245694","display_name":"Software & Systems Modeling","issn_l":"1619-1366","issn":["1619-1366","1619-1374"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-b","jufo-3","norway-2","poland-70","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software and Systems Modeling","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1007/s10270-026-01436-z","doi":"https://doi.org/10.1007/s10270-026-01436-z","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10270-026-01436-z","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10270-026-01436-z.pdf","source":{"id":"https://openalex.org/S64245694","display_name":"Software & Systems Modeling","issn_l":"1619-1366","issn":["1619-1366","1619-1374"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-b","jufo-3","norway-2","poland-70","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software and Systems Modeling","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320328447","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7225453229.pdf","grobid_xml":"https://content.openalex.org/works/W7225453229.grobid-xml"},"referenced_works_count":22,"referenced_works":["https://openalex.org/W1505230898","https://openalex.org/W1660714679","https://openalex.org/W1979514837","https://openalex.org/W1980794066","https://openalex.org/W1989783863","https://openalex.org/W2013136702","https://openalex.org/W2025196861","https://openalex.org/W2031641275","https://openalex.org/W2040329577","https://openalex.org/W2042554793","https://openalex.org/W2043283603","https://openalex.org/W2050882124","https://openalex.org/W2093779107","https://openalex.org/W2131653381","https://openalex.org/W2136793698","https://openalex.org/W2139875914","https://openalex.org/W2167685423","https://openalex.org/W2248099457","https://openalex.org/W2611594712","https://openalex.org/W4226086155","https://openalex.org/W4389315087","https://openalex.org/W4403935684"],"related_works":["https://openalex.org/W7019919288","https://openalex.org/W7122587223","https://openalex.org/W2157749290","https://openalex.org/W2039384225","https://openalex.org/W7132115778","https://openalex.org/W2035896351","https://openalex.org/W4414594753","https://openalex.org/W1971701943","https://openalex.org/W7123247640","https://openalex.org/W2736025084"],"abstract_inverted_index":{"Abstract":[0],"SQL":[1,37,55,123,131],"is":[2,33,72,102,186,197],"the":[3,52,62,77,165,178,184,194],"main":[4],"language":[5],"used":[6],"to":[7,35,59,76,99,109,188],"query":[8,26,29],"data":[9],"in":[10,79],"relational":[11,42,83,86],"databases":[12],"and":[13,85,106,119,125,144,159,170,191],"interact":[14],"with":[15,150],"them.":[16],"However,":[17],"for":[18],"accomplishing":[19],"certain":[20],"reasoning":[21],"tasks":[22],"(such":[23],"as":[24],"semantic":[25],"optimization,":[27],"reasoning,":[28],"containment,":[30],"etc),":[31],"it":[32],"desirable":[34],"translate":[36],"into":[38,136,167],"first-order":[39,48,126],"languages":[40],"(e.g.,":[41],"calculus,":[43],"or":[44,134,141],"Datalog).":[45],"Indeed,":[46],"a":[47,153,160],"logic":[49,137,142],"formalism":[50],"facilitates":[51],"analysis":[53],"of":[54,64,69],"queries":[56],"without":[57],"having":[58],"depend":[60],"on":[61,129,177,199],"nuances":[63],"their":[65],"implementations.":[66],"The":[67,147],"possibility":[68],"this":[70,90],"translation":[71,174],"already":[73],"known":[74],"due":[75],"equivalence":[78,91],"expression":[80],"power":[81],"between":[82,122],"algebra":[84],"calculus.":[87],"Unfortunately,":[88],"although":[89],"was":[92],"discovered":[93],"more":[94],"than":[95],"40":[96],"years":[97],"ago,":[98],"date":[100],"there":[101],"no":[103],"public,":[104],"open-source,":[105],"validated":[107],"tool":[108],"obtain":[110],"these":[111],"translations.":[112],"This":[113],"paper":[114],"presents":[115],"BLAST,":[116],"an":[117],"automatic":[118],"bidirectional":[120],"translator":[121,148,166],"expressions":[124],"logic,":[127],"focused":[128],"mapping":[130],"queries,":[132,138],"views":[133],"assertions":[135],"derivation":[139],"rules,":[140],"constraints,":[143],"vice":[145],"versa.":[146],"comes":[149],"two":[151,172],"interfaces,":[152],"GUI":[154],"one":[155],"(for":[156,163],"end":[157],"users),":[158],"Java":[161],"API":[162],"integrating":[164],"other":[168],"tools);":[169],"provides":[171],"different":[173],"strategies":[175],"depending":[176],"user":[179],"needs.":[180],"To":[181],"ensure":[182],"that":[183],"code":[185],"easy":[187],"adopt,":[189],"maintain,":[190],"contribute":[192],"to,":[193],"whole":[195],"project":[196],"based":[198],"metamodels.":[200]},"counts_by_year":[],"updated_date":"2026-11-09T13:22:03.289127","created_date":"2026-11-08T00:00:00"}