Tagged articles

Relational Algebra

3 articles · Page 1 of 1

Apr 23, 2023 · Databases

Why SQL Still Dominates Data Analysis: From Relational Algebra to Modern OLAP

This article explains how SQL, built on relational algebra, became the standard analysis language for OLAP engines, covering its history, data models, syntax, functions, aggregation techniques, window functions, subqueries, and practical optimization considerations for modern data warehouses.

AggregationOLAPRelational Algebra

0 likes · 46 min read

Why SQL Still Dominates Data Analysis: From Relational Algebra to Modern OLAP

Big Data Technology & Architecture

Sep 22, 2022 · Databases

Apache Calcite Overview: Architecture, SQL Processing Flow, and Practical Example

This article introduces Apache Calcite as a modular data‑management framework, explains its architecture and SQL processing pipeline—from parsing and validation to relational‑algebra conversion, optimization, and execution—and demonstrates a complete CSV‑based query example with code snippets.

Apache CalciteJavaQuery Optimization

0 likes · 13 min read

Apache Calcite Overview: Architecture, SQL Processing Flow, and Practical Example

dbaplus Community

Aug 29, 2019 · Databases

Inside PostgreSQL: How Queries Are Parsed, Optimized, and Executed

This article walks through PostgreSQL’s query processing pipeline—from parsing SQL into relational algebra, through semantic analysis, query rewriting, optimization techniques like sub‑query elimination and join ordering, to the executor’s sequential scan algorithm—illustrating each step with code snippets and diagrams.

Database OptimizerPostgreSQLQuery Processing

0 likes · 14 min read

Inside PostgreSQL: How Queries Are Parsed, Optimized, and Executed