Data Modelling

[lcsavb]

You could take a look at Knowledge Graphs for example and model a network of Indications and Medications based on the FHIR standard. Technologies like RDF and TripleStores (Neo4j) might be efficient to store that data. An entity relationship database like postgres can do that, but not the same extent. However keep Postgres for anything that's your application (like users, requests, and pdf generation). If you untangle the logic in your knowledge base, from your application code the whole thing will be much nicer to read and maintain.

[lcsavb]

https://www.hl7.org/fhir/

[lcsavb]

[15/10 07:43] Dominik Böhler If you have not given up on building the knowledge base yourself see here: https://owlready2.readthedocs.io/en/latest/

[lcsavb]

[15/10 07:48] Dominik Böhler Some science behind it: https://www.mdpi.com/1660-4601/18/22/12025 The Prescription of Drug Ontology 2.0 (PDRO): More Than the Sum of Its Parts While drugs and related products have profoundly changed the lives of people around the world, ongoing challenges remain, including inappropriate use of a drug product. Inappropriate uses can be ex... [15/10 07:50] Dominik Böhler These two articles describe a drug prescription ontology:

Barton, A.; Fabry, P.; Ethier, J.-F. A Classification of Instructions in Drug Prescriptions and Pharmacist Documents. In Proceedings of the 10th International Conference on Biomedical Ontology (ICBO 2019), Buffalo, NY, USA, 30 July–2 August 2019; pp. 1–7. [Google Scholar]

Ethier, J.-F.; Taseen, R.; Lavoie, L.; Barton, A. Improving the Semantics of Drug Prescriptions with a Realist Ontology. In Proceedings of the International Conference on Biomedical Ontology and BioCreative (ICBO BioCreative 2016), Corvallis, OR, USA, 1–4 August 2016; Volume 1747. Available online: CEUR-ws.org (accessed on 30 September 2021). [15/10 07:51] Dominik Böhler Happy to help if you want to down that rabbit hole :-) Don't lose focus on the other classes though. [15/10 07:54] Dominik Böhler Last post :-) Here's the owl file of the ontology to load into your knowledge graph: https://obofoundry.org/ontology/pdro.html#:~:text=PDRO%20is%20a%20realist%20ontology,like%20DRON%2C%20OMRSE%20and%20OAE. OBO Foundry [15/10 08:34] Dominik Böhler Absolute last: Chapter 9 is a great way to get started by just using an existing ontology for the ICD 10 codes: https://link.springer.com/content/pdf/10.1007/978-1-4842-6552-9.pdf Ontologies with Python This book shows how to use ontologies in Python, with the Owlready2 module developed for ontology-oriented programming. You will start with an introduction and refresher on Python and OWL ontologie...