title: The Stanford Data Miner: a novel approach for integrating and exploring heterogeneous immunological data.
abstract: BACKGROUND
  Systems-level approaches are increasingly common in both murine and human translational studies. These approaches employ multiple high information content assays. As a result, there is a need for tools to integrate heterogeneous types of laboratory and clinical/demographic data, and to allow the exploration of that data by aggregating and/or segregating results based on particular variables (e.g., mean cytokine levels by age and gender).
  
  
  METHODS
  Here we describe the application of standard data warehousing tools to create a novel environment for user-driven upload, integration, and exploration of heterogeneous data. The system presented here currently supports flow cytometry and immunoassays performed in the Stanford Human Immune Monitoring Center, but could be applied more generally.
  
  
  RESULTS
  Users upload assay results contained in platform-specific spreadsheets of a defined format, and clinical and demographic data in spreadsheets of flexible format. Users then map sample IDs to connect the assay results with the metadata. An OLAP (on-line analytical processing) data exploration interface allows filtering and display of various dimensions (e.g., Luminex analytes in rows, treatment group in columns, filtered on a particular study). Statistics such as mean, median, and N can be displayed. The views can be expanded or contracted to aggregate or segregate data at various levels. Individual-level data is accessible with a single click. The result is a user-driven system that permits data integration and exploration in a variety of settings. We show how the system can be used to find gender-specific differences in serum cytokine levels, and compare them across experiments and assay types.
  
  
  CONCLUSIONS
  We have used the tools and techniques of data warehousing, including open-source business intelligence software, to support investigator-driven data integration and mining of diverse immunological data.
authors.affiliation: CytoAnalytics, Denver, CO, USA. jsiebert@cytoanalytics.com
authors.forename: Janet C
authors.initials: JC
authors.lastname: Siebert
authors.forename: Wes
authors.initials: W
authors.lastname: Munsil
authors.forename: Yael
authors.initials: Y
authors.lastname: Rosenberg-Hasson
authors.forename: Mark M
authors.initials: MM
authors.lastname: Davis
authors.forename: Holden T
authors.initials: HT
authors.lastname: Maecker
mesh_terms: D000465:Algorithms; D000486:Allergy and Immunology / Q000458:organization & administration; D000818:Animals; D019295:Computational Biology; D003627:Data Interpretation, Statistical; D057225:Data Mining / Q000379:methods*; D003628:Database Management Systems; D016208:Databases, Factual; D006801:Humans; D016247:Information Storage and Retrieval / Q000379:methods; D051379:Mice; D012106:Research; D012984:Software; D018511:Systems Integration; D014584:User-Computer Interface; D054928:Validation Studies as Topic