Differences between OLAP and OLTP
| OLAP | OLTP | |
|---|---|---|
| 使用场景 | 海量数据分析 | 少量数据 CRUD |
| 工作负载 | 读取密集型 | 写入密集型，支持高批次写入 |
| 可用性要求 | 低，OLAP 数据库一般不修改数据 | 高，极高频数据 CRUD |
| 目标用户 | 一般为系统内部人员用于分析 | 多为外部人员服务 |
IBM
Within the data science field, there are two types of data processing systems: online analytical processing (OLAP) and online transaction processing (OLTP). The main difference is that one uses data to gain valuable insights, while the other is purely operational. However, there are meaningful ways to use both systems to solve data problems.[1]