BestHub
Sign in
Tagged articles
7 articles
Page 1 of 1
ByteDance Data Platform
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 DataSQL Defined Function
0 likes · 16 min read
Apache Calcite for Multi‑Engine Metric Management: Practices & Roadmap
Java Architect Essentials
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.

BackendCustom AnnotationData Isolation
0 likes · 13 min read
Implementing Data Isolation in Java Applications Using MyBatis Interceptor and Custom Annotations
vivo Internet Technology
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
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 RewriteVertical Partitioning
0 likes · 15 min read
Database Sharding: Partitioning Strategies, Consistent Hashing, SQL Rewrite, and Merge Engine
DevOps Cloud Academy
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
dbaplus Community
dbaplus Community
Jan 10, 2017 · Databases

How I Fixed a Sudden Oracle SQL Slowdown by Binding Execution Plans (And What Went Wrong)

When a critical Oracle query suddenly slowed down on regional databases while the central server remained fast, I diagnosed the issue, discovered execution‑plan differences caused by missing predicate push‑down, attempted a plan‑binding solution, faced unexpected failures, and ultimately rewrote the SQL using a WITH clause to meet a tight deadline.

Database PerformanceOraclePredicate Pushdown
0 likes · 11 min read
How I Fixed a Sudden Oracle SQL Slowdown by Binding Execution Plans (And What Went Wrong)