{"id":"https://openalex.org/W2528823043","doi":"https://doi.org/10.4018/ijdwm.2016070103","title":"Optimizing ETL by a Two-Level Data Staging Method","display_name":"Optimizing ETL by a Two-Level Data Staging Method","publication_year":2016,"publication_date":"2016-07-01","ids":{"openalex":"https://openalex.org/W2528823043","doi":"https://doi.org/10.4018/ijdwm.2016070103","mag":"2528823043"},"language":"en","primary_location":{"id":"doi:10.4018/ijdwm.2016070103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2016070103","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","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/A5100735899","display_name":"Xiufeng Liu","orcid":"https://orcid.org/0000-0001-5133-6688"},"institutions":[{"id":"https://openalex.org/I96673099","display_name":"Technical University of Denmark","ror":"https://ror.org/04qtj9h94","country_code":"DK","type":"education","lineage":["https://openalex.org/I96673099"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Xiufeng Liu","raw_affiliation_strings":["Department of Management Engineering, Technical University of Denmark, Kongens Lyngby, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Management Engineering, Technical University of Denmark, Kongens Lyngby, Denmark","institution_ids":["https://openalex.org/I96673099"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080204571","display_name":"Nadeem Iftikhar","orcid":"https://orcid.org/0000-0003-4872-8546"},"institutions":[{"id":"https://openalex.org/I315070680","display_name":"University College of Northern Denmark","ror":"https://ror.org/056c4z730","country_code":"DK","type":"education","lineage":["https://openalex.org/I315070680"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Nadeem Iftikhar","raw_affiliation_strings":["University College of Northern Denmark, Aalborg, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University College of Northern Denmark, Aalborg, Denmark","institution_ids":["https://openalex.org/I315070680"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102878677","display_name":"Huan Huo","orcid":"https://orcid.org/0000-0003-2440-714X"},"institutions":[{"id":"https://openalex.org/I113940042","display_name":"Shanghai University","ror":"https://ror.org/006teas31","country_code":"CN","type":"education","lineage":["https://openalex.org/I113940042"]},{"id":"https://openalex.org/I148128674","display_name":"University of Shanghai for Science and Technology","ror":"https://ror.org/00ay9v204","country_code":"CN","type":"education","lineage":["https://openalex.org/I148128674"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Huan Huo","raw_affiliation_strings":["Shanghai University of Science and Technology, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai University of Science and Technology, China","institution_ids":["https://openalex.org/I148128674","https://openalex.org/I113940042"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5073574012","display_name":"Per Sieverts Nielsen","orcid":"https://orcid.org/0000-0003-4090-7400"},"institutions":[{"id":"https://openalex.org/I96673099","display_name":"Technical University of Denmark","ror":"https://ror.org/04qtj9h94","country_code":"DK","type":"education","lineage":["https://openalex.org/I96673099"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Per Sieverts Nielsen","raw_affiliation_strings":["Technical University of Denmark, Kongens Lyngby, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technical University of Denmark, Kongens Lyngby, Denmark","institution_ids":["https://openalex.org/I96673099"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.13616315,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":"12","issue":"3","first_page":"32","last_page":"50"},"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.9990000128746033,"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.9990000128746033,"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/T11719","display_name":"Data Quality and Management","score":0.9966999888420105,"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.9948999881744385,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8747948408126831},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8738963603973389},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.6858368515968323},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.5771146416664124},{"id":"https://openalex.org/keywords/flexibility","display_name":"Flexibility (engineering)","score":0.554206132888794},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5471200346946716},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.5447708964347839},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5259207487106323},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.5124354958534241},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.509306788444519},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.08008575439453125}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8747948408126831},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8738963603973389},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.6858368515968323},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.5771146416664124},{"id":"https://openalex.org/C2780598303","wikidata":"https://www.wikidata.org/wiki/Q65921492","display_name":"Flexibility (engineering)","level":2,"score":0.554206132888794},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5471200346946716},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.5447708964347839},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5259207487106323},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.5124354958534241},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.509306788444519},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.08008575439453125},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"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/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","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/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","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/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.4018/ijdwm.2016070103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2016070103","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:12:y:2016:i:3:p:32-50","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJDWM.2016070103","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"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":"article"},{"id":"pmh:oai:pure.atira.dk:publications/875fadb0-18d9-453b-97d9-0fdb77c88a45","is_oa":false,"landing_page_url":"https://orbit.dtu.dk/en/publications/875fadb0-18d9-453b-97d9-0fdb77c88a45","pdf_url":null,"source":{"id":"https://openalex.org/S4306400705","display_name":"Technical University of Denmark, DTU Orbit (Technical University of Denmark, DTU)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I96673099","host_organization_name":"Technical University of Denmark","host_organization_lineage":["https://openalex.org/I96673099"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Liu , X , Iftikhar , N & Nielsen , P S 2016 , ' Optimizing ETL by a Two-level Data Staging Method ' , International Journal of Data Warehousing and Mining , vol. 12 , no. 3 , pp. 32-50 . https://doi.org/10.4018/IJDWM.2016070103","raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W1893018","https://openalex.org/W84515857","https://openalex.org/W174966132","https://openalex.org/W340880505","https://openalex.org/W1602435040","https://openalex.org/W1734064296","https://openalex.org/W1982583191","https://openalex.org/W1997355893","https://openalex.org/W2003374655","https://openalex.org/W2022678827","https://openalex.org/W2042970907","https://openalex.org/W2078783226","https://openalex.org/W2096347930","https://openalex.org/W2098935637","https://openalex.org/W2101127715","https://openalex.org/W2107760270","https://openalex.org/W2108971776","https://openalex.org/W2110086534","https://openalex.org/W2149877754","https://openalex.org/W2158643472","https://openalex.org/W2170634549","https://openalex.org/W2173213060","https://openalex.org/W2225161437","https://openalex.org/W2502894883","https://openalex.org/W2973379277","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2348093825","https://openalex.org/W2390710026","https://openalex.org/W2359411520","https://openalex.org/W2364425891","https://openalex.org/W2347601812","https://openalex.org/W3022239989","https://openalex.org/W2363759074","https://openalex.org/W2364409751","https://openalex.org/W1503556420","https://openalex.org/W2361930117"],"abstract_inverted_index":{"In":[0],"data":[1,4,13,33,63,83,102,115],"warehousing,":[2],"the":[3,32,49,114,120,135],"from":[5,84,101],"source":[6],"systems":[7],"are":[8],"populated":[9],"into":[10],"a":[11,44,61],"central":[12],"warehouse":[14],"(DW)":[15],"through":[16],"extraction,":[17],"transformation":[18],"and":[19,39,90,104,110,131],"loading":[20,99],"(ETL).":[21],"The":[22,70,93],"standard":[23,136],"ETL":[24,108,137],"approach":[25],"usually":[26],"uses":[27],"sequential":[28],"jobs":[29],"to":[30,47,67,113],"process":[31,48,100],"with":[34],"dependencies,":[35],"such":[36],"as":[37],"dimension":[38],"fact":[40],"data.":[41,92],"It":[42],"is":[43,73,128],"non-trivial":[45],"task":[46],"so-called":[50],"early-/late-arriving":[51,88],"data,":[52,89],"which":[53,106,124],"arrive":[54],"out":[55],"of":[56,82],"order.":[57],"This":[58,117],"paper":[59,118],"proposes":[60],"two-level":[62],"staging":[64,96],"area":[65,97],"method":[66,72,122],"optimize":[68],"ETL.":[69],"proposed":[71,121],"an":[74],"all-in-one":[75],"solution":[76],"that":[77,126],"supports":[78],"processing":[79],"different":[80],"types":[81],"operational":[85],"systems,":[86],"including":[87],"fast-/slowly-changing":[91],"introduced":[94],"additional":[95],"decouples":[98],"extraction":[103],"transformation,":[105],"improves":[107],"flexibility":[109],"minimizes":[111],"intervention":[112],"warehouse.":[116],"evaluates":[119],"empirically,":[123],"shows":[125],"it":[127],"more":[129],"efficient":[130],"less":[132],"intrusive":[133],"than":[134],"method.":[138]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}