BestHub
Sign in
Tagged articles

SQL

2900 articles · Page 16 of 29
Selected Java Interview Questions
Selected Java Interview Questions
Apr 9, 2022 · Databases

Comprehensive SQL Basics, Interview Questions, and Advanced Query Techniques

This article provides a thorough guide to SQL fundamentals—including SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, aggregate functions, joins, set operations, and Oracle-specific objects—followed by a collection of common interview questions with detailed solutions, top‑N queries, and row‑to‑column transformations, while also containing promotional notes for related resources.

AggregationJoinsOracle
0 likes · 25 min read
Comprehensive SQL Basics, Interview Questions, and Advanced Query Techniques
Top Architect
Top Architect
Apr 9, 2022 · Databases

Applying the Nested Set Model for Hierarchical Department Queries in MySQL

This article explains how to use the nested set (left‑right) model to efficiently query, count, and manipulate hierarchical department data in MySQL, providing SQL examples for retrieving descendants, ancestors, leaf detection, as well as insert, delete, and JavaScript tree‑building techniques.

MySQLNested Set ModelSQL
0 likes · 11 min read
Applying the Nested Set Model for Hierarchical Department Queries in MySQL
Bilibili Tech
Bilibili Tech
Apr 9, 2022 · Big Data

Bilibili Presto on Hadoop: Architecture, Scaling, and Performance Enhancements

Bilibili’s Presto on Hadoop combines a multi‑engine offline platform with Kubernetes‑managed YARN scheduling, Ranger security, and a custom dispatcher, scaling to over 400 nodes handling 160 k daily queries on 10 PB, while adding coordinator HA, resource‑group punishment, query limits, Alluxio caching, dynamic filtering, and numerous SQL‑level enhancements, with future auto‑scaling and materialized‑view automation.

HadoopSQLbig data
0 likes · 30 min read
Bilibili Presto on Hadoop: Architecture, Scaling, and Performance Enhancements
Architect's Tech Stack
Architect's Tech Stack
Apr 8, 2022 · Databases

Comprehensive Guide to MySQL Query Optimization and Common Pitfalls

This article explains why SQL performance degrades as data grows, outlines a step‑by‑step optimization workflow—including slow‑query detection, EXPLAIN analysis, profiling, optimizer tracing, and corrective actions—while detailing type and extra fields, index usage, and practical scenarios such as large pagination, IN‑order‑by, range queries, and complex joins.

MySQLQuery OptimizationSQL
0 likes · 10 min read
Comprehensive Guide to MySQL Query Optimization and Common Pitfalls
Su San Talks Tech
Su San Talks Tech
Apr 8, 2022 · Backend Development

How I Overcame Data Import Pitfalls and Canal Crashes in Production

This article recounts a series of real‑world challenges—including Excel‑to‑SQL imports, temporary table handling, Canal service failures, jar conflicts, and deployment mistakes—and explains the step‑by‑step solutions that restored system stability and delivered the required data to operations.

BackendCanalDataImport
0 likes · 17 min read
How I Overcame Data Import Pitfalls and Canal Crashes in Production
Liangxu Linux
Liangxu Linux
Apr 7, 2022 · Databases

Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More

This comprehensive guide covers MySQL fundamentals including the three normal forms, permission tables, ACID properties, index design principles, SQL statement categories, sharding, deadlock resolution, isolation anomalies, view characteristics, SQL lifecycle, primary key choices, performance troubleshooting, replication, GTID, backup tools, and backup planning.

MySQLReplicationSQL
0 likes · 13 min read
Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More
DataFunTalk
DataFunTalk
Apr 7, 2022 · Big Data

Apache Kyuubi: Architecture, Use Cases, Community, and Mobile Cloud Deployment

This article introduces Apache Kyuubi—a multi‑tenant Thrift JDBC/ODBC service built on Spark—detailing its architecture, advantages over Spark Thrift Server, real‑world use cases, open‑source community progress, and practical deployment strategies on mobile cloud, Kubernetes, and with Trino.

Apache SparkKubernetesKyuubi
0 likes · 16 min read
Apache Kyuubi: Architecture, Use Cases, Community, and Mobile Cloud Deployment
DataFunSummit
DataFunSummit
Apr 6, 2022 · Big Data

Real-time Dimension Modeling with Flink SQL: Challenges and Solutions

