How do I choose a data warehouse?

Question

While the specifics are, well, specific to every company, there are six key criteria to keep in mind when choosing a data warehouse: Cloud vs. on-prem. Tool ecosystem. Implementation cost and time. Ongoing costs and maintenance. Ease of scalability. Support and community.

What makes a good data warehouse?

A cost-effective data warehouse should be able to scale compute capacity to match demand, and then quickly and easily scale back when usage decreases. The cloud can help solve this problem, but only if the underlying architecture of the warehouse supports it.

Which approach is suitable for your data warehouse?

Only data marts are required, so Kimball's approach is suitable.

How do I choose a cloud data warehouse?

Consider the cost today and in the future. Choose a pricing structure that works with your needs so it's easy to predict the costs down the road as you scale. Consider the cost today and in the future. Choose pricing structure that works with your needs so it's easy to predict the costs down the road as you scale.

Which database is best for data warehouse?

Key takeaway: Oracle Database is best for enterprise companies looking to leverage machine learning to improve their business insights. Oracle Database offers data warehousing and analytics to help companies better analyze their data and reach deeper insights.

Expert · Answer