BestHub
Sign in
Tagged articles

SQL

2900 articles · Page 12 of 29
Laravel Tech Community
Laravel Tech Community
May 31, 2023 · Databases

CrateDB 5.3.2 Release Notes: Bug Fixes and Improvements

CrateDB 5.3.2 introduces numerous fixes and enhancements, including corrected handling of empty partition tables, improved default clause errors for OBJECT columns, resolved ON CONFLICT insert issues, fixed LIKE/ILIKE pattern bugs, snapshot restoration problems, Azure repository errors, and various optimizer and interval function improvements.

BugFixesCrateDBDistributedSQL
0 likes · 6 min read
CrateDB 5.3.2 Release Notes: Bug Fixes and Improvements
DeWu Technology
DeWu Technology
May 31, 2023 · Databases

Designing a Time Axis for HR Systems: Interval vs Effective‑Date Models

Designing a time axis for HR systems involves choosing between an interval model that stores start and end timestamps and an effective‑date model that uses effective dates and sequences, each affecting query simplicity, maintenance effort, common pitfalls, and ultimately enabling accurate historical and future employee data analysis.

Data ModelingDesign PatternsHR system
0 likes · 17 min read
Designing a Time Axis for HR Systems: Interval vs Effective‑Date Models
DataFunTalk
DataFunTalk
May 30, 2023 · Big Data

Optimizing Chart Query Performance in YouShu BI: Data Query Principles, Intelligent Caching, Query Merging, and Diagnostics

This article explains the data query fundamentals of YouShu BI charts, introduces intelligent caching design, describes query merging and various optimization techniques—including partition filters, value acceleration, and SQL generation—and outlines performance diagnosis methods to improve BI chart responsiveness.

BIChart PerformanceIntelligent Caching
0 likes · 16 min read
Optimizing Chart Query Performance in YouShu BI: Data Query Principles, Intelligent Caching, Query Merging, and Diagnostics
php Courses
php Courses
May 26, 2023 · Databases

Using Indexes to Optimize MySQL Queries

This article explains what indexes are, when they should be applied, and provides step‑by‑step MySQL commands—including single‑column, composite, and index‑hint examples—to improve query performance on large datasets.

MySQLQuery OptimizationSQL
0 likes · 6 min read
Using Indexes to Optimize MySQL Queries
Programmer DD
Programmer DD
May 24, 2023 · Databases

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

This article examines the inherent difficulties of SQL when handling multi‑step, ordered, and object‑referencing queries, illustrates them with practical examples, and introduces the Structured Process Language (SPL) as a more expressive alternative for data processing tasks.

CTEQuery OptimizationSPL
0 likes · 16 min read
Why SQL Struggles with Complex Queries and How SPL Offers a Solution
Top Architect
Top Architect
May 22, 2023 · Backend Development

Using MyBatis‑Plus‑Join Plugin for Multi‑Table Joins in Java

This article introduces the MyBatis‑Plus‑Join library that adds join capabilities to MyBatis‑Plus, explains how to install it via Maven or Gradle, shows how to extend mapper and service interfaces, and provides detailed code examples for simple three‑table queries, pagination, and advanced custom SQL usage.

BackendJOINJava
0 likes · 10 min read
Using MyBatis‑Plus‑Join Plugin for Multi‑Table Joins in Java
Laravel Tech Community
Laravel Tech Community
May 18, 2023 · Databases

SQLite 3.42.0 Release Highlights and New Features

SQLite 3.42.0, the widely used public-domain SQL database engine, introduces features such as FTS5 secure-delete, JSON5 support, new sqlite3_config options, enhanced query planner optimizations, CLI improvements, additional SQL functions, extended PRAGMA integrity_check, subsecond time modifiers, and various bug fixes and performance enhancements.

CLIDatabase EngineFTS5
0 likes · 5 min read
SQLite 3.42.0 Release Highlights and New Features
Tongcheng Travel Technology Center
Tongcheng Travel Technology Center
May 17, 2023 · Databases

StarRocks Production Practice at Tongcheng Travel: Architecture, Use Cases, and Technical Evaluation

