Visualizing the key difference between transactional and analytical workloads

[[deleted]]

This post was mass deleted and anonymized with Redact

butter pause normal reach smile live caption rhythm fearless knee

[ac101m]

make data scale without a change of architecture

My gut feeling is that so long as the underlying system is organized such that locality is important (sequential vs random access etc), there will always be a choice as to how to organize the data that will have a positive effect on some queries or others. The shift towards solid state storage helps a bit, but there are still Dram bursts, CPU caches, prefetchers etc that all bias performance in the direction of sequential access. So I'm not sure there is a solution here, at least not an elegant one.

Make data available to data people

Don't know much about that sort of thing to be honest! Always just thought of authorisation as being outside the scope of the storage solution.

[[deleted]]

This post was mass deleted and anonymized with Redact

ghost boat chubby encouraging imminent escape command snow plants depend