什么是 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 vs. 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屋！