This article details Tongcheng Travel’s production deployment of the StarRocks OLAP database, covering background, business scenarios, technical evaluation against ClickHouse and Greenplum, implementation with Flink SQL, real‑time analytics, offline reporting, CDP use cases, performance optimizations, and future cloud‑native plans.

FlinkOLAPReal-time Analytics
0 likes · 12 min read
StarRocks Production Practice at Tongcheng Travel: Architecture, Use Cases, and Technical Evaluation
Alibaba Cloud Developer
Alibaba Cloud Developer
May 16, 2023 · Artificial Intelligence

How to Build a Company‑Specific Chatbot with LLMs and Vector Databases

This article explains why combining large language models with vector databases enables enterprises to create specialized, up‑to‑date chatbots, outlines the underlying principles, describes the ADB‑PG vector‑search capabilities, and provides step‑by‑step implementation details including data processing, indexing, and query examples.

AnalyticDBLLMSQL
0 likes · 17 min read
How to Build a Company‑Specific Chatbot with LLMs and Vector Databases
Top Architect
Top Architect
May 9, 2023 · Databases

Performance Testing and Optimization of MySQL Pagination for Large Datasets

This article demonstrates how to generate, insert, and query ten‑million‑row MySQL tables, measures the latency of ordinary LIMIT pagination, analyzes the impact of offset size and result set size, and presents practical optimization techniques such as sub‑query pagination and ID‑range filtering to dramatically improve query speed.

Large DataMySQLOptimization
0 likes · 12 min read
Performance Testing and Optimization of MySQL Pagination for Large Datasets
DataFunTalk
DataFunTalk
May 9, 2023 · Databases

High‑Performance Inverted Index in Apache Doris for Log Data Storage and Analysis

This article explains how Apache Doris implements a high‑performance, column‑oriented inverted index to address the challenges of massive, real‑time log data storage and analysis, delivering dramatically higher write throughput, lower storage costs, and faster query performance than traditional Elasticsearch and Loki solutions.

Apache DorisLog AnalyticsSQL
0 likes · 19 min read
High‑Performance Inverted Index in Apache Doris for Log Data Storage and Analysis
Java High-Performance Architecture
Java High-Performance Architecture
May 9, 2023 · Databases

How to Efficiently Paginate 10 Million MySQL Records: Real‑World Tests & Optimizations

This article walks through creating a 10‑million‑row MySQL table, measuring pagination query times under different offsets and result sizes, and presents practical optimizations such as sub‑queries, ID‑range filtering, and column selection to dramatically improve performance while explaining why using SELECT * is discouraged.

Large DataMySQLOptimization
0 likes · 11 min read
How to Efficiently Paginate 10 Million MySQL Records: Real‑World Tests & Optimizations
Open Source Linux
Open Source Linux
May 5, 2023 · Databases

Mastering Subquery Unnesting: Turn Correlated Queries into Fast Joins

This article explains why correlated subqueries are a performance bottleneck, introduces the Apply (Correlated Join) operator and a systematic set of transformation rules that push Apply down and replace subqueries with efficient joins, covering scalar, existential, and quantified subqueries, aggregation handling, and set operations, all illustrated with TPC‑H examples.

Apply OperatorDatabase EnginesDecorrelate
0 likes · 17 min read
Mastering Subquery Unnesting: Turn Correlated Queries into Fast Joins
Liangxu Linux
Liangxu Linux
May 5, 2023 · Databases

Quickly Find the Highest CPU‑Consuming SQL in MySQL

This guide explains how to pinpoint the MySQL statements that use the most CPU by mapping OS thread IDs to MySQL sessions, querying performance_schema and information_schema, and reviewing the execution plan to identify optimization opportunities.

CPUMySQLSQL
0 likes · 3 min read
Quickly Find the Highest CPU‑Consuming SQL in MySQL
ITPUB
ITPUB
Apr 29, 2023 · Backend Development

When Multiple Indexes Meet: How MySQL’s Index Merge Optimizer Works

This article explains how MySQL handles queries that involve two separate indexed columns, demonstrates the index_merge execution plan with real‑world examples, details the three index‑merge strategies (intersect, union, sort_union), and shows how to control or disable the feature for better performance.

MySQLOptimizerSQL
0 likes · 11 min read
When Multiple Indexes Meet: How MySQL’s Index Merge Optimizer Works
Sanyou's Java Diary
Sanyou's Java Diary
Apr 27, 2023 · Databases

