OLTP

What does OLTP stand for?

Online Transactional Processing is a data processing mechanism that handles large volumes of consecutive transactions at speed. OLTP is used for transactional databases, at the core of businesses operations, with constant updates, many users accessing data, the need for fast response times and high availability. In contrast is OLAP processing, which is a read-only data process optimized for analytical queries. Data can be moved from OTLP databases to OLAP databases via ETL.