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

This article shows you what is the difference between OLTP and OLAP. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1. Today's data processing can be roughly divided into two categories:

Online transaction processing On-Line Transaction Processing

Online analytical processing On-Line Analytical Processing

2. The difference between the two characteristics determines the emphasis on the demand for resources.

01-1 OLTP (a large number of short transactions in real-time trading library require high IO)

1. Transaction-oriented real-time processing system OLTP

OLTP is the main application of traditional relational database, mainly basic, daily transaction processing, recording instant add, delete, change, query, such as deposit a sum of money in the bank, is a transaction transaction.

Also known as real-time system (Real time System). One of the important performance indicators of the online transaction processing system is the system performance, which is embodied in the real-time response time (Response Time), that is, the time it takes for the user to reply to the request after the user sends the data on the terminal.

II. Characteristics of OLTP

1. High real-time requirements

The OLTP database is designed to enable transactional applications to write only the data they need so that individual transactions can be processed as soon as possible.

2. The amount of data is not very large

3. Transactions are generally determined, so OLTP accesses deterministic data (for example, deposits and withdrawals have a specific amount).

4. Support a large number of concurrent users to add and modify data on a regular basis.

Concurrency is demanding and strictly requires the integrity and security of the transaction (for example, it is possible that you and your family withdraw money from the same account in different banks at the same time).

01-2 OLAP (data warehouse reading and analysis requires high CPU)

The so-called data warehouse is a kind of analytical database which reads more and updates less for a large number of historical data processing and analysis formed by OLTP, which is used to deal with business intelligence, decision support and other important decision information.

A brief introduction to OLAP

OLAP (online Analytical processing) is the core of data warehouse, supporting complex analysis operations, focusing on decision support, and providing intuitive and easy-to-understand query results. A typical application is a complex dynamic report system.

Interested friends might as well take a look at the scientific research, education, culture and health systems. They generally have a statistical analysis software called SPSS (the world's earliest statistical analysis software). There is an "analysis" project on the menu, and the first item to drop down is OLAP.

2. The characteristics of OLAP are generally as follows:

1. The real-time requirement is not very high, and many applications update the data at most every day.

2. 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.

3. Because the focus is on decision support, the query is generally dynamic, that is to say, users are allowed to make query requirements at any time. So in OLAP, an important concept "dimension" is used to build a dynamic query platform (or technology) for users to decide what information they need to know.

III. Product introduction of major OLAP manufacturers

1. Hyperion (acquired by Oracle) EssbaseOLAPServer

2. Cognos (acquired by Oracle) PowerPlay provides a comprehensive reporting and analysis environment for business efficiency evaluation BPM (BusinessPerformanceMeasurement). Provide decision makers with a variety of key data on the operational efficiency of the enterprise, and conduct a variety of analysis.

3. BusinessObjects is an easy-to-use BI tool that allows users to access, analyze and share data.

Second, the different characteristics determine the emphasis on the demand for resources.

OLTP and OLAP are different mainly by the following five points.

1. The orientation of users and systems:

OLTP is customer oriented and is used for transaction and query processing

OLAP is market-oriented and used for data analysis

2. Data content:

OLTP system manages current data

OLAP system manages a large amount of historical data and provides a mechanism for aggregation and aggregation.

3. Access mode:

The access of OLTP system is mainly composed of short atomic transactions, which requires parallel and rollback recovery mechanisms.

Most of the access to OLAP system is read-only.

4. View:

Current data within the OLTP organization, not involving historical data or data from different organizations

OLAP is on the contrary.

5. Database design:

OLTP adopts entity-relation ER model and application-oriented database design.

OLAP adopts star or snowflake model and topic-oriented database design.

What is the difference between OLTP and OLAP? have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.