12 Common MySQL Slow‑Query Causes and How to Fix Them

This article examines the most frequent reasons MySQL queries become slow—including missing or ineffective indexes, deep pagination, massive tables, excessive joins, IN‑list overload, dirty pages, ORDER BY file‑sort, lock contention, and hardware limits—while offering concrete optimization techniques and best‑practice recommendations.

Index OptimizationMySQLSQL
0 likes · 29 min read
12 Common MySQL Slow‑Query Causes and How to Fix Them
Tencent Database Technology
Tencent Database Technology
Apr 27, 2023 · Databases

Understanding MySQL Partition Pruning: Which Partition Should Be Queried?

This article explains how MySQL implements partition pruning, describing the conditions under which the optimizer can skip irrelevant partitions, the internal data structures such as read_partitions and lock_partitions, the role of SEL_TREE and SEL_ARG, and provides a detailed example with code to illustrate the pruning process.

MySQLPartition PruningSQL
0 likes · 15 min read
Understanding MySQL Partition Pruning: Which Partition Should Be Queried?
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 27, 2023 · Databases

Diagnosing Freeze and Dump Issues in OceanBase Memstore

This article explains how to verify whether OceanBase's freeze mechanism and memstore dump processes are functioning correctly by querying internal tables, inspecting logs, and checking related metrics such as active_memstore_used, major_freeze_trigger, and MemTable reference counts.

DUMPFreezeMemStore
0 likes · 14 min read
Diagnosing Freeze and Dump Issues in OceanBase Memstore
Top Architect
Top Architect
Apr 26, 2023 · Databases

Comparative Performance and Feature Analysis of Elasticsearch vs ClickHouse

This article presents a practical comparison between Elasticsearch and ClickHouse, detailing their architectures, Docker‑Compose deployment, data ingestion pipelines, a series of representative queries, and benchmark results that show ClickHouse generally outperforms Elasticsearch in basic search and aggregation scenarios.

ClickHouseDocker ComposeElasticsearch
0 likes · 14 min read
Comparative Performance and Feature Analysis of Elasticsearch vs ClickHouse
Liangxu Linux
Liangxu Linux
Apr 25, 2023 · Databases

How to Unnest Correlated Subqueries for Faster SQL Execution

This article explains why correlated subqueries are costly, introduces the Apply (correlated join) operator, and presents a series of systematic transformation rules that convert scalar, existential, and aggregate subqueries into efficient join‑based plans while preserving SQL semantics.

Apply OperatorDecorrelationQuery Optimization
0 likes · 17 min read
How to Unnest Correlated Subqueries for Faster SQL Execution
ITPUB
ITPUB
Apr 24, 2023 · Databases

Master PostgreSQL Performance: From Hardware to Query Tuning

Effective PostgreSQL performance tuning requires a holistic approach, covering hardware sizing, OS sysctl tweaks, filesystem choices, query and schema design, key PostgreSQL parameters, concurrency settings, cache management, and careful scheduling of automated maintenance tasks to avoid resource conflicts.

OS ConfigurationPostgreSQLSQL
0 likes · 10 min read
Master PostgreSQL Performance: From Hardware to Query Tuning
DataFunSummit
DataFunSummit
Apr 24, 2023 · Artificial Intelligence

OpenMLDB: A Production‑Grade Feature Platform for Consistent Online and Offline Machine Learning

OpenMLDB is an open‑source machine‑learning database that delivers a production‑grade, consistent online‑offline feature platform for real‑time AI applications such as recommendation, risk control and fraud detection, offering millisecond‑level feature computation, dual SQL engines, extensive ecosystem integration, and a roadmap of new capabilities.

AIFeature StoreOpenMLDB
0 likes · 13 min read
OpenMLDB: A Production‑Grade Feature Platform for Consistent Online and Offline Machine Learning
Architect
Architect
Apr 23, 2023 · Big Data

Performance Comparison of Elasticsearch and ClickHouse for Log Analytics

This article compares Elasticsearch and ClickHouse by describing their architectures, demonstrating a Docker‑compose test environment, executing equivalent queries via both systems, and presenting performance results that show ClickHouse generally outperforms Elasticsearch in basic search and aggregation scenarios for log data.

