NoSql and Data-Warehouse

Aito picture Aito · Apr 21, 2010 · Viewed 31.5k times · Source

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

What concepts they share?

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.

UPDATE:

Some useful links:

2nd UPDATE:

Answer

Cade Roux picture Cade Roux · Apr 28, 2010

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