NoSql 和数据仓库

问题描述

NoSql 和 Data-Warehouse 技术/理论之间有什么关系?

What are the relations between NoSql and Data-Warehouse technologies/theories?

他们共享什么概念?

它们之间的基本区别是什么?

What are the basic differences between them?

您如何看待彼此之间的好处/丰富?

How do you think each could be benefits/enriches from the other?

我认为您的想法应该对这两种技术的未来都有帮助.

I think your ideas should be helpful for the future of both technologies.

更新:

一些有用的链接:

• 在数据仓库中集成 NoSQL
• NoSQL 和数据仓库
• 您准备好迎接大数据了吗?

第二次更新:

• MongoDB、BI 和非关系数据库

推荐答案

数据仓库与 NoSQL 几乎没有共同之处 - 主要相似之处在于，任何两个数据仓库都可以有非常不同的理念或约定，就像任何两个 NoSQL 系统一样几乎不相关.

Data Warehouses have very little in common with NoSQL - the main similarity is that any two data warehouses can have very different philosopohies or conventions just like any two NoSQL systems can be nearly unrelated.

它们的唯一共同概念是它们都用于分析大量数据.

The only concept they share is that they are both used to analyze large amounts of data.

NoSQL 解决方案通常在少数实体中管理具有较大基数的相对有限的模式，而数据仓库通常在 3NF 模型中具有大量事实和维度(在维度模型中)或大量实体.DW 系统通常管理多个业务线并尝试合并这些数据.

NoSQL solutions usually manage relatively limited schemas with large cardinality in few entities, while data warehouses typically have lots of facts and dimensions (in a dimensional model) or lots of entities in a 3NF model. DW systems usually manage multiple lines of business and attempt to combine that data.

DW 系统通常在 SQL 中具有报告功能，允许您以标准方式访问所有数据.NoSQL 系统通常更基于代码 - 例如 Map/Reduce.

DW systems typically have reporting abilities in SQL which allows you to access all the data in a standard way. NoSQL systems are typically more code-based - for instance Map/Reduce.

这篇关于NoSql 和数据仓库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！