{"id":"https://openalex.org/W7223567149","doi":"https://doi.org/10.3390/app162110548","title":"Architectural Evolution of Stream Data Warehouses: A Systematic Literature Review and Research Perspectives","display_name":"Architectural Evolution of Stream Data Warehouses: A Systematic Literature Review and Research Perspectives","publication_year":2026,"publication_date":"2026-10-24","ids":{"openalex":"https://openalex.org/W7223567149","doi":"https://doi.org/10.3390/app162110548"},"language":"en","primary_location":{"id":"doi:10.3390/app162110548","doi":"https://doi.org/10.3390/app162110548","is_oa":true,"landing_page_url":"https://doi.org/10.3390/app162110548","pdf_url":null,"source":{"id":"https://openalex.org/S4210205812","display_name":"Applied Sciences","issn_l":"2076-3417","issn":["2076-3417"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","doaj","norway-1","oarl","poland-100","russia-white-list-2","vabb-shw"],"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":"Applied Sciences","raw_type":"journal-article"},"volume":null,"type":"review","is_traditional":true,"indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.3390/app162110548","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5105764461","display_name":"Marcin Gorawski","orcid":"https://orcid.org/0000-0003-4528-242X","observed_orcids":["https://orcid.org/0000-0003-4528-242X"]},"institutions":[{"id":"https://openalex.org/I119004910","display_name":"Silesian University of Technology","ror":"https://ror.org/02dyjk442","country_code":"PL","type":"education","lineage":["https://openalex.org/I119004910"]}],"countries":["PL"],"is_corresponding":false,"raw_author_name":"Marcin Gorawski","raw_affiliation_strings":["Department of Applied Informatics, Faculty of Automatic Control, Electronics, and Computer Science, Silesian University of Technology, 44-100 Gliwice, Poland"],"raw_orcid":"https://orcid.org/0000-0003-4528-242X","affiliations":[{"raw_affiliation_string":"Department of Applied Informatics, Faculty of Automatic Control, Electronics, and Computer Science, Silesian University of Technology, 44-100 Gliwice, Poland","institution_ids":["https://openalex.org/I119004910"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068621605","display_name":"Anna Gorawska","orcid":"https://orcid.org/0000-0003-1722-6738","observed_orcids":["https://orcid.org/0000-0003-1722-6738"]},"institutions":[{"id":"https://openalex.org/I119004910","display_name":"Silesian University of Technology","ror":"https://ror.org/02dyjk442","country_code":"PL","type":"education","lineage":["https://openalex.org/I119004910"]}],"countries":["PL"],"is_corresponding":true,"raw_author_name":"Anna Gorawska","raw_affiliation_strings":["Department of Applied Informatics, Faculty of Automatic Control, Electronics, and Computer Science, Silesian University of Technology, 44-100 Gliwice, Poland"],"raw_orcid":"https://orcid.org/0000-0003-1722-6738","affiliations":[{"raw_affiliation_string":"Department of Applied Informatics, Faculty of Automatic Control, Electronics, and Computer Science, Silesian University of Technology, 44-100 Gliwice, Poland","institution_ids":["https://openalex.org/I119004910"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5008141131","display_name":"Krzysztof Pasterak","orcid":"https://orcid.org/0000-0001-5024-954X","observed_orcids":["https://orcid.org/0000-0001-5024-954X"]},"institutions":[{"id":"https://openalex.org/I119004910","display_name":"Silesian University of Technology","ror":"https://ror.org/02dyjk442","country_code":"PL","type":"education","lineage":["https://openalex.org/I119004910"]}],"countries":["PL"],"is_corresponding":false,"raw_author_name":"Krzysztof Pasterak","raw_affiliation_strings":["Department of Applied Informatics, Faculty of Automatic Control, Electronics, and Computer Science, Silesian University of Technology, 44-100 Gliwice, Poland"],"raw_orcid":"https://orcid.org/0000-0001-5024-954X","affiliations":[{"raw_affiliation_string":"Department of Applied Informatics, Faculty of Automatic Control, Electronics, and Computer Science, Silesian University of Technology, 44-100 Gliwice, Poland","institution_ids":["https://openalex.org/I119004910"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5068621605"],"corresponding_institution_ids":["https://openalex.org/I119004910"],"apc_list":{"value":2400,"currency":"CHF","value_usd":2896},"apc_paid":{"value":2400,"currency":"CHF","value_usd":2896},"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.72752549,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"16","issue":"21","first_page":"10548","last_page":"10548"},"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.725600004196167,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.725600004196167,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.24169999361038208,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.012500000186264515,"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-warehouse-architecture","display_name":"data warehouse architecture","score":0.8690000176429749},{"id":"https://openalex.org/keywords/continuous-data-streams","display_name":"continuous data streams","score":0.546999990940094},{"id":"https://openalex.org/keywords/cloud-data-platforms","display_name":"cloud data platforms","score":0.8019999861717224},{"id":"https://openalex.org/keywords/data-lakes","display_name":"data lakes","score":0.828000009059906},{"id":"https://openalex.org/keywords/data-lakehouse","display_name":"data lakehouse","score":0.9800000190734863},{"id":"https://openalex.org/keywords/fault-tolerance","display_name":"fault tolerance","score":0.5479999780654907},{"id":"https://openalex.org/keywords/data-integration","display_name":"data integration","score":0.44699999690055847},{"id":"https://openalex.org/keywords/architectural-evolution","display_name":"architectural evolution","score":0.3490000069141388}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6870999932289124},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6736000180244446},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.5260000228881836},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.4749999940395355},{"id":"https://openalex.org/C158154518","wikidata":"https://www.wikidata.org/wiki/Q7310970","display_name":"Relevance (law)","level":2,"score":0.4189000129699707},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4180999994277954},{"id":"https://openalex.org/C189708586","wikidata":"https://www.wikidata.org/wiki/Q1504425","display_name":"Systematic review","level":3,"score":0.39489999413490295},{"id":"https://openalex.org/C2778484313","wikidata":"https://www.wikidata.org/wiki/Q1172540","display_name":"Data stream","level":2,"score":0.3422999978065491},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.33959999680519104},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.3334999978542328},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.31290000677108765},{"id":"https://openalex.org/C2778819808","wikidata":"https://www.wikidata.org/wiki/Q5135707","display_name":"Cloud manufacturing","level":3,"score":0.30640000104904175},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.2702000141143799},{"id":"https://openalex.org/C107027933","wikidata":"https://www.wikidata.org/wiki/Q2006448","display_name":"Stream processing","level":2,"score":0.2603999972343445}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3390/app162110548","doi":"https://doi.org/10.3390/app162110548","is_oa":true,"landing_page_url":"https://doi.org/10.3390/app162110548","pdf_url":null,"source":{"id":"https://openalex.org/S4210205812","display_name":"Applied Sciences","issn_l":"2076-3417","issn":["2076-3417"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","doaj","norway-1","oarl","poland-100","russia-white-list-2","vabb-shw"],"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":"Applied Sciences","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.3390/app162110548","doi":"https://doi.org/10.3390/app162110548","is_oa":true,"landing_page_url":"https://doi.org/10.3390/app162110548","pdf_url":null,"source":{"id":"https://openalex.org/S4210205812","display_name":"Applied Sciences","issn_l":"2076-3417","issn":["2076-3417"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-class-a","anvur-scientific","cwts-core","doaj","norway-1","oarl","poland-100","russia-white-list-2","vabb-shw"],"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":"Applied Sciences","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.5378999710083008}],"study_designs":[{"id":"https://openalex.org/study-designs/systematic-review","display_name":"Systematic Review"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320324727","display_name":"Silesian University of Technology","ror":"https://ror.org/02dyjk442"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":81,"referenced_works":["https://openalex.org/W135301534","https://openalex.org/W194804225","https://openalex.org/W1598406785","https://openalex.org/W1966577585","https://openalex.org/W2003584736","https://openalex.org/W2016536803","https://openalex.org/W2019218368","https://openalex.org/W2021184893","https://openalex.org/W2060161902","https://openalex.org/W2063936751","https://openalex.org/W2103106131","https://openalex.org/W2119584748","https://openalex.org/W2120828587","https://openalex.org/W2126915543","https://openalex.org/W2128362607","https://openalex.org/W2143235710","https://openalex.org/W2153935206","https://openalex.org/W2157095771","https://openalex.org/W2404983629","https://openalex.org/W2430301697","https://openalex.org/W2530589556","https://openalex.org/W2765719629","https://openalex.org/W2805350385","https://openalex.org/W2941447202","https://openalex.org/W2949006873","https://openalex.org/W2966995156","https://openalex.org/W3037843194","https://openalex.org/W3042004990","https://openalex.org/W3092064606","https://openalex.org/W3122513858","https://openalex.org/W3125504388","https://openalex.org/W3150093670","https://openalex.org/W3165554918","https://openalex.org/W3201379052","https://openalex.org/W3213715694","https://openalex.org/W4200058614","https://openalex.org/W4200402278","https://openalex.org/W4210915627","https://openalex.org/W4225151022","https://openalex.org/W4281657584","https://openalex.org/W4284973416","https://openalex.org/W4290466587","https://openalex.org/W4291366462","https://openalex.org/W4291743205","https://openalex.org/W4308325139","https://openalex.org/W4308547963","https://openalex.org/W4308723741","https://openalex.org/W4310069679","https://openalex.org/W4313593990","https://openalex.org/W4321257284","https://openalex.org/W4323654865","https://openalex.org/W4366828875","https://openalex.org/W4378627852","https://openalex.org/W4380685454","https://openalex.org/W4380877164","https://openalex.org/W4384284191","https://openalex.org/W4388479934","https://openalex.org/W4390291402","https://openalex.org/W4396897827","https://openalex.org/W4398234021","https://openalex.org/W4400875444","https://openalex.org/W4401020520","https://openalex.org/W4401396940","https://openalex.org/W4402898151","https://openalex.org/W4403210258","https://openalex.org/W4403761298","https://openalex.org/W4403998173","https://openalex.org/W4406458351","https://openalex.org/W4406679127","https://openalex.org/W4408444355","https://openalex.org/W4408703806","https://openalex.org/W4409729820","https://openalex.org/W4409838505","https://openalex.org/W4412423178","https://openalex.org/W4414173605","https://openalex.org/W7077076234","https://openalex.org/W7140093446","https://openalex.org/W7159775320","https://openalex.org/W7163690288","https://openalex.org/W7166175675","https://openalex.org/W7169581956"],"related_works":["https://openalex.org/W4396875251","https://openalex.org/W7215547498","https://openalex.org/W7128486873","https://openalex.org/W6912185558","https://openalex.org/W7217607704","https://openalex.org/W7129027167","https://openalex.org/W7167251795","https://openalex.org/W4409760013","https://openalex.org/W7217510043","https://openalex.org/W7220194270"],"abstract_inverted_index":{"Stream":[0],"Data":[1,90,92,96],"Warehouses":[2],"(SDWs)":[3],"were":[4,82],"introduced":[5],"to":[6,23,147],"integrate":[7],"traditional":[8],"data":[9,16,34,59,143,184],"warehousing":[10],"with":[11,89,175],"continuous":[12,33,133],"processing":[13],"of":[14,48,57,65,111,139,172,178,193],"incoming":[15],"streams.":[17],"Such":[18],"capabilities":[19,128],"are":[20,41,119,144],"increasingly":[21],"relevant":[22],"computational":[24,166],"intelligence":[25,167],"systems":[26],"operating":[27],"in":[28,54],"dynamic,":[29],"data-intensive":[30],"environments,":[31],"where":[32],"analysis,":[35],"high":[36],"performance,":[37],"and":[38,51,69,87,94,113,124,137,141,155],"fault":[39],"tolerance":[40],"essential.":[42],"This":[43,150],"study":[44],"investigates":[45],"the":[46,55,170,191],"evolution":[47],"SDW":[49,79,105],"architectures":[50,109],"their":[52],"relevance":[53],"era":[56],"cloud-based":[58],"platforms.":[60],"A":[61],"systematic":[62],"literature":[63],"review":[64],"Scopus,":[66],"IEEE":[67],"Xplore,":[68],"ScienceDirect":[70],"identified":[71],"102":[72],"unique":[73],"publications,":[74],"from":[75,103],"which":[76],"five":[77],"complete":[78],"architectural":[80,180],"models":[81,106],"selected":[83],"for":[84,165,182],"detailed":[85],"analysis":[86],"compared":[88],"Lakes,":[91],"Lakehouses,":[93],"Modern":[95],"Warehouses.":[97],"The":[98,158],"results":[99],"reveal":[100],"a":[101],"shift":[102],"specialized":[104],"towards":[107],"flexible":[108],"composed":[110],"cloud":[112,117,173],"data-processing":[114],"services.":[115,195],"While":[116],"platforms":[118,174],"generally":[120],"considered":[121],"scalable,":[122],"available,":[123],"technologically":[125],"flexible,":[126],"stream-specific":[127],"such":[129],"as":[130],"on-the-fly":[131],"processing,":[132],"querying,":[134],"low-latency":[135],"analytics,":[136],"integration":[138,156],"current":[140],"historical":[142],"often":[145],"delegated":[146],"additional":[148],"technologies.":[149],"may":[151],"increase":[152],"technological":[153],"dependencies":[154],"complexity.":[157],"findings":[159],"suggest":[160],"that":[161],"advancing":[162],"analytical":[163],"infrastructures":[164],"requires":[168],"combining":[169],"benefits":[171],"further":[176],"development":[177],"dedicated":[179],"mechanisms":[181],"stream":[183],"warehouses,":[185],"rather":[186],"than":[187],"relying":[188],"exclusively":[189],"on":[190],"composition":[192],"existing":[194]},"counts_by_year":[],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2026-10-26T00:00:00"}