6 ms·
Does OLAP vs OLTP describe a real technological difference or just a description of the use cases a specific tool is trying to address?
by jolux 6y ago
Does OLAP vs OLTP describe a real technological difference or just a description of the use cases a specific tool is trying to address?
- gigatexal 6y agoGenerally OLAP databases are columnar or otherwise optimized for batch and aggregations.
- pm90 6y agoYes 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.