Cost-Based Optimization

DataFunTalk

Sep 24, 2023 · Databases

Insights into the Design and Challenges of Doris' New Optimizer (Nereids)

The article explains why Doris needed a new optimizer, describes its architecture—including rule‑based and cost‑based stages, early data‑size reduction techniques, dynamic‑programming join‑reorder methods, and practical challenges such as statistics errors and runtime filters—while sharing performance results and a Q&A session.

Cost-Based OptimizationDatabase PerformanceDoris

0 likes · 17 min read

Insights into the Design and Challenges of Doris' New Optimizer (Nereids)

DataFunTalk

Apr 2, 2022 · Big Data

SuperSQL: A High‑Performance Cross‑Engine, Cross‑Data‑Center SQL Middleware for Big Data

The article introduces SuperSQL, a federated SQL middleware that unifies heterogeneous data sources across multiple data centers, leverages Apache Calcite for cost‑based optimization, pushes down operators to various engines, manages metadata with a Trie model, and demonstrates significant performance gains over traditional solutions.

Cost-Based OptimizationCross-Data-CenterSQL Middleware

0 likes · 27 min read

SuperSQL: A High‑Performance Cross‑Engine, Cross‑Data‑Center SQL Middleware for Big Data

Big Data Technology Architecture

Jun 4, 2021 · Big Data

Types of OLAP Data Warehouses and Performance Optimization Techniques

This article explains the various classifications of OLAP data warehouses—including MOLAP, ROLAP, HOLAP, and HTAP—based on data volume and modeling, reviews common open‑source ROLAP products, and details performance‑boosting techniques such as MPP architecture, cost‑based optimization, vectorized execution, and storage optimizations.

Cost-Based OptimizationMPPOLAP

0 likes · 27 min read

Types of OLAP Data Warehouses and Performance Optimization Techniques

Big Data Technology Architecture

Jun 28, 2020 · Databases

Understanding OLAP Data Warehouse Types, Architectures, and Performance Optimizations

This article provides a comprehensive overview of OLAP data warehouses, covering classification by data volume and modeling, detailed explanations of MOLAP, ROLAP, HOLAP and HTAP, common open‑source implementations, and a deep dive into performance‑boosting techniques such as MPP architectures, cost‑based optimization, vectorized execution, dynamic code generation, storage compression, runtime filters and resource management.

Cost-Based OptimizationDynamic Code GenerationMPP

0 likes · 25 min read

Understanding OLAP Data Warehouse Types, Architectures, and Performance Optimizations

360 Tech Engineering

Dec 11, 2018 · Databases

Understanding Relational Optimizer and Database Statistics for SQL Performance

This article explains the fundamentals of relational optimization, the role of the cost‑based optimizer, how CPU and I/O costs are estimated, and why accurate database statistics are essential for generating efficient SQL access paths and improving overall query performance.

Cost-Based OptimizationDatabase StatisticsPerformance Tuning

0 likes · 8 min read

Understanding Relational Optimizer and Database Statistics for SQL Performance