ClickHouseElasticsearchSQL
0 likes · 12 min read
Performance Comparison of Elasticsearch and ClickHouse for Log Analytics
ITPUB
ITPUB
Apr 23, 2023 · Databases

Why SQL Still Dominates Data Analysis: From Relational Algebra to Modern OLAP

This article explains how SQL, built on relational algebra, became the standard analysis language for OLAP engines, covering its history, data models, syntax, functions, aggregation techniques, window functions, subqueries, and practical optimization considerations for modern data warehouses.

AggregationOLAPRelational Algebra
0 likes · 46 min read
Why SQL Still Dominates Data Analysis: From Relational Algebra to Modern OLAP
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 22, 2023 · Databases

Weekly Tech News Digest – Database and SQL Updates

This weekly roundup curates the latest high‑quality technical shares on databases, featuring articles about PolarDB HTAP acceleration, MySQL datetime precision, new MySQL releases, ChatGPT as a database client, and the SQLE platform's recent enhancements and upcoming plans.

MySQLSQLSQLE
0 likes · 4 min read
Weekly Tech News Digest – Database and SQL Updates
Past Memory Big Data
Past Memory Big Data
Apr 19, 2023 · Databases

Why a New Open‑Source Language Is Needed to Replace SQL

The article analyses SQL’s fundamental shortcomings—its lack of ordered collections, incomplete set semantics, and missing object‑reference support—illustrates these issues with concrete query examples, and argues that the open‑source Structured Process Language (SPL) solves them with true ordering, full collection handling, and native reference mechanisms.

SPLSQLStructured Process Language
0 likes · 17 min read
Why a New Open‑Source Language Is Needed to Replace SQL
ITPUB
ITPUB
Apr 18, 2023 · Databases

Mastering MySQL Index Merge: Principles, Algorithms, and Practical Tips

This article explains MySQL's index‑merge optimization, detailing how the EXPLAIN output indicates its use, the three underlying algorithms (intersect, union, sort‑union), practical query examples, configuration flags, and step‑by‑step guidance for testing with sample tables and indexes.

AlgorithmsMySQLQuery Optimization
0 likes · 9 min read
Mastering MySQL Index Merge: Principles, Algorithms, and Practical Tips
Java Architect Essentials
Java Architect Essentials
Apr 16, 2023 · Databases

Alibaba Druid Connection Pool in Spring Boot: Concepts, Configuration, Monitoring and Customization

This article introduces Alibaba's Druid database connection pool, explains its core features and filters, shows how to add the Maven starter, configure properties and filters in Spring Boot, demonstrates the built‑in monitoring pages, slow‑SQL logging, Spring AOP integration, and provides methods to remove the default advertisement and retrieve monitoring data via code.

DruidSQLSpring Boot
0 likes · 16 min read
Alibaba Druid Connection Pool in Spring Boot: Concepts, Configuration, Monitoring and Customization
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 14, 2023 · Databases

SQLE 2.2304.0-pre2 Release Notes – Project Overview, New Features, and Full Release Information

The article introduces the SQLE 2.2304.0-pre2 preview release, outlines the tool’s purpose for database users and administrators, details new enterprise‑level features such as affected‑row statistics and enhanced rule severity display, lists added MySQL audit rules, and provides complete release information and resource links.

Database AuditingMySQLSQL
0 likes · 6 min read
SQLE 2.2304.0-pre2 Release Notes – Project Overview, New Features, and Full Release Information
MaGe Linux Operations
MaGe Linux Operations
Apr 10, 2023 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams Quickly

This guide introduces DBeaver, a free Java‑based database management tool, covering its cross‑platform installation, how to create connections for databases like PostgreSQL via JDBC, and how to generate ER diagrams from existing schemas, all illustrated with step‑by‑step screenshots.

DBeaverDatabase ManagementER diagram
0 likes · 7 min read
Master DBeaver: Install, Connect, and Generate ER Diagrams Quickly
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 10, 2023 · Big Data

Fine‑grained Configuration, State Migration, and Debugging Techniques for Flink SQL at Meituan

