Author
Siobhán O'Malley
A Senior Writer who dissects the latent logic of predicate pushdown and the complexities of view merging. She is passionate about helping readers visualize the cascading application of rules within execution plans to optimize intermediate result sets.
8 Articles
Articles by
Siobhán O'Malley
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Optimizing Distributed SQL: The Challenge of Query Mechanics in Cloud-Native Environments
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
The Transition from Rule-Based to Cost-Based Optimization: Oracle Case Study
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
Evolution of Predicate Pushdown: From Algebraic Rules to Distributed Execution
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Heuristics vs. Genetics: The Join Order Problem in PostgreSQL GEQO
Execution Plan Analysis and Visualization
All rights reserved to analyzequery.com
From System R to Modern CBO: The Legacy of Pat Selinger's 1979 Framework
Cost-Based Optimization Models
All rights reserved to analyzequery.com
Distributed CBO: Cost Models in Apache Spark and BigQuery Architecture
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com
The Rise of Star Schema Transformation: 1990s Data Warehousing and Bitmap Indexes
Algebraic Transformations and Query Rewriting
All rights reserved to analyzequery.com