BestHub
Sign in
Tagged articles
2782 articles
Page 19 of 28
Code Ape Tech Column
Code Ape Tech Column
Feb 24, 2021 · Databases

Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines

This article translates and expands on a HikariCP wiki post, explaining why smaller database connection pools often yield better performance, presenting benchmark videos and data, describing the underlying CPU, disk, and network constraints, and offering a simple formula to calculate an optimal pool size for typical server configurations.

Connection PoolDatabase PerformanceHikariCP
0 likes · 9 min read
Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines
Java Backend Technology
Java Backend Technology
Feb 23, 2021 · Databases

Why Misplaced Quotes Turn MySQL Updates into Zeroes – A Deep Dive

This article explains how incorrectly placed double‑quotation marks in MySQL UPDATE and SELECT statements cause implicit type conversion, turning intended string assignments into zero values and making WHERE clauses always true, leading to massive data corruption and unexpected query results.

Data CorruptionImplicit ConversionMySQL
0 likes · 7 min read
Why Misplaced Quotes Turn MySQL Updates into Zeroes – A Deep Dive
JavaEdge
JavaEdge
Feb 20, 2021 · Databases

Understanding SQL: DDL, DML, and DCL Explained

The article explains the three main types of SQL statements—DDL for defining database objects, DML for manipulating data, and DCL for controlling access—detailing their purposes, common keywords, and typical usage scenarios in relational database systems.

DCLDDLDML
0 likes · 3 min read
Understanding SQL: DDL, DML, and DCL Explained
Laravel Tech Community
Laravel Tech Community
Feb 18, 2021 · Databases

Why NULL Columns Can Break MySQL Indexes and How to Avoid It

This article explains how MySQL treats NULL values, why columns defined with NULL can invalidate indexes, demonstrates the behavior of IS NULL, IS NOT NULL, the spaceship operator, IFNULL, COUNT, DISTINCT, GROUP BY and ORDER BY with NULLs, and offers practical recommendations for schema design.

Database DesignIndexesMySQL
0 likes · 13 min read
Why NULL Columns Can Break MySQL Indexes and How to Avoid It
ITPUB
ITPUB
Feb 18, 2021 · Databases

52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries

This article compiles fifty‑two practical SQL tuning strategies—including proper indexing, query rewriting, avoiding full table scans, using temporary tables, managing locks, and choosing the right storage engine—to help developers dramatically improve database query performance and scalability.

Query Tuningindexingperformance
0 likes · 22 min read
52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries
DataFunTalk
DataFunTalk
Feb 17, 2021 · Big Data

Apache Iceberg 0.11.0: New Partition Support, SortOrder, Flink Streaming Reader, and Ecosystem Integrations

The article details Apache Iceberg 0.11.0's core enhancements—including partition changes, SortOrder, extensive Flink and Spark integrations, CDC/Upsert support, hash‑based write distribution to reduce small files, and upcoming 0.12.0 roadmap—while providing practical SQL and API examples for data‑lake practitioners.

Apache IcebergBig DataCDC
0 likes · 13 min read
Apache Iceberg 0.11.0: New Partition Support, SortOrder, Flink Streaming Reader, and Ecosystem Integrations
ITPUB
ITPUB
Feb 17, 2021 · Databases

52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries

This article compiles 52 practical SQL tuning strategies—including index best practices, query rewriting, use of temporary tables, proper data types, and server configuration tips—to dramatically improve MySQL query speed and overall database efficiency.

IndexesMySQLQuery Tuning
0 likes · 23 min read
52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries
Top Architect
Top Architect
Feb 17, 2021 · Backend Development

Understanding and Optimizing MyBatis PageHelper Pagination Performance

This article analyzes the performance bottlenecks of PageHelper's pagination in MyBatis, demonstrates how large offsets degrade MySQL query speed, and presents a more efficient sub‑query join solution along with suggestions for refactoring the interceptor to improve backend pagination efficiency.