This article describes how Meituan addresses the rapid growth of Flink SQL jobs by introducing fine‑grained TTL and concurrency settings, an editable execution plan for state migration, pre‑analysis compatibility checks, and a bytecode‑instrumented debugging system that captures operator data and streams it to Kafka for analysis.

FlinkMeituanSQL
0 likes · 24 min read
Fine‑grained Configuration, State Migration, and Debugging Techniques for Flink SQL at Meituan
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 10, 2023 · Databases

Understanding OceanBase Recycle Bin: Retrieval, Multiple Same‑Name Tables, Visibility, and Flashback Behavior

This article explains how OceanBase's recycle bin works, covering error causes when flashing back tables, methods to obtain a table's database, handling of multiple same‑name tables, visibility across tenants, and the ability to flash back tables or tenants even after the recycle bin is disabled.

Database ManagementFlashbackOceanBase
0 likes · 11 min read
Understanding OceanBase Recycle Bin: Retrieval, Multiple Same‑Name Tables, Visibility, and Flashback Behavior
Top Architect
Top Architect
Apr 7, 2023 · Databases

MySQL Performance Optimization Guidelines from a Senior Architect

This article presents a senior architect’s comprehensive MySQL optimization guide, covering execution process, naming conventions, storage engine choices, indexing strategies, query writing best practices, transaction handling, partitioning, and other performance‑tuning techniques to improve database efficiency and reliability.

DatabaseOptimizationMySQLSQL
0 likes · 24 min read
MySQL Performance Optimization Guidelines from a Senior Architect
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 3, 2023 · Databases

SQL Quality Management with Open-Source SQLE: Insights from the 2023 DAMS China Data Intelligence Management Summit

The 2023 DAMS China Data Intelligence Management Summit in Shanghai featured a technical presentation by Zhang Shenbo on an open‑source SQLE solution for SQL quality control, covering multi‑database auditing, automated review workflows, and practical tips to reduce DBA workload and cross‑department communication.

Data QualityDatabase ManagementSQL
0 likes · 3 min read
SQL Quality Management with Open-Source SQLE: Insights from the 2023 DAMS China Data Intelligence Management Summit
Top Architect
Top Architect
Apr 2, 2023 · Databases

Optimizing Large-Scale Pagination Queries in MySQL: Data Generation and Index Strategies

This article demonstrates how to generate millions of test rows in MySQL, analyzes the performance impact of deep pagination using LIMIT, explains why non‑clustered index lookups cause costly table scans, and presents two optimization approaches—sub‑query ID filtering and key‑set pagination—to dramatically reduce query latency.

Index OptimizationMySQLSQL
0 likes · 8 min read
Optimizing Large-Scale Pagination Queries in MySQL: Data Generation and Index Strategies
ITPUB
ITPUB
Mar 31, 2023 · Databases

How to Recover From an Accidental Full‑Table Update in Oracle

When a mistaken UPDATE statement overwrites an entire Oracle table, this guide explains four practical recovery techniques—including transaction rollback, flashback queries, LogMiner undo extraction, and RMAN backup restoration—detailing their prerequisites, commands, and trade‑offs.

Flashback QueryOracleSQL
0 likes · 7 min read
How to Recover From an Accidental Full‑Table Update in Oracle
Java High-Performance Architecture
Java High-Performance Architecture
Mar 31, 2023 · Databases

Mastering Liquibase with Spring Boot: A Step‑by‑Step Database Change Management Guide

This tutorial walks through setting up Liquibase in a Spring Boot project, creating a Maven plugin to generate XML/YAML changelogs, configuring the application, and performing common database operations such as creating tables, adding columns, creating indexes, initializing data, while also addressing a common includeAll path issue.

ChangelogLiquibaseMaven Plugin
0 likes · 19 min read
Mastering Liquibase with Spring Boot: A Step‑by‑Step Database Change Management Guide
Sohu Tech Products
Sohu Tech Products
Mar 29, 2023 · Databases

Understanding the Purpose and Impact of WHERE 1=1 in SQL Queries

This article explains why developers often include the redundant condition “WHERE 1=1” in SQL statements, demonstrating through performance tests that it has no effect on execution time, and describing its practical use for simplifying the addition of further conditions in both static and dynamic queries.