This article presents a JD.com case study on applying Flink SQL for real‑time dimension modeling, detailing two complex streaming scenarios—full‑join of multiple streams and full‑group aggregation—along with the associated challenges of historical data handling, state management, and performance optimization, and proposes component‑based architectural solutions.

FlinkSQLbig data
0 likes · 14 min read
Real-time Dimension Modeling with Flink SQL: Challenges and Solutions
Liangxu Linux
Liangxu Linux
Apr 5, 2022 · Databases

Efficiently Query Multi‑Business‑Entity Sales Data with MySQL Row Comparison

This article explains how to retrieve sales statistics for multiple business units and their selected products in MySQL, compares loop‑based, OR‑concatenated, mixed‑filter, and SQL‑92 row‑comparison approaches, and shows why the row‑comparison technique was ultimately chosen for its index usage and simplicity.

Dynamic SQLMySQLQuery Optimization
0 likes · 6 min read
Efficiently Query Multi‑Business‑Entity Sales Data with MySQL Row Comparison
Open Source Linux
Open Source Linux
Apr 2, 2022 · Databases

Mastering MySQL with Sequel Pro: A Complete Beginner's Guide

Sequel Pro is a user‑friendly MySQL client that lets you connect via standard, socket or SSH methods, configure connection details, test and save them, and then explore databases through panels for selecting schemas, viewing table structures, contents, relationships, triggers, table info, and running queries.

Database ManagementGUIMySQL
0 likes · 3 min read
Mastering MySQL with Sequel Pro: A Complete Beginner's Guide
Laravel Tech Community
Laravel Tech Community
Mar 31, 2022 · Databases

SQL Optimization Steps and Common Cases for Improving Query Performance

This article outlines a systematic approach to identifying and fixing slow MySQL queries, explains how to interpret EXPLAIN output and profiling information, and presents multiple real‑world cases illustrating index usage, implicit conversion, large pagination, IN queries, and other optimization techniques.

Explain PlanMySQLSQL
0 likes · 10 min read
SQL Optimization Steps and Common Cases for Improving Query Performance
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 30, 2022 · Databases

Understanding ClickHouse AggregatingMergeTree, AggregateFunction, and Materialized Views

This article explains how ClickHouse's AggregatingMergeTree engine uses the special AggregateFunction data type to pre‑aggregate data, demonstrates table creation, data insertion, and querying with state and merge functions, and shows how to combine it with materialized views for efficient analytics.

AggregateFunctionAggregatingMergeTreeClickHouse
0 likes · 8 min read
Understanding ClickHouse AggregatingMergeTree, AggregateFunction, and Materialized Views
21CTO
21CTO
Mar 30, 2022 · Big Data

What Drives Taobao App Users? Insights from AARRR and RFM Analyses

This article analyzes 2 million Taobao app user‑behavior records using AARRR funnel metrics and RFM segmentation, revealing daily and hourly usage patterns, conversion bottlenecks, product‑search mismatches, and offering data‑driven marketing recommendations to boost retention and sales.

AARRRRFMSQL
0 likes · 25 min read
What Drives Taobao App Users? Insights from AARRR and RFM Analyses
Qunar Tech Salon
Qunar Tech Salon
Mar 30, 2022 · Databases

Understanding and Optimizing PostgreSQL VACUUM and AUTOVACUUM

This article explains the purpose and mechanics of PostgreSQL's VACUUM and AUTOVACUUM processes, demonstrates practical examples of table bloat, transaction ID handling, and provides step‑by‑step guidance for precise triggering and performance optimization of vacuum operations.

AUTOVACUUMSQLdatabase tuning
0 likes · 37 min read
Understanding and Optimizing PostgreSQL VACUUM and AUTOVACUUM
Laravel Tech Community
Laravel Tech Community
Mar 29, 2022 · Databases

Efficient Methods for Removing Duplicate Records in MySQL Tables

This article explains why a naïve Python‑based row‑deletion approach is slow for large MySQL tables and provides step‑by‑step SQL techniques—including identifying duplicate names, handling MySQL’s update‑from‑same‑table limitation, and deleting duplicates while preserving a single record per group—complete with executable code examples.

MySQLSQLdata cleaning
0 likes · 5 min read
Efficient Methods for Removing Duplicate Records in MySQL Tables
StarRocks
StarRocks
Mar 28, 2022 · Backend Development

Scaling Microservice Tracing with Zipkin and StarRocks: A Practical Guide

