Propose a Design Forum Topic

[darius (Darius Jazayeri)]

On Monday March 19 I would like to discuss this on an OpenMRS design call:

Creating a Bahmni Mart database for analytics

Hi, The database used in Bahmni/Openmrs has an EAV data model, and hierarchical data (For Ex: Obs table). This makes it difficult to plugin the database to any analytical tools (Tableau, Strata etc) as unstructured hierarchical data is limited and multiplies existing complexity. In order for implementation engineers to extract data from the existing production databases is said to be very difficult without totally understanding the openmrs data model. For an implementation to generate indicator…

Specifically, this is work that a team is about to start doing for a Bahmni implementation project, and they’re asking for design feedback up front, when it’s easier to incorporate. And so that the output can be more generally useful for Bahmni (and presumably for OpenMRS too).

FYI @mseaton, @mksd, @jdick , @nkimaina, @pramidat

(Also FYI @paynejd since this will preemput our scheduled OCL discussion. But I promise to send some mockups soon.)