什么是OLTP和OLAP。它们之间有什么区别？ [英] What are OLTP and OLAP. What is the difference between them?

问题描述

其实它们是什么意思？我发现他们的所有文章都不会给我一个想法，或者我的知识太不足以理解它。

Actually what do they mean? All articles I find about them don't give me an idea, or my knowledge is too insufficient to understand it.

有人会给我一些资源，我可以

Will some one give me some resources with which I can learn this from scratch.

推荐答案

这里你会找到一个更好的解决方案 OLTP与OLAP

Here you will find a better solution OLTP vs. OLAP

• OLTP （在线交易处理）涉及特定系统的操作。 OLTP的特点是大量短的在线事务（INSERT，UPDATE，DELETE）。 OLTP系统的主要重点是进行非常快速的查询处理，在多访问环境中保持数据完整性，并通过每秒的事务数量来衡量有效性。在OLTP数据库中有详细和当前数据，用于存储事务数据库的模式是实体模型（通常为3NF）。

• OLTP (On-line Transaction Processing) is involved in the operation of a particular system. OLTP is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF). It involves Queries accessing individual record like Update your Email in Company database.

OLAP （在线分析处理）处理历史记录数据或档案数据。 OLAP的特点是交易量相对较低。查询通常非常复杂，涉及聚合。对于OLAP系统，响应时间是一种有效性度量。 OLAP应用程序被数据挖掘技术广泛使用。在OLAP数据库中有聚合的历史数据，存储在多维模式（通常是星型模式）中。有时查询需要在管理记录中访问大量数据，例如贵公司去年的利润。

OLAP (On-line Analytical Processing) deals with Historical Data or Archival Data. OLAP is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema). Sometime query need to access large amount of data in Management records like what was the profit of your company in last year.

这篇关于什么是OLTP和OLAP。它们之间有什么区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！