A kind of bidirectional mapping strategy of heterogeneous data model based on metadata-driven

Huang, Gang; Li, Jinrong; Wu, Xue-Bing

doi:10.1109/iccsnt.2012.6526100

Cited by 3 publications

(3 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The majority of publications describe the use of MDD approaches to develop an ETL/ELT process. This purpose can be divided into three detailed categories: (1) to automate the development of the ETL/ELT process [35,38,42,46,[48][49][50][51]60], (2) to develop a generic ETL/ELT process [39,47,52], and (3) to develop a new ETL/ELT process without any further technical specifications [40,45,46,55,57,61]. Additionally, the transformation part of the ETL/ELT process could also be automated by applying an MDD approach [34,37,41,44,58,63].…”

Section: Purposes Of Using Mdd Methods For Data Harmonizationmentioning

confidence: 99%

“…In order to gain an overview of the potential application focuses of MDDs (Q1) and thus an indication of where the approaches have proven beneficial, the focused theme of application was first evaluated. According to the extracted data, the focuses of all included publications are classified into 7 different categories, namely medicine (n=9) [10,[32][33][34][35][36][37][38][39], data warehouse (n=13) [40][41][42][43][44][45][46][47][48][49][50][51][52], big data (n=4) [53][54][55][56], industry (n=4) [57][58][59][60], geoinformatics (n=1) [61], archaeology (n=1) [62], and military (n=1) [63]. This shows that data warehouse and medicine are the 2 categories that use the MDD approach the most.…”

Section: Distribution Of Publicationsmentioning

confidence: 99%

“…Another frequently used type of MDD approach was rule-based, which applied transformation rules generated based on the source and target to the ETL/ELT process. The rule-based approach was also widely used in the categories of data warehouse [40][41][42][43]49] and medicine [33,34,37,39]. All other MDD approaches besides the ontology-based and rule-based approaches were categorized as "other" (Table 1).…”

Section: Mdd Approaches Used For Various Thematic Categoriesmentioning

confidence: 99%

See 2 more Smart Citations

Use of Metadata-Driven Approaches for Data Harmonization in the Medical Domain: Scoping Review

Peng,

Bathelt,

Gebler

et al. 2024

JMIR Med Inform

View full text Add to dashboard Cite

Background Multisite clinical studies are increasingly using real-world data to gain real-world evidence. However, due to the heterogeneity of source data, it is difficult to analyze such data in a unified way across clinics. Therefore, the implementation of Extract-Transform-Load (ETL) or Extract-Load-Transform (ELT) processes for harmonizing local health data is necessary, in order to guarantee the data quality for research. However, the development of such processes is time-consuming and unsustainable. A promising way to ease this is the generalization of ETL/ELT processes. Objective In this work, we investigate existing possibilities for the development of generic ETL/ELT processes. Particularly, we focus on approaches with low development complexity by using descriptive metadata and structural metadata. Methods We conducted a literature review following the PRISMA (Preferred Reporting Items for Systematic Reviews and Meta-Analyses) guidelines. We used 4 publication databases (ie, PubMed, IEEE Explore, Web of Science, and Biomed Center) to search for relevant publications from 2012 to 2022. The PRISMA flow was then visualized using an R-based tool (Evidence Synthesis Hackathon). All relevant contents of the publications were extracted into a spreadsheet for further analysis and visualization. Results Regarding the PRISMA guidelines, we included 33 publications in this literature review. All included publications were categorized into 7 different focus groups (ie, medicine, data warehouse, big data, industry, geoinformatics, archaeology, and military). Based on the extracted data, ontology-based and rule-based approaches were the 2 most used approaches in different thematic categories. Different approaches and tools were chosen to achieve different purposes within the use cases. Conclusions Our literature review shows that using metadata-driven (MDD) approaches to develop an ETL/ELT process can serve different purposes in different thematic categories. The results show that it is promising to implement an ETL/ELT process by applying MDD approach to automate the data transformation from Fast Healthcare Interoperability Resources to Observational Medical Outcomes Partnership Common Data Model. However, the determining of an appropriate MDD approach and tool to implement such an ETL/ELT process remains a challenge. This is due to the lack of comprehensive insight into the characterizations of the MDD approaches presented in this study. Therefore, our next step is to evaluate the MDD approaches presented in this study and to determine the most appropriate MDD approaches and the way to integrate them into the ETL/ELT process. This could verify the ability of using MDD approaches to generalize the ETL process for harmonizing medical data.

show abstract

Section: Purposes Of Using Mdd Methods For Data Harmonizationmentioning

confidence: 99%

Section: Distribution Of Publicationsmentioning

confidence: 99%

Section: Mdd Approaches Used For Various Thematic Categoriesmentioning

confidence: 99%

See 1 more Smart Citation

Use of Metadata-Driven Approaches for Data Harmonization in the Medical Domain: Scoping Review

Peng,

Bathelt,

Gebler

et al. 2024

JMIR Med Inform

View full text Add to dashboard Cite

show abstract

Towards Enterprise Data Management: Data Model Mapping

Petrasch

Kongkachandra

2018

2018 IEEE International WIE Conference on Electrical and Computer Engineering (WIECON-ECE)

View full text Add to dashboard Cite

Use of Metadata-Driven Approaches for Data Harmonization in the Medical Domain: Scoping Review (Preprint)

Peng,

Bathelt,

Gebler

et al. 2023

Preprint

View full text Add to dashboard Cite

BACKGROUND Multi-site clinical studies are increasingly utilizing Real-world data (RWD) to gain Real-world evidence (RWE). However, due to the heterogeneity of source data, it is difficult to analyze such data in a unified way across clinics. Therefore, the implementation of Extraction-Transform-Load (ETL) or Extraction-Load-Transform (ELT) processes for harmonizing local health data is necessary, in order to guarantee the data quality for research. Therefore, the development of such processes is time-consuming and unsustainable. A promising way to ease this is the generalization of ETL/ELT processes. OBJECTIVE In this work, we investigate existing possibilities for the development of generic ETL/ELT processes. Particularly, we focus on approaches with low development complexity by using descriptive metadata and structural metadata. METHODS We conducted a literature review following the Preferred Reporting Items for Systematic Reviews and Meta-Analyses (PRISMA) guidelines. We used four publication databases (i.e. PubMed, IEEE Explore, Web of Science and Biomed Center) to search for relevant publications from 2012 to 2022. The PRISMA flow was then visualized using an R-based online tool. All relevant contents of the publications were extracted into a spreadsheet for further analysis and visualization. RESULTS Regarding the PRISMA guidelines, we included 33 publications in this literature review. All included publications were categorized into seven different focus groups (i.e. Medicine, Data warehouse, Big Data, Industry, Geoinformatics, Archaeology and Military). Based on the extracted data, ontology-based and rule-based approaches were the two most used approaches in different focus groups. The ontology-based approach was mostly implemented using Protégé, while the rule-based approach was mostly implemented manually. CONCLUSIONS Our literature review shows that using metadata-driven approaches to develop an ETL/ELT process can serve different purposes in different focus groups. In some cases, using multiple metadata-driven approaches in combination can provide more opportunities for the development of ETL/ELT processes. Therefore, it is necessary to verify the ability of improving ETL/ELT processes for harmonizing medical data by using multiple metadata-driven approaches in combination in the future.

show abstract

A kind of bidirectional mapping strategy of heterogeneous data model based on metadata-driven

Cited by 3 publications

References 3 publications

Use of Metadata-Driven Approaches for Data Harmonization in the Medical Domain: Scoping Review

Use of Metadata-Driven Approaches for Data Harmonization in the Medical Domain: Scoping Review

Towards Enterprise Data Management: Data Model Mapping

Use of Metadata-Driven Approaches for Data Harmonization in the Medical Domain: Scoping Review (Preprint)

Contact Info

Product

Resources

About