←
Back to Projects
Case Study · Enterprise RDBMS · DBA · Engine Internals
Database Administration & DB Engineering
View Details on GitHub
Overview
Core Skills
DB Administration
SQL Tuning
Cost-Based Optimization
Statistics
SQL • PL/SQL
C/C++
3+
Production Issues / Week
ms
Latency Target
SPM
Plan Stability
CBO
Optimizer Logic
1. Production DB Performance Engineering
Representative Customer Environments
Typical Problems
How I Solved Them
2. RDBMS Engine Design & Implementation
Optimizer / Statistics
Product Features
Engine Modernization
RDBMS Optimization Architecture
SQL Parser
Optimizer
Statistics
SPM
Execution Plan
SQL Input
SQL Parser
Query Optimizer
Execution Engine
Statistics Manager
SQL Tuning Advisor
SQL Plan Management
Candidate Plan Generation · Cost Model · Cardinality Estimation
Baseline Enforcement · Plan Stability · Evolution
Context
Approach & Outcome
Case Studies
Case 1. SQL Plan Management (SPM)
Product Feature
Problem
Implementation
Outcome
Case 2. Join Performance Optimization
Optimizer Logic
Problem
Implementation
Measured Outcome
PK-FK Join
5s → 1s
OR Join Filter
3s → 0.8s
Partition Pruning
827.13ms → 27.24ms
Case 3. Production DB Performance Engineering & Engine Modernization
DBA + Engine
Production Performance Engineering
Engine Modernization
Conclusion