{"id":"https://openalex.org/W4308547963","doi":"https://doi.org/10.3390/bdcc6040132","title":"An Overview of Data Warehouse and Data Lake in Modern Enterprise Data Management","display_name":"An Overview of Data Warehouse and Data Lake in Modern Enterprise Data Management","publication_year":2022,"publication_date":"2022-11-07","ids":{"openalex":"https://openalex.org/W4308547963","doi":"https://doi.org/10.3390/bdcc6040132"},"language":"en","primary_location":{"id":"doi:10.3390/bdcc6040132","is_oa":true,"landing_page_url":"https://doi.org/10.3390/bdcc6040132","pdf_url":"https://www.mdpi.com/2504-2289/6/4/132/pdf?version=1667890507","source":{"id":"https://openalex.org/S4210238752","display_name":"Big Data and Cognitive Computing","issn_l":"2504-2289","issn":["2504-2289"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data and Cognitive Computing","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2504-2289/6/4/132/pdf?version=1667890507","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5049298671","display_name":"Athira Nambiar","orcid":"https://orcid.org/0000-0002-4957-5804"},"institutions":[{"id":"https://openalex.org/I145286018","display_name":"SRM Institute of Science and Technology","ror":"https://ror.org/050113w36","country_code":"IN","type":"education","lineage":["https://openalex.org/I145286018"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Athira Nambiar","raw_affiliation_strings":["Department of Computational Intelligence, School of Computing, SRM Institute of Science and Technology, Chennai 603203, India"],"affiliations":[{"raw_affiliation_string":"Department of Computational Intelligence, School of Computing, SRM Institute of Science and Technology, Chennai 603203, India","institution_ids":["https://openalex.org/I145286018"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5078117785","display_name":"Divyansh Mundra","orcid":null},"institutions":[{"id":"https://openalex.org/I145286018","display_name":"SRM Institute of Science and Technology","ror":"https://ror.org/050113w36","country_code":"IN","type":"education","lineage":["https://openalex.org/I145286018"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Divyansh Mundra","raw_affiliation_strings":["Department of Computational Intelligence, School of Computing, SRM Institute of Science and Technology, Chennai 603203, India"],"affiliations":[{"raw_affiliation_string":"Department of Computational Intelligence, School of Computing, SRM Institute of Science and Technology, Chennai 603203, India","institution_ids":["https://openalex.org/I145286018"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5049298671"],"corresponding_institution_ids":["https://openalex.org/I145286018"],"apc_list":{"value":1400,"currency":"CHF","value_usd":1515},"apc_paid":{"value":1400,"currency":"CHF","value_usd":1515},"fwci":30.7119,"has_fulltext":true,"cited_by_count":159,"citation_normalized_percentile":{"value":0.99831235,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"6","issue":"4","first_page":"132","last_page":"132"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9995999932289124,"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.9995999932289124,"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.9994999766349792,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9869999885559082,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8501255512237549},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.7737258076667786},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.7205979824066162},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.6606388092041016},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6534422636032104},{"id":"https://openalex.org/keywords/enterprise-data-management","display_name":"Enterprise data management","score":0.5865693092346191},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.5749481320381165},{"id":"https://openalex.org/keywords/data-management","display_name":"Data management","score":0.5283808708190918},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.5268582105636597},{"id":"https://openalex.org/keywords/competitive-advantage","display_name":"Competitive advantage","score":0.4757097363471985},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4511213004589081},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.42134183645248413},{"id":"https://openalex.org/keywords/business-process","display_name":"Business process","score":0.41094696521759033},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.35785937309265137},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.21894192695617676},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.1935439109802246},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.17564037442207336},{"id":"https://openalex.org/keywords/work-in-process","display_name":"Work in process","score":0.17100614309310913},{"id":"https://openalex.org/keywords/enterprise-information-system","display_name":"Enterprise information system","score":0.15963712334632874},{"id":"https://openalex.org/keywords/marketing","display_name":"Marketing","score":0.11580553650856018}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8501255512237549},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.7737258076667786},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.7205979824066162},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.6606388092041016},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6534422636032104},{"id":"https://openalex.org/C136227091","wikidata":"https://www.wikidata.org/wiki/Q5380376","display_name":"Enterprise data management","level":3,"score":0.5865693092346191},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.5749481320381165},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.5283808708190918},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.5268582105636597},{"id":"https://openalex.org/C58546491","wikidata":"https://www.wikidata.org/wiki/Q1150207","display_name":"Competitive advantage","level":2,"score":0.4757097363471985},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4511213004589081},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.42134183645248413},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.41094696521759033},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.35785937309265137},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.21894192695617676},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.1935439109802246},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.17564037442207336},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.17100614309310913},{"id":"https://openalex.org/C27295321","wikidata":"https://www.wikidata.org/wiki/Q831795","display_name":"Enterprise information system","level":2,"score":0.15963712334632874},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.11580553650856018},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","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}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3390/bdcc6040132","is_oa":true,"landing_page_url":"https://doi.org/10.3390/bdcc6040132","pdf_url":"https://www.mdpi.com/2504-2289/6/4/132/pdf?version=1667890507","source":{"id":"https://openalex.org/S4210238752","display_name":"Big Data and Cognitive Computing","issn_l":"2504-2289","issn":["2504-2289"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data and Cognitive Computing","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:f08173cd1aaa42ad8ec2a0a9d7e49317","is_oa":true,"landing_page_url":"https://doaj.org/article/f08173cd1aaa42ad8ec2a0a9d7e49317","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Big Data and Cognitive Computing, Vol 6, Iss 4, p 132 (2022)","raw_type":"article"},{"id":"pmh:oai:mdpi.com:/2504-2289/6/4/132/","is_oa":true,"landing_page_url":"https://dx.doi.org/10.3390/bdcc6040132","pdf_url":null,"source":{"id":"https://openalex.org/S4306400947","display_name":"MDPI (MDPI AG)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210097602","host_organization_name":"Multidisciplinary Digital Publishing Institute (Switzerland)","host_organization_lineage":["https://openalex.org/I4210097602"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Big Data and Cognitive Computing; Volume 6; Issue 4; Pages: 132","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.3390/bdcc6040132","is_oa":true,"landing_page_url":"https://doi.org/10.3390/bdcc6040132","pdf_url":"https://www.mdpi.com/2504-2289/6/4/132/pdf?version=1667890507","source":{"id":"https://openalex.org/S4210238752","display_name":"Big Data and Cognitive Computing","issn_l":"2504-2289","issn":["2504-2289"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Big Data and Cognitive Computing","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.4699999988079071,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4308547963.pdf","grobid_xml":"https://content.openalex.org/works/W4308547963.grobid-xml"},"referenced_works_count":82,"referenced_works":["https://openalex.org/W191610952","https://openalex.org/W266081997","https://openalex.org/W1568631300","https://openalex.org/W1573370377","https://openalex.org/W1587450574","https://openalex.org/W1918839972","https://openalex.org/W1975884197","https://openalex.org/W2006089711","https://openalex.org/W2006315879","https://openalex.org/W2034829411","https://openalex.org/W2037460328","https://openalex.org/W2072764742","https://openalex.org/W2074144235","https://openalex.org/W2076684951","https://openalex.org/W2119738171","https://openalex.org/W2131715540","https://openalex.org/W2136615775","https://openalex.org/W2160986485","https://openalex.org/W2166573899","https://openalex.org/W2189235061","https://openalex.org/W2228481026","https://openalex.org/W2261525379","https://openalex.org/W2338572656","https://openalex.org/W2339875979","https://openalex.org/W2424304400","https://openalex.org/W2425316268","https://openalex.org/W2430301697","https://openalex.org/W2477514072","https://openalex.org/W2533068969","https://openalex.org/W2559967977","https://openalex.org/W2566979091","https://openalex.org/W2575168421","https://openalex.org/W2575671591","https://openalex.org/W2575976797","https://openalex.org/W2612261081","https://openalex.org/W2750856415","https://openalex.org/W2754080593","https://openalex.org/W2767749111","https://openalex.org/W2773910439","https://openalex.org/W2785444232","https://openalex.org/W2811330025","https://openalex.org/W2885610719","https://openalex.org/W2900186403","https://openalex.org/W2904029892","https://openalex.org/W2914265602","https://openalex.org/W2932811132","https://openalex.org/W2946924440","https://openalex.org/W2948163032","https://openalex.org/W2949762319","https://openalex.org/W2962754908","https://openalex.org/W2968961077","https://openalex.org/W2970059736","https://openalex.org/W2970992672","https://openalex.org/W2990636397","https://openalex.org/W3014616325","https://openalex.org/W3033448144","https://openalex.org/W3037921969","https://openalex.org/W3146147323","https://openalex.org/W3176061300","https://openalex.org/W3185240253","https://openalex.org/W3187028635","https://openalex.org/W3197232753","https://openalex.org/W3211599194","https://openalex.org/W4200039627","https://openalex.org/W4205219456","https://openalex.org/W4211032396","https://openalex.org/W4214903737","https://openalex.org/W4231534397","https://openalex.org/W4234459250","https://openalex.org/W4255463977","https://openalex.org/W4289866570","https://openalex.org/W4301655952","https://openalex.org/W6634053571","https://openalex.org/W6634260419","https://openalex.org/W6682181530","https://openalex.org/W6687411485","https://openalex.org/W6703824361","https://openalex.org/W6721439383","https://openalex.org/W6731596640","https://openalex.org/W6746726098","https://openalex.org/W6756322188","https://openalex.org/W6922499981"],"related_works":["https://openalex.org/W208715492","https://openalex.org/W2581040172","https://openalex.org/W2383696629","https://openalex.org/W2506063602","https://openalex.org/W2800223264","https://openalex.org/W23190051","https://openalex.org/W2362581214","https://openalex.org/W3165010183","https://openalex.org/W2953652248","https://openalex.org/W4248501364"],"abstract_inverted_index":{"Data":[0],"is":[1,74],"the":[2,12,30,58,66,79,85,104,110,127,156,171,178,186,192,196,204,211],"lifeblood":[3],"of":[4,15,54,60,71,84,88,103,112,139,144,155,158,191,195],"any":[5],"organization.":[6],"In":[7,99],"today\u2019s":[8],"world,":[9],"organizations":[10,47],"recognize":[11],"vital":[13],"role":[14],"data":[16,35,73,106,114,117,120,129,159,162,167,180],"in":[17,29,109,142,164],"modern":[18,165],"business":[19,97],"intelligence":[20],"systems":[21,108],"for":[22,177,210],"making":[23],"meaningful":[24,94],"decisions":[25],"and":[26,33,44,50,64,69,119,131,147,161,174,188,206],"staying":[27],"competitive":[28,39],"field.":[31],"Efficient":[32],"optimal":[34],"analytics":[36,115],"provides":[37],"a":[38,75,152,201],"edge":[40],"to":[41,125],"its":[42],"performance":[43],"services.":[45],"Major":[46],"generate,":[48],"collect":[49],"process":[51],"vast":[52,86],"amounts":[53],"data,":[55],"falling":[56],"under":[57],"category":[59],"big":[61,72,113,128],"data.":[62],"Managing":[63],"analyzing":[65],"sheer":[67],"volume":[68],"variety":[70],"cumbersome":[76],"process.":[77],"At":[78],"same":[80],"time,":[81],"proper":[82],"utilization":[83],"collection":[87],"an":[89],"organization\u2019s":[90],"information":[91],"can":[92],"generate":[93],"insights":[95],"into":[96],"tactics.":[98],"this":[100],"regard,":[101],"two":[102],"popular":[105],"management":[107,181],"area":[111],"(i.e.,":[116],"warehouse":[118],"lake)":[121],"act":[122],"as":[123],"platforms":[124],"accumulate":[126],"generated":[130],"used":[132],"by":[133],"organizations.":[134],"Although":[135],"seemingly":[136],"similar,":[137],"both":[138],"them":[140],"differ":[141],"terms":[143],"their":[145],"characteristics":[146,173],"applications.":[148],"This":[149],"article":[150],"presents":[151],"detailed":[153],"overview":[154],"roles":[157],"warehouses":[160],"lakes":[163],"enterprise":[166],"management.":[168],"We":[169],"detail":[170],"definitions,":[172],"related":[175],"works":[176],"respective":[179],"frameworks.":[182],"Furthermore,":[183],"we":[184,199],"explain":[185],"architecture":[187],"design":[189],"considerations":[190],"current":[193],"state":[194],"art.":[197],"Finally,":[198],"provide":[200],"perspective":[202],"on":[203],"challenges":[205],"promising":[207],"research":[208],"directions":[209],"future.":[212]},"counts_by_year":[{"year":2026,"cited_by_count":10},{"year":2025,"cited_by_count":61},{"year":2024,"cited_by_count":51},{"year":2023,"cited_by_count":37}],"updated_date":"2026-04-16T08:26:57.006410","created_date":"2022-11-12T00:00:00"}