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 57

OLAP Slice and Dice Cost-Benefit Data Warehouse 57

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 86

OLAP Data Lake Data-driven Online Analytical Processing 86

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 91

Data Warehouse Data Lake OLAP Cost-Benefit 91

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

JANUARY 15, 2021

These benefits come with a caveat, however. In this respect, we often hear references to “switching costs” and “stickiness.” When the cost of switching to a new product is high, customers tend to remain where they are. Ultimately, though, switching costs are not so much about absolute numbers as they are about relative costs.

Cost-Benefit 72

Cost-Benefit Data Lake Reporting OLAP 72

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

AWS Big Data

AUGUST 1, 2024

These challenges can range from ensuring data quality and integrity during the migration process to addressing technical complexities related to data transformation, schema mapping, performance, and compatibility issues between the source and target data warehouses.

Data Warehouse 100

Data Warehouse KPI Optimization Cost-Benefit 100