{"id":"https://openalex.org/W4396988324","doi":"https://doi.org/10.1145/3663742.3663973","title":"Mallet: SQL Dialect Translation with LLM Rule Generation","display_name":"Mallet: SQL Dialect Translation with LLM Rule Generation","publication_year":2024,"publication_date":"2024-05-17","ids":{"openalex":"https://openalex.org/W4396988324","doi":"https://doi.org/10.1145/3663742.3663973"},"language":"en","primary_location":{"id":"doi:10.1145/3663742.3663973","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3663742.3663973","pdf_url":null,"source":null,"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Seventh International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3663742.3663973","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5080321727","display_name":"Amadou Ngom","orcid":"https://orcid.org/0009-0000-8422-5212"},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Amadou Latyr Ngom","raw_affiliation_strings":["Massachusetts Institute of Technology, United States of America"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, United States of America","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034086130","display_name":"Tim Kraska","orcid":"https://orcid.org/0009-0003-2414-2759"},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tim Kraska","raw_affiliation_strings":["Massachusetts Institute of Technology, United States of America"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, United States of America","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5080321727"],"corresponding_institution_ids":["https://openalex.org/I63966007"],"apc_list":null,"apc_paid":null,"fwci":1.3842,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.81401401,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"5"},"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.9922999739646912,"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.9922999739646912,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9886999726295471,"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"}},{"id":"https://openalex.org/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.9815999865531921,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/computer-science","display_name":"Computer science","score":0.6776916980743408},{"id":"https://openalex.org/keywords/mallet","display_name":"Mallet","score":0.6544411182403564},{"id":"https://openalex.org/keywords/translation","display_name":"Translation (biology)","score":0.5015463829040527},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4982790946960449},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.47210612893104553},{"id":"https://openalex.org/keywords/rule-based-system","display_name":"Rule-based system","score":0.45206838846206665},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.44174638390541077},{"id":"https://openalex.org/keywords/machine-translation","display_name":"Machine translation","score":0.4313455820083618},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.40170592069625854},{"id":"https://openalex.org/keywords/speech-recognition","display_name":"Speech recognition","score":0.35602501034736633},{"id":"https://openalex.org/keywords/acoustics","display_name":"Acoustics","score":0.0700022280216217},{"id":"https://openalex.org/keywords/physics","display_name":"Physics","score":0.05604091286659241}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6776916980743408},{"id":"https://openalex.org/C2778781484","wikidata":"https://www.wikidata.org/wiki/Q3202271","display_name":"Mallet","level":2,"score":0.6544411182403564},{"id":"https://openalex.org/C149364088","wikidata":"https://www.wikidata.org/wiki/Q185917","display_name":"Translation (biology)","level":4,"score":0.5015463829040527},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4982790946960449},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.47210612893104553},{"id":"https://openalex.org/C149271511","wikidata":"https://www.wikidata.org/wiki/Q1417149","display_name":"Rule-based system","level":2,"score":0.45206838846206665},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.44174638390541077},{"id":"https://openalex.org/C203005215","wikidata":"https://www.wikidata.org/wiki/Q79798","display_name":"Machine translation","level":2,"score":0.4313455820083618},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.40170592069625854},{"id":"https://openalex.org/C28490314","wikidata":"https://www.wikidata.org/wiki/Q189436","display_name":"Speech recognition","level":1,"score":0.35602501034736633},{"id":"https://openalex.org/C24890656","wikidata":"https://www.wikidata.org/wiki/Q82811","display_name":"Acoustics","level":1,"score":0.0700022280216217},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.05604091286659241},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C105580179","wikidata":"https://www.wikidata.org/wiki/Q188928","display_name":"Messenger RNA","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3663742.3663973","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3663742.3663973","pdf_url":null,"source":null,"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Seventh International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","raw_type":"proceedings-article"},{"id":"pmh:oai:dspace.mit.edu:1721.1/155537","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/155537","pdf_url":"https://dspace.mit.edu/bitstream/1721.1/155537/1/3663742.3663973.pdf","source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Association for Computing Machinery","raw_type":"http://purl.org/eprint/type/ConferencePaper"}],"best_oa_location":{"id":"doi:10.1145/3663742.3663973","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3663742.3663973","pdf_url":null,"source":null,"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Seventh International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W2799200990","https://openalex.org/W2999905431","https://openalex.org/W4292779060","https://openalex.org/W4312537169","https://openalex.org/W4366835679","https://openalex.org/W4379258895","https://openalex.org/W4386123453","https://openalex.org/W6778883912"],"related_works":["https://openalex.org/W2061682273","https://openalex.org/W1495287326","https://openalex.org/W2472790973","https://openalex.org/W2332119059","https://openalex.org/W4249019311","https://openalex.org/W4237376618","https://openalex.org/W4256630243","https://openalex.org/W3033131027","https://openalex.org/W2883671469","https://openalex.org/W2728761353"],"abstract_inverted_index":{"Translating":[0],"between":[1],"the":[2,34],"SQL":[3],"dialects":[4,37],"of":[5,36],"different":[6],"systems":[7],"is":[8],"important":[9],"for":[10],"migration":[11],"and":[12,28],"federated":[13],"query":[14],"processing.":[15],"Existing":[16],"approaches":[17],"rely":[18],"on":[19],"hand-crafted":[20],"translation":[21,43],"rules,":[22],"which":[23],"tend":[24],"to":[25,30,38],"be":[26],"incomplete":[27],"hard":[29],"maintain,":[31],"especially":[32],"as":[33],"number":[35],"translate":[39],"increases.":[40],"Thus,":[41],"dialect":[42],"remains":[44],"a":[45],"largely":[46],"unsolved":[47],"problem.":[48]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}