Shulou(Shulou.com)06/01 Report--

The difference between OLTP and OLAP

Online transaction processing OLTP (on-line transaction processing) mainly performs basic daily transactions, such as the addition, deletion, query and modification of database records. For example, a transaction in a bank is a typical transaction.

The general characteristics of OLTP are:

1. The real-time requirement is high. I remember that when I was in college, bank remittances from different places would not arrive until the next day, but now they arrive at a minute-by-minute pace, indicating that the real-time processing capacity of banks has been greatly enhanced.

two。 The amount of data is not very large, the amount of data on the production database is generally not too large, and the corresponding data processing and transfer will be done in time.

3. Transactions are generally determined, for example, the amount of bank deposits and withdrawals is certain, so OLTP accesses deterministic data

4. High concurrency and ACID principles are required. For example, two people operate a bank card account at the same time, such as tens of thousands of QPS requests from flash sale activity, a large shopping site.

Online analytical processing OLAP (On-Line Analytical Processing) is the main application of data warehouse system, which supports complex analysis operations, focuses on decision support, and provides intuitive and easy-to-understand query results. A typical application is a complex and dynamic reporting system.

The general characteristics of OLAP are:

1. The real-time requirement is not very high, for example, the most common application is sky-level update data, and then give the corresponding data report.

two。 There is a large amount of data, because OLAP supports dynamic query, so users may have to count a lot of data before they can get the information they want to know, such as time series analysis, etc., so the amount of data processed is very large.

The focus of 3.OLAP system is to provide decision support through data, so queries are generally dynamic and custom. So in OLAP, the concept of dimension is particularly important. Generally, all the dimensional data that users care about will be stored in the corresponding data platform.

Summary:

OLTP, that is, online transaction processing, is what we often call relational database, adding, deleting, querying and modifying is what we often apply, which is the basis of the database; TPCC (Transaction Processing Performance Council) belongs to this category.

OLAP, that is, online analytical processing, is the core of data warehouse, the so-called data warehouse is an analytical database for a large number of data formed by OLTP, which is used to deal with business intelligence, decision support and other important decision information; data warehouse is the processing and analysis of historical data after the database is applied to a certain program, reading more, updating less, TPCH belongs to this category.

With the advent of the era of big data, the column storage mode or nosql mode may have an advantage over the traditional row storage mode for OLAP.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.