数据库和数据仓库之间有什么区别？ [英] What is the difference between a database and a data warehouse?

问题描述

数据库和数据仓库之间有什么区别？

What is the difference between a database and a data warehouse?

它们不是同一件事，还是至少是用同一件事写的（即Oracle） RDBMS）？

Aren't they the same thing, or at least written in the same thing (ie. Oracle RDBMS)?

推荐答案

查看此以获取更多信息。

来自上一个链接：

数据库

1. 用于在线事务处理（ OLTP ），但可以用于其他目的，例如数据仓库。这会记录用户的历史数据。


2. 表和联接很复杂，因为它们已经标准化（对于 RDMS ）。这样做是为了减少冗余数据并节省存储空间。


3. 实体–关系建模技术用于RDMS数据库设计。


4. 针对写入进行了优化


5. 分析查询的性能较低。

1. Used for Online Transactional Processing (OLTP) but can be used for other purposes such as Data Warehousing. This records the data from the user for history.
2. The tables and joins are complex since they are normalized (for RDMS). This is done to reduce redundant data and to save storage space.
3. Entity – Relational modeling techniques are used for RDMS database design.
4. Optimized for write operation.
5. Performance is low for analysis queries.

数据仓库

1. 用于在线分析处理（ OLAP ）。这将读取用户的历史数据以进行业务决策。


2. 表和联接很简单，因为它们已被非规范化。这样做是为了减少分析查询的响应时间。


3. 数据–建模技术用于数据仓库设计。


4. 针对读取操作进行了优化。


5. 分析查询的高性能。


6. 通常是一个数据库。

1. Used for Online Analytical Processing (OLAP). This reads the historical data for the Users for business decisions.
2. The Tables and joins are simple since they are de-normalized. This is done to reduce the response time for analytical queries.
3. Data – Modeling techniques are used for the Data Warehouse design.
4. Optimized for read operations.
5. High performance for analytical queries.
6. Is usually a Database.

同样要注意的是，数据仓库可以从零到许多数据库中获取。

It's important to note as well that Data Warehouses could be sourced from zero to many databases.

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