scholarly journals Accessing OMOP Common Data Model Repositories with the i2b2 Webclient – Algorithm for Automatic Query Translation

2021 ◽  
Author(s):  
Raphael W. Majeed ◽  
Patrick Fischer ◽  
Andreas Günther
Keyword(s):  
User Interface ◽  
Data Integration ◽  
Data Model ◽  
Research Data ◽  
Feasibility Analysis ◽  
Common Data Model ◽  
Wide Spread ◽  
Query Translation ◽  
Fair Principles ◽  
Intuitive User Interface

In the era of translational research, data integration and clinical data warehouses are important enabling technologies for clinical researchers. The OMOP common data model is a wide-spread choice as a target for data integration in medical informatics. It’s portability of queries and analyses across different institutions and data are ideal also from the viewpoint of the FAIR principles. Yet, the OMOP CDM lacks a simple and intuitive user interface for untrained users to run simple queries for feasibility analysis. Aim of this study is to provide an algorithm to translate any given i2b2 query to an equivalent query which can then be run on the OMOP CDM database. The provided algorithm is able to convert queries created in the i2b2 webclient to SQL statements which can be executed on a standard OMOP CDM database programmatically.

A data model-independent approach to big research data integration

2019 ◽  
Vol 13 (4) ◽  
pp. 330
Author(s):  
Valentina Bartalesi ◽  
Carlo Meghini ◽  
Costantino Thanos
Keyword(s):  
Data Integration ◽  
Data Model ◽  
Research Data ◽  
Model Independent

A Data Structure Model Supporting Railway Distributed System Integration

2011 ◽  
Author(s):  
Hanning Wang ◽  
Weixiang Xu ◽  
Chaolong Jia
Keyword(s):  
Data Integration ◽  
Distributed System ◽  
Spatial Data ◽  
Data Model ◽  
System Integration ◽  
Information Exchange ◽  
Data Models ◽  
Common Data Model ◽  
Data Set ◽  
Application Systems

Railway distributed system integration needs to realize information exchange, resources sharing and coordination process across fields, departments and application systems. And railway data integration is essential to implement this integration. In order to resolve the problem of heterogeneity of data models among data sources of different railway operation systems, this paper presents a novel integration data model of spatial structure, a XML-oriented 3-dimension common data model. The proposed model accommodates both the flexibility of level relationship and syntax expression in data integration. In this model, a spatial data pattern is used to describe and express the characteristic relationship of data items among all types of data. Based on the data model with rooted directed graph and the organization of level as well as the flexibility of the expression, the model can represent the mapping between different data models, including relationship model and object-oriented model. A consistent concept and algebraic description of the data set is given to function as the metadata in data integration, so that the algebraic manipulation of data integration is standardized to support the data integration of distributed system.

A data model-independent approach to big research data integration

2019 ◽  
Vol 13 (4) ◽  
pp. 330
Author(s):  
Valentina Bartalesi ◽  
Carlo Meghini ◽  
Costantino Thanos
Keyword(s):  
Data Integration ◽  
Data Model ◽  
Research Data ◽  
Model Independent

scholarly journals Implementing FAIR principles for dissemination of data from the French OZCAR Critical Observatory network: the Theia/OZCAR information system

2020 ◽  
Author(s):  
Isabelle Braud ◽  
Véronique Chaffard ◽  
Charly Coussot ◽  
Sylvie Galle ◽  
Rémi Cailletaud
Keyword(s):  
Information System ◽  
Data Management ◽  
Data Model ◽  
Distribution Systems ◽  
Critical Zone ◽  
Research Infrastructure ◽  
Common Data Model ◽  
In Situ Observation ◽  
Data Discovery ◽  
Fair Principles

<p>OZCAR-RI, the French Critical Zone Research Infrastructure gathers 20 observatories sampling various compartments of the Critical Zone, and having historically developed their own data management and distribution systems. However, these efforts have generally been conducted independently. This has led to a very heterogeneous situation, with different levels of development and maturity of the systems and a general lack of visibility of data from the entire OZCAR-RI community. To overcome this difficulty, a common Information System (Theia/OZCAR IS) was built to make these in situ observation FAIR (Findable, Accessible, Interoperable, Reusable). The IS will allow the data to be visible in the European eLTER-RI (European Long Term Ecosystem Research) Research Infrastructure to which OZCAR-RI contributes.</p><p>The IS architecture was designed after consultation of the users, data producers and IT teams involved in data management. A common data model including all the requested information and based on several metadata standards was defined to set up information fluxes between observatories IS and the Theia/OZCAR IS. Controlled vocabularies were defined to develop a data discovery web portal offering a faceted search with various criteria, including variables names and categories that were harmonized in a thesaurus published on the web. The communication will describe the IS architecture, the pivot data model and open source solutions used to implement the data portal that allows data discovery. The communication will also present future steps to implement data downloading and interoperability services that will allow a full implementation of these FAIR principles.</p>

scholarly journals Can We Rely on Results From IQVIA Medical Research Data UK Converted to the Observational Medical Outcome Partnership Common Data Model?

2020 ◽  
Vol 107 (4) ◽  
pp. 915-925 ◽  
Author(s):  
Gianmario Candore ◽  
Karin Hedenmalm ◽  
Jim Slattery ◽  
Alison Cave ◽  
Xavier Kurz ◽  
...  
Keyword(s):  
Medical Research ◽  
Data Model ◽  
Research Data ◽  
Common Data Model ◽  
Medical Outcome ◽  
Observational Medical Outcome Partnership
Sign in / Sign up

Export Citation Format

Share Document