2003, Data Lake, Data Warehouse and Optimization

Data Modeling 201 for the cloud: designing databases for data warehouses

erwin

JUNE 7, 2022

Designing databases for data warehouses or data marts is intrinsically much different than designing for traditional OLTP systems. Accordingly, data modelers must embrace some new tricks when designing data warehouses and data marts. Figure 1: Pricing for a 4 TB data warehouse in AWS.

Data Warehouse

Data Warehouse Modeling Sales Data Lake

Materialized Views in Hive for Iceberg Table Format

Cloudera

FEBRUARY 8, 2024

Cloudera Data Warehouse (CDW) running Hive has previously supported creating materialized views against Hive ACID source tables. release and the matching CDW Private Cloud Data Services release, Hive also supports creating, using, and rebuilding materialized views for Iceberg table format.

Snapshot

Snapshot Metadata Cost-Benefit Data Warehouse

Data Leaders Brief

Data Modeling 201 for the cloud: designing databases for data warehouses

Materialized Views in Hive for Iceberg Table Format

Webinars

Stay Connected