Microsoft, as well as many other service providers, have listed the concepts of the modern data warehouse as follows:
Here are some of the many features a modern data warehouse should have:
- Integration of relational as well as non-relational sources: The data warehouse should be able to ingest data that is not easily integrable in the traditional data warehouse, such as big data, non-relational crunched data, and so on.
- Hybrid deployment: The data warehouse should be able to extend the data warehouse from on-premises storage to the cloud.
- Advanced analytics: The data warehouse should be able to analyze the data from ...