title: A Dimensional Bus model for integrating clinical and research data.
abstract: OBJECTIVE
  Many clinical research data integration platforms rely on the Entity-Attribute-Value model because of its flexibility, even though it presents problems in query formulation and execution time. The authors sought more balance in these traits.
  
  
  METHODS
  Borrowing concepts from Entity-Attribute-Value and from enterprise data warehousing, the authors designed an alternative called the Dimensional Bus model and used it to integrate electronic medical record, sponsored study, and biorepository data. Each type of observational collection has its own table, and the structure of these tables varies to suit the source data. The observational tables are linked to the Bus, which holds provenance information and links to various classificatory dimensions that amplify the meaning of the data or facilitate its query and exposure management.
  
  
  RESULTS
  The authors implemented a Bus-based clinical research data repository with a query system that flexibly manages data access and confidentiality, facilitates catalog search, and readily formulates and compiles complex queries.
  
  
  CONCLUSIONS
  The design provides a workable way to manage and query mixed schemas in a data warehouse.
authors.affiliation: Division of Biostatistics and Bioinformatics, National Jewish Health, Denver, Colorado 80206-2761, USA. wadet@njhealth.org
authors.forename: Ted D
authors.initials: TD
authors.lastname: Wade
authors.forename: Richard C
authors.initials: RC
authors.lastname: Hum
authors.forename: James R
authors.initials: JR
authors.lastname: Murphy
mesh_terms: D035843:Biomedical Research / Q000458:organization & administration*; D003628:Database Management Systems; D019992:Databases as Topic / Q000458:organization & administration*; D057286:Electronic Health Records / Q000458:organization & administration*; D006801:Humans; D016247:Information Storage and Retrieval; D012985:Software Design; D018511:Systems Integration