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

Jet Global

OCTOBER 7, 2020

Writing fresh reports requires deploying data entities, customizing them, and sometimes even creating new data entities from scratch with custom programming. Data entities are accessed using the OData protocol. In the future, customers will be able to deploy Data Entities and replicate transactional tables in an Azure Data Lake.

Data Warehouse 90

Data Warehouse OLAP Reporting Finance 90

IBM Big Data Hub

DECEMBER 7, 2023

Online analytical processing (OLAP) database systems and artificial intelligence (AI) complement each other and can help enhance data analysis and decision-making when used in tandem. As AI techniques continue to evolve, innovative applications in the OLAP domain are anticipated.

OLAP 58

OLAP Slice and Dice Cost-Benefit Data Warehouse 58

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

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

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 87

OLAP Data Lake Data-driven Snapshot 87