The difference between OLTP and OLAP

The difference between OLTP and OLAP

Online transaction processing OLTP (on-line transaction processing) mainly performs basic daily transaction processing, such as adding and deleting database records. A transaction record in a bank, for example, is a typical business.
The features of OLTP typically include:
1. High real-time requirements. I remember before going to college, the bank transfer, the next day to get to the account, and now is minutes to the rhythm of the account, the current bank's real-time processing capacity greatly enhanced.
2. The amount of data is not very large, the volume of data on the production database is generally not too large, and will be timely to do the corresponding data processing and transfer.
3. Transactions are generally deterministic, such as the amount of bank deposits and withdrawals is definitely determined, so OLTP is a deterministic data access
4. High concurrency and requires the acid principle to be met. For example, two people operate a bank card account at the same time, such as tens of thousands of QPS requests when a large shopping site kills.

OLAP (On-line Analytical Processing) is the main application of the Data Warehouse system, supports complex analysis operations, focuses on decision support, and provides intuitive and understandable query results. A typical application is a complex, dynamic reporting system.

Typical features of OLAP are:
1. Real-time requirements are not very high, such as the most common application is the day-level update data, and then out of the corresponding data report.
2. The amount of data is large, because OLAP supports dynamic query, so the user may have to get a lot of data after the statistics to obtain the information they want to know, such as time series analysis, etc., so the amount of data processed is very large;
The focus of the 3.OLAP system is to provide decision support through data, so queries are generally dynamic and customizable. So in OLAP, the concept of dimension is particularly important. In general, all the user-concerned dimension data will be stored in the corresponding data platform.

Summary:
OLTP is online transaction processing, is what we often say the relational database, adding and deleting is what we often apply, this is the basis of the database; TPCC (Transaction Processing Performance Council) belongs to this class.
OLAP is online analytical processing, is the core of the Data warehouse, the so-called Data Warehouse is a large number of OLTP-formed data of an analytical database for processing business intelligence, decision support and other important decision-making information The Data warehouse is the processing and analysis of the historical data after the database is applied to certain program, and the tpch belongs to this kind of reading and updating.
with the advent of the big data age, it is possible for OLAP, Columnstore mode, or NoSQL mode to be more advantageous than the traditional means of row storage.