BackendJavaMyBatis
0 likes · 9 min read
Understanding and Optimizing MyBatis PageHelper Pagination Performance
DataFunTalk
DataFunTalk
Feb 16, 2021 · Big Data

Understanding Presto: Architecture, Query Execution, and Youzan’s Practical Experience

This article explains Presto’s core architecture and low‑latency query execution process, describes how Youzan adopts Presto for various data‑platform scenarios, discusses the evolution of its deployment, and outlines the performance challenges and future enhancements such as Alluxio integration and session property management.

Big DataPerformance OptimizationYouzan
0 likes · 13 min read
Understanding Presto: Architecture, Query Execution, and Youzan’s Practical Experience
Code Ape Tech Column
Code Ape Tech Column
Feb 16, 2021 · Databases

52 Proven SQL Optimization Techniques to Supercharge Your Queries

This article compiles 52 practical SQL performance‑tuning strategies—including indexing rules, query‑writing shortcuts, join optimizations, lock handling, temporary tables, storage‑engine choices, data‑type recommendations, backup tips, and useful code examples—to help developers dramatically improve query speed and overall database efficiency.

DatabaseOptimizationQuery Tuning
0 likes · 20 min read
52 Proven SQL Optimization Techniques to Supercharge Your Queries
Selected Java Interview Questions
Selected Java Interview Questions
Feb 16, 2021 · Databases

Analysis of MySQL Index Usage Cases and Best Practices

This article demonstrates how to create a test table, build indexes, and analyze their effectiveness across multiple query scenarios using MySQL's EXPLAIN output, highlighting the best‑left‑prefix rule, range condition impacts, ORDER BY considerations, and common pitfalls such as Using filesort and temporary tables.

Database OptimizationEXPLAINMySQL
0 likes · 6 min read
Analysis of MySQL Index Usage Cases and Best Practices
Top Architect
Top Architect
Feb 15, 2021 · Databases

The 50‑Year Evolution of Relational Databases and SQL

This article traces the fifty‑year history of relational databases, from early storage systems and the IDS and CODASYL network model to Codd’s relational model, the rise of SQL, its standards, competitors, and the principles that have kept SQL dominant in modern data management.

CoddData ModelsDatabase History
0 likes · 13 min read
The 50‑Year Evolution of Relational Databases and SQL
Java Captain
Java Captain
Feb 14, 2021 · Databases

52 SQL Statement Performance Optimization Strategies

This article presents a comprehensive collection of 52 practical tips for optimizing SQL queries, covering index usage, query rewriting, data type selection, storage engine choices, transaction handling, and backup strategies to improve database performance and reduce resource consumption.

IndexesOptimizationperformance
0 likes · 18 min read
52 SQL Statement Performance Optimization Strategies
Java Architect Essentials
Java Architect Essentials
Feb 10, 2021 · Databases

Master DBeaver: Free Open‑Source Database Tool and Easy Installation Guide

This article introduces DBeaver, a free open‑source, cross‑platform database management tool that supports numerous databases via JDBC, outlines its rich features such as data editors, ER diagrams, import/export, and provides step‑by‑step installation instructions for Windows, macOS, and Linux, plus tips for creating connections.

Data ManagementDatabase ToolsInstallation
0 likes · 5 min read
Master DBeaver: Free Open‑Source Database Tool and Easy Installation Guide
php Courses
php Courses
Feb 9, 2021 · Databases

Impact of Quoting String Primary Keys on MySQL Query Performance

Testing shows that omitting single quotes around a string primary key in MySQL queries can cause a full table scan and increase execution time by about 100‑fold, while quoting the value enables index usage and dramatically improves performance, a difference that disappears when the column is an INT.

Databaseindexingquery optimization
0 likes · 4 min read
Impact of Quoting String Primary Keys on MySQL Query Performance
Code Ape Tech Column
Code Ape Tech Column
Feb 8, 2021 · Databases

Evaluating the ‘No Join Over Three Tables’ Rule from Alibaba Java Development Manual with MySQL and Oracle Experiments