Dynamic SQLQuery OptimizationSQL
0 likes · 6 min read
Understanding the Purpose and Impact of WHERE 1=1 in SQL Queries
AntTech
AntTech
Mar 29, 2023 · Information Security

Introducing SCQL: Secure Collaborative Query Language for Privacy-Preserving Data Analysis

SCQL, an open‑source Secure Collaborative Query Language built on multi‑party computation, enables SQL‑style privacy‑preserving data analysis for small‑to‑medium organizations by offering easy integration, fine‑grained column‑level access control, broad data‑source support, and optimized performance for collaborative queries.

Privacy ComputingSCQLSQL
0 likes · 6 min read
Introducing SCQL: Secure Collaborative Query Language for Privacy-Preserving Data Analysis
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 29, 2023 · Databases

Understanding Local and Global Indexes in OceanBase

The article explains the concepts, differences, and practical usage scenarios of local (partition‑aligned) and global indexes in OceanBase, providing SQL examples for queries with and without partition keys and guidance on creating unique indexes using either index type.

Global IndexLocal IndexOceanBase
0 likes · 7 min read
Understanding Local and Global Indexes in OceanBase
Selected Java Interview Questions
Selected Java Interview Questions
Mar 27, 2023 · Databases

Optimizing Deep Pagination in MySQL: Data Generation, Index Behavior, and Fast Query Strategies

This article demonstrates how to generate two million MySQL rows, examines the performance impact of large OFFSET values in LIMIT clauses, explains why non‑clustered indexes cause back‑table lookups, and presents two optimization strategies—using sub‑queries to fetch IDs and employing key‑based pagination—to dramatically speed up deep page queries.

Index OptimizationMySQLSQL
0 likes · 10 min read
Optimizing Deep Pagination in MySQL: Data Generation, Index Behavior, and Fast Query Strategies
Top Architect
Top Architect
Mar 27, 2023 · Backend Development

Three MyBatis Batch Insert Methods and Their Performance Comparison

The article explains three ways to perform batch inserts with MyBatis—ordinary single-row inserts, foreach‑based bulk inserts, and ExecutorType.BATCH—analyzes their SQL logs, performance bottlenecks, MySQL limits, and provides practical recommendations for large‑scale data insertion.

Batch InsertExecutorTypeJava
0 likes · 13 min read
Three MyBatis Batch Insert Methods and Their Performance Comparison
Selected Java Interview Questions
Selected Java Interview Questions
Mar 26, 2023 · Databases

9 Common Pitfalls of SQL Scripts During System Deployment and How to Avoid Them

This article outlines nine typical problems that arise when executing SQL scripts in production—such as missing scripts, syntax errors, wrong order, timing issues, wrong database selection, long‑running updates, lack of rollback, missing indexes, and field renaming—and provides practical solutions to prevent each pitfall.

DBADatabase deploymentDevOps
0 likes · 11 min read
9 Common Pitfalls of SQL Scripts During System Deployment and How to Avoid Them
ITPUB
ITPUB
Mar 25, 2023 · Big Data

Mastering Efficient SQL in ODPS: Union, Count‑Distinct, and Join Optimizations

This article walks through common SQL development scenarios on ODPS, examining why naïve UNION and COUNT DISTINCT can be slow, how to rewrite queries with GROUP BY, UNION ALL, JSON aggregation, and map‑join techniques, and shows the resulting execution‑plan improvements with concrete code and performance numbers.

CountDistinctMapJoinODPS
0 likes · 17 min read
Mastering Efficient SQL in ODPS: Union, Count‑Distinct, and Join Optimizations
ITPUB
ITPUB
Mar 24, 2023 · Big Data

What’s New in Apache Flink 1.17? Key Features, Performance Gains, and Streaming Warehouse Advances

Apache Flink 1.17 introduces a suite of batch and streaming enhancements—including a new Streaming Warehouse API, significant TPC‑DS performance boosts, adaptive batch scheduling, improved checkpointing, expanded SQL capabilities, Hive connector upgrades, and broader filesystem support—while also delivering upgrades to FRocksDB, Calcite, and the token framework to strengthen its position as a leading unified data‑processing engine.

Apache FlinkBatch ProcessingCheckpoint
0 likes · 23 min read
What’s New in Apache Flink 1.17? Key Features, Performance Gains, and Streaming Warehouse Advances
Efficient Ops
Efficient Ops
Mar 22, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries

