{"id":"https://openalex.org/W2094962819","doi":"https://doi.org/10.1007/s11334-013-0217-8","title":"A metadata driven approach to performing complex heterogeneous database schema migrations","display_name":"A metadata driven approach to performing complex heterogeneous database schema migrations","publication_year":2013,"publication_date":"2013-07-12","ids":{"openalex":"https://openalex.org/W2094962819","doi":"https://doi.org/10.1007/s11334-013-0217-8","mag":"2094962819"},"language":"en","primary_location":{"id":"doi:10.1007/s11334-013-0217-8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s11334-013-0217-8","pdf_url":null,"source":{"id":"https://openalex.org/S151239915","display_name":"Innovations in Systems and Software Engineering","issn_l":"1614-5046","issn":["1614-5046","1614-5054"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Innovations in Systems and Software Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://pure.ulster.ac.uk/en/publications/e13f2bc7-bd0d-4104-8493-20e7fc619030","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083215892","display_name":"Robert M. Marks","orcid":"https://orcid.org/0000-0002-1463-718X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Robert M. Marks","raw_affiliation_strings":["IBM United Kingdom Limited, Belfast, Northern Ireland, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM United Kingdom Limited, Belfast, Northern Ireland, UK","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034643563","display_name":"Roy Sterritt","orcid":"https://orcid.org/0000-0002-4035-9363"},"institutions":[{"id":"https://openalex.org/I138801177","display_name":"University of Ulster","ror":"https://ror.org/01yp9g959","country_code":"GB","type":"education","lineage":["https://openalex.org/I138801177"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Roy Sterritt","raw_affiliation_strings":["School of Computing and Mathematics, Faculty of Engineering, University of Ulster, Newtownabbey, Northern Ireland, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computing and Mathematics, Faculty of Engineering, University of Ulster, Newtownabbey, Northern Ireland, UK","institution_ids":["https://openalex.org/I138801177"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5034643563"],"corresponding_institution_ids":["https://openalex.org/I138801177"],"apc_list":{"value":2790,"currency":"USD","value_usd":2790},"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.16436155,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"9","issue":"3","first_page":"179","last_page":"190"},"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.9990000128746033,"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.9990000128746033,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9919999837875366,"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/T10639","display_name":"Advanced Software Engineering Methodologies","score":0.9768999814987183,"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/computer-science","display_name":"Computer science","score":0.7819924354553223},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.7249132394790649},{"id":"https://openalex.org/keywords/upgrade","display_name":"Upgrade","score":0.6839849948883057},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.6742790341377258},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6740247011184692},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.5868706703186035},{"id":"https://openalex.org/keywords/vendor","display_name":"Vendor","score":0.5757037997245789},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.5014328956604004},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.43451613187789917},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.4323657751083374},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4221777319908142},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.36504876613616943},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.34214532375335693},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.32134875655174255},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.2715955078601837},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.19282123446464539}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7819924354553223},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7249132394790649},{"id":"https://openalex.org/C2780615140","wikidata":"https://www.wikidata.org/wiki/Q920419","display_name":"Upgrade","level":2,"score":0.6839849948883057},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.6742790341377258},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6740247011184692},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.5868706703186035},{"id":"https://openalex.org/C2777338717","wikidata":"https://www.wikidata.org/wiki/Q1762621","display_name":"Vendor","level":2,"score":0.5757037997245789},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5014328956604004},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.43451613187789917},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.4323657751083374},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4221777319908142},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.36504876613616943},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.34214532375335693},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.32134875655174255},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.2715955078601837},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.19282123446464539},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/s11334-013-0217-8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s11334-013-0217-8","pdf_url":null,"source":{"id":"https://openalex.org/S151239915","display_name":"Innovations in Systems and Software Engineering","issn_l":"1614-5046","issn":["1614-5046","1614-5054"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Innovations in Systems and Software Engineering","raw_type":"journal-article"},{"id":"pmh:oai:pure.atira.dk:openaire/e13f2bc7-bd0d-4104-8493-20e7fc619030","is_oa":true,"landing_page_url":"https://pure.ulster.ac.uk/en/publications/e13f2bc7-bd0d-4104-8493-20e7fc619030","pdf_url":null,"source":{"id":"https://openalex.org/S4306402454","display_name":"Ulster University Research Portal (Ulster University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I138801177","host_organization_name":"University of Ulster","host_organization_lineage":["https://openalex.org/I138801177"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Marks, R M & Sterritt, R 2013, 'A Metadata Driven Approach to Performing Complex Heterogeneous Database Schema Migrations', NASA Innovations in Systems and Software Engineering, vol. 9, no. 3, pp. 179-190. https://doi.org/10.1007/s11334-013-0217-8","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:oai:pure.atira.dk:openaire/e13f2bc7-bd0d-4104-8493-20e7fc619030","is_oa":true,"landing_page_url":"https://pure.ulster.ac.uk/en/publications/e13f2bc7-bd0d-4104-8493-20e7fc619030","pdf_url":null,"source":{"id":"https://openalex.org/S4306402454","display_name":"Ulster University Research Portal (Ulster University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I138801177","host_organization_name":"University of Ulster","host_organization_lineage":["https://openalex.org/I138801177"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Marks, R M & Sterritt, R 2013, 'A Metadata Driven Approach to Performing Complex Heterogeneous Database Schema Migrations', NASA Innovations in Systems and Software Engineering, vol. 9, no. 3, pp. 179-190. https://doi.org/10.1007/s11334-013-0217-8","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[{"display_name":"Reduced inequalities","id":"https://metadata.un.org/sdg/10","score":0.6399999856948853}],"awards":[],"funders":[{"id":"https://openalex.org/F4320307762","display_name":"International Business Machines Corporation","ror":"https://ror.org/05hh8d621"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W1498996471","https://openalex.org/W1514257960","https://openalex.org/W1517309604","https://openalex.org/W1556686123","https://openalex.org/W1812194997","https://openalex.org/W1965014786","https://openalex.org/W1998046157","https://openalex.org/W2063455950","https://openalex.org/W2077296695","https://openalex.org/W2115258141","https://openalex.org/W2116037308","https://openalex.org/W2125822162","https://openalex.org/W2130966700","https://openalex.org/W2143397294","https://openalex.org/W2155618607","https://openalex.org/W2157952764","https://openalex.org/W2161717190","https://openalex.org/W2166955459","https://openalex.org/W2538734821"],"related_works":["https://openalex.org/W49842380","https://openalex.org/W2801431209","https://openalex.org/W2153455914","https://openalex.org/W2241925915","https://openalex.org/W2707736662","https://openalex.org/W1533863182","https://openalex.org/W2098506051","https://openalex.org/W2901432962","https://openalex.org/W1588786827","https://openalex.org/W2911644013"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-07-23T08:03:31.855105","created_date":"2025-10-10T00:00:00"}