SQL Rewrite | BestHub

ByteDance Data Platform

Sep 18, 2024 · Big Data

Apache Calcite for Multi‑Engine Metric Management: Practices & Roadmap

This article explains the technical principles and best practices of multi‑engine metric management based on Apache Calcite, covering common metric management methods, implementation details of unified SQL, virtual columns, and SQL defined functions, and outlines ByteDance’s future roadmap for extending these capabilities.

Apache CalciteBig DataMetric Management

0 likes · 16 min read

Apache Calcite for Multi‑Engine Metric Management: Practices & Roadmap

Java Architect Essentials

Apr 9, 2024 · Backend Development

Implementing Data Isolation in Java Applications Using MyBatis Interceptor and Custom Annotations

This article describes a Java data isolation solution that adds an 'env' field to tables, uses a MyBatis interceptor to rewrite SQL for environment‑aware queries, and introduces custom annotations with AOP to selectively skip environment checks, detailing implementation, challenges, and best practices.

AOPCustom AnnotationData Isolation

0 likes · 13 min read

Implementing Data Isolation in Java Applications Using MyBatis Interceptor and Custom Annotations

vivo Internet Technology

Mar 6, 2024 · Databases

Sharding-JDBC Source Code Analysis and Custom Development

The article dissects Sharding‑JDBC’s five core engines—parsing, routing, rewriting, execution, and merging—highlights production pain points, and details custom extensions such as skipping sharding for specific tables, forcing master routing, runtime configuration refresh, batch‑update handling, sharding‑condition deduplication, full‑route validation, and a simplified component wrapper to ease integration and improve performance.

Custom DevelopmentDatabase MiddlewareExecution Engine

0 likes · 55 min read

Sharding-JDBC Source Code Analysis and Custom Development

HelloTech

Feb 21, 2022 · Databases

Database Sharding: Partitioning Strategies, Consistent Hashing, SQL Rewrite, and Merge Engine

Database sharding improves performance by partitioning tables vertically or horizontally and routing rows with consistent hashing, while ShardingJDBC rewrites SQL for physical tables, adds missing columns, corrects pagination, splits batch inserts, and merges results using sorting, grouping, aggregation, and pagination engines.

MERGE EngineSQL Rewriteconsistent hashing

0 likes · 15 min read

Database Sharding: Partitioning Strategies, Consistent Hashing, SQL Rewrite, and Merge Engine

DevOps Cloud Academy

Nov 20, 2019 · Databases

Introducing Soar: Features, Usage Scenarios, and Practical Examples for SQL Optimization

This article introduces the open‑source SQL optimization tool Soar, explains its core features, configuration methods, heuristic rules, multiple report formats, syntax checking, SQL rewrite capabilities, EXPLAIN analysis, markdown‑to‑HTML conversion, and how to clean up test artifacts, providing concrete command‑line examples throughout.

Command LineDatabase OptimizationHeuristic Rules

0 likes · 8 min read

Introducing Soar: Features, Usage Scenarios, and Practical Examples for SQL Optimization