{"id":"https://openalex.org/W2405562871","doi":"https://doi.org/10.3233/978-1-61499-289-9-861","title":"Development of a Public Health Reporting Data Warehouse: Lessons Learned","display_name":"Development of a Public Health Reporting Data Warehouse: Lessons Learned","publication_year":2013,"publication_date":"2013-01-01","ids":{"openalex":"https://openalex.org/W2405562871","doi":"https://doi.org/10.3233/978-1-61499-289-9-861","mag":"2405562871","pmid":"https://pubmed.ncbi.nlm.nih.gov/23920680"},"language":"en","primary_location":{"id":"doi:10.3233/978-1-61499-289-9-861","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-289-9-861","pdf_url":null,"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":null,"license_id":null,"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":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Rizi Seyed Ali Mussavi","orcid":null},"institutions":[{"id":"https://openalex.org/I212119943","display_name":"University of Victoria","ror":"https://ror.org/04s5mat29","country_code":"CA","type":"education","lineage":["https://openalex.org/I212119943"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Rizi Seyed Ali Mussavi","raw_affiliation_strings":["School of Health Information Science, University of Victoria, Victoria, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Health Information Science, University of Victoria, Victoria, Canada","institution_ids":["https://openalex.org/I212119943"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011481114","display_name":"Abdul Roudsari","orcid":"https://orcid.org/0000-0001-6696-3609"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Roudsari Abdul","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.0024,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.90183559,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"192","issue":null,"first_page":"861","last_page":"5"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9980000257492065,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9980000257492065,"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.9878000020980835,"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.9592000246047974,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7814720273017883},{"id":"https://openalex.org/keywords/formative-assessment","display_name":"Formative assessment","score":0.5496698617935181},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5281838178634644},{"id":"https://openalex.org/keywords/process-management","display_name":"Process management","score":0.506184995174408},{"id":"https://openalex.org/keywords/scale","display_name":"Scale (ratio)","score":0.4534261226654053},{"id":"https://openalex.org/keywords/data-extraction","display_name":"Data extraction","score":0.44246500730514526},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.3989766538143158},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2949067950248718},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.23271042108535767},{"id":"https://openalex.org/keywords/medline","display_name":"MEDLINE","score":0.14629065990447998}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7814720273017883},{"id":"https://openalex.org/C42525527","wikidata":"https://www.wikidata.org/wiki/Q1209955","display_name":"Formative assessment","level":2,"score":0.5496698617935181},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5281838178634644},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.506184995174408},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.4534261226654053},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.44246500730514526},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.3989766538143158},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2949067950248718},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.23271042108535767},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.14629065990447998},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","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},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[{"descriptor_ui":"D001955","descriptor_name":"British Columbia","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D001955","descriptor_name":"British Columbia","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D001955","descriptor_name":"British Columbia","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003141","descriptor_name":"Communicable Diseases","qualifier_ui":"Q000453","qualifier_name":"epidemiology","is_major_topic":false},{"descriptor_ui":"D003141","descriptor_name":"Communicable Diseases","qualifier_ui":"Q000453","qualifier_name":"epidemiology","is_major_topic":false},{"descriptor_ui":"D003141","descriptor_name":"Communicable Diseases","qualifier_ui":"Q000453","qualifier_name":"epidemiology","is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D004282","descriptor_name":"Documentation","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D004282","descriptor_name":"Documentation","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D004282","descriptor_name":"Documentation","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D007253","descriptor_name":"Information Centers","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D007253","descriptor_name":"Information Centers","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D007253","descriptor_name":"Information Centers","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D011159","descriptor_name":"Population Surveillance","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D011159","descriptor_name":"Population Surveillance","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D011159","descriptor_name":"Population Surveillance","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D018511","descriptor_name":"Systems Integration","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D018511","descriptor_name":"Systems Integration","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D018511","descriptor_name":"Systems Integration","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D040442","descriptor_name":"Public Health Informatics","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D040442","descriptor_name":"Public Health Informatics","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D040442","descriptor_name":"Public Health Informatics","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false}],"locations_count":2,"locations":[{"id":"doi:10.3233/978-1-61499-289-9-861","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-289-9-861","pdf_url":null,"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},{"id":"pmid:23920680","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/23920680","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":null,"sustainable_development_goals":[{"display_name":"Partnerships for the goals","id":"https://metadata.un.org/sdg/17","score":0.46000000834465027}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W56108223","https://openalex.org/W1502921605","https://openalex.org/W1513224250","https://openalex.org/W1598938328","https://openalex.org/W2011627323","https://openalex.org/W2015054762","https://openalex.org/W2021184893","https://openalex.org/W2057012437","https://openalex.org/W2108971776","https://openalex.org/W2118979349","https://openalex.org/W2123065213","https://openalex.org/W2139555996","https://openalex.org/W3216828173"],"related_works":["https://openalex.org/W4392721137","https://openalex.org/W609482051","https://openalex.org/W3199325201","https://openalex.org/W2792035366","https://openalex.org/W2364409751","https://openalex.org/W2359411520","https://openalex.org/W1503556420","https://openalex.org/W2363759074","https://openalex.org/W2361930117","https://openalex.org/W337676661"],"abstract_inverted_index":{"Data":[0],"warehouse":[1,61],"projects":[2],"are":[3],"perceived":[4],"to":[5,10,13,62,78,99,124],"be":[6],"risky":[7],"and":[8,16,22,51,75,85,93,103,109],"prone":[9],"failure":[11],"due":[12],"many":[14],"organizational":[15],"technical":[17,81],"challenges.":[18],"However,":[19],"often":[20],"iterative":[21],"lengthy":[23],"processes":[24],"of":[25,27,40,53,57,83,87,106,127],"implementation":[26,52],"data":[28,60,88,129],"warehouses":[29],"at":[30,67,114],"an":[31,35,58],"enterprise":[32,59],"level":[33],"provide":[34],"opportunity":[36],"for":[37,71],"formative":[38],"evaluation":[39],"these":[41],"solutions.":[42],"This":[43],"paper":[44],"describes":[45],"lessons":[46],"learned":[47],"from":[48,89],"successful":[49],"development":[50],"the":[54,115,119,125,128],"first":[55],"phase":[56],"support":[63,113],"public":[64],"health":[65],"surveillance":[66],"British":[68],"Columbia":[69],"Centre":[70],"Disease":[72],"Control.":[73],"Iterative":[74],"prototyping":[76],"approach":[77,98],"development,":[79],"overcoming":[80],"challenges":[82],"extraction":[84],"integration":[86],"large":[90],"scale":[91],"clinical":[92,107],"ancillary":[94],"systems,":[95],"a":[96],"novel":[97],"record":[100],"linkage,":[101],"flexible":[102],"reusable":[104],"modeling":[105],"data,":[108],"securing":[110],"senior":[111],"management":[112],"right":[116],"time":[117],"were":[118],"main":[120],"factors":[121],"that":[122],"contributed":[123],"success":[126],"warehousing":[130],"project.":[131]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":2}],"updated_date":"2026-07-15T18:14:33.161393","created_date":"2025-10-10T00:00:00"}