{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,3]],"date-time":"2026-03-03T13:34:43Z","timestamp":1772544883727,"version":"3.50.1"},"reference-count":56,"publisher":"SAGE Publications","issue":"2","license":[{"start":{"date-parts":[[2024,4,1]],"date-time":"2024-04-01T00:00:00Z","timestamp":1711929600000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"funder":[{"name":"Minist\u00e8re de l\u2019\u00c9conomie et de l\u2019Innovation \u2013 Qu\u00e9bec"}],"content-domain":{"domain":["journals.sagepub.com"],"crossmark-restriction":true},"short-container-title":["Health Informatics J"],"published-print":{"date-parts":[[2024,4]]},"abstract":"<jats:p> Keeping track of data semantics and data changes in the databases is essential to support retrospective studies and the reproducibility of longitudinal clinical analysis by preventing false conclusions from being drawn from outdated data. A knowledge model combined with a temporal model plays an essential role in organizing the data and improving query expressiveness across time and multiple institutions. This paper presents a modelling framework for temporal relational databases using an ontology to derive a shareable and interoperable data model. The framework is based on: OntoRela an ontology-driven database modelling approach and Unified Historicization Framework a temporal database modelling approach. The method was applied to hospital organizational structures to show the impact of tracking organizational changes on data quality assessment, healthcare activities and data access rights. The paper demonstrated the usefulness of an ontology to provide a formal, interoperable, and reusable definition of entities and their relationships, as well as the adequacy of the temporal database to store, trace, and query data over time. <\/jats:p>","DOI":"10.1177\/14604582241259336","type":"journal-article","created":{"date-parts":[[2024,6,7]],"date-time":"2024-06-07T22:17:21Z","timestamp":1717798641000},"update-policy":"https:\/\/doi.org\/10.1177\/sage-journals-update-policy","source":"Crossref","is-referenced-by-count":1,"title":["Building ontology-based temporal databases for data reuse: An applied example on hospital organizational structures"],"prefix":"10.1177","volume":"30","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-1186-0300","authenticated-orcid":false,"given":"Christina","family":"Khnaisser","sequence":"first","affiliation":[{"name":"Universit\u00e9 de Sherbrooke, Deparment of Medecine, Sherbrooke, QC, Canada"}]},{"given":"Vincent","family":"Looten","sequence":"additional","affiliation":[{"name":"Association des Centres M\u00e9dicaux et Sociaux (ACMS), Suresnes, France"}]},{"given":"Luc","family":"Lavoie","sequence":"additional","affiliation":[{"name":"Universit\u00e9 de Sherbrooke, D\u00e9partement d'informatique, Sherbrooke, QC, Canada"}]},{"given":"Anita","family":"Burgun","sequence":"additional","affiliation":[{"name":"Universit\u00e9 de Sherbrooke, Sherbrooke, QC, Canada; Universit\u00e9 Paris Cit\u00e9, Paris, France; H\u00f4pital Europ\u00e9en Georges-Pompidou, Paris, France"}]},{"given":"Jean-Fran\u00e7ois","family":"Ethier","sequence":"additional","affiliation":[{"name":"Universit\u00e9 de Sherbrooke, Department of Medecine, Sherbrooke, QC, Canada"}]}],"member":"179","published-online":{"date-parts":[[2024,6,7]]},"reference":[{"key":"bibr1-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1056\/nejmp2200089"},{"key":"bibr2-14604582241259336","doi-asserted-by":"publisher","DOI":"10.3390\/ijerph191610159"},{"key":"bibr3-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1016\/j.jbi.2016.09.018"},{"key":"bibr4-14604582241259336","volume-title":"Best care at lower cost","author":"Committee on the Learning Health Care System in America and Institute of Medicine","year":"2013"},{"key":"bibr5-14604582241259336","doi-asserted-by":"publisher","DOI":"10.3233\/SHTI190805"},{"key":"bibr6-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1186\/s12911-017-0513-6"},{"key":"bibr7-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1136\/jamia.2009.000893"},{"key":"bibr8-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1186\/s12874-021-01434-3"},{"key":"bibr9-14604582241259336","first-page":"67","author":"Bodenreider O","year":"2008","journal-title":"Yearb Med Inform"},{"key":"bibr10-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1186\/s13326-017-0127-z"},{"key":"bibr11-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1056\/nejmra1615014"},{"key":"bibr12-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1142\/s0218213017600156"},{"issue":"3","key":"bibr13-14604582241259336","first-page":"57","volume":"11","author":"Ermolayev V","year":"2014","journal-title":"Int J Comput Sci Appl"},{"key":"bibr14-14604582241259336","doi-asserted-by":"publisher","DOI":"10.14569\/ijacsa.2018.090620"},{"key":"bibr15-14604582241259336","first-page":"1517","volume":"2017","author":"Schuler JC","year":"2017","journal-title":"AMIA Annu Symp Proc"},{"key":"bibr16-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1055\/a-1877-9498"},{"key":"bibr17-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-96655-7"},{"key":"bibr18-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1109\/isacc.2015.7377335"},{"key":"bibr19-14604582241259336","unstructured":"Hobbs JR, Pan F. Time ontology in owl, 2020. https:\/\/www.w3.org\/TR\/owl-time\/"},{"key":"bibr20-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-18472-7"},{"key":"bibr21-14604582241259336","doi-asserted-by":"publisher","DOI":"10.3233\/sw-160248"},{"key":"bibr22-14604582241259336","first-page":"64","volume":"2011","author":"Tao C","year":"2011","journal-title":"AMIA Summits Transl Sci Proc"},{"key":"bibr23-14604582241259336","unstructured":"Pustejovsky J, Casta\u00f1o JM, Ingria R et al. Timeml: robust specification of event and temporal expressions in text. In Maybury MT (ed.) New Directions in Question Answering, Papers from 2003 AAAI Spring Symposium, Stanford University, Stanford, CA, USA. AAAI Press, pp. 28\u201334."},{"key":"bibr24-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-23201-0_10"},{"key":"bibr25-14604582241259336","volume-title":"Morgan Kaufmann series in data management systems (eBook)","author":"Snodgrass RT","year":"1999"},{"key":"bibr26-14604582241259336","volume-title":"The Morgan Kaufmann series in data management systems","author":"Date CJ","year":"2014","edition":"2"},{"key":"bibr27-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-64471-4_9"},{"key":"bibr28-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-031-15740-0_16"},{"key":"bibr29-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1145\/181550.181560"},{"key":"bibr30-14604582241259336","unstructured":"NationalAcademyofMedicine. The future of health services research: advancing health systems research and practice in the United States, 2018. https:\/\/www.ncbi.nlm.nih.gov\/books\/NBK535995\/"},{"key":"bibr31-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1136\/qshc.2008.029165"},{"key":"bibr32-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1002\/hec.1281"},{"key":"bibr33-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1001\/jama.260.12.1743"},{"key":"bibr34-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1177\/1077558707309613"},{"key":"bibr35-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1016\/j.jbi.2014.02.003"},{"key":"bibr36-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2017.02.006"},{"key":"bibr37-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1016\/j.respe.2017.05.004"},{"key":"bibr38-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1186\/2041-1480-4-23"},{"key":"bibr39-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1186\/s13326-016-0087-8"},{"key":"bibr40-14604582241259336","volume":"1747","author":"Utecht J","year":"2016","journal-title":"CEUR Workshop Proc"},{"key":"bibr41-14604582241259336","unstructured":"Reynorlds D. The organization ontologie, 2014. https:\/\/www.w3.org\/TR\/vocab-org\/"},{"key":"bibr42-14604582241259336","unstructured":"Guide m\u00e9thodologique de comptabilit\u00e9 analytique hospitali\u00e8re, 2011. https:\/\/solidarites-sante.gouv.fr\/IMG\/pdf\/GUIDE_CAH___BOS_2011-3.pdf"},{"key":"bibr43-14604582241259336","unstructured":"Autorisations des unit\u00e9s m\u00e9dicales, 2014. https:\/\/www.atih.sante.fr\/nomenclatures-de-recueil-de-l-information\/autorisations-des-unites-medicales"},{"key":"bibr44-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1145\/2757001.2757003"},{"key":"bibr45-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1145\/1041410.1041421"},{"key":"bibr46-14604582241259336","volume-title":"l\u2019actualit\u00e9 des nouvelles technologies de la sant\u00e9","author":"TIcSantecom","year":"2009"},{"key":"bibr47-14604582241259336","unstructured":"Postgresql 14 documentation: range types, 2022. https:\/\/www.postgresql.org\/docs\/14\/rangetypes.html"},{"key":"bibr48-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1016\/0277-9536(83)90008-4"},{"key":"bibr49-14604582241259336","doi-asserted-by":"publisher","DOI":"10.3390\/e25030420"},{"key":"bibr50-14604582241259336","doi-asserted-by":"publisher","DOI":"10.2147\/CLEP.S91125"},{"key":"bibr51-14604582241259336","doi-asserted-by":"publisher","DOI":"10.4103\/bc.bc_11_19"},{"key":"bibr52-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2011-000400"},{"key":"bibr53-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1016\/j.jbi.2019.103314"},{"key":"bibr54-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-93317-7_3"},{"key":"bibr55-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1016\/j.cmpb.2018.10.016"},{"key":"bibr56-14604582241259336","doi-asserted-by":"publisher","DOI":"10.1016\/j.cmpb.2018.12.030"}],"container-title":["Health Informatics Journal"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/journals.sagepub.com\/doi\/pdf\/10.1177\/14604582241259336","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/journals.sagepub.com\/doi\/full-xml\/10.1177\/14604582241259336","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/journals.sagepub.com\/doi\/pdf\/10.1177\/14604582241259336","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,3,1]],"date-time":"2025-03-01T18:03:23Z","timestamp":1740852203000},"score":1,"resource":{"primary":{"URL":"https:\/\/journals.sagepub.com\/doi\/10.1177\/14604582241259336"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,4]]},"references-count":56,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2024,4]]}},"alternative-id":["10.1177\/14604582241259336"],"URL":"https:\/\/doi.org\/10.1177\/14604582241259336","relation":{},"ISSN":["1460-4582","1741-2811"],"issn-type":[{"value":"1460-4582","type":"print"},{"value":"1741-2811","type":"electronic"}],"subject":[],"published":{"date-parts":[[2024,4]]},"article-number":"14604582241259336"}}