This article explains how Sohu Smart Media built a high‑performance tracing system for microservices by integrating Zipkin for data collection with StarRocks for storage and analytics, covering architecture, data models, SQL queries, Flink processing, and real‑world results that boost observability and engineering efficiency.

FlinkSQLStarRocks
0 likes · 31 min read
Scaling Microservice Tracing with Zipkin and StarRocks: A Practical Guide
Java Captain
Java Captain
Mar 25, 2022 · Databases

Common MySQL Interview Questions and Answers

This article compiles essential MySQL interview topics, covering normal forms, privilege tables, ACID properties, SQL statement categories, sharding, deadlocks, isolation anomalies, view characteristics, statement lifecycle, primary key choices, CPU troubleshooting, replication, GTID, backup tools, and backup planning strategies.

MySQLReplicationSQL
0 likes · 15 min read
Common MySQL Interview Questions and Answers
DeWu Technology
DeWu Technology
Mar 23, 2022 · Databases

Introduction to ORM and Peewee Usage in Python

The article explains how ORM bridges Python objects and relational databases, compares options, and justifies choosing the lightweight Peewee library, then details its workflow—model generation, inserting, updating, deleting, and querying records—showcasing how this approach reduces manual data‑creation time from hours to seconds.

DjangoORMPeewee
0 likes · 9 min read
Introduction to ORM and Peewee Usage in Python
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 23, 2022 · Databases

ClickHouse SQL Fundamentals: CREATE, TABLE, Views, ALTER, Partitioning, Import/Export, and Mutation Operations

This article provides a comprehensive guide to ClickHouse SQL, covering database creation, table definitions, column defaults, temporary and partitioned tables, view types, DDL commands, data import/export formats, and mutation‑based update and delete operations with practical code examples.

ClickHouseMutationPartitioning
0 likes · 17 min read
ClickHouse SQL Fundamentals: CREATE, TABLE, Views, ALTER, Partitioning, Import/Export, and Mutation Operations
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 22, 2022 · Databases

Quick Start Guide: Building a Multi‑Tenant Ad Analytics Database with Distributed PostgreSQL (Citus)

This tutorial walks through setting up Citus, creating and distributing PostgreSQL tables for a multi‑tenant ad‑analytics application, loading sample data, executing CRUD and analytical queries, and extending the approach to real‑time GitHub event analysis, demonstrating end‑to‑end database operations in a distributed environment.

CitusPostgreSQLReal-time Analytics
0 likes · 14 min read
Quick Start Guide: Building a Multi‑Tenant Ad Analytics Database with Distributed PostgreSQL (Citus)
Java Interview Crash Guide
Java Interview Crash Guide
Mar 21, 2022 · Databases

Mastering Multi‑Entity Sales Queries with SQL Row Comparison

This article explains how to design a MySQL table for product sales statistics and compares several query strategies—including loop queries, OR concatenation, mixed filtering, and the SQL‑92 row‑by‑row comparison—to efficiently retrieve sales data for dynamic sets of business institutions and their products in a single indexed query.

MySQLRow ComparisonSQL
0 likes · 7 min read
Mastering Multi‑Entity Sales Queries with SQL Row Comparison
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 18, 2022 · Backend Development

13 Crucial Java Practices Every Developer Should Follow

This article examines fifteen common Java pitfalls and best‑practice guidelines—ranging from property copying and date formatting to HashMap sizing, thread‑pool creation, collection handling, logging, and serialization—explaining why each recommendation exists and how it impacts performance and safety.

CollectionsJavaSQL
0 likes · 9 min read
13 Crucial Java Practices Every Developer Should Follow
Architecture & Thinking
Architecture & Thinking
Mar 17, 2022 · Databases

Why Large OFFSETs Slow Down MySQL Queries and How to Fix Them

This article analyzes a production incident where massive OFFSET values in MySQL pagination caused severe query slowdown, demonstrates the problem with simulated data, benchmarks the impact, and presents three practical solutions—including index‑covering subqueries, remembering the last primary key, and limiting offset size—to dramatically improve performance and protect the database.

MySQLSQLindexing
0 likes · 13 min read
Why Large OFFSETs Slow Down MySQL Queries and How to Fix Them
Top Architect
Top Architect
Mar 14, 2022 · Databases

Implementing Multi‑Business‑Unit Sales Queries with SQL Row‑Comparison in MySQL

This article explains how to design a MySQL table for product sales statistics and compares several query strategies—including loop queries, OR concatenation, mixed filtering, and the SQL‑92 row‑comparison technique—to efficiently retrieve sales data for multiple business units and their associated products in a single indexed query.

