{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,25]],"date-time":"2025-10-25T12:18:46Z","timestamp":1761394726464},"reference-count":55,"publisher":"Georg Thieme Verlag KG","issue":"02","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Methods Inf Med"],"published-print":{"date-parts":[[2016]]},"abstract":"<jats:title>Summary<\/jats:title><jats:p>Background: In recent years, research data warehouses moved increasingly into the focus of interest of medical research. Nevertheless, there are only a few center-independent infrastructure solutions available. They aim to provide a consolidated view on medical data from various sources such as clinical trials, electronic health records, epidemiological registries or longitudinal cohorts. The i2b2 framework is a well-established solution for such repositories, but it lacks support for importing and integrating clinical data and metadata.<\/jats:p><jats:p>Objectives: The goal of this project was to develop a platform for easy integration and administration of data from heterogeneous sources, to provide capabilities for linking them to medical terminologies and to allow for transforming and mapping of data streams for user-specific views.<\/jats:p><jats:p>Methods: A suite of three tools has been developed: the i2b2 Wizard for simplifying administration of i2b2, the IDRT Import and Mapping Tool for loading clinical data from various formats like CSV, SQL, CDISC ODM or biobanks and the IDRT i2b2 Web Client Plugin for advanced export options. The Import and Mapping Tool also includes an ontology editor for rearranging and mapping patient data and structures as well as annotating clinical data with medical terminologies, primarily those used in Germany (ICD-10-GM, OPS, ICD-O, etc.).<\/jats:p><jats:p>Results: With the three tools functional, new i2b2-based research projects can be created, populated and customized to researcher\u2019s needs in a few hours. Amalgamating data and metadata from different databases can be managed easily. With regards to data privacy a pseudonymization service can be plugged in. Using common ontologies and reference terminologies rather than project-specific ones leads to a consistent understanding of the data semantics.<\/jats:p><jats:p>Conclusions: i2b2\u2019s promise is to enable clinical researchers to devise and test new hypothesis even without a deep knowledge in statistical programing. The approach pre -sented here has been tested in a number of scenarios with millions of observations and tens of thousands of patients. Initially mostly observant, trained researchers were able to construct new analyses on their own. Early feedback indicates that timely and extensive access to their \u201cown\u201d data is appreciated most, but it is also lowering the barrier for other tasks, for instance checking data quality and completeness (missing data, wrong coding).<\/jats:p>","DOI":"10.3414\/me15-01-0082","type":"journal-article","created":{"date-parts":[[2015,11,4]],"date-time":"2015-11-04T09:09:13Z","timestamp":1446628153000},"page":"125-135","source":"Crossref","is-referenced-by-count":20,"title":["Integrated Data Repository Toolkit (IDRT)"],"prefix":"10.3414","volume":"55","author":[{"given":"B.","family":"Baum","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"J.","family":"Christoph","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"I.","family":"Engel","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"M.","family":"L\u00f6be","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"S.","family":"Mate","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"S.","family":"St\u00e4ubert","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"J.","family":"Drepper","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"H.-U.","family":"Prokosch","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"A.","family":"Winter","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"U.","family":"Sax","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"C. R. K. D.","family":"Bauer","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"T.","family":"Ganslandt","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"194","published-online":{"date-parts":[[2018,1,8]]},"reference":[{"issue":"1","key":"10.3414\/ME15-01-0082-1","doi-asserted-by":"crossref","first-page":"38","DOI":"10.3414\/ME9132","volume":"48","author":"Prokosch","year":"2009","journal-title":"Methods Inf Med"},{"key":"10.3414\/ME15-01-0082-2","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2011-000133"},{"key":"10.3414\/ME15-01-0082-3","doi-asserted-by":"publisher","DOI":"10.4258\/hir.2014.20.2.109"},{"key":"10.3414\/ME15-01-0082-4","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2011.02.003"},{"key":"10.3414\/ME15-01-0082-5","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2012.11.008"},{"key":"10.3414\/ME15-01-0082-6","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2012-001042"},{"key":"10.3414\/ME15-01-0082-7","unstructured":"Moor GD, Sundgren M, Kalra D, Schmidt A, Dugas M, Claerhout B et al. Using Electronic Health Records for Clinical Research: the Case of the EHR4CR Project. J Biomed Inform 2014"},{"key":"10.3414\/ME15-01-0082-8","unstructured":"OHDSI | Observational Health Data Sciences and Informatics [cited 2015 Mar 3]. Available from: http:\/\/www.ohdsi.org\/"},{"key":"10.3414\/ME15-01-0082-9","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2014-002747"},{"key":"10.3414\/ME15-01-0082-10","doi-asserted-by":"publisher","DOI":"10.1136\/jamia.2009.000893"},{"key":"10.3414\/ME15-01-0082-11","doi-asserted-by":"publisher","DOI":"10.1186\/1471-2288-9-70"},{"key":"10.3414\/ME15-01-0082-12","doi-asserted-by":"publisher","DOI":"10.1136\/jamia.2010.007914"},{"key":"10.3414\/ME15-01-0082-13","unstructured":"Weinlich B, Mate S, Prokosch HU, Ganslandt T, Toddenroth D. \u201cR-Scriptlets\u201d f\u00fcr i2b2-Endanwender. GMDS 2014. 59. Jahrestagung der Deutschen Gesellschaft f\u00fcr Medizinische Informatik, Biometrie und Epidemiologie e.V. (GMDS). G\u00f6ttingen, 07.-10.09.2014. D\u00fcsseldorf: German Medical Science GMS Publishing House; 2014. DocAbstr. 346 2014"},{"key":"10.3414\/ME15-01-0082-14","unstructured":"Overview: i2b2 Wiki [cited 2015 Apr 29]. Available from: https:\/\/community.i2b2.org\/wiki\/ dashboard.action (archived at: http:\/\/www. webcitation.org\/6Y97WMkIF)"},{"key":"10.3414\/ME15-01-0082-15","doi-asserted-by":"publisher","DOI":"10.1016\/j.biopsych.2013.10.028"},{"key":"10.3414\/ME15-01-0082-16","doi-asserted-by":"publisher","DOI":"10.1016\/j.jaci.2013.02.030"},{"key":"10.3414\/ME15-01-0082-17","doi-asserted-by":"publisher","DOI":"10.1197\/jamia.M2408"},{"key":"10.3414\/ME15-01-0082-18","doi-asserted-by":"publisher","DOI":"10.1197\/jamia.M3115"},{"key":"10.3414\/ME15-01-0082-19","doi-asserted-by":"publisher","DOI":"10.1136\/jamia.2010.003947"},{"key":"10.3414\/ME15-01-0082-20","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2011-000203"},{"key":"10.3414\/ME15-01-0082-21","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2011-000784"},{"key":"10.3414\/ME15-01-0082-22","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2013-001628"},{"key":"10.3414\/ME15-01-0082-23","unstructured":"What is eTRIKS... [cited 2015 Mar 3]. Available from: URL:http:\/\/www.etriks.org\/"},{"key":"10.3414\/ME15-01-0082-24","first-page":"6","volume":"2013","author":"Athey","year":"2013","journal-title":"AMIA Jt Summits Transl Sci Proc"},{"key":"10.3414\/ME15-01-0082-25","unstructured":"tranSMART Foundation - [cited 2015 Mar 3]. Available from: http:\/\/transmartfoundation.org\/"},{"key":"10.3414\/ME15-01-0082-26","doi-asserted-by":"publisher","DOI":"10.1197\/jamia.M3191"},{"key":"10.3414\/ME15-01-0082-27","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2014-002759"},{"key":"10.3414\/ME15-01-0082-28","doi-asserted-by":"publisher","DOI":"10.4338\/ACI-2010-09-CR-0051"},{"key":"10.3414\/ME15-01-0082-29","doi-asserted-by":"publisher","DOI":"10.1186\/1471-2288-9-70"},{"key":"10.3414\/ME15-01-0082-30","unstructured":"TMF. Home [cited 2015 Mar 3]. Available from: http:\/\/www.tmf-ev.de\/EnglishSite\/Home.aspx"},{"key":"10.3414\/ME15-01-0082-31","unstructured":"CiteULike: Group: IDRT1WP1 - library 24 articles [cited 2015 Apr 27 (archived at: http:\/\/www. webcitation.org\/6Y69NRmPf)]. Available from: http:\/\/www.citeulike.org\/group\/19482"},{"key":"10.3414\/ME15-01-0082-32","unstructured":"L\u00f6be M, St\u00e4ubert S, Winter A. Integrated Data Repository Toolkit (IDRT) - Deliverable D1.1: Aktualisierung und Formalisierung der bestehenden Anforderungsanalyse.; 2012. Available from: http:\/\/ias4.imise.uni-leipzig.de\/idrt_edit\/IDRT-I\/Deliverables\/IDR1-D1.1-Anforderung analyse.pdf. Accessed: 2015-03-02. (Archived by WebCite\u00ae at http:\/\/www.webcitation.org\/6Wj1aVaBE)"},{"key":"10.3414\/ME15-01-0082-33","first-page":"409","volume":"150","author":"Stausberg","year":"2009","journal-title":"Stud Health Technol Inform"},{"key":"10.3414\/ME15-01-0082-34","doi-asserted-by":"publisher","DOI":"10.1016\/j.cmpb.2005.03.004"},{"key":"10.3414\/ME15-01-0082-35","unstructured":"TMF. V015-01 PID-Generator [cited 2015 Aug 24 (archived at: http:\/\/www.webcitation.org\/6b1Unil2R)]. Available from: http:\/\/www.tmf-ev.de\/Themen\/Projekte\/V015_01_PID_Generator. aspx"},{"key":"10.3414\/ME15-01-0082-36","unstructured":"InEK GmbH. Datensatzbeschreibung, InEK GmbH [cited 2015 Aug 25 (archived at: http:\/\/www.webcitation.org\/6b308BG2Z)]. Available from: http:\/\/www.g-drg.de\/cms\/inek_site_de\/Datenlieferung_gem._21_KHEntgG\/Dokumente_ zur_Datenlieferung\/Datensatzbeschreibung"},{"key":"10.3414\/ME15-01-0082-37","unstructured":"L\u00f6be M. Metadata Repository; 2014 [cited 2015 Mar 3]. Available from: https:\/\/mdr.imise.uni-leipzig.de\/"},{"key":"10.3414\/ME15-01-0082-38","first-page":"801","volume":"124","author":"van","year":"2006","journal-title":"Stud Health Technol Inform"},{"key":"10.3414\/ME15-01-0082-39","doi-asserted-by":"publisher","DOI":"10.1016\/S0169-2607(97)01815-4"},{"key":"10.3414\/ME15-01-0082-40","unstructured":"gnu.org [cited 2015 Mar 5]. Available from: URL:http:\/\/www.gnu.org\/licenses\/"},{"key":"10.3414\/ME15-01-0082-41","unstructured":"IDRT - Integrated Data Repository Toolkit - Related Project - IDRT - Integrated Data Repository Toolkit - i2b2 Wiki [cited 2015 Aug 25]. Available from: https:\/\/community.i2b2.org\/wiki\/display\/IDRT\/"},{"key":"10.3414\/ME15-01-0082-42","unstructured":"Optimizing Query Performance with the Ontology Total_Num field - i2b2 Developer\u2019s Forum - i2b2 Wiki [cited 2015 Aug 25 (archived at: http:\/\/www.webcitation.org\/6b2z98sBj)]. Available from: https:\/\/community.i2b2.org\/wiki\/display\/DevForum\/Optimizing+Query+Performance+ with+the+Ontology+Total_Num+field (V.04)"},{"key":"10.3414\/ME15-01-0082-43","unstructured":"Best Practices for Performance Optimiza- tion - Related Project - IDRT - Integrated Data Repository Toolkit - i2b2 Wiki [cited 2015 Aug 25 (archived at: http:\/\/www.webcitation.org\/6b30LuFSP)]. Available from: https:\/\/ community.i2b2.org\/wiki\/display\/IDRT\/710.+ Best+Practices+for+Performance+Optimization"},{"key":"10.3414\/ME15-01-0082-44","unstructured":"Kompetenznetz AHF: Information material [cited 2015 Apr 28 (archived at: http:\/\/www.webcitation.org\/6Y97WMkIF)]. Available from: http:\/\/www.kompetenznetz-ahf.de\/en\/competence-network\/information-material\/"},{"key":"10.3414\/ME15-01-0082-45","unstructured":"CSCC; 2015 [cited 2015 May 12]. Available from: http:\/\/www.cscc.uniklinikum-jena.de\/CSCC.html"},{"key":"10.3414\/ME15-01-0082-46","unstructured":"Reich-Erkelenz D. Clinical Research Group 241 [cited 2015 Apr 28]. Available from: http:\/\/www.kfo241.de\/index_en.php"},{"key":"10.3414\/ME15-01-0082-47","doi-asserted-by":"publisher","DOI":"10.3414\/ME13-01-0133"},{"key":"10.3414\/ME15-01-0082-48","unstructured":"Deutsche Hochschulmedizin e.V. Landkarte [German only]; 2014 [cited 2015 Apr 29 (archived at: http:\/\/www.webcitation.org\/6Y98p7WTO)]. Available from: http:\/\/www.landkarte-hochschulmedizin.de\/#auswertung"},{"key":"10.3414\/ME15-01-0082-49","first-page":"887","volume":"169","author":"Segagni","year":"2011","journal-title":"Stud Health Technol Inform"},{"key":"10.3414\/ME15-01-0082-50","unstructured":"Shawn Murphy. i2b2 Roadmap. G\u00f6ttingen; 2014. (2nd European i2b2 Academic User Group Meeting\/GMDS\/IMIA Workshop \u201cResearch Databases\u201d) [cited 2015 Aug 25 (archived at: http:\/\/ www.webcitation.org\/6b4XMA7T1)]. Available from: http:\/\/www.pg-ss.imi.uni-erlangen.de\/SiteCollectionDocuments\/S1T1%20Murphy.pdf"},{"key":"10.3414\/ME15-01-0082-51","unstructured":"Cameron D. Transforming \u201cBig Data\u201d into Knowledge|HMS [cited 2015 Aug 27 (archived at: http:\/\/www.webcitation.org\/6b5n1tJp4)]. Available from: https:\/\/hms.harvard.edu\/news\/ transforming-big-data-knowledge"},{"key":"10.3414\/ME15-01-0082-52","doi-asserted-by":"crossref","unstructured":"Paten B, Diekhans M, Druker BJ, Friend S, Guinney J, Gassner N et al. The NIH BD2K center for big data in translational genomics. J Am Med Inform Assoc 2015","DOI":"10.1093\/jamia\/ocv047"},{"key":"10.3414\/ME15-01-0082-53","doi-asserted-by":"publisher","DOI":"10.1093\/bib\/bbu006"},{"key":"10.3414\/ME15-01-0082-54","first-page":"648","volume":"2013","author":"Huser","year":"2013","journal-title":"AMIA Annu Symp Proc"},{"key":"10.3414\/ME15-01-0082-55","unstructured":"GITHub - TMF - Technologie- und Methodenplattform f\u00fcr die vernetzte medizinische Forschung e.V. [cited 2015 May 6]. Available from: https:\/\/github.com\/tmfev"}],"container-title":["Methods of Information in Medicine"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/www.thieme-connect.de\/products\/ejournals\/pdf\/10.3414\/ME15-01-0082.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,9,1]],"date-time":"2019-09-01T07:23:21Z","timestamp":1567322601000},"score":1,"resource":{"primary":{"URL":"http:\/\/www.thieme-connect.de\/DOI\/DOI?10.3414\/ME15-01-0082"}},"subtitle":["A Suite of Programs to Facilitate Health Analytics on Heterogeneous Medical Data"],"short-title":[],"issued":{"date-parts":[[2016]]},"references-count":55,"journal-issue":{"issue":"02","published-online":{"date-parts":[[2018,1,8]]},"published-print":{"date-parts":[[2016]]}},"URL":"https:\/\/doi.org\/10.3414\/me15-01-0082","relation":{},"ISSN":["0026-1270","2511-705X"],"issn-type":[{"value":"0026-1270","type":"print"},{"value":"2511-705X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2016]]}}}