{"id":"https://openalex.org/W2980526241","doi":"https://doi.org/10.3233/shti190218","title":"Transforming Two Decades of ePR Data to OMOP CDM for Clinical Research","display_name":"Transforming Two Decades of ePR Data to OMOP CDM for Clinical Research","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2980526241","doi":"https://doi.org/10.3233/shti190218","mag":"2980526241","pmid":"https://pubmed.ncbi.nlm.nih.gov/31437920"},"language":"en","primary_location":{"id":"doi:10.3233/shti190218","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti190218","pdf_url":null,"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":"book-chapter","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.3233/shti190218","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5009604570","display_name":"Daniel M\u00e1rio de Lima","orcid":"https://orcid.org/0000-0002-7818-6103"},"institutions":[{"id":"https://openalex.org/I4210092357","display_name":"Institute of Mathematics and Computer Science","ror":"https://ror.org/00fy4at53","country_code":"MD","type":"facility","lineage":["https://openalex.org/I112090838","https://openalex.org/I4210092357"]}],"countries":["MD"],"is_corresponding":false,"raw_author_name":"Lima Daniel M.","raw_affiliation_strings":["Institute of Mathematical and Computer Sciences (ICMC), University of S\u00e3o Paulo, S\u00e3o Carlos, S\u00e3o Paulo, Brazil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Mathematical and Computer Sciences (ICMC), University of S\u00e3o Paulo, S\u00e3o Carlos, S\u00e3o Paulo, Brazil","institution_ids":["https://openalex.org/I4210092357"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063700071","display_name":"Jos\u00e9 F. Rodrigues","orcid":"https://orcid.org/0000-0001-8318-1780"},"institutions":[{"id":"https://openalex.org/I4210092357","display_name":"Institute of Mathematics and Computer Science","ror":"https://ror.org/00fy4at53","country_code":"MD","type":"facility","lineage":["https://openalex.org/I112090838","https://openalex.org/I4210092357"]}],"countries":["MD"],"is_corresponding":false,"raw_author_name":"Rodrigues-Jr Jose F.","raw_affiliation_strings":["Institute of Mathematical and Computer Sciences (ICMC), University of S\u00e3o Paulo, S\u00e3o Carlos, S\u00e3o Paulo, Brazil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Mathematical and Computer Sciences (ICMC), University of S\u00e3o Paulo, S\u00e3o Carlos, S\u00e3o Paulo, Brazil","institution_ids":["https://openalex.org/I4210092357"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014783020","display_name":"Agma J. M. Traina","orcid":"https://orcid.org/0000-0003-4929-7258"},"institutions":[{"id":"https://openalex.org/I4210092357","display_name":"Institute of Mathematics and Computer Science","ror":"https://ror.org/00fy4at53","country_code":"MD","type":"facility","lineage":["https://openalex.org/I112090838","https://openalex.org/I4210092357"]}],"countries":["MD"],"is_corresponding":false,"raw_author_name":"Traina Agma J.M.","raw_affiliation_strings":["Institute of Mathematical and Computer Sciences (ICMC), University of S\u00e3o Paulo, S\u00e3o Carlos, S\u00e3o Paulo, Brazil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Mathematical and Computer Sciences (ICMC), University of S\u00e3o Paulo, S\u00e3o Carlos, S\u00e3o Paulo, Brazil","institution_ids":["https://openalex.org/I4210092357"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081483665","display_name":"Fabio A. Pires","orcid":"https://orcid.org/0000-0001-6762-2910"},"institutions":[{"id":"https://openalex.org/I4210092357","display_name":"Institute of Mathematics and Computer Science","ror":"https://ror.org/00fy4at53","country_code":"MD","type":"facility","lineage":["https://openalex.org/I112090838","https://openalex.org/I4210092357"]}],"countries":["MD"],"is_corresponding":false,"raw_author_name":"Pires Fabio A.","raw_affiliation_strings":["Institute of Mathematical and Computer Sciences (ICMC), University of S\u00e3o Paulo, S\u00e3o Carlos, S\u00e3o Paulo, Brazil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Mathematical and Computer Sciences (ICMC), University of S\u00e3o Paulo, S\u00e3o Carlos, S\u00e3o Paulo, Brazil","institution_ids":["https://openalex.org/I4210092357"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085369510","display_name":"Marco A. Guti\u00e9rrez","orcid":"https://orcid.org/0000-0003-0964-6222"},"institutions":[{"id":"https://openalex.org/I17974374","display_name":"Universidade de S\u00e3o Paulo","ror":"https://ror.org/036rp1748","country_code":"BR","type":"education","lineage":["https://openalex.org/I17974374"]},{"id":"https://openalex.org/I4210145268","display_name":"Hospital das Cl\u00ednicas da Faculdade de Medicina da Universidade de S\u00e3o Paulo","ror":"https://ror.org/03se9eg94","country_code":"BR","type":"healthcare","lineage":["https://openalex.org/I4210145268"]},{"id":"https://openalex.org/I4210162743","display_name":"Hospital S\u00e3o Paulo","ror":"https://ror.org/050z9fj14","country_code":"BR","type":"healthcare","lineage":["https://openalex.org/I4210162743"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Gutierrez Marco A.","raw_affiliation_strings":["Heart Institute (InCor), Clinics Hospital, Faculty of Medicine, University of S\u00e3o Paulo, S\u00e3o Paulo, S\u00e3o Paulo, Brazil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Heart Institute (InCor), Clinics Hospital, Faculty of Medicine, University of S\u00e3o Paulo, S\u00e3o Paulo, S\u00e3o Paulo, Brazil","institution_ids":["https://openalex.org/I17974374","https://openalex.org/I4210145268","https://openalex.org/I4210162743"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":7.2577,"has_fulltext":false,"cited_by_count":34,"citation_normalized_percentile":{"value":0.96869984,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"264","issue":null,"first_page":"233","last_page":"237"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10350","display_name":"Electronic Health Records Systems","score":0.9954000115394592,"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"}},"topics":[{"id":"https://openalex.org/T10350","display_name":"Electronic Health Records Systems","score":0.9954000115394592,"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/T10703","display_name":"Business Process Modeling and Analysis","score":0.9757999777793884,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13702","display_name":"Machine Learning in Healthcare","score":0.9697999954223633,"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.6039637923240662},{"id":"https://openalex.org/keywords/scripting-language","display_name":"Scripting language","score":0.598656177520752},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5106006264686584},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5082792639732361},{"id":"https://openalex.org/keywords/identification","display_name":"Identification (biology)","score":0.4711804687976837},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.43855413794517517},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4356372654438019},{"id":"https://openalex.org/keywords/data-source","display_name":"Data source","score":0.41789937019348145},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.413196861743927},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.15615537762641907}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6039637923240662},{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.598656177520752},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5106006264686584},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5082792639732361},{"id":"https://openalex.org/C116834253","wikidata":"https://www.wikidata.org/wiki/Q2039217","display_name":"Identification (biology)","level":2,"score":0.4711804687976837},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.43855413794517517},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4356372654438019},{"id":"https://openalex.org/C2983685735","wikidata":"https://www.wikidata.org/wiki/Q5227355","display_name":"Data source","level":2,"score":0.41789937019348145},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.413196861743927},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15615537762641907},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C59822182","wikidata":"https://www.wikidata.org/wiki/Q441","display_name":"Botany","level":1,"score":0.0}],"mesh":[{"descriptor_ui":"D003695","descriptor_name":"Delivery of Health Care","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003695","descriptor_name":"Delivery of Health Care","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003695","descriptor_name":"Delivery of Health Care","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":"D015331","descriptor_name":"Cohort Studies","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D015331","descriptor_name":"Cohort Studies","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D015331","descriptor_name":"Cohort Studies","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":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","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/shti190218","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti190218","pdf_url":null,"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:31437920","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/31437920","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/shti190218","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti190218","pdf_url":null,"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":[{"score":0.7300000190734863,"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1126991912","https://openalex.org/W1976043039","https://openalex.org/W1987336000","https://openalex.org/W2049833004","https://openalex.org/W2113164419","https://openalex.org/W2131801584","https://openalex.org/W2157365260","https://openalex.org/W2237564809","https://openalex.org/W2280101775","https://openalex.org/W2602792180"],"related_works":["https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W4320802139","https://openalex.org/W1639806124","https://openalex.org/W4366145086","https://openalex.org/W2902831276","https://openalex.org/W4385834214","https://openalex.org/W3022423983","https://openalex.org/W2540682188","https://openalex.org/W12347151"],"abstract_inverted_index":{"This":[0],"paper":[1],"presents":[2],"the":[3,8,14,19,28,43,52,58,68,74,89,98,108,125,132],"extract-transform-and-load":[4],"(ETL)":[5],"process":[6],"from":[7,62,97],"Electronic":[9],"Patient":[10],"Records":[11],"(ePR)":[12],"at":[13],"Heart":[15],"Institute":[16],"(InCor)":[17],"to":[18,86,115,131],"OMOP":[20,133],"Common":[21],"Data":[22],"Model":[23],"(CDM)":[24],"format.":[25],"We":[26,50],"describe":[27],"initial":[29],"database":[30,55,119],"characterization,":[31],"relational":[32],"source":[33],"mappings,":[34],"selection":[35],"filters,":[36],"data":[37,70,127],"transformations":[38],"and":[39,47,72,78,128],"patient":[40,60],"de-identification":[41],"using":[42],"open-source":[44],"OHDSI":[45],"tools":[46],"SQL":[48],"scripts.":[49],"evaluate":[51],"resulting":[53],"InCor-CDM":[54],"by":[56,94],"recreating":[57],"same":[59],"cohort":[61],"a":[63,117],"previous":[64],"reference":[65,90],"study":[66],"(over":[67],"original":[69,126],"source)":[71],"comparing":[73],"cohorts'":[75],"descriptive":[76],"statistics":[77],"inclusion":[79],"reports.":[80],"The":[81,104],"results":[82,105],"exhibit":[83],"that":[84,107,110,120],"up":[85],"91%":[87],"of":[88],"patients":[91],"were":[92],"retrieved":[93],"our":[95],"method":[96,109],"ePR":[99],"through":[100],"InCor-CDM,":[101],"with":[102,124],"AUC=0.938.":[103],"indicate":[106],"we":[111],"employed":[112],"was":[113,121],"able":[114],"produce":[116],"new":[118],"both":[122],"consistent":[123],"in":[129],"accordance":[130],"CDM":[134],"standard.":[135]},"counts_by_year":[{"year":2025,"cited_by_count":8},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":8},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":7}],"updated_date":"2026-08-02T14:50:37.381335","created_date":"2019-10-25T00:00:00"}