{"id":"https://openalex.org/W2755562077","doi":"https://doi.org/10.1186/s12911-017-0532-3","title":"Dynamic-ETL: a hybrid approach for health data extraction, transformation and loading","display_name":"Dynamic-ETL: a hybrid approach for health data extraction, transformation and loading","publication_year":2017,"publication_date":"2017-09-13","ids":{"openalex":"https://openalex.org/W2755562077","doi":"https://doi.org/10.1186/s12911-017-0532-3","mag":"2755562077","pmid":"https://pubmed.ncbi.nlm.nih.gov/28903729"},"language":"en","primary_location":{"id":"doi:10.1186/s12911-017-0532-3","is_oa":true,"landing_page_url":"https://doi.org/10.1186/s12911-017-0532-3","pdf_url":"https://bmcmedinformdecismak.biomedcentral.com/track/pdf/10.1186/s12911-017-0532-3","source":{"id":"https://openalex.org/S107516304","display_name":"BMC Medical Informatics and Decision Making","issn_l":"1472-6947","issn":["1472-6947"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320256","host_organization_name":"BioMed Central","host_organization_lineage":["https://openalex.org/P4310320256","https://openalex.org/P4310319965"],"host_organization_lineage_names":["BioMed Central","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BMC Medical Informatics and Decision Making","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj","pubmed"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://bmcmedinformdecismak.biomedcentral.com/track/pdf/10.1186/s12911-017-0532-3","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5005960274","display_name":"Toan C. Ong","orcid":"https://orcid.org/0000-0001-6787-1407"},"institutions":[{"id":"https://openalex.org/I51713134","display_name":"University of Colorado Anschutz Medical Campus","ror":"https://ror.org/03wmf1y16","country_code":"US","type":"education","lineage":["https://openalex.org/I51713134"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Toan C. Ong","raw_affiliation_strings":["Departments of Pediatrics, University of Colorado Anschutz Medical Campus, School of Medicine, Building AO1 Room L15-1414, 12631 East 17th Avenue, Mail Stop F563, Aurora, CO, 80045, USA. Toan.Ong@ucdenver.edu","Departments of Pediatrics, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departments of Pediatrics, University of Colorado Anschutz Medical Campus, School of Medicine, Building AO1 Room L15-1414, 12631 East 17th Avenue, Mail Stop F563, Aurora, CO, 80045, USA. Toan.Ong@ucdenver.edu","institution_ids":["https://openalex.org/I51713134"]},{"raw_affiliation_string":"Departments of Pediatrics, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA","institution_ids":["https://openalex.org/I51713134"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060507817","display_name":"Michael G. Kahn","orcid":"https://orcid.org/0000-0003-4786-6875"},"institutions":[{"id":"https://openalex.org/I51713134","display_name":"University of Colorado Anschutz Medical Campus","ror":"https://ror.org/03wmf1y16","country_code":"US","type":"education","lineage":["https://openalex.org/I51713134"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael G. Kahn","raw_affiliation_strings":["Colorado Clinical and Translational Sciences Institute, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","Departments of Pediatrics, University of Colorado Anschutz Medical Campus, School of Medicine, Building AO1 Room L15-1414, 12631 East 17th Avenue, Mail Stop F563, Aurora, CO, 80045, USA","Departments of Pediatrics, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA","Colorado Clinical and Translational Sciences Institute, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Colorado Clinical and Translational Sciences Institute, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","institution_ids":["https://openalex.org/I51713134"]},{"raw_affiliation_string":"Departments of Pediatrics, University of Colorado Anschutz Medical Campus, School of Medicine, Building AO1 Room L15-1414, 12631 East 17th Avenue, Mail Stop F563, Aurora, CO, 80045, USA","institution_ids":["https://openalex.org/I51713134"]},{"raw_affiliation_string":"Departments of Pediatrics, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA","institution_ids":["https://openalex.org/I51713134"]},{"raw_affiliation_string":"Colorado Clinical and Translational Sciences Institute, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA","institution_ids":["https://openalex.org/I51713134"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016351256","display_name":"Bethany M. Kwan","orcid":"https://orcid.org/0000-0002-4013-5618"},"institutions":[{"id":"https://openalex.org/I51713134","display_name":"University of Colorado Anschutz Medical Campus","ror":"https://ror.org/03wmf1y16","country_code":"US","type":"education","lineage":["https://openalex.org/I51713134"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bethany M. Kwan","raw_affiliation_strings":["Departments of Family Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","Departments of Family Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departments of Family Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","institution_ids":["https://openalex.org/I51713134"]},{"raw_affiliation_string":"Departments of Family Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA","institution_ids":["https://openalex.org/I51713134"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081601527","display_name":"Traci E. Yamashita","orcid":null},"institutions":[{"id":"https://openalex.org/I51713134","display_name":"University of Colorado Anschutz Medical Campus","ror":"https://ror.org/03wmf1y16","country_code":"US","type":"education","lineage":["https://openalex.org/I51713134"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Traci Yamashita","raw_affiliation_strings":["Departments of Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","Departments of Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departments of Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","institution_ids":["https://openalex.org/I51713134"]},{"raw_affiliation_string":"Departments of Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA","institution_ids":["https://openalex.org/I51713134"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5076439941","display_name":"Elias Brandt","orcid":"https://orcid.org/0000-0001-8798-7706"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Elias Brandt","raw_affiliation_strings":["DARTNet Institute, Aurora, CO, USA","DARTNet Institute, Aurora, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"DARTNet Institute, Aurora, CO, USA","institution_ids":[]},{"raw_affiliation_string":"DARTNet Institute, Aurora, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079674551","display_name":"Patrick Hosokawa","orcid":"https://orcid.org/0000-0002-4864-8530"},"institutions":[{"id":"https://openalex.org/I51713134","display_name":"University of Colorado Anschutz Medical Campus","ror":"https://ror.org/03wmf1y16","country_code":"US","type":"education","lineage":["https://openalex.org/I51713134"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Patrick Hosokawa","raw_affiliation_strings":["Departments of Family Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","Departments of Family Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departments of Family Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","institution_ids":["https://openalex.org/I51713134"]},{"raw_affiliation_string":"Departments of Family Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA","institution_ids":["https://openalex.org/I51713134"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032368939","display_name":"Chris Uhrich","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chris Uhrich","raw_affiliation_strings":["OSR Data Corporation, Lincoln, MA, USA","OSR Data Corporation, Lincoln, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"OSR Data Corporation, Lincoln, MA, USA","institution_ids":[]},{"raw_affiliation_string":"OSR Data Corporation, Lincoln, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5033615276","display_name":"Lisa M. Schilling","orcid":"https://orcid.org/0000-0002-6878-189X"},"institutions":[{"id":"https://openalex.org/I51713134","display_name":"University of Colorado Anschutz Medical Campus","ror":"https://ror.org/03wmf1y16","country_code":"US","type":"education","lineage":["https://openalex.org/I51713134"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lisa M. Schilling","raw_affiliation_strings":["Departments of Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","Departments of Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Departments of Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, CO, USA","institution_ids":["https://openalex.org/I51713134"]},{"raw_affiliation_string":"Departments of Medicine, University of Colorado Anschutz Medical Campus, School of Medicine, Aurora, USA","institution_ids":["https://openalex.org/I51713134"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5005960274"],"corresponding_institution_ids":["https://openalex.org/I51713134"],"apc_list":{"value":2690,"currency":"USD","value_usd":2690},"apc_paid":{"value":2690,"currency":"USD","value_usd":2690},"fwci":1.8243,"has_fulltext":true,"cited_by_count":67,"citation_normalized_percentile":{"value":0.85759366,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"17","issue":"1","first_page":"134","last_page":"134"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.32670000195503235,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},"topics":[{"id":"https://openalex.org/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.32670000195503235,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10350","display_name":"Electronic Health Records Systems","score":0.2822999954223633,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T14427","display_name":"Environmental Monitoring and Data Management","score":0.06289999932050705,"subfield":{"id":"https://openalex.org/subfields/1907","display_name":"Geology"},"field":{"id":"https://openalex.org/fields/19","display_name":"Earth and Planetary Sciences"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7754960656166077},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.66605144739151},{"id":"https://openalex.org/keywords/workflow","display_name":"Workflow","score":0.584241509437561},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5415256023406982},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5096120834350586},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4195806086063385},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.38729196786880493}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7754960656166077},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.66605144739151},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.584241509437561},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5415256023406982},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5096120834350586},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4195806086063385},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.38729196786880493}],"mesh":[{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008962","descriptor_name":"Models, Theoretical","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008962","descriptor_name":"Models, Theoretical","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008962","descriptor_name":"Models, Theoretical","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D035843","descriptor_name":"Biomedical Research","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D035843","descriptor_name":"Biomedical Research","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D035843","descriptor_name":"Biomedical Research","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057186","descriptor_name":"Comparative Effectiveness Research","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057186","descriptor_name":"Comparative Effectiveness Research","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057186","descriptor_name":"Comparative Effectiveness Research","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057225","descriptor_name":"Data Mining","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D057225","descriptor_name":"Data Mining","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D057225","descriptor_name":"Data Mining","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D057225","descriptor_name":"Data Mining","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057225","descriptor_name":"Data Mining","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057225","descriptor_name":"Data Mining","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false}],"locations_count":4,"locations":[{"id":"doi:10.1186/s12911-017-0532-3","is_oa":true,"landing_page_url":"https://doi.org/10.1186/s12911-017-0532-3","pdf_url":"https://bmcmedinformdecismak.biomedcentral.com/track/pdf/10.1186/s12911-017-0532-3","source":{"id":"https://openalex.org/S107516304","display_name":"BMC Medical Informatics and Decision Making","issn_l":"1472-6947","issn":["1472-6947"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320256","host_organization_name":"BioMed Central","host_organization_lineage":["https://openalex.org/P4310320256","https://openalex.org/P4310319965"],"host_organization_lineage_names":["BioMed Central","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BMC Medical Informatics and Decision Making","raw_type":"journal-article"},{"id":"pmid:28903729","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/28903729","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BMC medical informatics and decision making","raw_type":null},{"id":"pmh:oai:doaj.org/article:195964f54c964b2896a97fdf7f602b39","is_oa":false,"landing_page_url":"https://doaj.org/article/195964f54c964b2896a97fdf7f602b39","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"BMC Medical Informatics and Decision Making, Vol 17, Iss 1, Pp 1-12 (2017)","raw_type":"article"},{"id":"pmh:oai:europepmc.org:4528737","is_oa":true,"landing_page_url":"https://www.ncbi.nlm.nih.gov/pmc/articles/5598056","pdf_url":null,"source":{"id":"https://openalex.org/S4306400806","display_name":"Europe PMC (PubMed Central)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1303153112","host_organization_name":"European Bioinformatics Institute","host_organization_lineage":["https://openalex.org/I1303153112"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Text"}],"best_oa_location":{"id":"doi:10.1186/s12911-017-0532-3","is_oa":true,"landing_page_url":"https://doi.org/10.1186/s12911-017-0532-3","pdf_url":"https://bmcmedinformdecismak.biomedcentral.com/track/pdf/10.1186/s12911-017-0532-3","source":{"id":"https://openalex.org/S107516304","display_name":"BMC Medical Informatics and Decision Making","issn_l":"1472-6947","issn":["1472-6947"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320256","host_organization_name":"BioMed Central","host_organization_lineage":["https://openalex.org/P4310320256","https://openalex.org/P4310319965"],"host_organization_lineage_names":["BioMed Central","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"BMC Medical Informatics and Decision Making","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/17","display_name":"Partnerships for the goals","score":0.5899999737739563}],"awards":[{"id":"https://openalex.org/G1331609061","display_name":null,"funder_award_id":"R01 HS022956","funder_id":"https://openalex.org/F4320332177","funder_display_name":"Agency for Healthcare Research and Quality"},{"id":"https://openalex.org/G1732786736","display_name":null,"funder_award_id":"R01 HS019908","funder_id":"https://openalex.org/F4320332177","funder_display_name":"Agency for Healthcare Research and Quality"},{"id":"https://openalex.org/G46742105","display_name":null,"funder_award_id":"1R01HS022956","funder_id":"https://openalex.org/F4320332177","funder_display_name":"Agency for Healthcare Research and Quality"},{"id":"https://openalex.org/G5744599537","display_name":null,"funder_award_id":"1R01HS019908","funder_id":"https://openalex.org/F4320332177","funder_display_name":"Agency for Healthcare Research and Quality"}],"funders":[{"id":"https://openalex.org/F4320332161","display_name":"National Institutes of Health","ror":"https://ror.org/01cwqze88"},{"id":"https://openalex.org/F4320332177","display_name":"Agency for Healthcare Research and Quality","ror":"https://ror.org/03jmfdf59"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2755562077.pdf","grobid_xml":"https://content.openalex.org/works/W2755562077.grobid-xml"},"referenced_works_count":45,"referenced_works":["https://openalex.org/W41964281","https://openalex.org/W116194285","https://openalex.org/W158537288","https://openalex.org/W176477701","https://openalex.org/W343945789","https://openalex.org/W1501511408","https://openalex.org/W1915444313","https://openalex.org/W1973415432","https://openalex.org/W1983005394","https://openalex.org/W1998368672","https://openalex.org/W1999362902","https://openalex.org/W2007767904","https://openalex.org/W2025509044","https://openalex.org/W2028567167","https://openalex.org/W2031980847","https://openalex.org/W2032960629","https://openalex.org/W2056867850","https://openalex.org/W2058924226","https://openalex.org/W2061712899","https://openalex.org/W2063846874","https://openalex.org/W2071806619","https://openalex.org/W2087341911","https://openalex.org/W2088263677","https://openalex.org/W2092970016","https://openalex.org/W2103289836","https://openalex.org/W2104608657","https://openalex.org/W2112662877","https://openalex.org/W2117200425","https://openalex.org/W2124478641","https://openalex.org/W2134256069","https://openalex.org/W2134405146","https://openalex.org/W2135589624","https://openalex.org/W2135617001","https://openalex.org/W2140206469","https://openalex.org/W2144892976","https://openalex.org/W2148016376","https://openalex.org/W2151868700","https://openalex.org/W2252608272","https://openalex.org/W2260861673","https://openalex.org/W2319724808","https://openalex.org/W4206234897","https://openalex.org/W4231698305","https://openalex.org/W4251624698","https://openalex.org/W4285719527","https://openalex.org/W7037591065"],"related_works":["https://openalex.org/W1981780420","https://openalex.org/W2182707996","https://openalex.org/W45233828","https://openalex.org/W2964988449","https://openalex.org/W2397952901","https://openalex.org/W2029380707","https://openalex.org/W188202134","https://openalex.org/W4255934811","https://openalex.org/W2099525665","https://openalex.org/W2465382974"],"abstract_inverted_index":{"BACKGROUND:":[0],"Electronic":[1],"health":[2,66,94,195,253,276,314],"records":[3],"(EHRs)":[4],"contain":[5],"detailed":[6],"clinical":[7,21,85,169],"data":[8,26,44,54,82,95,196,199,205,217,234,254,277,281,294,300],"stored":[9],"in":[10,19,153,298],"proprietary":[11],"formats":[12],"with":[13,186,221],"non-standard":[14],"codes":[15],"and":[16,30,36,39,48,69,91,97,109,123,156,192,202,244,269,274,302],"structures.":[17],"Participating":[18],"multi-site":[20],"research":[22,86,170,299,310],"networks":[23],"requires":[24,134],"EHR":[25],"to":[27,42,52,55,57,84,103,164,211,260,272],"be":[28],"restructured":[29],"transformed":[31],"into":[32,226,278],"a":[33,72,93,249,267,279,286],"common":[34,204,233],"format":[35],"standard":[37],"terminologies,":[38],"optimally":[40],"linked":[41],"other":[43],"sources.":[45],"The":[46,236],"expertise":[47],"scalable":[49,250],"solutions":[50],"needed":[51],"transform":[53,273],"conform":[56],"network":[58],"requirements":[59],"are":[60,162,175],"beyond":[61],"the":[62,79,116,131,143,147,178,190,227,245,305],"scope":[63],"of":[64,81,115,120,130,136,149,158,189,194,307],"many":[65],"care":[67],"organizations":[68],"there":[70],"is":[71],"need":[73],"for":[74,146,252],"practical":[75],"tools":[76],"that":[77,112,133,161,215,239,288,292],"lower":[78],"barriers":[80,291],"contribution":[83],"networks.":[87,172],"METHODS:":[88],"We":[89],"designed":[90],"implemented":[92,210],"transformation":[96,159,255],"loading":[98],"approach,":[99],"which":[100],"we":[101],"refer":[102],"as":[104],"Dynamic":[105],"ETL":[106,148,166,179,184,213,240],"(Extraction,":[107],"Transformation":[108],"Loading)":[110],"(D-ETL),":[111],"automates":[113],"part":[114],"process":[117,132,271],"through":[118],"use":[119],"scalable,":[121],"reusable":[122],"customizable":[124],"code,":[125],"while":[126],"retaining":[127],"manual":[128],"aspects":[129],"knowledge":[135,188],"complex":[137],"coding":[138],"syntax.":[139],"This":[140,283],"approach":[141,284],"provides":[142],"flexibility":[144],"required":[145],"heterogeneous":[150],"data,":[151],"variations":[152],"semantic":[154],"expertise,":[155],"transparency":[157],"logic":[160],"essential":[163],"implement":[165],"conventions":[167],"across":[168],"sharing":[171],"Processing":[173],"workflows":[174],"directed":[176],"by":[177,183],"specifications":[180],"guideline,":[181],"developed":[182],"designers":[185],"extensive":[187],"structure":[191],"semantics":[193],"(i.e.,":[197],"\"health":[198],"domain":[200],"experts\")":[201],"target":[203,280],"model.":[206,235,282],"RESULTS:":[207],"D-ETL":[208,246,265],"was":[209],"perform":[212],"operations":[214],"load":[216,275],"from":[218,296],"various":[219],"sources":[220],"different":[222],"database":[223],"schema":[224],"structures":[225],"Observational":[228],"Medical":[229],"Outcome":[230],"Partnership":[231],"(OMOP)":[232],"results":[237],"showed":[238],"rule":[241],"composition":[242],"methods":[243],"engine":[247],"offer":[248],"solution":[251,287],"via":[256],"automatic":[257],"query":[258],"generation":[259],"harmonize":[261],"source":[262],"datasets.":[263],"CONCLUSIONS:":[264],"supports":[266],"flexible":[268],"transparent":[270],"offers":[285],"lowers":[289],"technical":[290],"prevent":[293],"partners":[295],"participating":[297],"networks,":[301],"therefore,":[303],"promotes":[304],"advancement":[306],"comparative":[308],"effectiveness":[309],"using":[311],"secondary":[312],"electronic":[313],"data.":[315]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":11},{"year":2024,"cited_by_count":11},{"year":2023,"cited_by_count":7},{"year":2022,"cited_by_count":10},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":8},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":1}],"updated_date":"2026-07-23T08:03:31.855105","created_date":"2025-10-10T00:00:00"}