This article reveals frequent SQL mistakes—such as misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS, condition push‑down, premature filtering, and intermediate result push‑down—and provides concrete rewrite techniques that dramatically improve MySQL query performance.

MySQLOptimizationQuery Tuning
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries
Alimama Tech
Alimama Tech
Mar 22, 2023 · Big Data

Intelligent Merchant‑Side Diagnostic System: Architecture, Rule Engine, and Data Center

The article describes an intelligent merchant‑side diagnostic platform that unifies ad‑operation data in a centralized lake, uses a low‑code rule engine with arithmetic, code, and Java class modes to orchestrate reusable SOPs, and employs an acceleration layer for fast large‑scale queries, achieving over 90% coverage and outlining future expansion.

Rule EngineSQLdata pipeline
0 likes · 12 min read
Intelligent Merchant‑Side Diagnostic System: Architecture, Rule Engine, and Data Center
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 22, 2023 · Databases

Understanding and Optimizing BUFFER (Queuing) Tables in OceanBase

The article explains what OceanBase BUFFER (Queuing) tables are, why frequent bulk updates cause performance degradation, and provides three optimization methods—including binding execution plans, manual data transfer, and setting table_mode='queuing'—with concrete MySQL and Oracle examples and query scripts to monitor merges.

BUFFER tableMySQLOceanBase
0 likes · 7 min read
Understanding and Optimizing BUFFER (Queuing) Tables in OceanBase
php Courses
php Courses
Mar 21, 2023 · Databases

Introduction to MySQL sql_mode and Its 10 Modes

This article explains the MySQL sql_mode setting, details each of its ten modes—including STRICT_TRANS_TABLES, STRICT_ALL_TABLES, and ONLY_FULL_GROUP_BY—provides a command to view the current mode, and also includes a brief promotion for a PHP training class.

Database ConfigurationDatabase SettingsMySQL
0 likes · 4 min read
Introduction to MySQL sql_mode and Its 10 Modes
Open Source Linux
Open Source Linux
Mar 21, 2023 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

This article reviews the SQLite SQL enhancements introduced between versions 3.22.0 and 3.26.0, covering boolean literals, window functions, the FILTER clause, upsert syntax, column renaming, and related API changes, while comparing SQLite’s support to other major database systems.

FILTER clauseSQLSQLite
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 20, 2023 · Databases

New Features and Enhancements in MySQL 8.0

MySQL 8.0 introduces numerous enhancements including InnoDB engine defaults, atomic DDL, instant column addition, CTE support, UTF8MB4 default charset, Clone plugin, resource groups, role management, multi-valued and functional indexes, invisible indexes, descending indexes, SET_VAR syntax, persistent parameters, window functions, online DDL, and improved backup and binlog capabilities.

8.0InnoDBMySQL
0 likes · 23 min read
New Features and Enhancements in MySQL 8.0
Laravel Tech Community
Laravel Tech Community
Mar 19, 2023 · Databases

How to Diagnose and Resolve MySQL Process CPU Usage Spiking to 900%

This article explains common scenarios that cause MySQL (and related services) to consume 900% CPU, outlines step‑by‑step diagnosis using tools like top and show processlist, and provides practical remediation such as killing offending threads, adding missing indexes, disabling slow‑log, and leveraging Redis caching to bring CPU usage down to acceptable levels.

CPUCachingMySQL
0 likes · 6 min read
How to Diagnose and Resolve MySQL Process CPU Usage Spiking to 900%
ITPUB
ITPUB
Mar 19, 2023 · Databases

Why MySQL 8’s Default utf8mb4 Breaks Legacy utf8 Tables – A Deep Dive

Upgrading MySQL 5.6/5.7 databases to 8.0 can introduce charset mismatches between existing utf8 (utf8mb3) tables and newly created utf8mb4 tables, causing index loss and performance degradation that can be resolved by unifying the character set across all tables.

MySQLSQLperformance
0 likes · 7 min read
Why MySQL 8’s Default utf8mb4 Breaks Legacy utf8 Tables – A Deep Dive
Programmer DD
Programmer DD
Mar 17, 2023 · Backend Development

