{"id":"https://openalex.org/W2404021945","doi":null,"title":"Life cycle of a data warehousing project in healthcare.","display_name":"Life cycle of a data warehousing project in healthcare.","publication_year":2001,"publication_date":"2001-01-01","ids":{"openalex":"https://openalex.org/W2404021945","mag":"2404021945","pmid":"https://pubmed.ncbi.nlm.nih.gov/11452573"},"language":"en","primary_location":{"id":"pmid:11452573","doi":null,"is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/11452573","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,"listed_in":[],"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":"Journal of healthcare information management : JHIM","raw_type":"Journal Article"},"volume":null,"type":"article","indexed_in":["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":"R Verma","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I84218800","display_name":"University of California, Davis","ror":"https://ror.org/05rrcem69","country_code":"US","type":"education","lineage":["https://openalex.org/I84218800"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"R Verma","raw_affiliation_strings":["University of California , Davis, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California , Davis, USA","institution_ids":["https://openalex.org/I84218800"]}]},{"author_position":"last","author":{"id":null,"display_name":"J Harper","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"J Harper","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":1.5605,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.87889052,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"15","issue":"2","first_page":"107","last_page":"17"},"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.9976000189781189,"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.9976000189781189,"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.0012000000569969416,"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/T14222","display_name":"Knowledge Management and Technology","score":0.00039999998989515007,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehousing","display_name":"data warehousing","score":0.9020000100135803},{"id":"https://openalex.org/keywords/health-data-integration","display_name":"health data integration","score":0.7120000123977661},{"id":"https://openalex.org/keywords/operational-data-store","display_name":"operational data store","score":0.9860000014305115},{"id":"https://openalex.org/keywords/data-cleaning","display_name":"data cleaning","score":0.7850000262260437},{"id":"https://openalex.org/keywords/data-mart","display_name":"data mart","score":0.8019999861717224},{"id":"https://openalex.org/keywords/star-schema","display_name":"star schema","score":0.8339999914169312},{"id":"https://openalex.org/keywords/data-modeling","display_name":"data modeling","score":0.7889999747276306},{"id":"https://openalex.org/keywords/business-rules","display_name":"business rules","score":0.8259999752044678},{"id":"https://openalex.org/keywords/medical-group-management","display_name":"medical group management","score":0.527999997138977},{"id":"https://openalex.org/keywords/transaction-data","display_name":"transaction data","score":0.3479999899864197}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8033301830291748},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5937249660491943},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.5561255812644958},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5352243781089783},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.48485076427459717},{"id":"https://openalex.org/C68489960","wikidata":"https://www.wikidata.org/wiki/Q2370659","display_name":"Transactional leadership","level":2,"score":0.4839754104614258},{"id":"https://openalex.org/C160735492","wikidata":"https://www.wikidata.org/wiki/Q31207","display_name":"Health care","level":2,"score":0.44458597898483276},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.42758506536483765},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.35431766510009766},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.352789044380188},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3457804322242737},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.3339313268661499},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.2462482452392578},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.14082154631614685},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.1359562873840332},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C50522688","wikidata":"https://www.wikidata.org/wiki/Q189833","display_name":"Economic growth","level":1,"score":0.0},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[{"descriptor_ui":"D002140","descriptor_name":"California","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":true},{"descriptor_ui":"D003660","descriptor_name":"Decision Support Systems, Management","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":"D007193","descriptor_name":"Independent Practice Associations","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":true},{"descriptor_ui":"D007253","descriptor_name":"Information Centers","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":true},{"descriptor_ui":"D007345","descriptor_name":"Insurance Claim Review","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012985","descriptor_name":"Software Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D013597","descriptor_name":"Systems Analysis","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","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":"D019982","descriptor_name":"Organizational Case Studies","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false}],"locations_count":2,"locations":[{"id":"pmid:11452573","doi":null,"is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/11452573","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,"listed_in":[],"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":"Journal of healthcare information management : JHIM","raw_type":"Journal Article"},{"id":"mag:2404021945","doi":null,"is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/11452573","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,"listed_in":[],"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":null,"is_accepted":false,"is_published":false,"raw_source_name":"PubMed","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":1,"referenced_works":["https://openalex.org/W124832240"],"related_works":["https://openalex.org/W2058027527","https://openalex.org/W2366223824","https://openalex.org/W2986506230","https://openalex.org/W4250518646","https://openalex.org/W2363886192","https://openalex.org/W7097429122","https://openalex.org/W2245882780","https://openalex.org/W63038191","https://openalex.org/W2379334191","https://openalex.org/W207599784"],"abstract_inverted_index":{"Hill":[0],"Physicians":[1],"Medical":[2],"Group":[3],"(and":[4],"its":[5,60],"medical":[6],"management":[7,152],"firm,":[8],"PriMed":[9,80],"Management)":[10],"early":[11],"on":[12],"recognized":[13],"the":[14,48,114],"need":[15],"for":[16,68,86,151],"a":[17,33,142],"data":[18,23,38,46,53,124,139,147],"warehouse.":[19],"Management":[20],"demanded":[21],"that":[22],"from":[24,47,97,125],"many":[25],"sources":[26],"be":[27],"integrated,":[28],"cleansed,":[29],"and":[30,43,63,71,99,122,137,141],"formatted.":[31],"As":[32],"first":[34],"step,":[35],"an":[36],"operational":[37],"store":[39],"(ODS)":[40],"was":[41,91],"built":[42],"populated":[44],"with":[45,129],"main":[49],"transactional":[50],"system;":[51],"encounter":[52],"were":[54],"added.":[55],"The":[56,107,133],"ODS":[57],"has":[58,64],"served":[59],"purpose":[61],"well":[62],"whetted":[65],"management's":[66],"appetite":[67],"more":[69,73],"information":[70,103],"faster,":[72],"reliable":[74],"access,":[75],"all":[76],"in":[77,120],"one":[78],"location.":[79],"hired":[81],"Annams":[82,98],"Systems":[83],"Consulting":[84],"(Annams)":[85],"this":[87],"effort.":[88],"A":[89],"team":[90,134],"formed,":[92],"made":[93],"up":[94],"of":[95,101,146],"consultants":[96],"members":[100],"PriMed's":[102],"services":[104],"(IS)":[105],"team.":[106],"\"classical\"":[108],"approach":[109],"is":[110,117,135],"being":[111],"taken:":[112],"enhancing":[113],"ODS,":[115],"which":[116],"largely":[118],"normalized":[119],"structure,":[121],"integrating":[123],"various":[126],"sources,":[127],"along":[128],"enforcing":[130],"business":[131],"rules.":[132],"designing":[136],"implementing":[138],"marts":[140],"\"star":[143],"schema\"":[144],"style":[145],"modeling--a":[148],"useful":[149],"tool":[150],"to":[153],"evaluate":[154],"results":[155],"before":[156],"investing":[157],"further.":[158]},"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-10-31T12:09:11.096373","created_date":"2016-06-24T00:00:00"}