Pragmatic MDR: a metadata repository with bottom-up standardization of medical metadata through reuse.

BACKGROUND: The variety of medical documentation often leads to incompatible data elements that impede data integration between institutions. A common approach to standardize and distribute metadata definitions are ISO/IEC 11179 norm-compliant metadata repositories with top-down standardization. To the best of our knowledge, however, it is not yet common practice to reuse the content of publicly accessible metadata repositories for creation of case report forms or routine documentation. We suggest an alternative concept called pragmatic metadata repository, which enables a community-driven bottom-up approach for agreeing on data collection models. A pragmatic metadata repository collects real-world documentation and considers frequent metadata definitions as high quality with potential for reuse. METHODS: We implemented a pragmatic metadata repository proof of concept application and filled it with medical forms from the Portal of Medical Data Models. We applied this prototype in two use cases to demonstrate its capabilities for reusing metadata: first, integration into a study editor for the suggestion of data elements and, second, metadata synchronization between two institutions. Moreover, we evaluated the emergence of bottom-up standards in the prototype and two medical data managers assessed their quality for 24 medical concepts. RESULTS: The resulting prototype contained 466,569 unique metadata definitions. Integration into the study editor led to a reuse of 1836 items and item groups. During the metadata synchronization, semantic codes of 4608 data elements were transferred. Our evaluation revealed that for less complex medical concepts weak bottom-up standards could be established. However, more diverse disease-related concepts showed no convergence of data elements due to an enormous heterogeneity of metadata. The survey showed fair agreement (Kalpha = 0.50, 95% CI 0.43-0.56) for good item quality of bottom-up standards. CONCLUSIONS: We demonstrated the feasibility of the pragmatic metadata repository concept for medical documentation. Applications of the prototype in two use cases suggest that it facilitates the reuse of data elements. Our evaluation showed that bottom-up standardization based on a large collection of real-world metadata can yield useful results. The proposed concept shall not replace existing top-down approaches, rather it complements them by showing what is commonly used in the community to guide other researchers.

Conducting an Epidemiologic Study and Making It FAIR: Reusable Tools and Procedures from a Population-Based Cohort Study.

Conducting large-scale epidemiologic studies requires powerful software for electronic data capture, data management, data quality assessments, and participant management. There is also an increasing need to make studies and the data collected findable, accessible, interoperable, and reusable (FAIR). However, reusable software tools from major studies, underlying such needs, are not necessarily known to other researchers. Therefore, this work gives an overview on the main tools used to conduct the internationally highly networked population-based project Study of Health in Pomerania (SHIP), as well as approaches taken to improve its FAIRness. Deep phenotyping, formalizing processes from data capture to data transfer, with a strong emphasis on cooperation and data exchange have laid the foundation for a broad scientific impact with more than 1500 published papers to date.

Implementing SNOMED CT in Open Software Solutions to Enhance the Findability of COVID-19 Questionnaires.

SNOMED CT fosters interoperability in healthcare and research. This use case implemented SNOMED CT for browsing COVID-19 questionnaires in the open-software solutions OPAL/MICA. We implemented a test server requiring files in a given YAML format for implementation of taxonomies with only two levels of hierarchy. Within this format, neither the implementation of SNOMED CT hierarchies and post-coordination nor the use of release files were possible. To solve this, Python scripts were written to integrate the required SNOMED CT concepts (Fully Specified Name, FSN and SNOMED CT Identifier, SCTID) into the YAML format (YAML Mode). Mappings of SNOMED CT to data items of the questionnaires had to be provided as Excel files for implementation into Opal/MICA and further Python scripts were established within the Excel Mode. Finally, a total of eight questionnaires containing 1.178 data items were successfully mapped to SNOMED CT and implemented in OPAL/MICA. This use case showed that implementing SNOMED CT for browsing COVID-19 questionnaires is feasible despite software solutions not supporting SNOMED CT. However, limitations of not being able to implement SNOMED CT release files and its provided hierarchy and post-coordination still have to be overcome.

Improving the FAIRness of Health Studies in Germany: The German Central Health Study Hub COVID-19.

The German Central Health Study Hub COVID-19 is an online service that offers bundled access to COVID-19 related studies conducted in Germany. It combines metadata and other information of epidemiologic, public health and clinical studies into a single data repository for FAIR data access. In addition to study characteristics the system also allows easy access to study documents, as well as instruments for data collection. Study metadata and survey instruments are decomposed into individual data items and semantically enriched to ease the findability. Data from existing clinical trial registries (DRKS, clinicaltrails.gov and WHO ICTRP) are merged with epidemiological and public health studies manually collected and entered. More than 850 studies are listed as of September 2021.

Automatic Conversion of Metadata from the Study of Health in Pomerania to ODM.

BACKGROUND: Electronic collection and high quality analysis of medical data is expected to have a big potential to improve patient care and medical research. However, the integration of data from different stake holders is posing a crucial problem. The exchange and reuse of medical data models as well as annotations with unique semantic identifiers were proposed as a solution. OBJECTIVES: Convert metadata from the Study of Health in Pomerania to the standardized CDISC ODM format. METHODS: The structure of the two data formats is analyzed and a mapping is suggested and implemented. RESULTS: The metadata from the Study of Health in Pomerania was successfully converted to ODM. All relevant information was included in the resulting forms. Three sample forms were evaluated in-depth, which demonstrates the feasibility of this conversion. CONCLUSION: Hundreds of data entry forms with more than 15.000 items can be converted into a standardized format with some limitations, e.g. regarding logical constraints. This enables the integration of the Study of Health in Pomerania metadata into various systems, facilitating the implementation and reuse in different study sites.

Square2 - A Web Application for Data Monitoring in Epidemiological and Clinical Studies

Valid scientific inferences from epidemiological and clinical studies require high data quality. Data generating departments therefore aim to detect data irregularities as early as possible in order to guide quality management processes. In addition, after the completion of data collections the obtained data quality must be evaluated. This can be challenging in complex studies due to a wide scope of examinations, numerous study variables, multiple examiners, devices, and examination centers. This paper describes a Java EE web application used to monitor and evaluate data quality in institutions with complex and multiple studies, named Square2. It uses the Java libraries Apache MyFaces 2, extended by BootsFaces for layout and style. RServe and REngine manage calls to R server processes. All study data and metadata are stored in PostgreSQL. R is the statistics backend and LaTeX is used for the generation of print ready PDF reports. A GUI manages the entire workflow. Square2 covers all steps in the data monitoring workflow, including the setup of studies and their structure, the handling of metadata for data monitoring purposes, selection of variables, upload of data, statistical analyses, and the generation as well as inspection of quality reports. To take into account data protection issues, Square2 comprises an extensive user rights and roles concept.