{"id":"https://openalex.org/W3178252834","doi":"https://doi.org/10.1007/978-3-030-80126-7_24","title":"A Systematic Literature Review on Big Data Extraction, Transformation and Loading (ETL)","display_name":"A Systematic Literature Review on Big Data Extraction, Transformation and Loading (ETL)","publication_year":2021,"publication_date":"2021-01-01","ids":{"openalex":"https://openalex.org/W3178252834","doi":"https://doi.org/10.1007/978-3-030-80126-7_24","mag":"3178252834"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-030-80126-7_24","pdf_url":null,"source":{"id":"https://openalex.org/S4210169156","display_name":"Lecture notes in networks and systems","issn_l":"2367-3389","issn":["2367-3389","2367-3370"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":true,"is_core":true,"host_organization":"https://openalex.org/P4310319972","host_organization_name":"Springer International Publishing","host_organization_lineage":["https://openalex.org/P4310319965","https://openalex.org/P4310319972"],"host_organization_lineage_names":["Springer Nature","Springer International Publishing"],"type":"book series"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"book-chapter","type_crossref":"book-chapter","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/A5049708919","display_name":"Joshua C. Nwokeji","orcid":"https://orcid.org/0000-0003-4643-2418"},"institutions":[{"id":"https://openalex.org/I967637","display_name":"Gannon University","ror":"https://ror.org/02y041669","country_code":"US","type":"funder","lineage":["https://openalex.org/I967637"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Joshua C. Nwokeji","raw_affiliation_strings":["Gannon University, Erie, PA, 16541, USA"],"affiliations":[{"raw_affiliation_string":"Gannon University, Erie, PA, 16541, USA","institution_ids":["https://openalex.org/I967637"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5022093181","display_name":"Richard Matovu","orcid":"https://orcid.org/0000-0002-3120-6728"},"institutions":[{"id":"https://openalex.org/I967637","display_name":"Gannon University","ror":"https://ror.org/02y041669","country_code":"US","type":"funder","lineage":["https://openalex.org/I967637"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Richard Matovu","raw_affiliation_strings":["Gannon University, Erie, PA, 16541, USA"],"affiliations":[{"raw_affiliation_string":"Gannon University, Erie, PA, 16541, USA","institution_ids":["https://openalex.org/I967637"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":9.33,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.900166,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":91},"biblio":{"volume":null,"issue":null,"first_page":"308","last_page":"324"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9992,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9992,"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/T11719","display_name":"Data Quality and Management","score":0.9989,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9945,"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-extraction","display_name":"Data extraction","score":0.5844687},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business Intelligence","score":0.5785207},{"id":"https://openalex.org/keywords/popularity","display_name":"Popularity","score":0.55485606},{"id":"https://openalex.org/keywords/data-analysis","display_name":"Data Analysis","score":0.45919526},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.44152862}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8028817},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.6450424},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6410195},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.617037},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.5844687},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.5785207},{"id":"https://openalex.org/C2780586970","wikidata":"https://www.wikidata.org/wiki/Q1357284","display_name":"Popularity","level":2,"score":0.55485606},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.5217727},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.4854196},{"id":"https://openalex.org/C189708586","wikidata":"https://www.wikidata.org/wiki/Q1504425","display_name":"Systematic review","level":3,"score":0.47702548},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.45919526},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.45857814},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.44152862},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.42023498},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.37147748},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.31322813},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.19099352},{"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/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.0},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-030-80126-7_24","pdf_url":null,"source":{"id":"https://openalex.org/S4210169156","display_name":"Lecture notes in networks and systems","issn_l":"2367-3389","issn":["2367-3389","2367-3370"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":true,"is_core":true,"host_organization":"https://openalex.org/P4310319972","host_organization_name":"Springer International Publishing","host_organization_lineage":["https://openalex.org/P4310319965","https://openalex.org/P4310319972"],"host_organization_lineage_names":["Springer Nature","Springer International Publishing"],"type":"book series"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":18,"referenced_works":["https://openalex.org/W1502767276","https://openalex.org/W1568685344","https://openalex.org/W1990566463","https://openalex.org/W1993582687","https://openalex.org/W2004505745","https://openalex.org/W2049833004","https://openalex.org/W2127912974","https://openalex.org/W2149229014","https://openalex.org/W2150375884","https://openalex.org/W2163857507","https://openalex.org/W2203389554","https://openalex.org/W2285118877","https://openalex.org/W2525221147","https://openalex.org/W2766578791","https://openalex.org/W2899253782","https://openalex.org/W2921842771","https://openalex.org/W3112977321","https://openalex.org/W854634292"],"related_works":["https://openalex.org/W4360993986","https://openalex.org/W4319993366","https://openalex.org/W4226165183","https://openalex.org/W3178252834","https://openalex.org/W3130756120","https://openalex.org/W2946587456","https://openalex.org/W2736909413","https://openalex.org/W2551093110","https://openalex.org/W2469081135","https://openalex.org/W2188714748"],"abstract_inverted_index":null,"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3178252834","counts_by_year":[{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":3}],"updated_date":"2025-03-24T20:42:35.250432","created_date":"2021-07-19"}