Dynamic SQLMyBatisMySQL
0 likes · 7 min read
Implementing Multi‑Business‑Unit Sales Queries with SQL Row‑Comparison in MySQL
ITPUB
ITPUB
Mar 10, 2022 · Databases

How to Speed Up Latest‑Record Queries in Large PostgreSQL Time‑Series Tables

This article explains why querying the most recent record for a specific device in massive time‑series tables can be painfully slow in PostgreSQL, demonstrates the impact of using only a timestamp index, and presents several indexing and query‑design strategies—including composite indexes, lateral joins, SkipScan, recursive CTEs, and logging tables with triggers—to dramatically improve performance.

PostgreSQLSQLTime-Series
0 likes · 22 min read
How to Speed Up Latest‑Record Queries in Large PostgreSQL Time‑Series Tables
21CTO
21CTO
Mar 9, 2022 · Databases

Mastering Multi‑Business Sales Queries with Row‑Comparison in MySQL

This article explores how to query sales data for multiple business units and selected products in MySQL, comparing loop queries, OR concatenation, mixed filtering, and SQL‑92 row‑value comparison, ultimately recommending the row‑comparison technique for efficiency and maintainability.

Dynamic SQLMySQLRow Comparison
0 likes · 8 min read
Mastering Multi‑Business Sales Queries with Row‑Comparison in MySQL
Selected Java Interview Questions
Selected Java Interview Questions
Mar 8, 2022 · Databases

Understanding and Using CASE Expressions in SQL

This article explains the concept, syntax, and practical applications of SQL CASE expressions, covering simple and searched forms, row‑to‑column pivots, statistical transformations, conditional SELECT and UPDATE statements, and CHECK constraints, with detailed code examples and best‑practice tips.

CASE expressionConditional LogicSQL
0 likes · 14 min read
Understanding and Using CASE Expressions in SQL
DataFunTalk
DataFunTalk
Mar 8, 2022 · Databases

OpenMLDB 0.4.0 Full-Process Features and Quick‑Start Guide for Building End‑to‑End Online AI Applications

This article introduces the new full‑process features of OpenMLDB 0.4.0, explains its unified online/offline storage, high‑availability task management, and end‑to‑end AI workflow, and provides step‑by‑step instructions for quickly deploying both single‑node and cluster versions to run a complete online AI application.

AIWorkflowDistributedSystemsFeatureEngineering
0 likes · 24 min read
OpenMLDB 0.4.0 Full-Process Features and Quick‑Start Guide for Building End‑to‑End Online AI Applications
Top Architect
Top Architect
Mar 5, 2022 · Databases

Why MySQL LIMIT with Large Offsets Is Slow and How to Optimize It

The article demonstrates that MySQL queries using LIMIT with a large offset cause heavy random I/O by scanning many rows, and shows how rewriting the query with a sub‑query that selects only primary keys dramatically reduces execution time from seconds to milliseconds.

Buffer PoolLIMITMySQL
0 likes · 8 min read
Why MySQL LIMIT with Large Offsets Is Slow and How to Optimize It
DaTaobao Tech
DaTaobao Tech
Mar 3, 2022 · Databases

Comparative Analysis of MySQL and MongoDB: Features, Performance, and Practical Insights

The article compares MySQL’s relational tables with MongoDB’s schema‑free documents, detailing equivalent concepts, CRUD syntax, and benchmark results that show MongoDB achieving higher write and query throughput, easier schema evolution, and built‑in sharding, recommending it for new agile projects while suggesting MySQL remain viable for legacy systems.

MongoDBMySQLNoSQL
0 likes · 14 min read
Comparative Analysis of MySQL and MongoDB: Features, Performance, and Practical Insights
IT Xianyu
IT Xianyu
Mar 3, 2022 · Databases

Introducing SPL: An Open‑Source Structured Data Processing Language with Full SQL‑92 Capabilities

SPL is an open‑source structured data processing language that extends full SQL‑92 functionality to a wide range of data sources—including CSV, Excel, JSON, NoSQL and Hadoop—allowing developers to perform complex queries, multi‑step calculations, and mixed‑source analytics without a traditional relational database.

Data IntegrationQuery LanguageSPL
0 likes · 14 min read
Introducing SPL: An Open‑Source Structured Data Processing Language with Full SQL‑92 Capabilities
Architect's Tech Stack
Architect's Tech Stack
Mar 3, 2022 · Databases

