90% of the data for our application is to be kept in NOSql - aws documentDB.
for the 10% data, that will be frequently accessed but updated maybe once a month, there was a proposal to use AuroraDB.
Another proposal was to avoid multiple db connectivity & different tech stack for application,**** we keep this 10% relation data in documentDB and use references.****
In future of application there is a possibility to work on reporting tools as well.
**Could someone guide me with some points that will help make this decision, from performance & security perspective as well. **
We see that DocumentDb supports references. Hence we create several collections and use references for this 10% data. Or We keep a Aurora DB - MySQL, where we work with tables and relational integrity can be enforced.
