Using a relational database to index infectious disease information

Int J Environ Res Public Health. 2010 May;7(5):2177-90. doi: 10.3390/ijerph7052177. Epub 2010 May 4.

Abstract

Mapping medical knowledge into a relational database became possible with the availability of personal computers and user-friendly database software in the early 1990s. To create a database of medical knowledge, the domain expert works like a mapmaker to first outline the domain and then add the details, starting with the most prominent features. The resulting "intelligent database" can support the decisions of healthcare professionals. The intelligent database described in this article contains profiles of 275 infectious diseases. Users can query the database for all diseases matching one or more specific criteria (symptom, endemic region of the world, or epidemiological factor). Epidemiological factors include sources (patients, water, soil, or animals), routes of entry, and insect vectors. Medical and public health professionals could use such a database as a decision-support software tool.

Keywords: decision support; differential diagnosis; early detection; indexing information; infectious diseases; knowledge mapping; public health informatics; relational database.

MeSH terms

  • Communicable Diseases*
  • Database Management Systems*
  • Diagnosis, Differential
  • Humans
  • Information Storage and Retrieval*