erwin

AUGUST 15, 2022

For NoSQL, data lakes, and data lake houses—data modeling of both structured and unstructured data is somewhat novel and thorny. This blog is an introduction to some advanced NoSQL and data lake database design techniques (while avoiding common pitfalls) is noteworthy. Data Modeling.

Data Lake 52

Data Lake Modeling Unstructured Data Data Warehouse 52

AWS Big Data

JUNE 21, 2023

In traditional databases, we would model such applications using a normalized data model (entity-relation diagram). A key pillar of AWS’s modern data strategy is the use of purpose-built data stores for specific use cases to achieve performance, cost, and scale. These types of queries are suited for a data warehouse.

Data Warehouse 83

Data Warehouse Data Lake OLAP Cost-Benefit 83

Jet Global

DECEMBER 3, 2021

The term “ business intelligence ” (BI) has been in common use for several decades now, referring initially to the OLAP systems that drew largely upon pre-processed information stored in data warehouses. As the cost benefit ratio of BI has become more and more attractive, the pace of global business has also accelerated.

Business Intelligence 52

Business Intelligence Sales OLAP Data Warehouse 52

erwin

JUNE 7, 2022

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.

Data Warehouse 52

Data Warehouse Modeling Sales Data Lake 52

Sisense

NOVEMBER 12, 2020

While the architecture of traditional data warehouses and cloud data warehouses does differ, the ways in which data professionals interact with them (via SQL or SQL-like languages) is roughly the same. The primary differentiator is the data workload they serve. with a cloud data warehouse is simple.

Data Warehouse 52

Data Warehouse Data Lake OLAP Data-driven 52

IBM Big Data Hub

SEPTEMBER 25, 2023

Presto is an open source distributed SQL query engine for data analytics and the data lakehouse, designed for running interactive analytic queries against datasets of all sizes, from gigabytes to petabytes. Because of its distributed nature, Presto scales for petabytes and exabytes of data.

OLAP 91

OLAP Data Lake Data-driven Snapshot 91