{"id":"https://openalex.org/W155462512","doi":"https://doi.org/10.1136/amiajnl-2011-000339","title":"A Dimensional Bus model for integrating clinical and research data","display_name":"A Dimensional Bus model for integrating clinical and research data","publication_year":2011,"publication_date":"2011-08-19","ids":{"openalex":"https://openalex.org/W155462512","doi":"https://doi.org/10.1136/amiajnl-2011-000339","mag":"155462512","pmid":"https://pubmed.ncbi.nlm.nih.gov/21856687"},"language":"en","primary_location":{"id":"doi:10.1136/amiajnl-2011-000339","is_oa":true,"landing_page_url":"https://doi.org/10.1136/amiajnl-2011-000339","pdf_url":"https://academic.oup.com/jamia/article-pdf/18/Supplement_1/i96/6900545/18-Supplement_1-i96.pdf","source":{"id":"https://openalex.org/S129839026","display_name":"Journal of the American Medical Informatics Association","issn_l":"1067-5027","issn":["1067-5027","1527-974X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the American Medical Informatics Association","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://academic.oup.com/jamia/article-pdf/18/Supplement_1/i96/6900545/18-Supplement_1-i96.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5084097016","display_name":"Ted D. Wade","orcid":"https://orcid.org/0000-0002-4296-7143"},"institutions":[{"id":"https://openalex.org/I3019586173","display_name":"National Jewish Health","ror":"https://ror.org/016z2bp30","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I3019586173"]},{"id":"https://openalex.org/I4389425372","display_name":"Colorado Clinical and Translational Sciences Institute","ror":"https://ror.org/03xsh7c04","country_code":null,"type":"facility","lineage":["https://openalex.org/I4389425372","https://openalex.org/I921990950","https://openalex.org/I92446798"]},{"id":"https://openalex.org/I921990950","display_name":"University of Colorado Denver","ror":"https://ror.org/02hh7en24","country_code":"US","type":"education","lineage":["https://openalex.org/I921990950"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"T. D. Wade","raw_affiliation_strings":["Division of Biostatistics and Bioinformatics, National Jewish Health, Denver, Colorado 80206-2761, USA. wadet@njhealth.org","Colorado Clinical and Translational Sciences Institute, Aurora, Colorado, USA","Division of Biostatistics and Bioinformatics, National Jewish Health, Denver, Colorado, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Division of Biostatistics and Bioinformatics, National Jewish Health, Denver, Colorado 80206-2761, USA. wadet@njhealth.org","institution_ids":["https://openalex.org/I3019586173","https://openalex.org/I921990950"]},{"raw_affiliation_string":"Colorado Clinical and Translational Sciences Institute, Aurora, Colorado, USA","institution_ids":["https://openalex.org/I4389425372"]},{"raw_affiliation_string":"Division of Biostatistics and Bioinformatics, National Jewish Health, Denver, Colorado, USA","institution_ids":["https://openalex.org/I3019586173","https://openalex.org/I921990950"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045923501","display_name":"Richard C. Hum","orcid":null},"institutions":[{"id":"https://openalex.org/I3019586173","display_name":"National Jewish Health","ror":"https://ror.org/016z2bp30","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I3019586173"]},{"id":"https://openalex.org/I921990950","display_name":"University of Colorado Denver","ror":"https://ror.org/02hh7en24","country_code":"US","type":"education","lineage":["https://openalex.org/I921990950"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"R. C. Hum","raw_affiliation_strings":["Division of Biostatistics and Bioinformatics, National Jewish Health, Denver, Colorado, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Division of Biostatistics and Bioinformatics, National Jewish Health, Denver, Colorado, USA","institution_ids":["https://openalex.org/I3019586173","https://openalex.org/I921990950"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023642931","display_name":"J. R. Murphy","orcid":null},"institutions":[{"id":"https://openalex.org/I3019586173","display_name":"National Jewish Health","ror":"https://ror.org/016z2bp30","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I3019586173"]},{"id":"https://openalex.org/I4389425372","display_name":"Colorado Clinical and Translational Sciences Institute","ror":"https://ror.org/03xsh7c04","country_code":null,"type":"facility","lineage":["https://openalex.org/I4389425372","https://openalex.org/I921990950","https://openalex.org/I92446798"]},{"id":"https://openalex.org/I921990950","display_name":"University of Colorado Denver","ror":"https://ror.org/02hh7en24","country_code":"US","type":"education","lineage":["https://openalex.org/I921990950"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"J. R. Murphy","raw_affiliation_strings":["Colorado Clinical and Translational Sciences Institute, Aurora, Colorado, USA","Division of Biostatistics and Bioinformatics, National Jewish Health, Denver, Colorado, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Colorado Clinical and Translational Sciences Institute, Aurora, Colorado, USA","institution_ids":["https://openalex.org/I4389425372"]},{"raw_affiliation_string":"Division of Biostatistics and Bioinformatics, National Jewish Health, Denver, Colorado, USA","institution_ids":["https://openalex.org/I3019586173","https://openalex.org/I921990950"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5084097016"],"corresponding_institution_ids":["https://openalex.org/I3019586173","https://openalex.org/I4389425372","https://openalex.org/I921990950"],"apc_list":{"value":3967,"currency":"USD","value_usd":3967},"apc_paid":null,"fwci":6.7715,"has_fulltext":false,"cited_by_count":23,"citation_normalized_percentile":{"value":0.96035282,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"18","issue":"Supplement 1","first_page":"i96","last_page":"i102"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.20160000026226044,"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"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.20160000026226044,"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"}},{"id":"https://openalex.org/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.13349999487400055,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.10109999775886536,"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/computer-science","display_name":"Computer science","score":0.5903525948524475},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3709200620651245}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5903525948524475},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3709200620651245}],"mesh":[{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"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":"D012985","descriptor_name":"Software Design","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":"D012985","descriptor_name":"Software Design","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":"D016247","descriptor_name":"Information Storage and Retrieval","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":"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":"D019992","descriptor_name":"Databases as Topic","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D019992","descriptor_name":"Databases as Topic","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D019992","descriptor_name":"Databases as Topic","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D035843","descriptor_name":"Biomedical Research","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D035843","descriptor_name":"Biomedical Research","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D035843","descriptor_name":"Biomedical Research","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":3,"locations":[{"id":"doi:10.1136/amiajnl-2011-000339","is_oa":true,"landing_page_url":"https://doi.org/10.1136/amiajnl-2011-000339","pdf_url":"https://academic.oup.com/jamia/article-pdf/18/Supplement_1/i96/6900545/18-Supplement_1-i96.pdf","source":{"id":"https://openalex.org/S129839026","display_name":"Journal of the American Medical Informatics Association","issn_l":"1067-5027","issn":["1067-5027","1527-974X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the American Medical Informatics Association","raw_type":"journal-article"},{"id":"pmid:21856687","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/21856687","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":"Journal of the American Medical Informatics Association : JAMIA","raw_type":null},{"id":"pmh:oai:europepmc.org:2512762","is_oa":false,"landing_page_url":"https://www.ncbi.nlm.nih.gov/pmc/articles/3241170","pdf_url":null,"source":{"id":"https://openalex.org/S4306400806","display_name":"Europe PMC (PubMed Central)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1303153112","host_organization_name":"European Bioinformatics Institute","host_organization_lineage":["https://openalex.org/I1303153112"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Text"}],"best_oa_location":{"id":"doi:10.1136/amiajnl-2011-000339","is_oa":true,"landing_page_url":"https://doi.org/10.1136/amiajnl-2011-000339","pdf_url":"https://academic.oup.com/jamia/article-pdf/18/Supplement_1/i96/6900545/18-Supplement_1-i96.pdf","source":{"id":"https://openalex.org/S129839026","display_name":"Journal of the American Medical Informatics Association","issn_l":"1067-5027","issn":["1067-5027","1527-974X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the American Medical Informatics Association","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5848552159","display_name":null,"funder_award_id":"UL1RR025780","funder_id":"https://openalex.org/F4320337375","funder_display_name":"National Center for Research Resources"},{"id":"https://openalex.org/G6986171645","display_name":null,"funder_award_id":"UL1 RR025780","funder_id":"https://openalex.org/F4320337375","funder_display_name":"National Center for Research Resources"}],"funders":[{"id":"https://openalex.org/F4320313443","display_name":"National Jewish Health","ror":"https://ror.org/016z2bp30"},{"id":"https://openalex.org/F4320337375","display_name":"National Center for Research Resources","ror":"https://ror.org/04pw6fb54"},{"id":"https://openalex.org/F4320337711","display_name":"Colorado Clinical and Translational Sciences Institute","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W69578548","https://openalex.org/W123968353","https://openalex.org/W1510220247","https://openalex.org/W1512404644","https://openalex.org/W1550138383","https://openalex.org/W1652425438","https://openalex.org/W2044900550","https://openalex.org/W2087772818","https://openalex.org/W2096716534","https://openalex.org/W2097601626","https://openalex.org/W2104608657","https://openalex.org/W2118094100","https://openalex.org/W2122824930","https://openalex.org/W2126703991","https://openalex.org/W2128608433","https://openalex.org/W2133413127","https://openalex.org/W2138489156","https://openalex.org/W2152480209","https://openalex.org/W2158166765","https://openalex.org/W2169129708"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2478288626","https://openalex.org/W2350741829","https://openalex.org/W2530322880","https://openalex.org/W1596801655"],"abstract_inverted_index":{"OBJECTIVES:":[0],"Many":[1],"clinical":[2,129],"research":[3,130],"data":[4,45,115,131,140,169],"integration":[5],"platforms":[6],"rely":[7],"on":[8],"the":[9,47,53,80,88,97,111,114],"Entity-Attribute-Value":[10,41],"model":[11,56],"because":[12],"of":[13,72,82,113],"its":[14,76,118],"flexibility,":[15],"even":[16],"though":[17],"it":[18,59],"presents":[19],"problems":[20],"in":[21,32,167],"query":[22,119,135,164],"formulation":[23],"and":[24,42,57,67,79,103,120,142,147,150,163],"execution":[25],"time.":[26],"The":[27,91,124,155],"authors":[28,48,125],"sought":[29],"more":[30],"balance":[31],"these":[33,83],"traits.":[34],"MATERIALS":[35],"AND":[36],"METHODS:":[37],"Borrowing":[38],"concepts":[39],"from":[40,43],"enterprise":[44],"warehousing,":[46],"designed":[49],"an":[50],"alternative":[51],"called":[52],"Dimensional":[54],"Bus":[55],"used":[58],"to":[60,86,96,105,161],"integrate":[61],"electronic":[62],"medical":[63],"record,":[64],"sponsored":[65],"study,":[66],"biorepository":[68],"data.":[69,90],"Each":[70],"type":[71],"observational":[73,92],"collection":[74],"has":[75],"own":[77],"table,":[78],"structure":[81],"tables":[84,93],"varies":[85],"suit":[87],"source":[89],"are":[94],"linked":[95],"Bus,":[98],"which":[99],"holds":[100],"provenance":[101],"information":[102],"links":[104],"various":[106],"classificatory":[107],"dimensions":[108],"that":[109,137],"amplify":[110],"meaning":[112],"or":[116],"facilitate":[117],"exposure":[121],"management.":[122],"RESULTS:":[123],"implemented":[126],"a":[127,134,158,168],"Bus-based":[128],"repository":[132],"with":[133],"system":[136],"flexibly":[138],"manages":[139],"access":[141],"confidentiality,":[143],"facilitates":[144],"catalog":[145],"search,":[146],"readily":[148],"formulates":[149],"compiles":[151],"complex":[152],"queries.":[153],"CONCLUSION:":[154],"design":[156],"provides":[157],"workable":[159],"way":[160],"manage":[162],"mixed":[165],"schemas":[166],"warehouse.":[170]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":4}],"updated_date":"2026-06-24T13:16:06.693445","created_date":"2025-10-10T00:00:00"}