{"id":"https://openalex.org/W3165591189","doi":"https://doi.org/10.3233/shti210077","title":"Accessing OMOP Common Data Model Repositories with the i2b2 Webclient \u2013 Algorithm for Automatic Query Translation","display_name":"Accessing OMOP Common Data Model Repositories with the i2b2 Webclient \u2013 Algorithm for Automatic Query Translation","publication_year":2021,"publication_date":"2021-05-24","ids":{"openalex":"https://openalex.org/W3165591189","doi":"https://doi.org/10.3233/shti210077","mag":"3165591189","pmid":"https://pubmed.ncbi.nlm.nih.gov/34042902"},"language":"en","primary_location":{"id":"doi:10.3233/shti210077","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti210077","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI210077","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://ebooks.iospress.nl/pdf/doi/10.3233/SHTI210077","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5017874388","display_name":"Raphael W. Majeed","orcid":"https://orcid.org/0000-0002-8260-8815"},"institutions":[{"id":"https://openalex.org/I200763008","display_name":"Justus-Liebig-Universit\u00e4t Gie\u00dfen","ror":"https://ror.org/033eqas34","country_code":"DE","type":"education","lineage":["https://openalex.org/I200763008"]},{"id":"https://openalex.org/I4210131615","display_name":"Universities of Giessen and Marburg Lung Center","ror":"https://ror.org/045f0ws19","country_code":"DE","type":"education","lineage":["https://openalex.org/I4210131615"]},{"id":"https://openalex.org/I887968799","display_name":"RWTH Aachen University","ror":"https://ror.org/04xfq0f34","country_code":"DE","type":"education","lineage":["https://openalex.org/I887968799"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Raphael W. Majeed","raw_affiliation_strings":["Institute of Medical Informatics, Medical Faculty of RWTH Aachen University, Germany","Universities Giessen and Marburg Lung Center (UGMLC), German Centre For Lung Research (DZL), Justus-Liebig University Giessen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Medical Informatics, Medical Faculty of RWTH Aachen University, Germany","institution_ids":["https://openalex.org/I887968799"]},{"raw_affiliation_string":"Universities Giessen and Marburg Lung Center (UGMLC), German Centre For Lung Research (DZL), Justus-Liebig University Giessen, Germany","institution_ids":["https://openalex.org/I4210131615","https://openalex.org/I200763008"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106695758","display_name":"Patrick Fischer","orcid":"https://orcid.org/0000-0003-4679-5489"},"institutions":[{"id":"https://openalex.org/I200763008","display_name":"Justus-Liebig-Universit\u00e4t Gie\u00dfen","ror":"https://ror.org/033eqas34","country_code":"DE","type":"education","lineage":["https://openalex.org/I200763008"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Patrick Fischer","raw_affiliation_strings":["Institute for Medical Informatics, Justus-Liebig University Giessen, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for Medical Informatics, Justus-Liebig University Giessen, Germany","institution_ids":["https://openalex.org/I200763008"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110709590","display_name":"Andreas G\u00fcnther","orcid":"https://orcid.org/0000-0002-2187-0975"},"institutions":[{"id":"https://openalex.org/I200763008","display_name":"Justus-Liebig-Universit\u00e4t Gie\u00dfen","ror":"https://ror.org/033eqas34","country_code":"DE","type":"education","lineage":["https://openalex.org/I200763008"]},{"id":"https://openalex.org/I4210131615","display_name":"Universities of Giessen and Marburg Lung Center","ror":"https://ror.org/045f0ws19","country_code":"DE","type":"education","lineage":["https://openalex.org/I4210131615"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Andreas G\u00fcnther","raw_affiliation_strings":["Universities Giessen and Marburg Lung Center (UGMLC), German Centre For Lung Research (DZL), Justus-Liebig University Giessen, Germany","Universities Giessen and Marburg Lung Center (UGMLC),"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universities Giessen and Marburg Lung Center (UGMLC), German Centre For Lung Research (DZL), Justus-Liebig University Giessen, Germany","institution_ids":["https://openalex.org/I4210131615","https://openalex.org/I200763008"]},{"raw_affiliation_string":"Universities Giessen and Marburg Lung Center (UGMLC),","institution_ids":["https://openalex.org/I4210131615"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5017874388"],"corresponding_institution_ids":["https://openalex.org/I200763008","https://openalex.org/I4210131615","https://openalex.org/I887968799"],"apc_list":null,"apc_paid":null,"fwci":5.6875,"has_fulltext":true,"cited_by_count":7,"citation_normalized_percentile":{"value":0.96477273,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"278","issue":null,"first_page":"251","last_page":"259"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9940999746322632,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9940999746322632,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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.9909999966621399,"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.9865999817848206,"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.8017147779464722},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.593947172164917},{"id":"https://openalex.org/keywords/software-portability","display_name":"Software portability","score":0.5798354148864746},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.49084144830703735},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.448917418718338},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4482842683792114},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.4440808892250061},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4165887236595154},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.26877719163894653}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8017147779464722},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.593947172164917},{"id":"https://openalex.org/C63000827","wikidata":"https://www.wikidata.org/wiki/Q3080428","display_name":"Software portability","level":2,"score":0.5798354148864746},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.49084144830703735},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.448917418718338},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4482842683792114},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.4440808892250061},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4165887236595154},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.26877719163894653},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000465","descriptor_name":"Algorithms","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000465","descriptor_name":"Algorithms","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D000465","descriptor_name":"Algorithms","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":"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":3,"locations":[{"id":"doi:10.3233/shti210077","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti210077","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI210077","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:34042902","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/34042902","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},{"id":"pmh:oai:publications.rwth-aachen.de:845963","is_oa":false,"landing_page_url":"https://publications.rwth-aachen.de/record/845963","pdf_url":null,"source":{"id":"https://openalex.org/S4306401033","display_name":"RWTH Publications (RWTH Aachen)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I887968799","host_organization_name":"RWTH Aachen University","host_organization_lineage":["https://openalex.org/I887968799"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Studies in health technology and informatics 278, (2021). doi:10.3233/SHTI210077","raw_type":"info:eu-repo/semantics/publishedVersion"}],"best_oa_location":{"id":"doi:10.3233/shti210077","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti210077","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI210077","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.41999998688697815,"display_name":"Partnerships for the goals"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3165591189.pdf","grobid_xml":"https://content.openalex.org/works/W3165591189.grobid-xml"},"referenced_works_count":17,"referenced_works":["https://openalex.org/W278411638","https://openalex.org/W1899105192","https://openalex.org/W2104608657","https://openalex.org/W2131941936","https://openalex.org/W2540149843","https://openalex.org/W2613482391","https://openalex.org/W2784358526","https://openalex.org/W2886582736","https://openalex.org/W2889124667","https://openalex.org/W2901300060","https://openalex.org/W2908068368","https://openalex.org/W2915873263","https://openalex.org/W2949944067","https://openalex.org/W2980526241","https://openalex.org/W2982451647","https://openalex.org/W2990090486","https://openalex.org/W6753548069"],"related_works":["https://openalex.org/W107105315","https://openalex.org/W4367156293","https://openalex.org/W1584537303","https://openalex.org/W4388155270","https://openalex.org/W1872724644","https://openalex.org/W2750549761","https://openalex.org/W28826848","https://openalex.org/W2122272819","https://openalex.org/W2130894091","https://openalex.org/W2994151208"],"abstract_inverted_index":{"In":[0],"the":[1,52,55,59,104,118],"era":[2],"of":[3,39,54,80],"translational":[4],"research,":[5],"data":[6,10,22,32,47],"integration":[7,33],"and":[8,41,46,65],"clinical":[9,17],"warehouses":[11],"are":[12,48],"important":[13],"enabling":[14],"technologies":[15],"for":[16,31,69,76],"researchers.":[18],"The":[19,108],"OMOP":[20,60,105,131],"common":[21],"model":[23],"is":[24,83,111],"a":[25,29,63,129],"wide-spread":[26],"choice":[27],"as":[28],"target":[30],"in":[34,117],"medical":[35],"informatics.":[36],"It's":[37],"portability":[38],"queries":[40,75,115],"analyses":[42],"across":[43],"different":[44],"institutions":[45],"ideal":[49],"also":[50],"from":[51],"viewpoint":[53],"FAIR":[56],"principles.":[57],"Yet,":[58],"CDM":[61,106,132],"lacks":[62],"simple":[64,74],"intuitive":[66],"user":[67],"interface":[68],"untrained":[70],"users":[71],"to":[72,84,88,94,113,121],"run":[73,102],"feasibility":[77],"analysis.":[78],"Aim":[79],"this":[81],"study":[82],"provide":[85],"an":[86,95],"algorithm":[87,110],"translate":[89],"any":[90],"given":[91],"i2b2":[92,119],"query":[93,97],"equivalent":[96],"which":[98,124],"can":[99,125],"then":[100],"be":[101,126],"on":[103,128],"database.":[107],"provided":[109],"able":[112],"convert":[114],"created":[116],"webclient":[120],"SQL":[122],"statements":[123],"executed":[127],"standard":[130],"database":[133],"programmatically.":[134]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":3}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}