Tag Archives: OLTP vs OLAP vs NoSQL

Categories of Databases

OLTP  is a class of systems that supports or facilitates high transaction-oriented applications it is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second.