This article investigates why the Alibaba Java Development Manual advises against joining more than three tables by designing and executing large‑scale MySQL and Oracle experiments, analyzing query performance, indexing effects, and data‑generation scripts to determine the practical limits of multi‑table joins.

Data GenerationDatabase OptimizationJoin Performance
0 likes · 11 min read
Evaluating the ‘No Join Over Three Tables’ Rule from Alibaba Java Development Manual with MySQL and Oracle Experiments
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 7, 2021 · Big Data

Building a Flink SQL Platform on Zeppelin: Installation, Configuration, and Advanced Use Cases

This guide walks through setting up Apache Zeppelin as a low‑cost, SQL‑centric development platform for Flink, covering environment preparation, installation, interpreter configuration, execution modes, verification, common pitfalls, dimension‑table joins, custom UDFs, Redis integration, and dual‑stream join techniques.

FlinkRedisStreaming
0 likes · 24 min read
Building a Flink SQL Platform on Zeppelin: Installation, Configuration, and Advanced Use Cases
DataFunTalk
DataFunTalk
Feb 7, 2021 · Big Data

Optimizations and Extensions for Flink SQL in Tencent Real‑Time Computing Platform

This article, presented by Tencent senior engineer Du Li, details the current state of Flink SQL, compares Jar, Canvas, and SQL modes, introduces window‑function extensions, retract‑stream optimizations, and outlines future roadmap plans for cost‑based optimization and new features in the real‑time computing platform.

Big DataFlinkRetract Stream
0 likes · 19 min read
Optimizations and Extensions for Flink SQL in Tencent Real‑Time Computing Platform
JD Tech Talk
JD Tech Talk
Feb 5, 2021 · Big Data

Design and Implementation of a Real‑Time OLAP Engine Using ClickHouse in JD Energy Management Platform

This article describes how JD's Energy Management Platform leverages ClickHouse as a high‑performance, MPP‑based OLAP engine to provide real‑time, multi‑dimensional analytics on IoT energy data, covering business background, technology selection, system architecture, data ingestion, storage, replication, and a generic query interface with code examples.

ClickHouseKafkaOLAP
0 likes · 11 min read
Design and Implementation of a Real‑Time OLAP Engine Using ClickHouse in JD Energy Management Platform
ITPUB
ITPUB
Feb 5, 2021 · Databases

Mastering Subquery Unnesting: Theory, Apply Operator, and Practical Rules

This article explains why correlated subqueries are a performance bottleneck, introduces the Apply (Correlated Join) operator, and presents a comprehensive set of transformation rules—including basic unnesting, Project/Filter push‑down, Aggregate handling, and Set‑operation rewrites—to convert subqueries into efficient join plans for modern SQL engines.

Apply OperatorUnnestingquery optimization
0 likes · 18 min read
Mastering Subquery Unnesting: Theory, Apply Operator, and Practical Rules
ITPUB
ITPUB
Feb 3, 2021 · Artificial Intelligence

Can GPT‑3 Write Complex SQL Queries? A Hands‑On Exploration

This article demonstrates how GPT‑3 can translate plain‑English questions into SQL statements, starting with simple counts and progressing to multi‑table joins, while highlighting prompting techniques, limitations, and the impact of model variants such as GPT‑3 Instruct.

AI-generated codeGPT-3database automation
0 likes · 7 min read
Can GPT‑3 Write Complex SQL Queries? A Hands‑On Exploration
Java Captain
Java Captain
Feb 3, 2021 · Databases

Why MySQL UPDATE Statements Can Turn All Values to Zero When Quotes Are Misplaced

The article analyzes a production incident where dozens of MySQL UPDATE statements unintentionally set a column to zero because misplaced quotation marks caused MySQL to interpret the expression as a boolean comparison with implicit type conversion, and it explains how to detect and prevent such errors.

