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-relat...