{"id":"https://openalex.org/W3164819623","doi":"https://doi.org/10.3233/shti210198","title":"A Data Warehouse Design for Dangerous Pathogen Monitoring","display_name":"A Data Warehouse Design for Dangerous Pathogen Monitoring","publication_year":2021,"publication_date":"2021-05-27","ids":{"openalex":"https://openalex.org/W3164819623","doi":"https://doi.org/10.3233/shti210198","mag":"3164819623","pmid":"https://pubmed.ncbi.nlm.nih.gov/34042783"},"language":"en","primary_location":{"id":"doi:10.3233/shti210198","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti210198","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI210198","source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI210198","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5062591099","display_name":"Amadou Dicko","orcid":"https://orcid.org/0000-0003-2282-3086"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Amadou Dicko","raw_affiliation_strings":["National Institute of Public Health, Burkina Faso"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"National Institute of Public Health, Burkina Faso","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023818154","display_name":"Seydou Golo Barro","orcid":"https://orcid.org/0000-0001-8274-6700"},"institutions":[{"id":"https://openalex.org/I3131918342","display_name":"Nazi Boni University","ror":"https://ror.org/04cq90n15","country_code":"BF","type":"education","lineage":["https://openalex.org/I3131918342"]}],"countries":["BF"],"is_corresponding":false,"raw_author_name":"Seydou Golo Barro","raw_affiliation_strings":["Nazi BONI University, Burkina Faso","RETINES Lab \u2013 IRIS department \u2013 Medical Faculty of Nice University, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Nazi BONI University, Burkina Faso","institution_ids":["https://openalex.org/I3131918342"]},{"raw_affiliation_string":"RETINES Lab \u2013 IRIS department \u2013 Medical Faculty of Nice University, France","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086371856","display_name":"Yaya Traor\u00e9","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yaya Traore","raw_affiliation_strings":["Joseph Ki-ZERBO University, Burkina Faso"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Joseph Ki-ZERBO University, Burkina Faso","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056891151","display_name":"Pascal Staccini","orcid":"https://orcid.org/0000-0002-7608-4066"},"institutions":[{"id":"https://openalex.org/I4210119200","display_name":"Institut de Recherche sur le Cancer et le Vieillissement de Nice","ror":"https://ror.org/01td3kv81","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I154526488","https://openalex.org/I201841394","https://openalex.org/I4210096427","https://openalex.org/I4210119200"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Pascal Staccini","raw_affiliation_strings":["RETINES Lab \u2013 IRIS department \u2013 Medical Faculty of Nice University, France","RETINES Lab - IRIS department - Medical Faculty of Nice University, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"RETINES Lab \u2013 IRIS department \u2013 Medical Faculty of Nice University, France","institution_ids":[]},{"raw_affiliation_string":"RETINES Lab - IRIS department - Medical Faculty of Nice University, France","institution_ids":["https://openalex.org/I4210119200"]}]}],"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":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.12693083,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":"281","issue":null,"first_page":"447","last_page":"451"},"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.9882000088691711,"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.9882000088691711,"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/T11396","display_name":"Artificial Intelligence in Healthcare","score":0.9388999938964844,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9150000214576721,"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","display_name":"Data warehouse","score":0.7214469909667969},{"id":"https://openalex.org/keywords/multidisciplinary-approach","display_name":"Multidisciplinary approach","score":0.6647096872329712},{"id":"https://openalex.org/keywords/pandemic","display_name":"Pandemic","score":0.5559377074241638},{"id":"https://openalex.org/keywords/public-health","display_name":"Public health","score":0.5469279289245605},{"id":"https://openalex.org/keywords/work","display_name":"Work (physics)","score":0.4602922201156616},{"id":"https://openalex.org/keywords/component","display_name":"Component (thermodynamics)","score":0.4334525763988495},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.4331277906894684},{"id":"https://openalex.org/keywords/digital-health","display_name":"Digital health","score":0.41679781675338745},{"id":"https://openalex.org/keywords/health-data","display_name":"Health data","score":0.41582080721855164},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.4101717472076416},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4029625952243805},{"id":"https://openalex.org/keywords/coronavirus-disease-2019","display_name":"Coronavirus disease 2019 (COVID-19)","score":0.37141960859298706},{"id":"https://openalex.org/keywords/process-management","display_name":"Process management","score":0.35957980155944824},{"id":"https://openalex.org/keywords/engineering-management","display_name":"Engineering management","score":0.3347064256668091},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3219773769378662},{"id":"https://openalex.org/keywords/health-care","display_name":"Health care","score":0.2802557349205017},{"id":"https://openalex.org/keywords/medicine","display_name":"Medicine","score":0.2237321436405182},{"id":"https://openalex.org/keywords/infectious-disease","display_name":"Infectious disease (medical specialty)","score":0.19504833221435547},{"id":"https://openalex.org/keywords/disease","display_name":"Disease","score":0.163315087556839},{"id":"https://openalex.org/keywords/political-science","display_name":"Political science","score":0.09346392750740051}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7214469909667969},{"id":"https://openalex.org/C22467394","wikidata":"https://www.wikidata.org/wiki/Q849359","display_name":"Multidisciplinary approach","level":2,"score":0.6647096872329712},{"id":"https://openalex.org/C89623803","wikidata":"https://www.wikidata.org/wiki/Q12184","display_name":"Pandemic","level":5,"score":0.5559377074241638},{"id":"https://openalex.org/C138816342","wikidata":"https://www.wikidata.org/wiki/Q189603","display_name":"Public health","level":2,"score":0.5469279289245605},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.4602922201156616},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.4334525763988495},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4331277906894684},{"id":"https://openalex.org/C2780433410","wikidata":"https://www.wikidata.org/wiki/Q5276090","display_name":"Digital health","level":3,"score":0.41679781675338745},{"id":"https://openalex.org/C3017977704","wikidata":"https://www.wikidata.org/wiki/Q18745135","display_name":"Health data","level":3,"score":0.41582080721855164},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.4101717472076416},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4029625952243805},{"id":"https://openalex.org/C3008058167","wikidata":"https://www.wikidata.org/wiki/Q84263196","display_name":"Coronavirus disease 2019 (COVID-19)","level":4,"score":0.37141960859298706},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.35957980155944824},{"id":"https://openalex.org/C110354214","wikidata":"https://www.wikidata.org/wiki/Q6314146","display_name":"Engineering management","level":1,"score":0.3347064256668091},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3219773769378662},{"id":"https://openalex.org/C160735492","wikidata":"https://www.wikidata.org/wiki/Q31207","display_name":"Health care","level":2,"score":0.2802557349205017},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.2237321436405182},{"id":"https://openalex.org/C524204448","wikidata":"https://www.wikidata.org/wiki/Q788926","display_name":"Infectious disease (medical specialty)","level":3,"score":0.19504833221435547},{"id":"https://openalex.org/C2779134260","wikidata":"https://www.wikidata.org/wiki/Q12136","display_name":"Disease","level":2,"score":0.163315087556839},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.09346392750740051},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C97355855","wikidata":"https://www.wikidata.org/wiki/Q11473","display_name":"Thermodynamics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C142724271","wikidata":"https://www.wikidata.org/wiki/Q7208","display_name":"Pathology","level":1,"score":0.0},{"id":"https://openalex.org/C159110408","wikidata":"https://www.wikidata.org/wiki/Q121176","display_name":"Nursing","level":1,"score":0.0}],"mesh":[{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000086382","descriptor_name":"COVID-19","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000086382","descriptor_name":"COVID-19","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000086382","descriptor_name":"COVID-19","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000086402","descriptor_name":"SARS-CoV-2","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000086402","descriptor_name":"SARS-CoV-2","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000086402","descriptor_name":"SARS-CoV-2","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000349","descriptor_name":"Africa","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000349","descriptor_name":"Africa","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000349","descriptor_name":"Africa","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D058873","descriptor_name":"Pandemics","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D058873","descriptor_name":"Pandemics","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D058873","descriptor_name":"Pandemics","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false}],"locations_count":2,"locations":[{"id":"doi:10.3233/shti210198","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti210198","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI210198","source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},{"id":"pmid:34042783","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/34042783","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":"Studies in health technology and informatics","raw_type":null}],"best_oa_location":{"id":"doi:10.3233/shti210198","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti210198","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI210198","source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/3","score":0.7099999785423279,"display_name":"Good health and well-being"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3164819623.pdf","grobid_xml":"https://content.openalex.org/works/W3164819623.grobid-xml"},"referenced_works_count":6,"referenced_works":["https://openalex.org/W295358224","https://openalex.org/W2245882780","https://openalex.org/W2922441566","https://openalex.org/W3086487856","https://openalex.org/W4254304078","https://openalex.org/W6831246416"],"related_works":["https://openalex.org/W4286508873","https://openalex.org/W2185045523","https://openalex.org/W2175024588","https://openalex.org/W156969523","https://openalex.org/W4205981462","https://openalex.org/W2949717487","https://openalex.org/W3137007662","https://openalex.org/W4226526324","https://openalex.org/W3134303910","https://openalex.org/W3000746864"],"abstract_inverted_index":{"Emerging":[0],"diseases":[1],"are":[2,58],"a":[3,26,90,110],"major":[4],"public":[5,22,43],"health":[6,23,44,56],"problem":[7],"as":[8,61],"illustrated":[9],"by":[10],"the":[11,19,46,71,77],"current":[12],"coronavirus":[13],"disease":[14],"(COVID-19)":[15],"pandemic.":[16],"To":[17],"make":[18],"right":[20],"decisions,":[21],"departments":[24],"need":[25],"decision-making":[27],"system.":[28],"In":[29],"Africa":[30],"few":[31],"IT":[32],"systems":[33],"have":[34],"been":[35],"put":[36],"in":[37,45,89,101],"place":[38],"to":[39,98],"help":[40],"managers":[41],"of":[42,48,54,82],"analysis":[47],"their":[49],"multidisciplinary":[50],"data.":[51],"The":[52],"majority":[53],"digital":[55],"solutions":[57],"operational":[59],"databases,":[60],"well,":[62],"focused":[63],"on":[64],"surveillance":[65],"activities":[66],"that":[67],"do":[68],"not":[69],"include":[70],"laboratory":[72],"component.":[73],"This":[74],"paper":[75],"describes":[76],"design":[78],"model":[79],"and":[80,106],"implementation":[81],"data":[83,94,100],"warehouse":[84],"for":[85],"dangerous":[86],"pathogen":[87],"monitoring":[88],"laboratories":[91],"network.":[92],"Talend":[93],"integration":[95],"is":[96],"used":[97],"extract":[99],"Excel":[102],"sheets,":[103],"transform":[104],"it":[105,108],"load":[107],"into":[109],"MySQL":[111],"database.":[112]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}