27 Mar
2017
27 Mar
'17
5:41 p.m.
Hi!
Forgive me if this is radical, but has anyone thought of / discussed using a NoSQL alternative to our very normalized SQL db as a way to avoid the problem of aggregating details? Using mongodb as an example, embed some of the smaller objects, and there's no cost of aggregation there. IIRC, Doctor REST uses mongo under the hood.
https://docs.mongodb.com/manual/tutorial/model-embedded-one-to-many-relation...
What about data integrity that is critical to us? Shmuel