The week of the first presentations

This has been a good week. I have been getting a lot of coding done but the highlight of the week was the presentations. It was very nice to finally hear the voices of some of the other interns as well as learning about them and the projects they are working on. I am really excited about all the work we are doing and it sounds like everyone is working hard and has some very important work going on for the OpenMRS community.

Here is some of the information I presented about my project:

Project name: Concept Management Tools App

The goal of the project is to create some simple tools for the users by using the Concept Dictionary Data and mappings to terminology in systems such as SNOMED.

Step 1

Create mappings to systems such as SNOMED by downloading all the concepts missing this mapping and creating a csv file for the users to fill out and then upload it back into the system to capture in the database

Step 2

Once the mappings between the SNOMED data and our concepts have been captured we need to add the IS_A relationships to the database.
We can do this by creating a tool that lets you populate the concept_reference_term table with all the concepts in a given concept source by uploading a CSV.
Then we can create a tool that lets you populate the concept_reference_term_map table with relationships between terms
For example, by allowing the uploading of the SNOMED hierarchy files distributed by NLM.

IS_A Example:
pneumonia IS_A disease so pneumonia would be a child of disease and bacterial pneumonia IS_A pneumonia
This makes bacterial pneumonia a child of pneumonia and bacterial pneumonia and pneumonia are both subsets of disease with disease being the root concept.

Step 3

Finally we will create a view that will allow us to see the hierarchical relationships between the concepts with the IS_A child parent relationships

Things I think would be exciting to use this for in the future:

Being able to view the IS_A relationships with the concepts in a hierarchy can help in decision support to minimize the risk of costly errors in treatment .

Having data mapped to systems such as SNOMED provides us with the ability to discover patterns and relationships with concepts that can aid in research and development. Such as, researching the effectiveness of different approaches to disease management and treatment.

Progress this week:

I am finishing up a database query and making sure it works. Then, I am going to make sure I have all of my validations in place. After that I will work with Wyclif to get the first step ready to be tested by Ellen Ball.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s