Understanding MySQL InnoDB Full-Text Search and Inverted Index

This article explains why traditional B‑Tree indexes fail for keyword searches, introduces the concept of inverted indexes, shows how to create and use MySQL InnoDB full‑text indexes with MATCH‑AGAINST in various modes, and covers index maintenance and query‑expansion techniques.

Boolean ModeMySQLQuery Expansion
0 likes · 12 min read
Understanding MySQL InnoDB Full-Text Search and Inverted Index
Programmer DD
Programmer DD
Mar 2, 2022 · Databases

Why DBeaver Is the Free Alternative to Navicat After the Malware Scare

Following the Navicat Premium malware incident, this guide introduces DBeaver—a free, open‑source, multi‑platform database management tool, explains its features, installation steps, driver setup, and where to obtain both community and commercial versions.

DBeaverDatabase ManagementJDBC
0 likes · 4 min read
Why DBeaver Is the Free Alternative to Navicat After the Malware Scare
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 23, 2022 · Big Data

Understanding Mini‑Batch Streaming Aggregation in Flink SQL

This article explains Flink SQL’s streaming aggregation Mini‑Batch feature, covering its purpose, configuration parameters, underlying optimizer rules, operator implementations, watermark handling, buffer processing, and the optional Local‑Global two‑phase aggregation optimization for improving throughput and reducing state overhead in large‑scale data pipelines.

AggregationFlinkMini-Batch
0 likes · 10 min read
Understanding Mini‑Batch Streaming Aggregation in Flink SQL
Youzan Coder
Youzan Coder
Feb 17, 2022 · Databases

Master MySQL Slow Query Optimization: Practical Indexing Techniques

This article shares hands‑on experience with MySQL 5.7 slow‑query problems, explaining common causes, proper index design, pitfalls that invalidate indexes, efficient SQL writing, deep‑pagination avoidance, and how to use EXPLAIN to verify that queries leverage the right indexes.

Explain PlanIndex OptimizationMySQL
0 likes · 16 min read
Master MySQL Slow Query Optimization: Practical Indexing Techniques
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 17, 2022 · Big Data

Comprehensive Guide to Installing and Configuring Apache Atlas with Hive and Sqoop Hooks

This article provides a step‑by‑step tutorial on using Apache Atlas for data lineage, including SQL execution, custom data maps, tagging, field search, detailed installation procedures, runtime commands, and the configuration of Hive and Sqoop hooks for a complete big‑data governance solution.

Apache AtlasHive HookInstallation guide
0 likes · 18 min read
Comprehensive Guide to Installing and Configuring Apache Atlas with Hive and Sqoop Hooks
Laravel Tech Community
Laravel Tech Community
Feb 16, 2022 · Databases

Using Phinx for Database Migrations in ThinkPHP

This tutorial explains how to install, configure, and operate Phinx within a ThinkPHP project to manage database schema migrations, create and run seed data, update tables, roll back changes, and keep development environments synchronized.

CLIPHPPhinx
0 likes · 6 min read
Using Phinx for Database Migrations in ThinkPHP
Alibaba Cloud Developer
Alibaba Cloud Developer
Feb 14, 2022 · Backend Development

How Kuaishou Boosted Flink SQL Performance with Window Extensions and State Optimizations

Kuaishou dramatically increased Flink SQL adoption, introduced Group Window Aggregate and Window TVF extensions, applied aggregation state reuse and mini‑batch techniques, and enhanced stability through data‑skew mitigation and aggregate‑state compatibility, outlining future plans for streaming and batch SQL improvements.

FlinkSQLState Optimization
0 likes · 19 min read
How Kuaishou Boosted Flink SQL Performance with Window Extensions and State Optimizations
Laravel Tech Community
Laravel Tech Community
Feb 13, 2022 · Databases

Understanding NULL Values and Their Impact on Indexes in MySQL

This article explains how MySQL treats NULL values, the behavior of IS NULL, IS NOT NULL, the spaceship operator, IFNULL, and demonstrates with practical examples how NULL affects indexing, query performance, aggregation functions, and sorting, while offering recommendations for schema design.

MySQLNULLSQL
0 likes · 12 min read
Understanding NULL Values and Their Impact on Indexes in MySQL
dbaplus Community
dbaplus Community
Feb 13, 2022 · Databases

Mastering SQL Execution Order and Optimization: Practical Tips and Best Practices