DataRecoveryDatabaseSafetyImplicitConversion
0 likes · 6 min read
Why MySQL UPDATE Statements Can Turn All Values to Zero When Quotes Are Misplaced
Architecture Digest
Architecture Digest
Feb 2, 2021 · Databases

Why Alibaba's Java Development Manual Prohibits Joins Over Three Tables – MySQL and Oracle Performance Experiments

The article investigates the Alibaba Java Development Manual's rule against joining more than three tables by designing and executing extensive MySQL and Oracle experiments, generating massive test data, measuring query performance, and concluding that the restriction stems from join scalability limits on large datasets.

Data GenerationDatabase OptimizationJoin Performance
0 likes · 11 min read
Why Alibaba's Java Development Manual Prohibits Joins Over Three Tables – MySQL and Oracle Performance Experiments
ITPUB
ITPUB
Feb 1, 2021 · Databases

Master MySQL Index Interview Questions: 9 Essential Concepts Explained

This article breaks down nine core MySQL index concepts—including index types, B+Tree advantages, search steps, covering indexes, index invalidation, left‑most prefix rules, index push‑down, and safe index creation on large tables—to help candidates answer interview questions about tree‑search operations and performance trade‑offs.

B+TreeInterviewMySQL
0 likes · 16 min read
Master MySQL Index Interview Questions: 9 Essential Concepts Explained
dbaplus Community
dbaplus Community
Jan 27, 2021 · Big Data

How We Upgraded a 1500-Node Flink Cluster to 1.10: Challenges and Solutions

Facing a massive 1500‑node Flink 1.4.2 cluster handling over 12,000 tasks and 30 trillion daily events, we migrated to Flink 1.10, detailing new DDL/Catalog support, SQL enhancements, memory tuning, compatibility patches, extensive testing, and engine optimizations such as task‑load metrics and balanced sub‑task scheduling.

Big DataFlinkPerformance Optimization
0 likes · 13 min read
How We Upgraded a 1500-Node Flink Cluster to 1.10: Challenges and Solutions
Big Data Technology & Architecture
Big Data Technology & Architecture
Jan 26, 2021 · Big Data

Comprehensive Guide to Apache Superset: Features, Installation, Data Source Integration, and Permissions

This article provides an in‑depth overview of Apache Superset, covering its recent graduation to a top‑level Apache project, key visualization features, extensive data source support, step‑by‑step installation via pip or Docker, PostgreSQL connection, role‑based permission model, and practical usage insights.

Apache SupersetData visualizationDocker
0 likes · 8 min read
Comprehensive Guide to Apache Superset: Features, Installation, Data Source Integration, and Permissions
Big Data Technology & Architecture
Big Data Technology & Architecture
Jan 24, 2021 · Big Data

Design and Implementation of a Big Data OLAP Platform Based on Apache Kylin

This article explains the background, challenges, and architectural design of a big‑data OLAP platform that integrates Apache Kylin with a BI system, detailing pre‑computation strategies, cube construction, user authentication, storage engines, and query mechanisms to achieve sub‑second analytics on massive datasets.

Apache KylinData WarehouseHBase
0 likes · 11 min read
Design and Implementation of a Big Data OLAP Platform Based on Apache Kylin
Java Captain
Java Captain
Jan 23, 2021 · Databases

Introducing DBeaver: A Free Open‑Source Database Management Tool and Installation Guide

This article introduces DBeaver, a free open‑source, Java‑based database management and development tool that supports a wide range of databases via JDBC, outlines its rich features, provides installation instructions for Windows, macOS, and Linux, and walks through creating and using a database connection with screenshots.

DBeaverDatabase ManagementInstallation
0 likes · 5 min read
Introducing DBeaver: A Free Open‑Source Database Management Tool and Installation Guide
macrozheng
macrozheng
Jan 22, 2021 · Databases

Why Misplaced Double Quotes Turn MySQL Updates Into Zeroes

A developer’s production update accidentally set every row’s source_name to 0 because misplaced double‑quotation marks altered the SQL semantics, and the article explains how MySQL interprets such malformed statements and how to recover the data.

