{"id":"https://openalex.org/W2330152295","doi":"https://doi.org/10.1080/12460125.2016.1138392","title":"Managing application compatibility during ETL tools and environment upgrades","display_name":"Managing application compatibility during ETL tools and environment upgrades","publication_year":2016,"publication_date":"2016-02-21","ids":{"openalex":"https://openalex.org/W2330152295","doi":"https://doi.org/10.1080/12460125.2016.1138392","mag":"2330152295"},"language":"en","primary_location":{"id":"doi:10.1080/12460125.2016.1138392","is_oa":false,"landing_page_url":"https://doi.org/10.1080/12460125.2016.1138392","pdf_url":null,"source":{"id":"https://openalex.org/S119153320","display_name":"Journal of Decision System","issn_l":"1246-0125","issn":["1246-0125","2116-7052"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Decision Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5108100245","display_name":"Nayem Rahman","orcid":null},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Nayem Rahman","raw_affiliation_strings":["IT Enterprise Applications, Intel Corporation, Hillsboro, OR, USA"],"affiliations":[{"raw_affiliation_string":"IT Enterprise Applications, Intel Corporation, Hillsboro, OR, USA","institution_ids":["https://openalex.org/I1343180700"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5104234738","display_name":"Navneet Kumar","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Navneet Kumar","raw_affiliation_strings":["Product Engineering and Development, GlobalLogic, Noida, Uttar Pradesh, India"],"affiliations":[{"raw_affiliation_string":"Product Engineering and Development, GlobalLogic, Noida, Uttar Pradesh, India","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5030245918","display_name":"Dale Rutz","orcid":null},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dale Rutz","raw_affiliation_strings":["Supply Chain IT, Intel Corporation, Santa Clara, CA, USA"],"affiliations":[{"raw_affiliation_string":"Supply Chain IT, Intel Corporation, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I1343180700"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5108100245"],"corresponding_institution_ids":["https://openalex.org/I1343180700"],"apc_list":null,"apc_paid":null,"fwci":0.3591,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.67772324,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"25","issue":"2","first_page":"136","last_page":"150"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9991999864578247,"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.9991999864578247,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9973000288009644,"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/upgrade","display_name":"Upgrade","score":0.8234758377075195},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7692979574203491},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7206885814666748},{"id":"https://openalex.org/keywords/compatibility","display_name":"Compatibility (geochemistry)","score":0.6159276366233826},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5999629497528076},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.5462696552276611},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.4487961530685425},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.4400283694267273},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.32056766748428345},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.2273741364479065},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.13649311661720276}],"concepts":[{"id":"https://openalex.org/C2780615140","wikidata":"https://www.wikidata.org/wiki/Q920419","display_name":"Upgrade","level":2,"score":0.8234758377075195},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7692979574203491},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7206885814666748},{"id":"https://openalex.org/C2778648169","wikidata":"https://www.wikidata.org/wiki/Q967768","display_name":"Compatibility (geochemistry)","level":2,"score":0.6159276366233826},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5999629497528076},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.5462696552276611},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4487961530685425},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.4400283694267273},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.32056766748428345},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2273741364479065},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.13649311661720276},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C42360764","wikidata":"https://www.wikidata.org/wiki/Q83588","display_name":"Chemical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1080/12460125.2016.1138392","is_oa":false,"landing_page_url":"https://doi.org/10.1080/12460125.2016.1138392","pdf_url":null,"source":{"id":"https://openalex.org/S119153320","display_name":"Journal of Decision System","issn_l":"1246-0125","issn":["1246-0125","2116-7052"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Decision Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.5199999809265137}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":48,"referenced_works":["https://openalex.org/W85675793","https://openalex.org/W111139864","https://openalex.org/W127844095","https://openalex.org/W201028377","https://openalex.org/W822279801","https://openalex.org/W1502921605","https://openalex.org/W1513026617","https://openalex.org/W1516261653","https://openalex.org/W1523653024","https://openalex.org/W1546081490","https://openalex.org/W1563183496","https://openalex.org/W1576019077","https://openalex.org/W1620335650","https://openalex.org/W1759737144","https://openalex.org/W1969815352","https://openalex.org/W1970205746","https://openalex.org/W1989762853","https://openalex.org/W2018311362","https://openalex.org/W2020010531","https://openalex.org/W2042892766","https://openalex.org/W2047722764","https://openalex.org/W2072553660","https://openalex.org/W2110710386","https://openalex.org/W2116138426","https://openalex.org/W2116244849","https://openalex.org/W2116426976","https://openalex.org/W2117078826","https://openalex.org/W2136451344","https://openalex.org/W2151461605","https://openalex.org/W2153814977","https://openalex.org/W2155516490","https://openalex.org/W2158951848","https://openalex.org/W2163883525","https://openalex.org/W2188809343","https://openalex.org/W2307354236","https://openalex.org/W2984360154","https://openalex.org/W3124166862","https://openalex.org/W3124974841","https://openalex.org/W3145178692","https://openalex.org/W3151678985","https://openalex.org/W3151685851","https://openalex.org/W3216828173","https://openalex.org/W4200087257","https://openalex.org/W4200118404","https://openalex.org/W4200372628","https://openalex.org/W4200425518","https://openalex.org/W4285719527","https://openalex.org/W4289126737"],"related_works":["https://openalex.org/W2368672678","https://openalex.org/W2965111880","https://openalex.org/W2370626080","https://openalex.org/W2368576029","https://openalex.org/W2364409751","https://openalex.org/W2359411520","https://openalex.org/W1503556420","https://openalex.org/W2363759074","https://openalex.org/W2361930117","https://openalex.org/W337676661"],"abstract_inverted_index":{"Extract,":[0],"transform":[1],"and":[2,18,42,74,105,122,133],"load":[3],"(ETL)":[4],"tools":[5,25,65,75,104],"are":[6],"software":[7,73,100],"applications":[8],"responsible":[9],"for":[10,87,135],"data":[11,22,35,56,78,146],"extraction":[12],"from":[13],"multiple":[14],"sources,":[15],"cleansing,":[16],"customisation":[17],"insertion":[19],"into":[20],"a":[21,47,84,88],"warehouse.":[23,36],"ETL":[24,64,96,114,119],"integrate":[26],"data,":[27],"which":[28],"enables":[29],"the":[30,33,93,110],"building":[31],"of":[32,95],"enterprise":[34,145],"To":[37],"meet":[38],"different":[39],"business":[40],"requirements":[41],"in":[43,77,113,143],"order":[44],"to":[45,50,53,62,72,126],"bring":[46],"system":[48],"up":[49],"date":[51],"or":[52],"improve":[54],"its":[55],"integration":[57],"capabilities,":[58],"it":[59],"is":[60],"necessary":[61],"upgrade":[63,121,140],"periodically.":[66],"This":[67],"paper":[68],"reviews":[69],"issues":[70],"related":[71],"upgrades":[76,101],"warehousing":[79],"environments.":[80],"It":[81],"reads":[82],"as":[83],"research":[85],"report":[86],"practitioner":[89],"audience.":[90],"We":[91,107,129],"propose":[92,123],"managing":[94],"application":[97,115],"compatibility":[98,116],"during":[99,118],"through":[102,138],"automated":[103],"processes.":[106],"will":[108],"discuss":[109],"challenges":[111],"involved":[112],"evaluation":[117],"tool":[120],"step-by-step":[124],"methods":[125],"approach":[127],"this.":[128],"also":[130],"share":[131],"suggestions":[132],"recommendations":[134],"improvement":[136],"realised":[137],"recent":[139],"activities":[141],"conducted":[142],"an":[144],"warehouse":[147],"production":[148],"environment.":[149]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":11},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2017,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}