article thumbnail

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

erwin

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.

article thumbnail

Materialized Views in Hive for Iceberg Table Format

Cloudera

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.

article thumbnail

Multiplicity: Succeed Awesomely At Web Analytics 2.0!

Occam's Razor

My first eMetrics summit was June 2003 and as a young inexperienced person new in the field it was a great learning experience (eMetrics in Santa Barbara were the best!). The concept was brutal in its simplicity: The web is different and the reason was the existences of multiple constituencies, tools and types of data sources.