# Design Forum 2018-03-19: Create a Bahmni Mart Database for Analytics **URL:** \ **Category:** Development\ **Tags:** meetings, design-forum\ **Created:** [March 19, 2018, 1:41pm UTC](https://talk.openmrs.org/t/design-forum-2018-03-19-create-a-bahmni-mart-database-for-analytics/17001 "2018-03-19T13:41:02Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![jthomas](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jthomas/32/21_2.png) [@jthomas](https://talk.openmrs.org/u/jthomas)\ **Post date:** [March 19, 2018, 1:41pm UTC](https://talk.openmrs.org/t/design-forum-2018-03-19-create-a-bahmni-mart-database-for-analytics/17001/1 "2018-03-19T13:41:02Z")
Today’s [design forum](https://wiki.openmrs.org/display/RES/Design+Forum) is on Creating a Bahmni Mart Database for Analytics. If you have a topic you would like to discuss during the call please post it at [Propose a Design Forum Topic - Development - OpenMRS Talk](http://om.rs/designtime) or join us from 4-5 pm UTC. > [@Creating a Bahmni Mart database for analytics](https://talk.openmrs.org/t/creating-a-bahmni-mart-database-for-analytics/16800?source_topic_id=11596): > > 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… FYI @mseaton, @mksd, @jdick , @nkimaina, @pramidat The next design forum on Wednesday, March 21 @ 6-7 pm UTC - Moving Event Logic to Event Module > [@Sync 2.0 Planning](https://talk.openmrs.org/t/sync-2-0-planning/11799/40): > > A few quick thoughts: If we can’t use the event module for this…what exactly is the purpose of the event module? If we think the implementation of the event module is buggy, then we should fix the implementation, right? It would be nice for us to deal with hibernate interceptor messiness once, and do it properly, in the event module, and then for us to rely on that for a way to publish / subscribe to changes. Presumably, there could be an Event listener that we support which would simply h… To join the call using Audio, Chat, & Screen Sharing please use the latest Firefox, Chrome, or other WebRTC-compatible browser and go to: > **[Dialpad Ai Meetings](https://meetings.dialpad.com/openmrs)** > > With HD video, crystal-clear audio, and built in voice intelligence, Dialpad Ai Meetings helps you connect with colleagues and clients around the world hassle-free.