Skip to content
Tagged articles

SQL rewriting

3 articles · Page 1 of 1
JD Tech
JD Tech
Oct 15, 2026 · Databases

Building a Custom Database Sharding Component with MyBatis: Migration Strategies & SQL Rewriting

This article details the design and implementation of a custom database sharding component built on MyBatis plugin architecture, covering sharding strategies, read/write policies (double-write/double-read), SQL parsing and rewriting for COUNT/SUM/ORDER BY, routing algorithms with distributed locks, parameter mapping handling, and solutions to migration challenges like ORDER BY alias errors and aggregate query merging.

MyBatis pluginSQL rewritingdata migration
0 likes · 25 min read
Building a Custom Database Sharding Component with MyBatis: Migration Strategies & SQL Rewriting
Youzan Coder
Youzan Coder
Jan 18, 2019 · Information Security

Security Architecture and Data Masking in a Big Data Platform

The article outlines Youzan’s evolving security architecture for its big‑data platform—starting with Apache Ranger‑based permission control, moving to a centralized permission‑management service for easier requests and audits, and finally implementing column‑level masking via SQL rewriting to protect sensitive data while balancing usability.

Column MaskingSQL rewritingaccess control
0 likes · 10 min read
Security Architecture and Data Masking in a Big Data Platform