Parse and Format SQL in Java Instantly with JSqlParser

This article introduces JSqlParser, a Java library that parses SQL statements into object structures, demonstrates how to extract query components with sample code, lists supported databases, and highlights additional features like formatting and framework integration.

JSqlParserJavaSQL
0 likes · 3 min read
Parse and Format SQL in Java Instantly with JSqlParser
StarRing Big Data Open Lab
StarRing Big Data Open Lab
Mar 15, 2023 · Databases

Why Distributed Analytical Databases Are the Future: Inside ArgoDB’s Architecture

This article explains the architecture and key components of distributed analytical databases, contrasting them with MPP systems, and details the design of StarRing’s ArgoDB—including its storage, compute, transaction, and SQL engines—highlighting scalability, elasticity, and resource management for modern data warehousing.

ArgoDBSQLanalytical database
0 likes · 16 min read
Why Distributed Analytical Databases Are the Future: Inside ArgoDB’s Architecture
Laravel Tech Community
Laravel Tech Community
Mar 12, 2023 · Databases

Why COUNT(*) May Be Slower Than COUNT(1) in MySQL InnoDB

This article analyses how MySQL 5.7 InnoDB processes COUNT(*) versus COUNT(1), COUNT(id) and COUNT on indexed or non‑indexed columns, showing execution‑plan differences across various index configurations, explaining why count(*) can be unexpectedly slower and offering practical guidance for query optimization.

COUNTInnoDBMySQL
0 likes · 10 min read
Why COUNT(*) May Be Slower Than COUNT(1) in MySQL InnoDB
ITPUB
ITPUB
Mar 12, 2023 · Databases

Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost

This article walks through a practical SQL optimization workflow, showing how to detect problematic queries via system metrics and execution plans, analyze table structures and indexes, apply concrete ALTER statements and index changes, and iteratively verify performance improvements, illustrated with a detailed MySQL case study that achieved a twenty‑fold speed increase.

Index OptimizationMySQLSQL
0 likes · 10 min read
Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost
Sanyou's Java Diary
Sanyou's Java Diary
Mar 9, 2023 · Databases

21 Essential SQL Habits to Boost Performance and Avoid Regrets

This guide presents 21 practical SQL habits covering performance tuning, safe data manipulation, and coding standards—such as using EXPLAIN, adding LIMIT to deletes, documenting tables, consistent formatting, proper indexing, and transaction handling—to help developers write more efficient, reliable, and maintainable queries.

SQLcoding standardsdatabase optimization
0 likes · 15 min read
21 Essential SQL Habits to Boost Performance and Avoid Regrets
ITPUB
ITPUB
Mar 9, 2023 · Databases

9 Common SQL Script Pitfalls When Deploying to Production and How to Avoid Them

Deploying SQL scripts to production often leads to missed scripts, syntax errors, wrong execution order, mistimed runs, wrong databases, long runtimes, lack of rollback, missing indexes, and illegal column renames, but following structured version‑controlled practices can prevent these costly issues.

Database deploymentDevOpsSQL
0 likes · 11 min read
9 Common SQL Script Pitfalls When Deploying to Production and How to Avoid Them
Alimama Tech
Alimama Tech
Mar 8, 2023 · Artificial Intelligence

Secure Data Hub: Alibaba's Marketing Privacy Computing Platform

Alibaba’s Secure Data Hub (SDH) is a privacy‑preserving data clean‑room platform that uses secure multi‑party computation and privacy‑enhancing machine learning to let advertisers, ad platforms, and auditors jointly analyze marketing data via a simple SQL API while keeping raw data encrypted, column‑level protected, and confined to each party’s private domain.

SQLbig datadata clean room
0 likes · 13 min read
Secure Data Hub: Alibaba's Marketing Privacy Computing Platform
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 8, 2023 · Databases

OceanBase Tenant Deletion Methods and Syntax

This article explains OceanBase's three tenant deletion approaches—normal, delayed, and immediate—detailing the DROP TENANT syntax, recycle‑bin behavior, and providing step‑by‑step SQL examples for creating, dropping, restoring, and permanently removing tenants.

MySQLOceanBaseSQL
0 likes · 7 min read
OceanBase Tenant Deletion Methods and Syntax