Search CTRL + K

Differences between OLAP and OLTP

OLAP 系统用于分析数据内部关联,使用者多为系统内管理者。
OLTP 系统用于支撑业务系统,使用者多为外部服务人员。


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]

  1. ↩︎