Virtual Columns

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 CalciteMetric ManagementSQL Defined Function

0 likes · 16 min read

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

Top Architect

Dec 25, 2021 · Databases

Using MySQL JSON Data Type for Flexible Schema Design and Efficient Indexing

This article explains the MySQL JSON data type, demonstrates how to store structured and semi‑structured data with JSON objects and arrays, shows practical table designs for user login and profiling, and details virtual columns, function indexes, and multi‑valued indexes for fast querying.

Database DesignIndexingJSON

0 likes · 13 min read

Using MySQL JSON Data Type for Flexible Schema Design and Efficient Indexing

Laravel Tech Community

Dec 17, 2020 · Databases

Understanding Index Usage and Slow Queries in MySQL

This article explains why using indexes in MySQL does not always prevent slow queries, analyzes full‑index scans, index selectivity, back‑table lookups, virtual columns, and provides practical optimization techniques to reduce scanned rows and improve performance.

Database PerformanceIndexesMySQL

0 likes · 11 min read

Understanding Index Usage and Slow Queries in MySQL