Matches in SemOpenAlex for { <https://semopenalex.org/work/W2802392436> ?p ?o ?g. }
- W2802392436 abstract "Utilization of the observational healthcare datasets is key to complement and strengthen the postmarketing safety studies. Use of common data models (CDM) is the predominant approach in order to enable large scale systematic analyses on disparate data models and vocabularies. Current CDM transformation practices depend on proprietarily developed Extract - Transform - Load (ETL) procedures, which require knowledge both on the semantics and technical characteristics of the source datasets and target CDM. Our aim is to develop a modular but coordinated transformation approach in order to separate semantic and technical steps of transformation processes, which do not have a strict separation in traditional ETL approaches. Such an approach would discretize the operations to extract data from source electronic health record systems, alignment of the source and target models on the semantic level and the operations to populate target common data repositories. In order to separate the activities that are required to transform heterogeneous data sources to a target CDM, we introduce a semantic transformation approach composed of three steps: 1) transformation of source datasets to Resource Description Framework (RDF) format, 2) application of semantic conversion rules to get the data as instances of ontological model of the target CDM and 3) population of repositories, which comply with the specifications of the CDM, by processing the RDF instances from step 2. The proposed approach has been implemented on real healthcare settings where Observational Medical Outcomes Partnership (OMOP) CDM has been chosen as the common data model and a comprehensive comparative analysis between the native and transformed data has been conducted. Health records of approximately 1 million patients have been successfully transformed to an OMOP CDM based database from the source database. Descriptive statistics obtained from the source and target databases present analogous and consistent results. Our method goes beyond the traditional ETL approaches by being more declarative and rigorous. Declarative because the use of RDF based mapping rules makes each mapping more transparent and understandable to humans while retaining logic-based computability. Rigorous because the mappings would be based on computer readable semantics which are amenable to validation through logic-based inference methods." @default.
- W2802392436 created "2018-05-17" @default.
- W2802392436 creator A5002145217 @default.
- W2802392436 creator A5032773700 @default.
- W2802392436 creator A5047907795 @default.
- W2802392436 creator A5052360032 @default.
- W2802392436 creator A5059170956 @default.
- W2802392436 date "2018-04-30" @default.
- W2802392436 modified "2023-10-06" @default.
- W2802392436 title "A Semantic Transformation Methodology for the Secondary Use of Observational Healthcare Data in Postmarketing Safety Studies" @default.
- W2802392436 cites W126115071 @default.
- W2802392436 cites W149606709 @default.
- W2802392436 cites W1537617436 @default.
- W2802392436 cites W1975557539 @default.
- W2802392436 cites W1982489161 @default.
- W2802392436 cites W1989269439 @default.
- W2802392436 cites W1997927489 @default.
- W2802392436 cites W2005366883 @default.
- W2802392436 cites W2020199254 @default.
- W2802392436 cites W2020829916 @default.
- W2802392436 cites W2027710934 @default.
- W2802392436 cites W2080656905 @default.
- W2802392436 cites W2081624704 @default.
- W2802392436 cites W2094060652 @default.
- W2802392436 cites W2113330592 @default.
- W2802392436 cites W2119463649 @default.
- W2802392436 cites W2127912974 @default.
- W2802392436 cites W2138162199 @default.
- W2802392436 cites W2163649042 @default.
- W2802392436 cites W2323367901 @default.
- W2802392436 cites W2407626384 @default.
- W2802392436 cites W2418822099 @default.
- W2802392436 cites W2589119372 @default.
- W2802392436 cites W2616141209 @default.
- W2802392436 cites W34678172 @default.
- W2802392436 doi "https://doi.org/10.3389/fphar.2018.00435" @default.
- W2802392436 hasPubMedCentralId "https://www.ncbi.nlm.nih.gov/pmc/articles/5937227" @default.
- W2802392436 hasPubMedId "https://pubmed.ncbi.nlm.nih.gov/29760661" @default.
- W2802392436 hasPublicationYear "2018" @default.
- W2802392436 type Work @default.
- W2802392436 sameAs 2802392436 @default.
- W2802392436 citedByCount "15" @default.
- W2802392436 countsByYear W28023924362019 @default.
- W2802392436 countsByYear W28023924362020 @default.
- W2802392436 countsByYear W28023924362021 @default.
- W2802392436 countsByYear W28023924362022 @default.
- W2802392436 countsByYear W28023924362023 @default.
- W2802392436 crossrefType "journal-article" @default.
- W2802392436 hasAuthorship W2802392436A5002145217 @default.
- W2802392436 hasAuthorship W2802392436A5032773700 @default.
- W2802392436 hasAuthorship W2802392436A5047907795 @default.
- W2802392436 hasAuthorship W2802392436A5052360032 @default.
- W2802392436 hasAuthorship W2802392436A5059170956 @default.
- W2802392436 hasBestOaLocation W28023924361 @default.
- W2802392436 hasConcept C101468663 @default.
- W2802392436 hasConcept C104317684 @default.
- W2802392436 hasConcept C111919701 @default.
- W2802392436 hasConcept C124101348 @default.
- W2802392436 hasConcept C147497476 @default.
- W2802392436 hasConcept C184337299 @default.
- W2802392436 hasConcept C185592680 @default.
- W2802392436 hasConcept C199360897 @default.
- W2802392436 hasConcept C204241405 @default.
- W2802392436 hasConcept C206345919 @default.
- W2802392436 hasConcept C2129575 @default.
- W2802392436 hasConcept C23123220 @default.
- W2802392436 hasConcept C2522767166 @default.
- W2802392436 hasConcept C31258907 @default.
- W2802392436 hasConcept C41008148 @default.
- W2802392436 hasConcept C55493867 @default.
- W2802392436 hasConcept C69075417 @default.
- W2802392436 hasConcept C72634772 @default.
- W2802392436 hasConceptScore W2802392436C101468663 @default.
- W2802392436 hasConceptScore W2802392436C104317684 @default.
- W2802392436 hasConceptScore W2802392436C111919701 @default.
- W2802392436 hasConceptScore W2802392436C124101348 @default.
- W2802392436 hasConceptScore W2802392436C147497476 @default.
- W2802392436 hasConceptScore W2802392436C184337299 @default.
- W2802392436 hasConceptScore W2802392436C185592680 @default.
- W2802392436 hasConceptScore W2802392436C199360897 @default.
- W2802392436 hasConceptScore W2802392436C204241405 @default.
- W2802392436 hasConceptScore W2802392436C206345919 @default.
- W2802392436 hasConceptScore W2802392436C2129575 @default.
- W2802392436 hasConceptScore W2802392436C23123220 @default.
- W2802392436 hasConceptScore W2802392436C2522767166 @default.
- W2802392436 hasConceptScore W2802392436C31258907 @default.
- W2802392436 hasConceptScore W2802392436C41008148 @default.
- W2802392436 hasConceptScore W2802392436C55493867 @default.
- W2802392436 hasConceptScore W2802392436C69075417 @default.
- W2802392436 hasConceptScore W2802392436C72634772 @default.
- W2802392436 hasFunder F4320333065 @default.
- W2802392436 hasLocation W28023924361 @default.
- W2802392436 hasLocation W28023924362 @default.
- W2802392436 hasLocation W28023924363 @default.
- W2802392436 hasLocation W28023924364 @default.
- W2802392436 hasLocation W28023924365 @default.
- W2802392436 hasLocation W28023924366 @default.
- W2802392436 hasOpenAccess W2802392436 @default.
- W2802392436 hasPrimaryLocation W28023924361 @default.
- W2802392436 hasRelatedWork W148350657 @default.