Database DebuggingImplicit ConversionQuotation Marks
0 likes · 6 min read
Why Misplaced Double Quotes Turn MySQL Updates Into Zeroes
MaGe Linux Operations
MaGe Linux Operations
Jan 15, 2021 · Databases

Why ORDER BY with LIMIT Returns Unexpected Row Order in MySQL

When you combine ORDER BY with LIMIT in MySQL, the result set may appear in a different order than expected, especially if the ordered column contains duplicate values, and understanding the optimizer's behavior and adding deterministic columns can resolve this issue.

DatabaseLIMITMySQL
0 likes · 6 min read
Why ORDER BY with LIMIT Returns Unexpected Row Order in MySQL
Big Data Technology & Architecture
Big Data Technology & Architecture
Jan 14, 2021 · Databases

ClickHouse Overview: Architecture, Performance, Core Concepts, and Enterprise Use Cases

This article provides a comprehensive introduction to ClickHouse, an open‑source column‑oriented OLAP database, covering its high‑performance benchmarks, core architectural components, query processing model, deployment patterns, Java client usage, and real‑world implementations at large enterprises.

ClickHouseColumnar DatabaseOLAP
0 likes · 28 min read
ClickHouse Overview: Architecture, Performance, Core Concepts, and Enterprise Use Cases
Didi Tech
Didi Tech
Jan 12, 2021 · Big Data

Upgrading DiDi Real‑time Computing Engine from Flink 1.4 to Flink 1.10: Challenges, Optimizations, and Lessons Learned

DiDi upgraded its massive real‑time computing engine from Flink 1.4.2 to Flink 1.10, implementing a transparent migration across 1500 machines, adding native DDL, binary rows, MiniBatch, improved scheduling and window functions, and establishing a rigorous testing pipeline that achieved 99.9 % compatibility while preventing OOM issues.

FlinkPerformanceOptimizationRealTimeComputing
0 likes · 11 min read
Upgrading DiDi Real‑time Computing Engine from Flink 1.4 to Flink 1.10: Challenges, Optimizations, and Lessons Learned
Code Ape Tech Column
Code Ape Tech Column
Jan 12, 2021 · Backend Development

How to Build a High‑Performance Search API with SQL and Redis Caching

This article walks through three progressively better implementations for a complex e‑commerce search API—starting with a monolithic SQL query, then splitting the query and adding indexes, and finally using Redis sets and sorted sets to cache filter results, handle pagination, and achieve production‑grade performance.

BackendRedispagination
0 likes · 8 min read
How to Build a High‑Performance Search API with SQL and Redis Caching
Java Interview Crash Guide
Java Interview Crash Guide
Jan 10, 2021 · Databases

Boost MySQL Query Speed: Practical SQL Optimization Tips for 2021

This article explains why SQL performance is critical for fast‑response web services, presents database‑agnostic optimization techniques—such as preferring EXISTS over IN, using JOINs, avoiding unnecessary ORDER BY, leveraging UNION ALL, and applying indexes—to dramatically reduce query latency and resource consumption.

IndexesMySQLperformance
0 likes · 15 min read
Boost MySQL Query Speed: Practical SQL Optimization Tips for 2021
Top Architect
Top Architect
Jan 8, 2021 · Databases

MySQL Master‑Slave Replication Setup Guide

This article provides a step‑by‑step tutorial on configuring MySQL master‑slave replication, covering the underlying principles, master and slave configuration files, user creation, data backup, log synchronization, and verification with example commands and code snippets.

Master‑Slavereplicationsql
0 likes · 8 min read
MySQL Master‑Slave Replication Setup Guide
ITPUB
ITPUB
Jan 7, 2021 · Databases

52 Proven SQL Performance Optimization Techniques You Must Use

This article compiles 52 practical SQL performance‑tuning strategies—including index best practices, query rewrites, use of temporary tables, proper data types, and server configuration tips—to help developers dramatically speed up MySQL and other relational database queries while avoiding common pitfalls.