This guide walks through MySQL's query execution sequence, then presents concrete optimization techniques—from selecting specific columns and avoiding OR conditions to proper indexing, using EXPLAIN, handling VARCHAR vs CHAR, limiting result sets, and improving joins, GROUP BY, and UNION operations—complete with code examples and visual explain plans.

MySQLSQLdatabase
0 likes · 20 min read
Mastering SQL Execution Order and Optimization: Practical Tips and Best Practices
Programmer DD
Programmer DD
Feb 13, 2022 · Backend Development

How SPL Transforms Report Data Preparation and Cuts Development Time

This article explains how the open‑source Structured Process Language (SPL) streamlines report data preparation, replaces complex SQL and Java code, supports multi‑source processing, enables hot‑swap, and dramatically reduces development effort and performance bottlenecks.

SPLSQLdata preparation
0 likes · 16 min read
How SPL Transforms Report Data Preparation and Cuts Development Time
DaTaobao Tech
DaTaobao Tech
Feb 11, 2022 · Databases

Guidelines for Choosing Storage Solutions and Database Types

When selecting a storage engine, evaluate business metrics such as user and data volume, read/write bias, and consistency needs, then match those requirements to the strengths and limits of relational databases, key‑value caches, column‑stores, document stores, search engines, and other NoSQL options to achieve the right balance of performance, scalability, and operational cost.

NoSQLSQLperformance
0 likes · 17 min read
Guidelines for Choosing Storage Solutions and Database Types
Top Architect
Top Architect
Feb 11, 2022 · Databases

Understanding MySQL INT Display Width and ZEROFILL

This article explains that the numeric value in MySQL INT definitions (e.g., int(1) or int(10)) does not limit the column's range, demonstrates inserting the maximum unsigned value, and shows how ZEROFILL combined with a display width pads numbers with leading zeros.

MySQLSQLZEROFILL
0 likes · 5 min read
Understanding MySQL INT Display Width and ZEROFILL
Architecture & Thinking
Architecture & Thinking
Feb 10, 2022 · Databases

MySQL Custom Functions: How to Create, Use, and Compare with Stored Procedures

This guide explains MySQL custom functions, covering their definition, advantages over stored procedures, step‑by‑step creation syntax, parameter handling, invocation, and management commands such as showing, altering, and dropping functions, with practical examples for both parameterless and parameterized functions and a concise comparison table.

FunctionsMySQLSQL
0 likes · 6 min read
MySQL Custom Functions: How to Create, Use, and Compare with Stored Procedures
dbaplus Community
dbaplus Community
Feb 6, 2022 · Databases

10 Common MySQL Index Pitfalls and How to Avoid Them

This article walks through ten typical scenarios where MySQL indexes fail—covering left‑most prefix violations, SELECT *, calculations, functions, type mismatches, LIKE patterns, column comparisons, OR, NOT IN/NOT EXISTS, and ORDER BY—showing why each occurs and how to keep indexes effective.

EXPLAINIndex OptimizationMySQL
0 likes · 22 min read
10 Common MySQL Index Pitfalls and How to Avoid Them
Top Architect
Top Architect
Feb 6, 2022 · Databases

Understanding MySQL InnoDB Full‑Text Search and Inverted Index

This article explains why InnoDB full‑text search is needed for keyword‑based queries, introduces inverted index structures, shows how to create, use, and delete full‑text indexes in MySQL, and demonstrates natural language, boolean, and query‑expansion search modes with practical SQL examples.

MySQLSQLdatabase
0 likes · 15 min read
Understanding MySQL InnoDB Full‑Text Search and Inverted Index
Youzan Coder
Youzan Coder
Jan 26, 2022 · Big Data

How to Build a Robust Data Quality Assurance Strategy for Large-Scale Data Platforms

This article outlines a comprehensive data quality assurance framework for a massive reporting platform, covering the data pipeline architecture, detailed testing methods for timeliness, completeness, and accuracy, as well as application‑level checks, downgrade and backup strategies, and future automation plans.

Data QualityMonitoringSQL
0 likes · 14 min read
How to Build a Robust Data Quality Assurance Strategy for Large-Scale Data Platforms
Laravel Tech Community
Laravel Tech Community
Jan 25, 2022 · Databases

Understanding LEFT JOIN ON vs WHERE Conditions in SQL

