The DDIA book sharing session will be shared chapter by chapter, and some details will be added based on some of my experience in distributed storage and databases in the industry. Share every two weeks or so, welcome to join, the Schedule is here . We have a corresponding distributed & database discussion group, which will be notified in the group before each sharing. If you want to join, you can add my WeChat account: qtmuniao, briefly introduce yourself, and indicate: distributed system group.

Transactional or Analytical

The term OL (Online) mainly refers to interactive queries.

There are some historical reasons for the origin of the term transaction . The early database users were mostly commercial transactions, such as buying and selling, paying wages and so on. But as database applications continue to expand, transaction\transaction remains as a noun.

Transactions do not necessarily have ACID characteristics. Transactional processing is mostly random read and write with low latency. On the contrary, analytical processing is mostly periodic batch processing with high latency.

Source: https://www.qtmuniao.com/2022/04/16/ddia-reading-chapter3-part2/