IndexesMySQLperformance
0 likes · 19 min read
52 Proven SQL Performance Optimization Techniques You Must Use
Liangxu Linux
Liangxu Linux
Jan 6, 2021 · Databases

52 Proven SQL Performance Tweaks to Supercharge Your Queries

This article compiles 52 practical SQL optimization strategies—including index usage, query rewriting, avoiding full table scans, proper data types, and server configuration tips—to help developers dramatically improve query speed and overall database performance.

IndexesMySQLperformance
0 likes · 22 min read
52 Proven SQL Performance Tweaks to Supercharge Your Queries
21CTO
21CTO
Jan 5, 2021 · Databases

5 Essential Rules for Writing High‑Performance SQL Queries

This article presents five practical rules—return only needed rows, use proper indexes, avoid subqueries, replace OFFSET pagination with key‑based limits, and understand SQL's logical execution order—to help developers write efficient, high‑performance SQL queries across major relational databases.

Indexespaginationperformance
0 likes · 13 min read
5 Essential Rules for Writing High‑Performance SQL Queries
Architect
Architect
Jan 5, 2021 · Databases

MySQL Index Fundamentals: Types, Structures, and Design Principles

This article introduces MySQL index basics, covering index concepts, advantages and disadvantages, various index types such as B‑Tree, B+Tree, hash, and full‑text, their storage structures, creation syntax, left‑most prefix and covering indexes, and practical design guidelines for effective indexing.

B-TreeDatabase OptimizationIndexes
0 likes · 22 min read
MySQL Index Fundamentals: Types, Structures, and Design Principles
Code Ape Tech Column
Code Ape Tech Column
Jan 5, 2021 · Databases

5 Essential Rules for Writing High‑Performance SQL Queries

This article explains why SQL query optimization matters and presents five practical rules—return only needed rows, use the right indexes, avoid subqueries, replace OFFSET‑based pagination, and master the logical execution order—to help developers write faster, more efficient database queries across major relational systems.

DatabaseIndexesPerformance tuning
0 likes · 14 min read
5 Essential Rules for Writing High‑Performance SQL Queries
Laravel Tech Community
Laravel Tech Community
Jan 3, 2021 · Databases

52 SQL Query Performance Optimization Strategies

This article presents a comprehensive collection of 52 practical SQL performance optimization techniques, covering indexing, query rewriting, use of EXISTS, avoiding full table scans, proper handling of NULLs, OR/IN clauses, temporary tables, storage engine choices, backup procedures, and other best practices to improve database efficiency.

DatabaseIndexesMySQL
0 likes · 18 min read
52 SQL Query Performance Optimization Strategies
dbaplus Community
dbaplus Community
Jan 3, 2021 · Databases

21 Essential SQL Habits to Boost Performance and Avoid Mistakes

This article presents 21 practical SQL habits covering safe delete/update usage, testing changes, backups, transaction handling, performance tuning with EXPLAIN and indexes, concise SELECT statements, proper data types, batch operations, and clean coding conventions to make your database work more reliable and efficient.

Database OptimizationMySQLsql
0 likes · 12 min read
21 Essential SQL Habits to Boost Performance and Avoid Mistakes
ITPUB
ITPUB
Jan 3, 2021 · Databases

5 Essential Rules for Writing High‑Performance SQL Queries

This article presents five practical rules for optimizing SQL queries—including selecting only needed columns, ensuring proper indexes, avoiding subqueries, using keyset pagination instead of OFFSET, and understanding the logical execution order—along with concrete examples and execution‑plan analysis for major relational databases.

Indexesexecution planpagination
0 likes · 14 min read
5 Essential Rules for Writing High‑Performance SQL Queries
Architect
Architect
Dec 30, 2020 · Databases

Overview of Database System Design

This article provides a comprehensive overview of database system design, covering its historical evolution, classification of relational and NoSQL databases, key architectural patterns, consistency models, indexing techniques, storage formats, compression methods, and practical considerations for selecting the right database solution.

