{"id":"https://openalex.org/W4411075643","doi":"https://doi.org/10.3389/fdgth.2025.1599514","title":"The development and use of data warehousing in clinical settings: a scoping review","display_name":"The development and use of data warehousing in clinical settings: a scoping review","publication_year":2025,"publication_date":"2025-06-05","ids":{"openalex":"https://openalex.org/W4411075643","doi":"https://doi.org/10.3389/fdgth.2025.1599514","pmid":"https://pubmed.ncbi.nlm.nih.gov/40538572"},"language":"en","primary_location":{"id":"doi:10.3389/fdgth.2025.1599514","is_oa":true,"landing_page_url":"https://doi.org/10.3389/fdgth.2025.1599514","pdf_url":"https://www.frontiersin.org/journals/digital-health/articles/10.3389/fdgth.2025.1599514/pdf","source":{"id":"https://openalex.org/S4210170686","display_name":"Frontiers in Digital Health","issn_l":"2673-253X","issn":["2673-253X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320527","host_organization_name":"Frontiers Media","host_organization_lineage":["https://openalex.org/P4310320527"],"host_organization_lineage_names":["Frontiers Media"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Digital Health","raw_type":"journal-article"},"type":"review","indexed_in":["crossref","doaj","pubmed"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.frontiersin.org/journals/digital-health/articles/10.3389/fdgth.2025.1599514/pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5013077950","display_name":"Shiyang Lyu","orcid":"https://orcid.org/0000-0002-4859-6072"},"institutions":[{"id":"https://openalex.org/I56590836","display_name":"Monash University","ror":"https://ror.org/02bfwt286","country_code":"AU","type":"education","lineage":["https://openalex.org/I56590836"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Shiyang Lyu","raw_affiliation_strings":["Software Systems and Cybersecurity Department, Faculty of Information Technology, Monash University, Melbourne, VIC, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Software Systems and Cybersecurity Department, Faculty of Information Technology, Monash University, Melbourne, VIC, Australia","institution_ids":["https://openalex.org/I56590836"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034324385","display_name":"Simon Craig","orcid":"https://orcid.org/0000-0003-2594-1643"},"institutions":[{"id":"https://openalex.org/I2801350665","display_name":"Monash Medical Centre","ror":"https://ror.org/036s9kg65","country_code":"AU","type":"healthcare","lineage":["https://openalex.org/I2801350665","https://openalex.org/I4210121067"]},{"id":"https://openalex.org/I4210121067","display_name":"Monash Health","ror":"https://ror.org/02t1bej08","country_code":"AU","type":"healthcare","lineage":["https://openalex.org/I4210121067"]},{"id":"https://openalex.org/I56590836","display_name":"Monash University","ror":"https://ror.org/02bfwt286","country_code":"AU","type":"education","lineage":["https://openalex.org/I56590836"]}],"countries":["AU"],"is_corresponding":true,"raw_author_name":"Simon Craig","raw_affiliation_strings":["Department of Paediatrics, School of Clinical Sciences, Faculty of Medicine, Nursing and Health Sciences, Monash University, Melbourne, VIC, Australia","Paediatric Emergency Department, Monash Medical Centre, Monash Health, Melbourne, VIC, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Paediatrics, School of Clinical Sciences, Faculty of Medicine, Nursing and Health Sciences, Monash University, Melbourne, VIC, Australia","institution_ids":["https://openalex.org/I56590836"]},{"raw_affiliation_string":"Paediatric Emergency Department, Monash Medical Centre, Monash Health, Melbourne, VIC, Australia","institution_ids":["https://openalex.org/I2801350665","https://openalex.org/I4210121067"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074872024","display_name":"Gerard O\u2019Reilly","orcid":"https://orcid.org/0000-0001-5763-917X"},"institutions":[{"id":"https://openalex.org/I4210163178","display_name":"Alfred Health","ror":"https://ror.org/04scfb908","country_code":"AU","type":"healthcare","lineage":["https://openalex.org/I4210163178"]},{"id":"https://openalex.org/I56590836","display_name":"Monash University","ror":"https://ror.org/02bfwt286","country_code":"AU","type":"education","lineage":["https://openalex.org/I56590836"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Gerard O'Reilly","raw_affiliation_strings":["Emergency and Trauma Centre, Alfred Health, Melbourne, VIC, Australia","School of Public Health and Preventive Medicine, Faculty of Medicine, Nursing and Health Sciences, Monash University, Melbourne, VIC, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Emergency and Trauma Centre, Alfred Health, Melbourne, VIC, Australia","institution_ids":["https://openalex.org/I4210163178"]},{"raw_affiliation_string":"School of Public Health and Preventive Medicine, Faculty of Medicine, Nursing and Health Sciences, Monash University, Melbourne, VIC, Australia","institution_ids":["https://openalex.org/I56590836"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5065353209","display_name":"David Taniar","orcid":"https://orcid.org/0000-0002-8862-3960"},"institutions":[{"id":"https://openalex.org/I56590836","display_name":"Monash University","ror":"https://ror.org/02bfwt286","country_code":"AU","type":"education","lineage":["https://openalex.org/I56590836"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"David Taniar","raw_affiliation_strings":["Software Systems and Cybersecurity Department, Faculty of Information Technology, Monash University, Melbourne, VIC, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Software Systems and Cybersecurity Department, Faculty of Information Technology, Monash University, Melbourne, VIC, Australia","institution_ids":["https://openalex.org/I56590836"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5034324385"],"corresponding_institution_ids":["https://openalex.org/I2801350665","https://openalex.org/I4210121067","https://openalex.org/I56590836"],"apc_list":{"value":1900,"currency":"USD","value_usd":1900},"apc_paid":{"value":1900,"currency":"USD","value_usd":1900},"fwci":7.0716,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.96561487,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":98},"biblio":{"volume":"7","issue":null,"first_page":"1599514","last_page":"1599514"},"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.3547999858856201,"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.3547999858856201,"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/T10350","display_name":"Electronic Health Records Systems","score":0.16949999332427979,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.025499999523162842,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"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.8858463764190674},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.7650178074836731},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7148973345756531},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.5754449367523193},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.5657753348350525},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.49289464950561523},{"id":"https://openalex.org/keywords/cinahl","display_name":"CINAHL","score":0.4824700653553009},{"id":"https://openalex.org/keywords/scopus","display_name":"Scopus","score":0.4388093948364258},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4354485273361206},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38654160499572754},{"id":"https://openalex.org/keywords/medline","display_name":"MEDLINE","score":0.2387300729751587},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.14127445220947266},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.10690444707870483}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8858463764190674},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7650178074836731},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7148973345756531},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.5754449367523193},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.5657753348350525},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.49289464950561523},{"id":"https://openalex.org/C2781145037","wikidata":"https://www.wikidata.org/wiki/Q5011772","display_name":"CINAHL","level":3,"score":0.4824700653553009},{"id":"https://openalex.org/C83867959","wikidata":"https://www.wikidata.org/wiki/Q371467","display_name":"Scopus","level":3,"score":0.4388093948364258},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4354485273361206},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38654160499572754},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.2387300729751587},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.14127445220947266},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.10690444707870483},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","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}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.3389/fdgth.2025.1599514","is_oa":true,"landing_page_url":"https://doi.org/10.3389/fdgth.2025.1599514","pdf_url":"https://www.frontiersin.org/journals/digital-health/articles/10.3389/fdgth.2025.1599514/pdf","source":{"id":"https://openalex.org/S4210170686","display_name":"Frontiers in Digital Health","issn_l":"2673-253X","issn":["2673-253X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320527","host_organization_name":"Frontiers Media","host_organization_lineage":["https://openalex.org/P4310320527"],"host_organization_lineage_names":["Frontiers Media"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Digital Health","raw_type":"journal-article"},{"id":"pmid:40538572","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/40538572","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in digital health","raw_type":null},{"id":"pmh:oai:pubmedcentral.nih.gov:12176853","is_oa":true,"landing_page_url":"https://www.ncbi.nlm.nih.gov/pmc/articles/12176853","pdf_url":null,"source":{"id":"https://openalex.org/S2764455111","display_name":"PubMed Central","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":"Front Digit Health","raw_type":"Text"},{"id":"pmh:oai:doaj.org/article:e55dae93a8d9484e8c59046c4f99b748","is_oa":true,"landing_page_url":"https://doaj.org/article/e55dae93a8d9484e8c59046c4f99b748","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Frontiers in Digital Health, Vol 7 (2025)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.3389/fdgth.2025.1599514","is_oa":true,"landing_page_url":"https://doi.org/10.3389/fdgth.2025.1599514","pdf_url":"https://www.frontiersin.org/journals/digital-health/articles/10.3389/fdgth.2025.1599514/pdf","source":{"id":"https://openalex.org/S4210170686","display_name":"Frontiers in Digital Health","issn_l":"2673-253X","issn":["2673-253X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320527","host_organization_name":"Frontiers Media","host_organization_lineage":["https://openalex.org/P4310320527"],"host_organization_lineage_names":["Frontiers Media"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Digital Health","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4411075643.pdf","grobid_xml":"https://content.openalex.org/works/W4411075643.grobid-xml"},"referenced_works_count":47,"referenced_works":["https://openalex.org/W155462512","https://openalex.org/W340417874","https://openalex.org/W1909382067","https://openalex.org/W1991679319","https://openalex.org/W2018717854","https://openalex.org/W2032521420","https://openalex.org/W2042396631","https://openalex.org/W2079741789","https://openalex.org/W2151560197","https://openalex.org/W2197666063","https://openalex.org/W2290196138","https://openalex.org/W2343415708","https://openalex.org/W2549260305","https://openalex.org/W2737022843","https://openalex.org/W2757953902","https://openalex.org/W2806155780","https://openalex.org/W2891378911","https://openalex.org/W2924622475","https://openalex.org/W2963335492","https://openalex.org/W2966330911","https://openalex.org/W2995516681","https://openalex.org/W2996619863","https://openalex.org/W3046810235","https://openalex.org/W3092345257","https://openalex.org/W3103947652","https://openalex.org/W4220742612","https://openalex.org/W4281835402","https://openalex.org/W4285604208","https://openalex.org/W4318755628","https://openalex.org/W4367048659","https://openalex.org/W4386159371","https://openalex.org/W4386544822","https://openalex.org/W4389492841","https://openalex.org/W4390889621","https://openalex.org/W4396711069","https://openalex.org/W4400232282","https://openalex.org/W6639872429","https://openalex.org/W6670554044","https://openalex.org/W6687895481","https://openalex.org/W6729205344","https://openalex.org/W6752523342","https://openalex.org/W6771942995","https://openalex.org/W6772588980","https://openalex.org/W6783968181","https://openalex.org/W6803337432","https://openalex.org/W6854213366","https://openalex.org/W6860007060"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W2872228342","https://openalex.org/W2357522326"],"abstract_inverted_index":{"Introduction:":[0],"The":[1],"emergence":[2],"of":[3,21,30,43,46,158,227,235,275],"data":[4,12,31,47,99,108,123,164,170,172,182,219,236,263,268,294,313],"warehousing":[5,100],"in":[6,33,101],"clinical":[7,34,197],"settings":[8,35],"has":[9],"greatly":[10],"enhanced":[11],"analysis":[13,214],"capabilities,":[14],"facilitating":[15],"the":[16,28,38,64,117,122,155,225,251],"accurate":[17],"and":[18,41,55,71,82,120,166,195,212,243,253,280,286,315,342],"comprehensive":[19,273],"extraction":[20],"valuable":[22],"information.":[23],"This":[24,59],"scoping":[25,60],"review":[26,61],"explores":[27],"contributions":[29],"warehouses":[32,165,173,200,220,264,295,327],"by":[36,230],"analysing":[37],"strengths,":[39],"challenges":[40,255,330,338],"implications":[42],"each":[44],"type":[45],"warehouse,":[48],"with":[49,207,257,339],"a":[50,125,203,232,272],"particular":[51],"focus":[52,97,301],"on":[53,98,162,168,223,302],"general":[54,105,163,196],"specialised":[56,107,169,218,241,293,326],"types.":[57],"Methods:":[58],"adheres":[62],"to":[63,92,115,176,180,238,249,270,332],"Preferred":[65],"Reporting":[66],"Items":[67],"for":[68,128,147,186,299,317],"Systematic":[69],"Reviews":[70],"Meta-Analyses":[72],"(PRISMA)":[73],"guidelines.":[74],"We":[75],"searched":[76],"four":[77],"databases":[78],"(PubMed,":[79],"CINAHL,":[80],"Scopus":[81],"IEEE-Xplore),":[83],"identifying":[84],"peer-reviewed,":[85],"English-language":[86],"studies":[87],"from":[88],"1st":[89,93],"January":[90,94],"2014":[91],"2024,":[95],"that":[96],"healthcare,":[102],"covering":[103],"either":[104],"or":[106,305],"warehouse":[109],"applications.":[110],"Python":[111],"programming":[112],"was":[113],"used":[114,179],"extract":[116],"search":[118],"results":[119],"transform":[121],"into":[124],"tabular":[126],"format":[127],"analysis.":[129],"Results:":[130],"After":[131],"removing":[132],"1,194":[133],"duplicates,":[134],"4,864":[135],"unique":[136,252],"papers":[137,153],"remained.":[138],"Abstract":[139],"screening":[140],"excluded":[141],"4,590":[142],"as":[143,312],"irrelevant,":[144],"leaving":[145],"274":[146],"full-text":[148],"evaluation.":[149],"In":[150,216,291],"total,":[151],"27":[152],"met":[154],"inclusion":[156],"criteria,":[157],"which":[159],"17":[160],"focused":[161,222],"10":[167],"warehouses.General":[171],"were":[174,221],"found":[175],"be":[177],"primarily":[178],"address":[181,250],"integration":[183],"issues,":[184],"particularly":[185],"electronic":[187],"health":[188],"record":[189],"(EHR)/":[190],"Electronic":[191],"medical":[192],"Record":[193],"(EMR)":[194],"data.":[198],"These":[199],"typically":[201],"use":[202],"star":[204],"schema":[205],"architecture":[206],"online":[208],"analytical":[209,287,319],"processing":[210],"(OLAP)":[211],"query":[213],"capabilities.":[215],"contrast,":[217,292],"improving":[224],"quality":[226],"decision":[228],"support":[229],"handling":[231],"wide":[233],"range":[234],"specific":[237,303],"diseases,":[239],"using":[240,308],"architectures":[242,344],"advanced":[244,309,340],"artificial":[245],"intelligence":[246],"(AI)":[247],"capabilities":[248,288],"complex":[254],"associated":[256],"these":[258,325,337],"tasks.":[259],"Conclusions:":[260],"General":[261],"purpose":[262],"effectively":[265],"integrate":[266],"disparate":[267],"sources":[269],"provide":[271],"view":[274],"disease":[276],"management,":[277],"patient":[278],"care,":[279],"resource":[281],"management.":[282],"However,":[283],"their":[284,300,322,333],"flexibility":[285],"need":[289],"improvement.":[290],"are":[296],"gaining":[297],"popularity":[298],"diseases":[304],"research":[306],"purposes,":[307],"tools":[310],"such":[311],"mining":[314],"AI":[316],"superior":[318],"performance.":[320],"Despite":[321],"innovative":[323],"designs,":[324],"face":[328],"scalability":[329],"due":[331],"customised":[334],"nature.":[335],"Addressing":[336],"analytics":[341],"flexible":[343],"is":[345],"critical.":[346]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}