OLTP and OLAP

Source: Internet
Author: User
The differences between online transaction processing (OLTP) and Online Analytical Processing (OLAP) are mainly distinguished by the following five points. User and system orientation: OLTP is customer-oriented, and OLAP is market-oriented for transaction and query processing. It is used for data analysis. data content: OLTP system manages current data. the OLAP system manages a large amount of historical data and provides a collection and aggregation mechanism.

The differences between online transaction processing (OLTP) and Online Analytical Processing (OLAP) are mainly distinguished by the following five points. User and system orientation: OLTP is customer-oriented, and OLAP is market-oriented for transaction and query processing. It is used for data analysis. data content: OLTP system manages current data. the OLAP system manages a large amount of historical data and provides a collection and aggregation mechanism.

The differences between online transaction processing (OLTP) and Online Analytical Processing (OLAP) are mainly distinguished by the following five points.
User and system orientation:
OLTP is customer-oriented and used for transaction and query processing.
OLAP is market-oriented and used for data analysis
Data content:
The OLTP system manages the current data.
The OLAP system manages a large amount of historical data and provides a collection and aggregation mechanism.
Database Design:
OLTP adopts the entity-contact ER model and application-oriented database design.
OLAP adopts the star or snowflake model and topic-oriented database design.
View:
OLTP focuses on the current data of an enterprise or department, and does not involve historical data or data of different organizations.
OLAP is the opposite.
Access Mode:
OLTP system access is mainly composed of short atomic transactions, which require parallel and recovery mechanisms.
Access to OLAP systems is mostly read-only.


OLTP is the main application of traditional relational databases, mainly for basic and daily transaction processing, such as bank transactions.
OLAP is the main application of the data warehouse system. It supports complex analysis operations, focuses on decision support, and provides intuitive and easy-to-understand query results.

The following table lists the comparison between OLTP and OLAP:
OLTP

OLAP

User

Operator and lower-level management personnel

Decision makers and senior management personnel

Function

Routine operations

Analysis and decision-making

DB Design

Application-oriented

Subject-oriented

Data

Latest, detailed, two-dimensional, discrete

Historical, aggregated, multidimensional, and integrated

Access Scale

Read/write several (or even several hundred) records

Reads millions or even hundreds of millions of records

Operation Frequency

Very frequent (in seconds)

Relatively loose (in hours or even weeks)

Work Unit

Strict transactions

Complex Query

Number of users

Hundreds to tens of millions

Several-hundreds

DB size

100MB-GB

100GB-TB

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.