article thumbnail

How Etihad taps data science to optimise airline operations

CIO Business Intelligence

Despite the worldwide chaos, UAE national airline Etihad has managed to generate productivity gains and cost savings from insights using data science. Etihad began its data science journey with the Cloudera Data Platform and moved its data to the cloud to set up a data lake. Reem Alaya Lebhar.

article thumbnail

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

erwin

Static over-provisioning or dynamic scaling will run up monthly cloud costs very quickly on a bad design. So, you really should get familiar with your cloud providers sizing vs. cost calculator. It shows pricing for a data warehousing project with just 4 TBs of data, small by today’s standards. Look at Figure 1 below.

article thumbnail

Materialized Views in Hive for Iceberg Table Format

Cloudera

year_total_mv1 ]) The above CBO (cost based optimizer) plan shows that only the year_total_mv1 materialized view is scanned and a filter condition applied since the range filter in the query is a subset of the range in the materialized view. Overall, across all queries, the average reduction in total elapsed time was 40%.