Consider hybrid database implementation utilizing SQL for transactional and NoSQL for logging, auditing, BI/Big-Data, Fraud and Rules

[elnyry-sam-k]

Consider hybrid database implementation utilizing SQL for transactional and NoSQL for logging, auditing, BI/Big-Data, Fraud and Rules

kevin-biot's comment:
All these activities should not be on the main transaction database. Better to simply allow a full or selective sync copy of transaction DB where reports etc are generated from. Lessens risks for operational staff initiating weird and wonderful reports that could hose the transaction DB.

Miller's comment:
In the case of the forensic log, the ability to generated sealed reports should be available without loading the transaction system. The KMS would be touched to verify horizontal log entries, after they are selected, and as they are added to the report, and again to seal the report with a vertical signature. Likewise, reports can be verified via a service that can touch the KMS to verify report signatures and flag report that have been tampered with. This activity should also be outside the transaction system.

old issue - https://github.com/mojaloop/mojaloop/issues/65