This article explains why adding conditions after a LEFT JOIN's ON clause does not filter rows, contrasts ON and WHERE behavior, and demonstrates the differences with multiple SQL examples and visual illustrations of intermediate result tables.

LEFT JOINON clauseSQL
0 likes · 5 min read
Understanding LEFT JOIN ON vs WHERE Conditions in SQL
IT Xianyu
IT Xianyu
Jan 19, 2022 · Databases

Understanding Linux Memory Usage, Buff/Cache Cleanup, and SQL Join Optimization

This article explains how to inspect and clear Linux memory buffers, details the information shown by the free command, and provides a comprehensive overview of SQL join types, their performance impact, and optimization techniques such as indexing, join buffer tuning, and algorithm choices.

BuffCacheLinuxSQL
0 likes · 7 min read
Understanding Linux Memory Usage, Buff/Cache Cleanup, and SQL Join Optimization
Java Backend Technology
Java Backend Technology
Jan 18, 2022 · Databases

Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization

This article explains how InnoDB implements full-text search using inverted indexes, shows how to create and use full-text indexes with various query modes—including natural language, boolean, and query expansion—covers relevance calculation, stopwords, token size limits, and demonstrates how to delete indexes, all illustrated with SQL examples and diagrams.

Boolean ModeMySQLQuery Expansion
0 likes · 13 min read
Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization
Hacker Afternoon Tea
Hacker Afternoon Tea
Jan 16, 2022 · Databases

Sentry Developer Contribution Guide – Database Migrations

This guide explains how Sentry uses Django migrations to manage database schema changes, covering commands for upgrading, targeting specific migrations, generating SQL, creating and merging migrations, and detailed best‑practice procedures for handling filters, indexes, column and table modifications, foreign keys, and renaming while avoiding downtime.

DjangoPostgreSQLSQL
0 likes · 16 min read
Sentry Developer Contribution Guide – Database Migrations
Alimama Tech
Alimama Tech
Jan 12, 2022 · Artificial Intelligence

AI FAAS Solution for Advertising Tools: Architecture, Platform, and Real‑time Feature SQL Production

The team built a lightweight AI‑FAAS platform that migrates C++ ad‑algorithm services to a Java‑centric, cloud‑native environment, encapsulates core operators as DolphinSQL plugins, and defines real‑time feature pipelines via standardized SQL, cutting service creation from weeks to days, enabling rapid iteration, high operator reuse, and near‑instant feature delivery.

AIAdvertisingAlgorithm Platform
0 likes · 14 min read
AI FAAS Solution for Advertising Tools: Architecture, Platform, and Real‑time Feature SQL Production
Java Backend Technology
Java Backend Technology
Jan 11, 2022 · Databases

Why SQL Fails at Multi‑Group & Top‑N Queries and How SPL Fixes It

The article explains how conventional SQL struggles with executing multiple grouping and Top‑N aggregations on massive tables, leading to repeated full scans and poor performance, and demonstrates how the SPL compute engine can perform these operations in a single pass with parallelism, improving speed and scalability.

SPLSQLTOP N
0 likes · 14 min read
Why SQL Fails at Multi‑Group & Top‑N Queries and How SPL Fixes It
macrozheng
macrozheng
Jan 11, 2022 · Big Data

Deploy Metabase in 5 Minutes and Master Its Data Visualization Features

Metabase is a fast, open‑source BI tool that can be set up in about five minutes using Docker, offering a user‑friendly interface for creating dashboards, custom SQL queries, data pivots, and multi‑table analysis without requiring deep SQL knowledge, making data visualization accessible to all.

BIDockerMetabase
0 likes · 11 min read
Deploy Metabase in 5 Minutes and Master Its Data Visualization Features
Architects Research Society
Architects Research Society
Jan 8, 2022 · Databases

Understanding Database Isolation Levels and Dirty Reads

This article explains database isolation levels, including read committed, repeatable read, serializable, and snapshot isolation, discusses dirty reads, phantom reads, and how various systems such as SQL Server, PostgreSQL, MySQL, Oracle, MongoDB, and others implement or differ in these isolation semantics.

Dirty ReadIsolation LevelSQL
0 likes · 19 min read
Understanding Database Isolation Levels and Dirty Reads
dbaplus Community
dbaplus Community
Jan 5, 2022 · Big Data

How ByteDance Optimized Flink SQL for Real‑World Streaming at Scale

This article details ByteDance's practical experience with Apache Flink, covering SQL extensions, a visual SQL platform, performance tweaks such as window mini‑batching and custom windows, join and checkpoint recovery improvements, stream‑batch integration experiments, and future roadmap plans.

