samuelabebayehu/openmrs-module-mamba-core

# openmrs-module-mamba-core ## **Background** MambaETL (or simply known as Mamba) is an OpenMRS (Open Electronic Medical Records System) implementation of data Extraction, Loading and Transforming (ETL) of data into a more denormalised format for faster data retrieval and analysis. OpenMRS stores patient observational data in a long format. Essentially, for each encounter type for a given patient, multiple rows are saved into the OpenMRS Obs table. Sometimes as many as 50 or more rows saved for a single encounter in just the Obs table. This means that the Obs table quickly grows to millions of records in fairly sized facilities making reporting and any analysis on such data incredibly slow and difficult. ## **Purpose of this project** The `openmrs-module-mamba-core` or simply called the MambaETL Core module is an OpenMRS module that is a library collection of familiar artefacts/tooling that collectively offer out-of-the box database flattening/transposing and abstraction of repetitive reporting tasks so that implementers, analysts, data scientists or teams building reports focus on building without worrying about system performance bottlenecks or bothering too much about how the data is extracted from the primary data source into the reporting destination. `openmrs-module-mamba-core` is supposed to be a dependency used in any OpenMRS module that seeks to leverage the functionality of MambaETL. One such example module that shows how to use `openmrs-module-mamba-core` is the quick start or example module found here: Artefacts in this module include: * SQL scripts (functions, views & stored procedures), * An automation engine/bash/shell scripts, * Maven configurations (Maven 3.1.0 & above), * Java functionality (JAVA 7 & above) ## **How to use the module** This module is intended to be added or included in your main reporting or ETL module as a dependency library (more on this later). We have developed a reference/quick-start or template module called openmrs …