Trial Data / Platform Tour

Help Index > Trial Data / Platform Tour

Live Demo

1 Background

Patient-based data from clinical trials cannot generally be made public for data protection reasons. Since there is no concept and few standards for data sharing, a lot of data remains hidden forever.

2 Solution

Data in LHA is systematically prepared together with the data generating groups and then uploaded and presented in various formats and for online exploring. The metadata enriched CDISC ODM format is used consistently, SPSS and Excel formats are generated. The LHA is bound by data protection laws and patient approvals. Therefore, only basic results of the studies are offered to registered and authorized users online, which is decided by the study management. Metadata is public.

3 Guided Tour

Task: Retreave and view data from Trials of the German Lymphoma Alliance (GLA)

Which projects are related to non-Hodgkin lymphoma?

Which trials are available from the GLA?

Download studie data and metadata of the presented studie

  • navigate through the tree by double clicking the data files
  • No login/password is required to access metadata
  • You need a login/password to access patient related data from this studie (see How to Contribute)

Explore Data

  • You need a login/password to explore contents from this project
  • Click on the i2b2 button of one of the data files
  • Your are now redirected to the LHA instance of the i2b2 Query and Analysis Tool from the i2b2/tranSMART Foundation (see
  • Enter login/password. If you are registered for more then one group select “DSHNHL”. You have access to all published trial-data of this group:

  • In i2b2, look into upper left “Navigate Terms” click on “DSHNHL”. This opens all available trial data sets.
  • The number to the right (e.g. 124) indicates how many patients own this “concept”
  • Open “Demography/Sex; drag the concept “female” to “Group 1” on the right
  • Open “EFS-Status”; drag “event” to “Group 2” on the right
  • Click “Run Query”; check “Age patient breakdown” (scroll a little)
  • Click “Ok”; your just performed an sql join statement…
  • See result in in “Graph Results”: 24 patients are found. For age distribution scroll “Graph Results” down a little

I2b2 queries can be much more complex. A complete introduction to the i2b2 system goes beyond the scope of this tour. Besides the included “Help”-Button on the upper right, there a many public i2b2-manuals available; e.g from Boston University:

Powered by
Seek new full
Copyright © 2008 - 2019 The University of Manchester and HITS gGmbH
Institute for Medical Informatics, Statistics and Epidemiology, University of Leipzig