17 ms·
I do order the solution in "you should choose the simplest one that doesn't disrupt your environment" as: Use a single database for transational and analytical
by marcosdumay 6y ago
I do order the solution in "you should choose the simplest one that doesn't disrupt your environment" as:
Use a single database for transational and analytical workloads.
Replicate your transational database as is for analytical workloads.
Remodel your data and replicate to the exact same technology stack.
Remodel your data and replicate into specialized tools for analytics.
I have never seen anybody that actually needs the last one. But the largest environments I've looked are government databases with a few thousands of people working on (there are bigger envs out there).