DatabaseNoSQLarchitecture
0 likes · 43 min read
Overview of Database System Design
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 28, 2020 · Big Data

Implementing Historical Slowly Changing Dimension (Chain) Tables with PL/pgSQL

This article explains the concept of historical chain (slowly changing dimension) tables in data warehousing, demonstrates how to create source and target tables, provides a PL/pgSQL stored procedure to handle inserts, updates, and deletions, and shows step‑by‑step testing with sample SQL scripts.

Big DataPL/pgSQLSlowly Changing Dimension
0 likes · 10 min read
Implementing Historical Slowly Changing Dimension (Chain) Tables with PL/pgSQL
Su San Talks Tech
Su San Talks Tech
Dec 24, 2020 · Databases

Master MySQL: Deep Dive into Execution Flow, Logs, Indexes, Transactions, and Optimization

This comprehensive guide explains MySQL's server and storage engine layers, SQL execution order, BinLog/RedoLog/UndoLog mechanisms, index structures and design principles, transaction isolation levels, lock types, MVCC, buffer pool behavior, table slimming, join strategies, statistics, random queries, and practical optimization techniques for high‑performance database operations.

Database InternalsIndexesMySQL
0 likes · 43 min read
Master MySQL: Deep Dive into Execution Flow, Logs, Indexes, Transactions, and Optimization
Top Architect
Top Architect
Dec 24, 2020 · Databases

Understanding MySQL Indexes: B+Tree Structure, Implementation, and Optimization

This article explains why MySQL uses B+‑tree indexes, describes the principles of B‑tree and B+‑tree structures, compares MyISAM and InnoDB index implementations, and provides practical optimization tips such as using auto‑increment primary keys, the left‑most prefix rule, and proper configuration settings.

B+TreeDatabase OptimizationInnoDB
0 likes · 22 min read
Understanding MySQL Indexes: B+Tree Structure, Implementation, and Optimization
Code Ape Tech Column
Code Ape Tech Column
Dec 23, 2020 · Databases

Master MySQL Indexes: Why B+Tree Outperforms Other Structures

This article explains how proper index creation boosts MySQL query performance, detailing the mechanics of indexes, why B+Tree is chosen over binary and balanced trees, the storage differences between MyISAM and InnoDB, and practical guidelines for designing effective single‑column, composite, and covering indexes.

B+TreeDatabase OptimizationMySQL
0 likes · 19 min read
Master MySQL Indexes: Why B+Tree Outperforms Other Structures
Architect
Architect
Dec 22, 2020 · Big Data

Dimensional Modeling in Data Warehousing: Concepts, Theory, and Practical Example

This article explains data warehouse fundamentals, reviews classic warehouse models such as ER, dimensional, Data Vault and Anchor, then dives deep into dimensional modeling concepts, star and snowflake schemas, and demonstrates a practical e‑commerce scenario with SQL examples and trade‑offs.

Big DataData WarehouseETL
0 likes · 11 min read
Dimensional Modeling in Data Warehousing: Concepts, Theory, and Practical Example
Tencent Database Technology
Tencent Database Technology
Dec 17, 2020 · Databases

Understanding MySQL Character Set Variables

This article explains the purpose and usage of MySQL character set system variables, illustrates how they affect client‑server communication and file handling, and provides practical examples and diagrams to help developers correctly configure character sets for optimal performance.

Database VariablesEncodingMySQL
0 likes · 9 min read
Understanding MySQL Character Set Variables
ITPUB
ITPUB
Dec 17, 2020 · Databases

5 Essential Rules to Write High‑Performance SQL Queries

This article presents five practical rules for writing efficient SQL queries—including selecting only needed rows, using proper indexes, avoiding subqueries, replacing OFFSET pagination, and understanding the logical execution order—supported by examples, execution plans, and performance tips for various relational databases.

