{"id":"https://openalex.org/W4401824979","doi":"https://doi.org/10.3233/shti240419","title":"Converting Entity-Attribute-Value Data Sources to OMOP\u2019s CDM: Lessons Learned","display_name":"Converting Entity-Attribute-Value Data Sources to OMOP\u2019s CDM: Lessons Learned","publication_year":2024,"publication_date":"2024-08-22","ids":{"openalex":"https://openalex.org/W4401824979","doi":"https://doi.org/10.3233/shti240419","pmid":"https://pubmed.ncbi.nlm.nih.gov/39176749"},"language":"en","primary_location":{"id":"doi:10.3233/shti240419","is_oa":true,"landing_page_url":"http://dx.doi.org/10.3233/shti240419","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI240419","source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"type":"article","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI240419","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5022037530","display_name":"Florian Katsch","orcid":"https://orcid.org/0000-0001-7952-9326"},"institutions":[{"id":"https://openalex.org/I4210104219","display_name":"Austrian Institute for Health Technology Assessment GmbH","ror":"https://ror.org/00v16df20","country_code":"AT","type":"nonprofit","lineage":["https://openalex.org/I4210104219"]},{"id":"https://openalex.org/I76134821","display_name":"Medical University of Vienna","ror":"https://ror.org/05n3x4p02","country_code":"AT","type":"education","lineage":["https://openalex.org/I76134821"]}],"countries":["AT"],"is_corresponding":true,"raw_author_name":"Florian Katsch","raw_affiliation_strings":["Center for Medical Data Science, Medical University of Vienna, Vienna, Austria","Ludwig Boltzmann Institute for Digital Health and Prevention, Salzburg, Austria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Center for Medical Data Science, Medical University of Vienna, Vienna, Austria","institution_ids":["https://openalex.org/I76134821"]},{"raw_affiliation_string":"Ludwig Boltzmann Institute for Digital Health and Prevention, Salzburg, Austria","institution_ids":["https://openalex.org/I4210104219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041007161","display_name":"Rada Hussein","orcid":"https://orcid.org/0000-0003-1257-4848"},"institutions":[{"id":"https://openalex.org/I4210104219","display_name":"Austrian Institute for Health Technology Assessment GmbH","ror":"https://ror.org/00v16df20","country_code":"AT","type":"nonprofit","lineage":["https://openalex.org/I4210104219"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Rada Hussein","raw_affiliation_strings":["Ludwig Boltzmann Institute for Digital Health and Prevention, Salzburg, Austria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ludwig Boltzmann Institute for Digital Health and Prevention, Salzburg, Austria","institution_ids":["https://openalex.org/I4210104219"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5033998677","display_name":"Georg Duftschmid","orcid":"https://orcid.org/0000-0001-8007-0735"},"institutions":[{"id":"https://openalex.org/I76134821","display_name":"Medical University of Vienna","ror":"https://ror.org/05n3x4p02","country_code":"AT","type":"education","lineage":["https://openalex.org/I76134821"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Georg Duftschmid","raw_affiliation_strings":["Center for Medical Data Science, Medical University of Vienna, Vienna, Austria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Center for Medical Data Science, Medical University of Vienna, Vienna, Austria","institution_ids":["https://openalex.org/I76134821"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5022037530"],"corresponding_institution_ids":["https://openalex.org/I4210104219","https://openalex.org/I76134821"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.41888353,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"316","issue":null,"first_page":"356","last_page":"357"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9753000140190125,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9753000140190125,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.9674999713897705,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.944599986076355,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"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.6322311162948608},{"id":"https://openalex.org/keywords/observational-study","display_name":"Observational study","score":0.5637328624725342},{"id":"https://openalex.org/keywords/general-partnership","display_name":"General partnership","score":0.5542077422142029},{"id":"https://openalex.org/keywords/value","display_name":"Value (mathematics)","score":0.5166335701942444},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.4973907768726349},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.48533859848976135},{"id":"https://openalex.org/keywords/work","display_name":"Work (physics)","score":0.4382965564727783},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3953099250793457},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.33467650413513184},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.13252931833267212},{"id":"https://openalex.org/keywords/medicine","display_name":"Medicine","score":0.1002970039844513},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.09560883045196533},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.0722016990184784}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6322311162948608},{"id":"https://openalex.org/C23131810","wikidata":"https://www.wikidata.org/wiki/Q818574","display_name":"Observational study","level":2,"score":0.5637328624725342},{"id":"https://openalex.org/C71750763","wikidata":"https://www.wikidata.org/wiki/Q646164","display_name":"General partnership","level":2,"score":0.5542077422142029},{"id":"https://openalex.org/C2776291640","wikidata":"https://www.wikidata.org/wiki/Q2912517","display_name":"Value (mathematics)","level":2,"score":0.5166335701942444},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.4973907768726349},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.48533859848976135},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.4382965564727783},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3953099250793457},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.33467650413513184},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.13252931833267212},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.1002970039844513},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.09560883045196533},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0722016990184784},{"id":"https://openalex.org/C142724271","wikidata":"https://www.wikidata.org/wiki/Q7208","display_name":"Pathology","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0}],"mesh":[{"descriptor_ui":"D000093983","descriptor_name":"Information Sources","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000093983","descriptor_name":"Information Sources","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000093983","descriptor_name":"Information Sources","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000093983","descriptor_name":"Information Sources","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":"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":"D017063","descriptor_name":"Outcome Assessment, Health Care","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D017063","descriptor_name":"Outcome Assessment, Health Care","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D017063","descriptor_name":"Outcome Assessment, Health Care","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D017063","descriptor_name":"Outcome Assessment, Health Care","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true}],"locations_count":2,"locations":[{"id":"doi:10.3233/shti240419","is_oa":true,"landing_page_url":"http://dx.doi.org/10.3233/shti240419","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI240419","source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},{"id":"pmid:39176749","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/39176749","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":"Studies in health technology and informatics","raw_type":null}],"best_oa_location":{"id":"doi:10.3233/shti240419","is_oa":true,"landing_page_url":"http://dx.doi.org/10.3233/shti240419","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI240419","source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/17","score":0.6000000238418579,"display_name":"Partnerships for the goals"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4401824979.pdf","grobid_xml":"https://content.openalex.org/works/W4401824979.grobid-xml"},"referenced_works_count":1,"referenced_works":["https://openalex.org/W2044900550"],"related_works":["https://openalex.org/W4381328000","https://openalex.org/W2109147503","https://openalex.org/W2103779230","https://openalex.org/W2911339178","https://openalex.org/W334096847","https://openalex.org/W2322581019","https://openalex.org/W3141050733","https://openalex.org/W2030936866","https://openalex.org/W3141550469","https://openalex.org/W1533309927"],"abstract_inverted_index":{"Clinical":[0],"data":[1,7,17,53],"repositories":[2],"often":[3],"use":[4],"entity-attribute-value":[5],"(EAV)":[6],"models.":[8],"To":[9],"be":[10,19],"valuable":[11],"for":[12,61],"secondary":[13],"use,":[14],"these":[15],"health":[16],"can":[18],"transformed":[20],"to":[21],"the":[22,36,45],"Observational":[23],"Medical":[24],"Outcomes":[25],"Partnership":[26],"(OMOP)":[27],"Common":[28],"Data":[29],"Model":[30],"(CDM).":[31],"The":[32],"present":[33],"paper":[34],"describes":[35],"lessons":[37],"learned":[38],"from":[39],"such":[40],"an":[41],"endeavour":[42],"based":[43],"on":[44,51],"concept":[46],"of":[47],"registering":[48],"transformation":[49],"functions":[50],"source":[52],"elements.":[54],"We":[55],"further":[56],"provide":[57],"future":[58],"work":[59],"directions":[60],"follow-up":[62],"projects.":[63]},"counts_by_year":[],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2024-08-24T00:00:00"}