{"id":"https://openalex.org/W4403413378","doi":"https://doi.org/10.1145/3674805.3690746","title":"Automatic Library Migration Using Large Language Models: First Results","display_name":"Automatic Library Migration Using Large Language Models: First Results","publication_year":2024,"publication_date":"2024-10-15","ids":{"openalex":"https://openalex.org/W4403413378","doi":"https://doi.org/10.1145/3674805.3690746"},"language":"en","primary_location":{"id":"doi:10.1145/3674805.3690746","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3674805.3690746","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3674805.3690746?download=true","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM/IEEE International Symposium on Empirical Software Engineering and Measurement","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3674805.3690746?download=true","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Aylton Almeida","orcid":"https://orcid.org/0009-0002-0649-856X"},"institutions":[{"id":"https://openalex.org/I4210134014","display_name":"Hospital das Cl\u00ednicas da Universidade Federal de Minas Gerais","ror":"https://ror.org/035rpst33","country_code":"BR","type":"healthcare","lineage":["https://openalex.org/I4210134014"]}],"countries":["BR"],"is_corresponding":true,"raw_author_name":"Aylton Almeida","raw_affiliation_strings":["DCC, UFMG, Brazil"],"affiliations":[{"raw_affiliation_string":"DCC, UFMG, Brazil","institution_ids":["https://openalex.org/I4210134014"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078717416","display_name":"Laerte Xavier","orcid":"https://orcid.org/0000-0001-7925-4115"},"institutions":[{"id":"https://openalex.org/I170935008","display_name":"Pontif\u00edcia Universidade Cat\u00f3lica de Minas Gerais","ror":"https://ror.org/03j1rr444","country_code":"BR","type":"education","lineage":["https://openalex.org/I170935008"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Laerte Xavier","raw_affiliation_strings":["PUC Minas, Brazil"],"affiliations":[{"raw_affiliation_string":"PUC Minas, Brazil","institution_ids":["https://openalex.org/I170935008"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100703246","display_name":"Marco T\u00falio Valente","orcid":"https://orcid.org/0000-0002-8180-7548"},"institutions":[{"id":"https://openalex.org/I4210134014","display_name":"Hospital das Cl\u00ednicas da Universidade Federal de Minas Gerais","ror":"https://ror.org/035rpst33","country_code":"BR","type":"healthcare","lineage":["https://openalex.org/I4210134014"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Marco Tulio Valente","raw_affiliation_strings":["DCC, UFMG, Brazil"],"affiliations":[{"raw_affiliation_string":"DCC, UFMG, Brazil","institution_ids":["https://openalex.org/I4210134014"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210134014"],"apc_list":null,"apc_paid":null,"fwci":2.4003,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.89594519,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"427","last_page":"433"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9958999752998352,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9958999752998352,"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"}},{"id":"https://openalex.org/T10203","display_name":"Recommender Systems and Techniques","score":0.9925000071525574,"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.9889000058174133,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7274459600448608},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.4477458596229553},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.37771326303482056},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3706575632095337}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7274459600448608},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.4477458596229553},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.37771326303482056},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3706575632095337}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3674805.3690746","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3674805.3690746","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3674805.3690746?download=true","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM/IEEE International Symposium on Empirical Software Engineering and Measurement","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2408.16151","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2408.16151","pdf_url":"https://arxiv.org/pdf/2408.16151","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/3674805.3690746","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3674805.3690746","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3674805.3690746?download=true","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM/IEEE International Symposium on Empirical Software Engineering and Measurement","raw_type":"proceedings-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities","score":0.7699999809265137}],"awards":[{"id":"https://openalex.org/G5079005330","display_name":null,"funder_award_id":"support","funder_id":"https://openalex.org/F4320322025","funder_display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico"}],"funders":[{"id":"https://openalex.org/F4320322025","display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico","ror":"https://ror.org/03swz6y49"},{"id":"https://openalex.org/F4320322980","display_name":"Funda\u00e7\u00e3o de Amparo \u00e0 Pesquisa do Estado de Minas Gerais","ror":"https://ror.org/00nc55f03"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4403413378.pdf","grobid_xml":"https://content.openalex.org/works/W4403413378.grobid-xml"},"referenced_works_count":15,"referenced_works":["https://openalex.org/W2129216008","https://openalex.org/W2144827892","https://openalex.org/W2762481683","https://openalex.org/W2773858744","https://openalex.org/W2953951611","https://openalex.org/W2990868959","https://openalex.org/W3094949573","https://openalex.org/W3121596715","https://openalex.org/W3184420437","https://openalex.org/W3204578495","https://openalex.org/W4284709233","https://openalex.org/W4312763760","https://openalex.org/W4389104713","https://openalex.org/W4399668074","https://openalex.org/W4400484796"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W3204019825"],"abstract_inverted_index":{"Despite":[0],"being":[1],"introduced":[2],"only":[3],"a":[4,43,86,91],"few":[5],"years":[6],"ago,":[7],"Large":[8],"Language":[9],"Models":[10],"(LLMs)":[11],"are":[12,48,127],"already":[13],"widely":[14,102],"used":[15,103],"by":[16,129,134,165],"developers":[17],"for":[18],"code":[19,159,180],"generation.":[20],"However,":[21],"their":[22],"application":[23,88,155],"in":[24,34,45,71,104],"automating":[25],"other":[26],"Software":[27],"Engineering":[28],"activities":[29],"remains":[30],"largely":[31],"unexplored.":[32],"Thus,":[33],"this":[35],"paper,":[36,73],"we":[37,47,74,144],"report":[38],"the":[39,50,72,80,108,124,130,135,141,178],"first":[40],"results":[41,78,126],"of":[42,52,82,94,110,113,152],"study":[44],"which":[46],"exploring":[49],"use":[51,81,90,109,161],"ChatGPT":[53,83],"to":[54,84,89,147,160],"support":[55],"API":[56],"migration":[57],"tasks,":[58],"an":[59,96],"important":[60],"problem":[61],"that":[62,123],"demands":[63],"manual":[64],"effort":[65],"and":[66,117,121,156,173],"attention":[67],"from":[68],"developers.":[69],"Specifically,":[70],"share":[75],"our":[76,153],"initial":[77],"involving":[79],"migrate":[85,149],"client":[87],"newer":[92],"version":[93],"SQLAlchemy,":[95],"ORM":[97],"(Object":[98],"Relational":[99],"Mapping)":[100],"library":[101],"Python.":[105],"We":[106],"evaluate":[107],"three":[111],"types":[112],"prompts":[114],"(Zero-Shot,":[115],"One-Shot,":[116],"Chain":[118,136],"Of":[119,137],"Thoughts)":[120],"show":[122],"best":[125],"achieved":[128],"One-Shot":[131,142],"prompt,":[132],"followed":[133],"Thoughts.":[138],"Particularly,":[139],"with":[140],"prompt":[143],"were":[145],"able":[146],"successfully":[148],"all":[150],"columns":[151],"target":[154],"upgrade":[157],"its":[158],"new":[162],"functionalities":[163],"enabled":[164],"SQLAlchemy\u2019s":[166],"latest":[167],"version,":[168],"such":[169],"as":[170],"Python\u2019s":[171],"asyncio":[172],"typing":[174],"modules,":[175],"while":[176],"preserving":[177],"original":[179],"behavior.":[181]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}