Indexesperformancequery optimization
0 likes · 14 min read
5 Essential Rules to Write High‑Performance SQL Queries
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 16, 2020 · Big Data

Designing a Real‑Time Data Processing Platform with Flink: Architecture, Deployment, and Operations

This article explains how to build a real‑time data processing platform using Flink, covering the Lambda architecture, design approaches, SQL and custom‑Jar task definitions, UI drag‑and‑drop, cluster resource management on Yarn and Kubernetes, submission modes, scheduling, permission and metadata handling, logging, and monitoring with Prometheus and Grafana.

Cluster ManagementFlinkLambda architecture
0 likes · 19 min read
Designing a Real‑Time Data Processing Platform with Flink: Architecture, Deployment, and Operations
JD Tech Talk
JD Tech Talk
Dec 16, 2020 · Databases

Understanding SQL Parser and Its Implementation in Apache ShardingSphere

This article explains the fundamentals of SQL parsing, covering lexer and parser mechanisms, context‑free grammar concepts, LL(1) and LR(1) parsing techniques, and demonstrates how Apache ShardingSphere implements a flexible, multi‑dialect SQL parser with features such as formatting, parameterization, and extensibility.

ASTParserShardingSphere
0 likes · 11 min read
Understanding SQL Parser and Its Implementation in Apache ShardingSphere
ITPUB
ITPUB
Dec 16, 2020 · Databases

5 Essential Rules to Write High‑Performance SQL Queries

This article presents five practical rules for writing efficient SQL queries—including selecting only needed rows, using proper indexes, avoiding costly subqueries, replacing OFFSET‑based pagination with key‑set pagination, and mastering the logical execution order of SQL clauses—to help developers and DBAs improve query performance across major relational databases.

Databasesql
0 likes · 15 min read
5 Essential Rules to Write High‑Performance SQL Queries
Architect's Tech Stack
Architect's Tech Stack
Dec 16, 2020 · Databases

MyBatis Dynamic SQL Tutorial: Using if, choose, trim, foreach, and bind Tags with Code Examples

This article explains MyBatis dynamic SQL features—including if, choose, trim, foreach, and bind tags—by showing how to set up a Maven project, create a student table, write mapper methods, and run tests that demonstrate conditional queries, updates, inserts, batch operations, and database‑agnostic expressions.

Dynamic SQLMyBatisorm
0 likes · 19 min read
MyBatis Dynamic SQL Tutorial: Using if, choose, trim, foreach, and bind Tags with Code Examples
Code Ape Tech Column
Code Ape Tech Column
Dec 15, 2020 · Databases

Why Indexes Still Lead to Slow Queries and How to Optimize Them

Even when a MySQL query uses an index, it can still become a slow query; this article explains index structures, explains why full‑index scans and poor selectivity cause performance issues, and presents step‑by‑step optimization techniques such as index condition pushdown, virtual columns, and better filtering.

DatabaseIndexesMySQL
0 likes · 13 min read
Why Indexes Still Lead to Slow Queries and How to Optimize Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 14, 2020 · Databases

Using MyFlash: A MySQL Flashback Tool for Rolling Back DML Operations

This article introduces MyFlash, an open‑source MySQL flashback utility, explains its limitations, provides step‑by‑step installation commands, details the available command‑line options for specifying databases, tables, time ranges and SQL types, and demonstrates a complete rollback test case with binlog parsing and execution.

DatabaseFlashbackMyFlash
0 likes · 13 min read
Using MyFlash: A MySQL Flashback Tool for Rolling Back DML Operations
DataFunTalk
DataFunTalk
Dec 11, 2020 · Big Data

My Journey and Contributions in the Apache Flink Community

The author shares his personal journey from first encountering Flink to becoming an Apache Flink Committer at ByteDance, detailing community involvement, code contributions, bug fixes, lessons learned, advice for newcomers, and concluding with promotional offers for Flink services.

Apache FlinkBlink PlannerStream Processing
0 likes · 12 min read
My Journey and Contributions in the Apache Flink Community