{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,17]],"date-time":"2026-01-17T23:08:48Z","timestamp":1768691328625,"version":"3.49.0"},"reference-count":35,"publisher":"Springer Science and Business Media LLC","issue":"1","license":[{"start":{"date-parts":[[2019,4,24]],"date-time":"2019-04-24T00:00:00Z","timestamp":1556064000000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["J Biomed Semant"],"published-print":{"date-parts":[[2019,12]]},"DOI":"10.1186\/s13326-019-0199-z","type":"journal-article","created":{"date-parts":[[2019,4,24]],"date-time":"2019-04-24T02:05:34Z","timestamp":1556071534000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":9,"title":["Integrating terminologies into standard SQL: a new approach for research on routine data"],"prefix":"10.1186","volume":"10","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-1843-3125","authenticated-orcid":false,"given":"Andr\u00e9","family":"Sander","sequence":"first","affiliation":[]},{"given":"Roland","family":"Wauer","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2019,4,24]]},"reference":[{"key":"199_CR1","unstructured":"Prokosch U. Arbeitsgruppe \u201cNutzung von elektronischen Patientenakten f\u00fcr die klinische Forschung\u201d. \n                    https:\/\/gmds.de\/aktivitaeten\/medizinische-informatik\/arbeitsgruppenseiten\/nutzung-von-elektronischen-patientenakten-fuer-die-klinische-forschung\/\n                    \n                  . Accessed 4 Apr 2019."},{"issue":"5","key":"199_CR2","doi-asserted-by":"publisher","first-page":"392","DOI":"10.1197\/jamia.M1552","volume":"11","author":"C Friedman","year":"2004","unstructured":"Friedman C, Shagina L, Lussier Y, Hripcsak G. Automated encoding of clinical documents based on natural language processing. J Am Med Inform Assoc. 2004;11(5):392\u2013402.","journal-title":"J Am Med Inform Assoc"},{"issue":"5","key":"199_CR3","doi-asserted-by":"publisher","first-page":"507","DOI":"10.1136\/jamia.2009.001560","volume":"17","author":"GK Savova","year":"2010","unstructured":"Savova GK, Masanz JJ, Ogren PV, Zheng J, Sohn S, Kipper-Schuler KC, et al. Mayo clinical text analysis and knowledge extraction system (cTAKES): architecture, component evaluation and applications. J Am Med Inform Assoc. 2010;17(5):507\u201313.","journal-title":"J Am Med Inform Assoc"},{"key":"199_CR4","first-page":"172","volume":"6","author":"PL Elkin","year":"2008","unstructured":"Elkin PL, Froehling D, Wahner-Roedler D, Trusko B, Welsh G, Ma H, Asatryan AX, Tokars JI, Rosenbloom ST, Brown SH. NLP-based identification of pneumonia cases from free-text radiological reports. AMIA Annu Symp Proc. 2008;6:172\u20136.","journal-title":"AMIA Annu Symp Proc"},{"issue":"10","key":"199_CR5","doi-asserted-by":"publisher","first-page":"134","DOI":"10.1007\/s10916-014-0134-x","volume":"38","author":"JL Allones","year":"2014","unstructured":"Allones JL, Martinez D, Taboada M. Automated mapping of clinical terms into SNOMED-CT. An application to codify procedures in pathology. J Med Syst. 2014;38(10):134. \n                    https:\/\/doi.org\/10.1007\/s10916-014-0134-x\n                    \n                   Epub 2014 Sep 2.","journal-title":"J Med Syst"},{"key":"199_CR6","doi-asserted-by":"publisher","first-page":"91","DOI":"10.1186\/s12911-015-0215-x","volume":"15","author":"M Toepfer","year":"2015","unstructured":"Toepfer M, Corovic H, Fette G, Kluegl P, Stoerk S, Puppe F. Fine-grained information extraction from German transthoracic echocardiography reports. BMC Med Inform Decis Mak. 2015;15:91. \n                    https:\/\/doi.org\/10.1186\/s12911-015-0215-x\n                    \n                  .","journal-title":"BMC Med Inform Decis Mak"},{"issue":"Suppl 9","key":"199_CR7","doi-asserted-by":"publisher","first-page":"S14","DOI":"10.1186\/1471-2105-10-S9-S14","volume":"10","author":"NH Shah","year":"2009","unstructured":"Shah NH, Bhatia N, Jonquet C, Rubin D, Chiang AP, Musen MA. Comparison of concept recognizers for building the open biomedical annotator. BMC Bioinformatics. 2009;10(Suppl 9):S14.","journal-title":"BMC Bioinformatics"},{"key":"199_CR8","first-page":"63","volume-title":"Comparing Metamap to MGrep as a tool for mapping free text to formal medical lexicons, proceedings of the 1st international workshop on Knowledge Extraction & Consolidation from social media","author":"SA Stewart","year":"2012","unstructured":"Stewart SA, von Maltzahn ME, Abidi SSR. Comparing Metamap to MGrep as a tool for mapping free text to formal medical lexicons, proceedings of the 1st international workshop on Knowledge Extraction & Consolidation from social media, vol. 895; 2012. p. 63."},{"key":"199_CR9","volume-title":"The semantic web. Latest advances and new domains. ESWC 2016. Lecture notes in computer science","author":"S Zwicklbauer","year":"2016","unstructured":"Zwicklbauer S, Seifert C, Granitzer M. DoSeR - a Knowledge-Base-agnostic framework for entity disambiguation using semantic Embeddings. In: Sack H, Blomqvist E, d'Aquin M, Ghidini C, Ponzetto S, Lange C, editors. The semantic web. Latest advances and new domains. ESWC 2016. Lecture notes in computer science, vol. 9678. Cham: Springer; 2016."},{"key":"199_CR10","first-page":"349","volume-title":"Terminology query language: a server Interface for concept-oriented terminology systems, Proc AMIA Symp","author":"MA Hogarth","year":"2000","unstructured":"Hogarth MA, Gerz M, Gorin FA. Terminology query language: a server Interface for concept-oriented terminology systems, Proc AMIA Symp; 2000. p. 349\u201353."},{"key":"199_CR11","first-page":"406","volume-title":"Semantic web programming","author":"J Hebeler","year":"2009","unstructured":"Hebeler J, Fisher M, Blace R, Perez-Lopez A. Semantic web programming. Indianapolis: Wiley; 2009. p. 406. ISBN 978-0-470-41801-7"},{"key":"199_CR12","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1016\/j.artmed.2010.10.001","volume":"51","author":"RS Travillian","year":"2011","unstructured":"Travillian RS, Diatchkab K, Judgec TK, Wilamowskad K, Shapiro LG. An ontology-based comparative anatomy information system. Artif Intell Med. 2011;51:1\u201315.","journal-title":"Artif Intell Med"},{"key":"199_CR13","doi-asserted-by":"publisher","first-page":"279","DOI":"10.1016\/S0933-3657(98)00038-4","volume":"14","author":"A Riva","year":"1998","unstructured":"Riva A, Bellazzi R, Lanzola G, Stefanelli M. A development environment for knowledge-based medical applications on the world-wide web. Artif Intell Med. 1998;14:279\u201393.","journal-title":"Artif Intell Med"},{"key":"199_CR14","doi-asserted-by":"publisher","first-page":"177","DOI":"10.1016\/j.artmed.2005.10.009","volume":"36","author":"I Bichindaritz","year":"2006","unstructured":"Bichindaritz I. M\u00e9moire: a framework for semantic interoperability of case-based reasoning systems in biology and medicine. Artif Intell Med. 2006;36:177\u201392.","journal-title":"Artif Intell Med"},{"key":"199_CR15","doi-asserted-by":"publisher","first-page":"87","DOI":"10.1016\/j.artmed.2009.07.001","volume":"47","author":"T Mabotuwana","year":"2009","unstructured":"Mabotuwana T, Warren J. An ontology-based approach to enhance querying capabilities of general practice medicine for better management of hypertension. Artif Intell Med. 2009;47:87\u2013103.","journal-title":"Artif Intell Med"},{"key":"199_CR16","first-page":"142","volume":"192","author":"AA Kamaa","year":"2013","unstructured":"Kamaa AA, Choqueta R, Melsb G, Daniela C, Charleta J, Jaulent MC. An ontological approach for the exploitation of clinical data. Stud Health Technol Inform. 2013;192:142\u20136.","journal-title":"Stud Health Technol Inform"},{"key":"199_CR17","doi-asserted-by":"publisher","first-page":"962","DOI":"10.1136\/amiajnl-2013-001756","volume":"20","author":"R Epstein","year":"2013","unstructured":"Epstein R, Jacques P, Stockin M, Rothman B, Ehrenfeld J, Denny J. Automated identification of drug and food allergies entered using non-standard terminology. J Am Med Inform Assoc. 2013;20:962\u20138.","journal-title":"J Am Med Inform Assoc"},{"issue":"1","key":"199_CR18","doi-asserted-by":"publisher","first-page":"67","DOI":"10.1142\/S1793351X14500032","volume":"8","author":"S Zheng","year":"2014","unstructured":"Zheng S, Wang F, Lu J. Enabling ontology based semantic queries in biomedical database systems. Int J Semant Comput. 2014;8(1):67\u201383. \n                    https:\/\/doi.org\/10.1142\/S1793351X14500032\n                    \n                  .","journal-title":"Int J Semant Comput"},{"issue":"4","key":"199_CR19","doi-asserted-by":"publisher","first-page":"33","DOI":"10.1145\/2661643","volume":"39","author":"M Bienvenu","year":"2014","unstructured":"Bienvenu M, Cate BT, Lutz C, Wolter F. Ontology-based data access: a study through disjunctive datalog, CSP, and MMSNP. ACM Trans Database Syst. 2014;39(4):33.","journal-title":"ACM Trans Database Syst"},{"key":"199_CR20","doi-asserted-by":"publisher","first-page":"e327","DOI":"10.1136\/amiajnl-2013-001858","volume":"20","author":"R Bache","year":"2013","unstructured":"Bache R, Miles S, Taweel A. An adaptable architecture for patient cohort identification from diverse data sources. Am Med Inform Assoc. 2013;20:e327\u201333. \n                    https:\/\/doi.org\/10.1136\/amiajnl-2013-001858\n                    \n                  .","journal-title":"Am Med Inform Assoc"},{"key":"199_CR21","doi-asserted-by":"publisher","first-page":"666","DOI":"10.1016\/j.ahj.2006.12.022","volume":"153","author":"SS Pakhomov","year":"2007","unstructured":"Pakhomov SS, Hemingway H, Weston SA, Jacobsen SJ, Rodeheffer R, Roger VL. Epidemiology of angina pectoris: role of natural language processing of the medical record. Am Heart J. 2007;153:666\u201373.","journal-title":"Am Heart J"},{"key":"199_CR22","doi-asserted-by":"publisher","DOI":"10.3233\/978-1-61499-564-7-1084","volume-title":"Cohort discovery query optimization via computable controlled vocabulary versioning, MEDINFO","author":"TA Ferrisa","year":"2015","unstructured":"Ferrisa TA, Podchiyskaa T. Cohort discovery query optimization via computable controlled vocabulary versioning, MEDINFO; 2015. \n                    https:\/\/doi.org\/10.3233\/978-1-61499-564-7-1084\n                    \n                  ."},{"key":"199_CR23","unstructured":"Rapoport I. \n                    https:\/\/en.wikipedia.org\/wiki\/Ingeborg_Rapoport\n                    \n                   (Accessed 02 Nov 2016)."},{"key":"199_CR24","volume-title":"Extracting Information from Textual Documents in the Electronic Health Record: A Review of Recent Research, IMIA Yearbook of Medical Informatics","author":"SM Meystre","year":"2008","unstructured":"Meystre SM, Savova GK, Kipper-Schuler KC, Hurdle JF, Extracting Information from Textual Documents in the Electronic Health Record: A Review of Recent Research, IMIA Yearbook of Medical Informatics (2008). Schattauer GmbH."},{"key":"199_CR25","series-title":"Proc Annu Symp Comput Appl Med Care","first-page":"294","volume-title":"Enhancing medical database semantics","author":"F Le\u00e3o Bde","year":"1995","unstructured":"Le\u00e3o Bde F, Pavan A. Enhancing medical database semantics, Proc Annu Symp Comput Appl Med Care; 1995. p. 294\u20138."},{"key":"199_CR26","unstructured":"Common Terminology Services 2. \n                    http:\/\/www.omg.org\/spec\/CTS2\/\n                    \n                  . Accessed 06 Nov 2016)."},{"key":"199_CR27","series-title":"Proceedings of the 40th anniversary meeting of the association for computational linguistics (ACL\u201902), Philadelphia","volume-title":"GATE: a framework and graphical development environment for robust NLP tools and applications","author":"H Cunningham","year":"2002","unstructured":"Cunningham H, Maynard D, Bontcheva K, Tablan V. GATE: a framework and graphical development environment for robust NLP tools and applications. Proceedings of the 40th anniversary meeting of the association for computational linguistics (ACL\u201902), Philadelphia; 2002."},{"key":"199_CR28","series-title":"AMIA Annu Symp Proc","first-page":"910","volume-title":"The use of SNOMED CT simplifies querying of a clinical data warehouse","author":"MI Lieberman","year":"2003","unstructured":"Lieberman MI, Ricciardi TN, Masarie FE, Spackman KA. The use of SNOMED CT simplifies querying of a clinical data warehouse, AMIA Annu Symp Proc; 2003. p. 910."},{"key":"199_CR29","unstructured":"MedCalc. \n                    https:\/\/www.medcalc.org\/calc\/diagnostic_test.php\n                    \n                  . Accessed:02 Nov 2016."},{"key":"199_CR30","first-page":"10","volume":"2012","author":"J Pathak","year":"2012","unstructured":"Pathak J, Kiefer RC, Chute CG. Using semantic web technologies for cohort identification from electronic health records for clinical research. AMIA Jt Summits Transl Sci Proc. 2012;2012:10\u20139 Epub 2012 Mar 19.","journal-title":"AMIA Jt Summits Transl Sci Proc"},{"key":"199_CR31","doi-asserted-by":"publisher","first-page":"16","DOI":"10.1186\/s13326-015-0012-6","volume":"6","author":"H Leroux","year":"2015","unstructured":"Leroux H, Lefort L. Semantic enrichment of longitudinal clinical study data using the CDISC standards and the semantic statistics vocabularies. J Biomedical Semantics. 2015;6:16. \n                    https:\/\/doi.org\/10.1186\/s13326-015-0012-6\n                    \n                  .","journal-title":"J Biomedical Semantics"},{"issue":"1","key":"199_CR32","doi-asserted-by":"publisher","first-page":"e0144717","DOI":"10.1371\/journal.pone.0144717","volume":"11","author":"P Thompson","year":"2016","unstructured":"Thompson P, Batista-Navarro RT, Kontonatsios G, Carter J, Toon E, McNaught J, et al. Text mining the history of medicine. PLoS One. 2016;11(1):e0144717. \n                    https:\/\/doi.org\/10.1371\/journal.pone.0144717\n                    \n                  .","journal-title":"PLoS One"},{"key":"199_CR33","first-page":"281","volume":"13","author":"S Pakhomov","year":"2007","unstructured":"Pakhomov S, Weston SA, Jacobsen SJ, Chute CG, Meverden R, Roger VL. Electronic medical records for clinical research: application to the identification of heart failure. Am J Manag Care. 2007;13:281\u20138.","journal-title":"Am J Manag Care"},{"key":"199_CR34","unstructured":"Vipin Kumar.N et al, A comprehensive comparative study of SPARQL and SQL, Int J Comput Sci Inform Technol, Vol. 2 (4) , 2011, 1706\u20131710."},{"issue":"1","key":"199_CR35","doi-asserted-by":"publisher","first-page":"125","DOI":"10.1515\/jpm-2018-0003","volume":"47","author":"Andr\u00e9 Sander","year":"2018","unstructured":"Sander A, Wauer R. From single-case analysis of neonatal deaths toward a further reduction of the neonatal mortality rate. J Perinat Med. 2018. \n                    https:\/\/doi.org\/10.1515\/jpm-2018-0003\n                    \n                  .","journal-title":"Journal of Perinatal Medicine"}],"container-title":["Journal of Biomedical Semantics"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1186\/s13326-019-0199-z.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1186\/s13326-019-0199-z\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1186\/s13326-019-0199-z.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,4,22]],"date-time":"2020-04-22T23:11:17Z","timestamp":1587597077000},"score":1,"resource":{"primary":{"URL":"https:\/\/jbiomedsem.biomedcentral.com\/articles\/10.1186\/s13326-019-0199-z"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,4,24]]},"references-count":35,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2019,12]]}},"alternative-id":["199"],"URL":"https:\/\/doi.org\/10.1186\/s13326-019-0199-z","relation":{},"ISSN":["2041-1480"],"issn-type":[{"value":"2041-1480","type":"electronic"}],"subject":[],"published":{"date-parts":[[2019,4,24]]},"assertion":[{"value":"23 July 2018","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"26 March 2019","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"24 April 2019","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"Ethics approval is not required for historical data over 30\u2009years old.","order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Ethics approval and consent to participate"}},{"value":"Not applicable.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Consent for publication"}},{"value":"The author works for the company ID Information und Dokumentation im Gesundheitswesen GmbH & Co KGaA and has contributed to the development of the product ID LOGIK\u00ae.","order":3,"name":"Ethics","group":{"name":"EthicsHeading","label":"Competing interests"}},{"value":"Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.","order":4,"name":"Ethics","group":{"name":"EthicsHeading","label":"Publisher\u2019s Note"}}],"article-number":"7"}}