Olap Articles

Page 1 of 1 (4 articles)

5/2/2025 • EN

Introduction to Data Engineering Concepts | Data Modeling Basics

An introduction to data modeling concepts, covering OLTP vs OLAP systems, normalization, and common schema designs for data engineering.

Data Engineering Data Modeling Database Design Olap Oltp

Alex Merced

2/3/2024 • EN

Columnar vs. Row-based Data Structures in OLTP and OLAP Systems

Compares columnar vs. row-based data structures, explaining their optimal use in OLAP and OLTP systems for performance and scalability.

Columnar Storage data structures Database Design Olap Oltp

Alex Merced

6/20/2022 • EN

Introduction to The World of Data - (OLTP, OLAP, Data Warehouses, Data Lakes and more)

An introduction to modern data systems, explaining OLTP, OLAP, data warehouses, data lakes, and the roles of data engineers, analysts, and scientists.

Data Engineering Data Lakes Data Warehousing Olap Oltp

Alex Merced

3/18/2021 • EN

What is Batch and Streaming Data? (Data 101)

Explains the differences between batch and streaming data processing, covering OLTP, OLAP, and ETL concepts for data engineers.

Batch Processing Etl Olap Oltp Streaming Data

Alex Merced

Olap Articles

Introduction to Data Engineering Concepts | Data Modeling Basics

Columnar vs. Row-based Data Structures in OLTP and OLAP Systems

Introduction to The World of Data - (OLTP, OLAP, Data Warehouses, Data Lakes and more)

What is Batch and Streaming Data? (Data 101)

Select Language