8 min to complete
Generally, online analytical processing (OLAP) and online transaction processing (OLTP) are two different data processing systems designed for different purposes. OLAP is optimized for complex data analysis and reporting, while OLTP is optimized for transactional processing and real-time updates.
ScyllaDB has slightly different names for the same thing:
OLTP = Interactive, requests are generated individually as a result of some interactive process (website clicking, user-specific client application)
OLAP = Batch, requests normally are part of larger computations and usually will have some dependencies, i.e – some queries will run which will determine the next set of queries to run etc…
This topic covers the Workload Types, characteristics, and real-world examples.