The difference between OLAP and OLTP (fundamentals)

The concept of online analytical processing (OLAP) was first proposed by the parent of the relational database e.f.codd in 1993, and he also proposed 12 guidelines on OLAP. OLAP has aroused a great deal of repercussions, OLAP as a class of products and online transaction processing (OLTP) clearly distinguished.
Today's data processing can be broadly divided into two broad categories: online transaction processing OLTP (on-line transaction processing), online analytical processing OLAP (On-line Analytical Processing). OLTP is the main application of the traditional relational database, mainly basic, daily transaction processing, such as bank transaction.

OLAP is the main application of Data Warehouse system, supports complex analysis operations, focuses on decision support, and provides intuitive and understandable query results.

The following table lists the comparisons between OLTP and OLAP.

The difference between OLAP and OLTP (fundamentals)