3 ms·
Yes it does describe a technological difference. Specifically, the kind of tasks that they are good for. My very crude shorthand is that olap == optimized for
by pm90 6y ago
Yes it does describe a technological difference. Specifically, the kind of tasks that they are good for.
My very crude shorthand is that olap == optimized for time series (usually column oriented) and oltp == optimized for transactional processing (row oriented).
- CharlesW 6y agoThe "description of the uses cases" answer can also be a reasonable shorthand for databases which support both, which allows the DBA to optimize on a table-by-table (and even column-by-column) basis.