Which data warehouse is best?

How do I choose a data warehouse?

While the specifics are, well, specific to every company, there are six key criteria to keep in mind when choosing a data warehouse:1Cloud vs. on-prem.2Tool ecosystem.3Implementation cost and time.4Ongoing costs and maintenance.5Ease of scalability.6Support and community.Data Warehouse Selection Criteria: How To Choose the Right Storage

Which data warehousing architecture is the best?

Architecture design: Kimball or Inmon Inmon's approach is considered top down; it treats the warehouse as a centralized repository for all of an organization's data. Once there's a centralized data model for that repository, organizations can use dimensional data marts based on that model.

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.

What are the types of data warehouse?

The three main types of data warehouses are enterprise data warehouse (EDW), operational data store (ODS), and data mart.Enterprise Data Warehouse (EDW) An enterprise data warehouse (EDW) is a centralized warehouse that provides decision support services across the enterprise. ... Operational Data Store (ODS) ... Data Mart.Data Warehouse - Overview, History, Types, How It Works