{"id":"https://openalex.org/W4415307818","doi":"https://doi.org/10.1145/3756681.3756947","title":"Seamless Data Migration between Database Schemas with DAMI-Framework: An Empirical Study on Developer Experience","display_name":"Seamless Data Migration between Database Schemas with DAMI-Framework: An Empirical Study on Developer Experience","publication_year":2025,"publication_date":"2025-06-17","ids":{"openalex":"https://openalex.org/W4415307818","doi":"https://doi.org/10.1145/3756681.3756947"},"language":"en","primary_location":{"id":"doi:10.1145/3756681.3756947","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3756681.3756947","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3756681.3756947?download=true","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 29th International Conference on Evaluation and Assessment in Software Engineering","raw_type":"proceedings-article"},"type":"article","indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3756681.3756947?download=true","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5069474411","display_name":"Delfina Ramos-Vidal","orcid":"https://orcid.org/0000-0001-6452-9307"},"institutions":[{"id":"https://openalex.org/I11019714","display_name":"Universidade da Coru\u00f1a","ror":"https://ror.org/01qckj285","country_code":"ES","type":"education","lineage":["https://openalex.org/I11019714"]}],"countries":["ES"],"is_corresponding":true,"raw_author_name":"Delfina Ramos-Vidal","raw_affiliation_strings":["Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain"],"raw_orcid":"https://orcid.org/0000-0001-6452-9307","affiliations":[{"raw_affiliation_string":"Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain","institution_ids":["https://openalex.org/I11019714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091259182","display_name":"Alejandro Corti\u00f1as","orcid":"https://orcid.org/0000-0002-2555-6342"},"institutions":[{"id":"https://openalex.org/I11019714","display_name":"Universidade da Coru\u00f1a","ror":"https://ror.org/01qckj285","country_code":"ES","type":"education","lineage":["https://openalex.org/I11019714"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Alejandro Corti\u00f1as","raw_affiliation_strings":["Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain"],"raw_orcid":"https://orcid.org/0000-0002-2555-6342","affiliations":[{"raw_affiliation_string":"Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain","institution_ids":["https://openalex.org/I11019714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007513751","display_name":"Miguel R. Luaces","orcid":"https://orcid.org/0000-0003-0549-2000"},"institutions":[{"id":"https://openalex.org/I11019714","display_name":"Universidade da Coru\u00f1a","ror":"https://ror.org/01qckj285","country_code":"ES","type":"education","lineage":["https://openalex.org/I11019714"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Miguel R. Luaces","raw_affiliation_strings":["Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain"],"raw_orcid":"https://orcid.org/0000-0003-0549-2000","affiliations":[{"raw_affiliation_string":"Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain","institution_ids":["https://openalex.org/I11019714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088519435","display_name":"\u00d3scar Pedreira","orcid":"https://orcid.org/0000-0001-6176-4475"},"institutions":[{"id":"https://openalex.org/I11019714","display_name":"Universidade da Coru\u00f1a","ror":"https://ror.org/01qckj285","country_code":"ES","type":"education","lineage":["https://openalex.org/I11019714"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Oscar Pedreira","raw_affiliation_strings":["Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain"],"raw_orcid":"https://orcid.org/0000-0001-6176-4475","affiliations":[{"raw_affiliation_string":"Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain","institution_ids":["https://openalex.org/I11019714"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022292980","display_name":"\u00c1ngeles S. Places","orcid":"https://orcid.org/0000-0001-8539-304X"},"institutions":[{"id":"https://openalex.org/I11019714","display_name":"Universidade da Coru\u00f1a","ror":"https://ror.org/01qckj285","country_code":"ES","type":"education","lineage":["https://openalex.org/I11019714"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"\u00c1ngeles Saavedra Places","raw_affiliation_strings":["Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain"],"raw_orcid":"https://orcid.org/0000-0001-8539-304X","affiliations":[{"raw_affiliation_string":"Universidade da Coru\u00f1a, CITIC, Database Lab, A Coru\u00f1a, Spain","institution_ids":["https://openalex.org/I11019714"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039130090","display_name":"Wesley K. G. Assun\u00e7\u00e3o","orcid":"https://orcid.org/0000-0002-7557-9091"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wesley K. G. Assun\u00e7\u00e3o","raw_affiliation_strings":["North Carolina State University, Raleigh, USA"],"raw_orcid":"https://orcid.org/0000-0002-7557-9091","affiliations":[{"raw_affiliation_string":"North Carolina State University, Raleigh, USA","institution_ids":["https://openalex.org/I137902535"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5069474411"],"corresponding_institution_ids":["https://openalex.org/I11019714"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.40023138,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"453","last_page":"464"},"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.86080002784729,"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.86080002784729,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-migration","display_name":"Data migration","score":0.6086000204086304},{"id":"https://openalex.org/keywords/digital-subscriber-line","display_name":"Digital subscriber line","score":0.593999981880188},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.5181000232696533},{"id":"https://openalex.org/keywords/empirical-research","display_name":"Empirical research","score":0.5034999847412109},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4708999991416931},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.4602000117301941},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4487999975681305},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.4350000023841858},{"id":"https://openalex.org/keywords/legacy-system","display_name":"Legacy system","score":0.35659998655319214}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8353999853134155},{"id":"https://openalex.org/C146152329","wikidata":"https://www.wikidata.org/wiki/Q1932543","display_name":"Data migration","level":2,"score":0.6086000204086304},{"id":"https://openalex.org/C201374245","wikidata":"https://www.wikidata.org/wiki/Q104534","display_name":"Digital subscriber line","level":2,"score":0.593999981880188},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5322999954223633},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.5181000232696533},{"id":"https://openalex.org/C120936955","wikidata":"https://www.wikidata.org/wiki/Q2155640","display_name":"Empirical research","level":2,"score":0.5034999847412109},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4708999991416931},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4602000117301941},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4487999975681305},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.4350000023841858},{"id":"https://openalex.org/C105446022","wikidata":"https://www.wikidata.org/wiki/Q445962","display_name":"Legacy system","level":3,"score":0.35659998655319214},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3517000079154968},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.34130001068115234},{"id":"https://openalex.org/C135257023","wikidata":"https://www.wikidata.org/wiki/Q691358","display_name":"Domain-specific language","level":2,"score":0.3127000033855438},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.30970001220703125},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.3012999892234802},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.287200003862381},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.28299999237060547},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.28049999475479126},{"id":"https://openalex.org/C174348530","wikidata":"https://www.wikidata.org/wiki/Q188635","display_name":"Bridging (networking)","level":2,"score":0.28029999136924744},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.27649998664855957},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.273499995470047},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.2624000012874603},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.25949999690055847},{"id":"https://openalex.org/C2983685735","wikidata":"https://www.wikidata.org/wiki/Q5227355","display_name":"Data source","level":2,"score":0.25440001487731934}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3756681.3756947","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3756681.3756947","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3756681.3756947?download=true","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 29th International Conference on Evaluation and Assessment in Software Engineering","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2504.17662","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2504.17662","pdf_url":"https://arxiv.org/pdf/2504.17662","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":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2504.17662","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2504.17662","pdf_url":null,"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":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"doi:10.1145/3756681.3756947","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3756681.3756947","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3756681.3756947?download=true","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 29th International Conference on Evaluation and Assessment in Software Engineering","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1496055848","display_name":null,"funder_award_id":"ED431C","funder_id":"https://openalex.org/F4320326655","funder_display_name":"Xunta de Galicia"},{"id":"https://openalex.org/G1622782223","display_name":null,"funder_award_id":"MCIN/AEI/10","funder_id":"https://openalex.org/F4320335322","funder_display_name":"European Regional Development Fund"},{"id":"https://openalex.org/G3480869486","display_name":null,"funder_award_id":"13039","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G3652310071","display_name":null,"funder_award_id":"ED431C 2021/53","funder_id":"https://openalex.org/F4320326655","funder_display_name":"Xunta de Galicia"},{"id":"https://openalex.org/G3694284866","display_name":null,"funder_award_id":"ED431C","funder_id":"https://openalex.org/F4320335322","funder_display_name":"European Regional Development Fund"},{"id":"https://openalex.org/G3876637791","display_name":null,"funder_award_id":"ED431G","funder_id":"https://openalex.org/F4320326655","funder_display_name":"Xunta de Galicia"},{"id":"https://openalex.org/G7084143925","display_name":null,"funder_award_id":"AEI/10","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G7086754869","display_name":null,"funder_award_id":"ED431G 2023/01","funder_id":"https://openalex.org/F4320326655","funder_display_name":"Xunta de Galicia"}],"funders":[{"id":"https://openalex.org/F4320326655","display_name":"Xunta de Galicia","ror":"https://ror.org/0181xnw06"},{"id":"https://openalex.org/F4320335322","display_name":"European Regional Development Fund","ror":"https://ror.org/00k4n6c32"},{"id":"https://openalex.org/F4320335598","display_name":"Agencia Estatal de Investigaci\u00f3n","ror":null},{"id":"https://openalex.org/F4320338080","display_name":"European Social Fund","ror":"https://ror.org/00k4n6c32"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4415307818.pdf","grobid_xml":"https://content.openalex.org/works/W4415307818.grobid-xml"},"referenced_works_count":26,"referenced_works":["https://openalex.org/W2156025393","https://openalex.org/W2065911415","https://openalex.org/W4405444642","https://openalex.org/W2092013815","https://openalex.org/W2599384653","https://openalex.org/W2004281168","https://openalex.org/W2297557791","https://openalex.org/W146241770","https://openalex.org/W2913391231","https://openalex.org/W2122103021","https://openalex.org/W4391116573","https://openalex.org/W2084429940","https://openalex.org/W2130966700","https://openalex.org/W1504962781","https://openalex.org/W4214915124","https://openalex.org/W2752364478","https://openalex.org/W2018951244","https://openalex.org/W3091291078","https://openalex.org/W3185884410","https://openalex.org/W2612914260","https://openalex.org/W2811395712","https://openalex.org/W4388536723","https://openalex.org/W4324139823","https://openalex.org/W2765330630","https://openalex.org/W1996210202","https://openalex.org/W4229772528"],"related_works":[],"abstract_inverted_index":{"Many":[0],"businesses":[1],"depend":[2],"on":[3],"legacy":[4],"systems,":[5],"which":[6],"often":[7],"use":[8],"outdated":[9],"technology":[10],"that":[11,157],"complicates":[12],"maintenance":[13],"and":[14,33,48,52,62,86,140,150,177,185],"updates.":[15],"Therefore,":[16],"software":[17],"modernization":[18],"is":[19,68],"essential,":[20],"particularly":[21],"data":[22,58,91,164],"migration":[23,59,92,165,182],"between":[24,93],"different":[25],"database":[26,46,94],"schemas.":[27,54,95],"Established":[28],"methodologies,":[29],"like":[30],"model":[31],"transformation":[32],"ETL":[34],"tools,":[35],"facilitate":[36,90],"this":[37],"migration.":[38],"However,":[39],"these":[40],"methodologies":[41],"require":[42],"deep":[43],"knowledge":[44],"of":[45,136,152,175],"languages":[47],"both":[49],"the":[50,101,137,173,181],"source":[51],"target":[53],"This":[55,79],"necessity":[56],"renders":[57],"an":[60,112],"error-prone":[61],"cognitively":[63],"demanding":[64],"task.":[65],"Our":[66],"objective":[67],"to":[69,89,118,132,168],"alleviate":[70],"developers\u2019":[71],"workloads":[72],"during":[73],"schema":[74,98],"evolution":[75],"by":[76,171,183],"proposing":[77],"DAMI-Framework.":[78],"framework":[80,159],"incorporates":[81],"a":[82,87],"domain-specific":[83],"language":[84],"(DSL)":[85],"parser":[88,102],"DAMI-DSL":[96,146],"simplifies":[97],"mapping,":[99],"while":[100],"automates":[103],"SQL":[104,169],"script":[105],"generation.":[106],"To":[107],"evaluate":[108],"DAMI-Framework,":[109],"we":[110],"conducted":[111],"empirical":[113],"evaluation":[114],"with":[115],"21":[116],"developers":[117],"assess":[119],"their":[120,134],"experiences":[121],"using":[122],"our":[123,158],"DSL":[124,138],"versus":[125],"traditional":[126],"SQL.":[127],"The":[128,143,154],"study":[129],"allows":[130],"us":[131],"measure":[133],"perceptions":[135],"properties":[139],"user":[141],"experience.":[142],"participants":[144],"praised":[145],"for":[147,180],"its":[148],"readability":[149],"ease":[151],"use.":[153],"findings":[155],"indicate":[156],"has":[160],"positive":[161],"impact":[162],"in":[163],"efforts":[166],"compared":[167],"scripts,":[170],"reducing":[172],"lines":[174],"code":[176],"characters":[178],"required":[179],"18.3%":[184],"35.6%,":[186],"respectively.":[187]},"counts_by_year":[],"updated_date":"2026-06-04T09:04:59.091469","created_date":"2025-10-18T00:00:00"}