Batch IntegrationCheckpointFlink
0 likes · 16 min read
How ByteDance Optimized Flink SQL for Real‑World Streaming at Scale
Top Architect
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.

JSONMulti-Valued IndexMySQL
0 likes · 13 min read
Using MySQL JSON Data Type for Flexible Schema Design and Efficient Indexing
Programmer DD
Programmer DD
Dec 25, 2021 · Databases

Why SQL Struggles with Complex Queries and How SPL Offers a Solution

The article analyzes four fundamental limitations of SQL—lack of stepwise execution, incomplete set semantics, missing ordered operations, and no object reference mechanism—illustrates them with real queries, and introduces SPL as a more intuitive language that overcomes these issues.

Query OptimizationSPLSQL
0 likes · 19 min read
Why SQL Struggles with Complex Queries and How SPL Offers a Solution
Laravel Tech Community
Laravel Tech Community
Dec 23, 2021 · Databases

Database Object Naming and Design Standards

This guide details comprehensive naming conventions and design best‑practices for MySQL database objects—including schemas, tables, indexes, views, stored procedures, functions, triggers, constraints, and users—along with recommended storage engine, character set, field types, index strategies, and SQL usage rules to ensure consistency, performance, and maintainability.

MySQLNaming ConventionSQL
0 likes · 20 min read
Database Object Naming and Design Standards
Senior Brother's Insights
Senior Brother's Insights
Dec 21, 2021 · Databases

9 Essential MySQL Optimization Techniques to Boost Performance

This article presents practical MySQL optimization methods—including proper column definitions, NOT NULL usage, JOIN over sub‑queries, UNION, transaction handling, foreign keys, table locking, indexing strategies, and a collection of query‑tuning tips—each illustrated with clear examples and code snippets to improve database speed and reliability.

MySQLSQLTransactions
0 likes · 18 min read
9 Essential MySQL Optimization Techniques to Boost Performance
Alibaba Cloud Native
Alibaba Cloud Native
Dec 19, 2021 · Databases

Build a Serverless Order Storage System with Alibaba Cloud Tablestore

This article explains how to design and implement a fully elastic, zero‑ops Serverless database using Alibaba Cloud Tablestore, covering its architecture, key features, step‑by‑step CLI setup, table creation, data import, querying, indexing, and cost efficiency for high‑volume order workloads.

CLISQLServerless
0 likes · 12 min read
Build a Serverless Order Storage System with Alibaba Cloud Tablestore
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 18, 2021 · Big Data

Slowly Changing Dimensions (SCD) – Design Principles, Challenges, and Hive Implementation

This article explains the concept of Slowly Changing Dimensions (SCD), discusses practical design questions, compares three change‑tracking requirements, presents three implementation patterns, and provides detailed Hive/SQL examples for historical data initialization and incremental updates in large‑scale data warehouses.

HiveSCDSQL
0 likes · 20 min read
Slowly Changing Dimensions (SCD) – Design Principles, Challenges, and Hive Implementation
Youzan Coder
Youzan Coder
Dec 17, 2021 · Big Data

Upgrading Real-Time Computing Engine from Flink 1.10 to 1.13: Practices and Challenges

Youzan upgraded its real‑time computing engine from Flink 1.10 to 1.13 to meet rising SQL and containerization demands, gaining enhanced SQL syntax, time‑function handling, Window TVF standardization, Hive integration, K8s stability, elastic scaling, richer Kafka and format support, improved metrics and debugging tools, and successfully migrated all custom connectors, UDFs, and SQL jobs to the new Kubernetes‑based platform.

FlinkK8sReal-Time Computing
0 likes · 22 min read
Upgrading Real-Time Computing Engine from Flink 1.10 to 1.13: Practices and Challenges
dbaplus Community
dbaplus Community
Dec 12, 2021 · Databases

7 Common MySQL Index Pitfalls That Can Kill Query Performance

This article examines seven typical scenarios where MySQL indexes unexpectedly fail—such as OR conditions, leading wildcards in LIKE, missing quotes, functions on indexed columns, NULL checks, arithmetic operations, and composite index ordering—providing SQL examples, execution plans, and practical tips to avoid costly full‑table scans.

MySQLQuery TuningSQL
0 likes · 9 min read
7 Common MySQL Index Pitfalls That Can Kill Query Performance