3 ms·
OLAP vs OLTP is more than just read vs write -heavy or column vs row -oriented (although it certainly is those things). RDBMSs used for OLTP also provide consi
by advisedwang 4y ago
OLAP vs OLTP is more than just read vs write -heavy or column vs row -oriented (although it certainly is those things).
RDBMSs used for OLTP also provide consistency and transaction semantics, which are critical to application correctness, but not needed for OLAP uses.
- gavinray 4y agoRealistically what OLAP DBs do you know that don't provide correctness guarantees too though? For example: https://cloud.google.com/bigquery/docs/reference/standard-sql/transactions https://cloud.google.com/bigquery/docs/reference/standard-sq...
- advisedwang 4y agoTrue transaction semantics are rare in OLAP world. As for BigQuery: > If a transaction mutates (update or deletes) rows in a table, then other transactions or DML statements that mutate rows in the same table cannot run concurrently. Kind of a non-starter.
- jimcavel888 4y agoAlmost none that are less than $500k/year to rent, next to none.