NoSql and Data-Warehouse

Question

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:

• Integrating NoSQL in the Data Warehouse
• NoSQL and Data Warehousing
• Are You Ready for Big Data?

2nd UPDATE:

• MongoDB, BI and Non-Relational Databases

question from:https://stackoverflow.com/questions/2684462/nosql-and-data-warehouse

Answer 1

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.