BestHub
Sign in
Tagged articles

SQL

2900 articles · Page 25 of 29
Architect's Tech Stack
Architect's Tech Stack
Sep 3, 2019 · Databases

Practical MySQL Slow Query Optimization: Case Studies and Techniques

This article presents a step‑by‑step analysis of several real‑world MySQL slow‑query problems, demonstrates how to reproduce the issues, examines execution plans, applies concrete optimizations such as removing function calls, adjusting date comparisons, adding bigint indexes, and explains the impact of different EXPLAIN types on performance.

Database IndexingEXPLAINMySQL
0 likes · 12 min read
Practical MySQL Slow Query Optimization: Case Studies and Techniques
Efficient Ops
Efficient Ops
Sep 2, 2019 · Databases

Master MySQL Optimization: Strategies, Tools, and Best Practices

This comprehensive guide explains MySQL optimization philosophy, required participants, key dimensions, essential tools, step‑by‑step tuning procedures, hardware and system tuning, and detailed MySQL and InnoDB parameter settings to improve performance and reliability.

MySQLSQLdatabase optimization
0 likes · 18 min read
Master MySQL Optimization: Strategies, Tools, and Best Practices
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 2, 2019 · Databases

Apache Phoenix Tutorial: Quick Start, Data Types, DML, Indexes, Salted Tables, and Advanced Features

This comprehensive guide introduces Apache Phoenix as an HBase SQL layer, covering quick‑start steps, supported data types, DML syntax, salted tables to prevent hotspots, various secondary index types, bulk‑load methods, auto‑increment IDs, dynamic columns, pagination, query plan analysis, and data migration techniques.

Apache PhoenixHBaseSQL
0 likes · 33 min read
Apache Phoenix Tutorial: Quick Start, Data Types, DML, Indexes, Salted Tables, and Advanced Features
dbaplus Community
dbaplus Community
Aug 29, 2019 · Databases

Inside PostgreSQL: How Queries Are Parsed, Optimized, and Executed

This article walks through PostgreSQL’s query processing pipeline—from parsing SQL into relational algebra, through semantic analysis, query rewriting, optimization techniques like sub‑query elimination and join ordering, to the executor’s sequential scan algorithm—illustrating each step with code snippets and diagrams.

Database OptimizerPostgreSQLQuery Processing
0 likes · 14 min read
Inside PostgreSQL: How Queries Are Parsed, Optimized, and Executed
Big Data Technology Architecture
Big Data Technology Architecture
Aug 29, 2019 · Databases

19 Common MySQL Optimization Techniques

This article presents nineteen practical MySQL optimization methods—including using EXPLAIN, limiting IN clause size, specifying columns in SELECT, proper use of LIMIT, avoiding costly ORDER BY RAND(), choosing between IN and EXISTS, leveraging full‑text indexes, and applying join and index best practices—to improve query performance and reduce resource consumption.

MySQLOptimizationSQL
0 likes · 11 min read
19 Common MySQL Optimization Techniques
Liangxu Linux
Liangxu Linux
Aug 27, 2019 · Databases

19 Essential MySQL Optimization Techniques Every Developer Should Know

This guide compiles nineteen practical MySQL optimization tips—from using EXPLAIN and avoiding costly IN clauses to leveraging full‑text indexes, proper pagination, and join strategies—providing concrete SQL examples and actionable advice to improve query performance and reduce resource consumption.

MySQLQuery TuningSQL
0 likes · 11 min read
19 Essential MySQL Optimization Techniques Every Developer Should Know
360 Tech Engineering
360 Tech Engineering
Aug 27, 2019 · Databases

Quicksql: A Unified Cross‑Data‑Source SQL Query Engine

Quicksql is an open‑source, cross‑data‑source SQL engine built on Apache Calcite that provides a unified, safe, and fast SQL interface, enabling users to query heterogeneous storage systems such as Hive, MySQL, Elasticsearch, and Druid through command‑line, API, or JDBC connections.

Apache CalciteData IntegrationSQL
0 likes · 6 min read
Quicksql: A Unified Cross‑Data‑Source SQL Query Engine
macrozheng
macrozheng
Aug 16, 2019 · Databases

Designing Home Page Recommendation Tables: SQL Schemas Explained

This article details the database table structures used for managing various homepage recommendation features—including brand, new product, popular product, subject, and advertisement tables—providing full MySQL DDL statements, field descriptions, and visual examples of both admin and mobile interfaces.

MySQLSQLbackend development
0 likes · 6 min read
Designing Home Page Recommendation Tables: SQL Schemas Explained
Efficient Ops
Efficient Ops
Aug 15, 2019 · Fundamentals

Master SQL SELECT: 10 Steps to Understand Execution Order and Joins

This comprehensive guide explains how SQL's declarative nature, the mismatch between syntax and execution order, table references, various join types, derived tables, GROUP BY behavior, and key keywords like DISTINCT, UNION, ORDER BY, and OFFSET work together to help readers master SELECT statements.

Database fundamentalsJoinsSQL
0 likes · 20 min read
Master SQL SELECT: 10 Steps to Understand Execution Order and Joins
DevOps Cloud Academy
DevOps Cloud Academy
Aug 13, 2019 · Databases

Step‑by‑Step Guide to Installing Oracle 12c Database on Linux

This article provides a comprehensive, ordered tutorial for preparing the environment, configuring the root and oracle users, adjusting kernel and system limits, and finally installing and initializing Oracle 12c on a Linux server using detailed command‑line instructions.

Database InstallationLinuxOracle
0 likes · 5 min read
Step‑by‑Step Guide to Installing Oracle 12c Database on Linux
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 12, 2019 · Big Data

Spark SQL Parameter Tuning and Performance Optimization (Spark 2.3.2)

This article explains how to troubleshoot and tune Spark SQL configuration parameters—covering exception‑related settings such as spark.sql.hive.convertMetastoreParquet, file‑ignore options, and partition verification, as well as performance‑focused tweaks like broadcast join thresholds, adaptive execution, and parquet schema merging—while providing a comprehensive parameter reference table.

Hive MigrationPerformance OptimizationSQL
0 likes · 23 min read
Spark SQL Parameter Tuning and Performance Optimization (Spark 2.3.2)
macrozheng
macrozheng
Aug 9, 2019 · Databases

Mastering Coupon System Design: Database Schemas and UI Integration

This article provides a comprehensive walkthrough of the coupon feature's database tables—including definitions for coupons, coupon history, product relations, and category relations—along with screenshots of both admin and mobile interfaces that illustrate how these tables are used in an e‑commerce system.

SQLcoupondatabase-schema
0 likes · 6 min read
Mastering Coupon System Design: Database Schemas and UI Integration
Java Captain
Java Captain
Aug 7, 2019 · Databases

Practical Guide to Group, Join, and CASE WHEN Queries in SQL

This article provides a beginner‑friendly, step‑by‑step tutorial on common SQL operations—including GROUP BY aggregation, JOIN types, CASE WHEN expressions, and useful built‑in functions—illustrated with clear examples, typical pitfalls, and ready‑to‑use code snippets.

CASE WHENDatabase TutorialFunctions
0 likes · 10 min read
Practical Guide to Group, Join, and CASE WHEN Queries in SQL
21CTO
21CTO
Aug 6, 2019 · Databases

Why SQL Is Making a Comeback: From NoSQL’s Rise to the New Data Era

This article explores the resurgence of SQL, tracing its historical roots, the rise and limitations of NoSQL, and how modern cloud and NewSQL solutions are re‑establishing SQL as the universal interface for data storage, processing, and analysis.

NewSQLNoSQLSQL
0 likes · 14 min read
Why SQL Is Making a Comeback: From NoSQL’s Rise to the New Data Era
Programmer DD
Programmer DD
Aug 5, 2019 · Databases

Master MySQL Optimization: Practical Strategies to Boost Performance and Stability

This guide walks you through MySQL's query process, the philosophy and risks of optimization, the key participants, core dimensions such as hardware, system, schema and SQL, essential diagnostic tools, emergency and regular tuning steps, system‑level monitoring, kernel and user limits, as well as detailed MySQL and InnoDB configuration parameters for achieving high performance and reliability.

MySQLSQLdatabase optimization
0 likes · 15 min read
Master MySQL Optimization: Practical Strategies to Boost Performance and Stability
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2019 · Databases

Using MySQL 8.0 CLONE Plugin to Create Instance Replicas

This article explains how the MySQL 8.0 CLONE plugin simplifies creating reliable replica instances by installing the plugin, granting necessary privileges, executing the CLONE SQL statement, monitoring progress via performance_schema, and verifying successful completion of all clone stages.

CloneDatabase ReplicationInnoDB
0 likes · 12 min read
Using MySQL 8.0 CLONE Plugin to Create Instance Replicas
ITPUB
ITPUB
Jul 25, 2019 · Databases

Master Oracle Database: Create, Backup, Restore, and Manage Tables & Data

This guide provides step‑by‑step Oracle commands for creating and dropping databases, performing full and selective backups, restoring data locally or remotely, managing tables—including creation, deletion, renaming, column alterations, primary keys, indexes, and views—as well as querying, inserting, updating, deleting, and copying data efficiently.

Data manipulationOracleRestore
0 likes · 8 min read
Master Oracle Database: Create, Backup, Restore, and Manage Tables & Data
macrozheng
macrozheng
Jul 25, 2019 · Databases

Mastering Order Return Database Design: Schemas, Statuses, and UI Flow

This article provides a comprehensive walkthrough of the order return and return‑reason database tables, detailing each field, status codes, and the corresponding admin and mobile UI screens that illustrate how the return process works in an e‑commerce system.

SQLdatabase-schemae-commerce
0 likes · 7 min read
Mastering Order Return Database Design: Schemas, Statuses, and UI Flow
macrozheng
macrozheng
Jul 18, 2019 · Databases

Unlocking Order Management: Complete Database Schema for E‑Commerce Orders

This article provides a detailed analysis of the order-related database tables—including orders, order items, operation history, and order settings—along with their fields, data types, and meanings, and showcases how these tables are presented in both admin and mobile interfaces of an e‑commerce system.

SQLbackend developmentdatabase design
0 likes · 9 min read
Unlocking Order Management: Complete Database Schema for E‑Commerce Orders
macrozheng
macrozheng
Jul 16, 2019 · Backend Development

Unlocking E‑Commerce Product Management: Deep Dive into Database Schemas

This article walks through the core database tables that power product editing, SKU management, tiered pricing, full‑reduction discounts, member pricing, product reviews, verification records, and operation logs in an e‑commerce system, complete with SQL definitions and UI screenshots.

SQLbackend developmentdatabase design
0 likes · 14 min read
Unlocking E‑Commerce Product Management: Deep Dive into Database Schemas
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 15, 2019 · Databases

Common Causes and Fixes for MySQL Error 1045 (Access Denied)

This article enumerates the typical reasons why MySQL returns error 1045 – such as connecting to the wrong host, using a non‑existent user, host‑based access restrictions, incorrect passwords, special characters in Bash, and missing SSL – and provides step‑by‑step commands to diagnose and resolve each issue.

Access deniedDatabase AuthenticationError 1045
0 likes · 9 min read
Common Causes and Fixes for MySQL Error 1045 (Access Denied)
Architecture Digest
Architecture Digest
Jul 11, 2019 · Databases

The Rise of Oracle and the Evolution of the Database Industry

This article chronicles the origins and growth of Oracle, the colorful personality of its founder Larry Ellison, the early development of relational databases, the fierce competition among IBM, Sybase, Borland and other vendors, and the later impact of open‑source and cloud‑computing trends on the database market.

Database historyLarry EllisonOracle
0 likes · 43 min read
The Rise of Oracle and the Evolution of the Database Industry
Qunar Tech Salon
Qunar Tech Salon
Jul 9, 2019 · Databases

SQL Fundamentals and Query Optimization Techniques for PostgreSQL

This article introduces SQL fundamentals, explains DDL/DML/DCL categories, and provides practical PostgreSQL query optimization techniques—including index selection, condition rewriting, sub‑query removal, expression and partial indexes, DDL decomposition, CTE usage, and key configuration parameters—to help developers and DBAs improve performance and maintainability.

PostgreSQLQuery OptimizationSQL
0 likes · 12 min read
SQL Fundamentals and Query Optimization Techniques for PostgreSQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 8, 2019 · Databases

Understanding and Resolving MySQL Table Fragmentation

This article explains MySQL table fragmentation, how to detect it with SHOW TABLE STATUS, the reasons such as frequent DELETE and UPDATE operations, demonstrates its effects, and presents cleanup methods like OPTIMIZE TABLE and engine conversion, showing significant space savings and query speed improvements.

MySQLOptimizationSQL
0 likes · 5 min read
Understanding and Resolving MySQL Table Fragmentation
JD Retail Technology
JD Retail Technology
Jul 3, 2019 · Databases

CB‑SQL: JD Retail’s Elastic Distributed Database Built on CockroachDB – Architecture and Implementation Details

The article introduces CB‑SQL, JD Retail’s next‑generation elastic database based on CockroachDB, and comprehensively explains its overview, layered architecture, storage replication, cluster management, MVCC, hybrid logical clocks, lock‑free distributed transactions, CDC changefeeds, and SQL interface support.

CDCCockroachDBMVCC
0 likes · 14 min read
CB‑SQL: JD Retail’s Elastic Distributed Database Built on CockroachDB – Architecture and Implementation Details
Programmer DD
Programmer DD
Jul 2, 2019 · Databases

Why MySQL LIMIT Slows Down on Large Offsets and How to Fix It

This article analyzes why MySQL LIMIT pagination becomes increasingly slow with larger offsets, presents six optimization techniques—including using primary keys, covering indexes, prepared statements, subqueries, and composite indexes—and provides experimental results that demonstrate dramatic performance improvements.

Index OptimizationMySQLSQL
0 likes · 12 min read
Why MySQL LIMIT Slows Down on Large Offsets and How to Fix It
Architect's Tech Stack
Architect's Tech Stack
Jun 29, 2019 · Databases

Practical MySQL Optimization Guide: Philosophy, Tools, and Tuning Techniques

This article provides a comprehensive, step‑by‑step guide to MySQL performance tuning, covering the underlying query process, optimization philosophy, practical tools, system‑level diagnostics, hardware and OS recommendations, as well as detailed configuration parameters for both the server and storage engine.

MySQLSQLdatabase optimization
0 likes · 16 min read
Practical MySQL Optimization Guide: Philosophy, Tools, and Tuning Techniques
DataFunTalk
DataFunTalk
Jun 28, 2019 · Databases

Deep Dive into Phoenix Index Creation, Maintenance, and SQL Compilation

This article provides a detailed technical analysis of Phoenix's native index creation and maintenance mechanisms, the underlying source code for index building, the role of coprocessors, and the complete SQL compilation pipeline from parsing to execution, highlighting how hints and optimizers influence index usage.

CoprocessorHBasePhoenix
0 likes · 26 min read
Deep Dive into Phoenix Index Creation, Maintenance, and SQL Compilation
Programmer DD
Programmer DD
Jun 28, 2019 · Databases

19 Essential MySQL Optimization Techniques Every Developer Should Know

The article outlines 19 practical MySQL optimization methods—from using EXPLAIN and limiting IN clause size to proper pagination, index usage, and JOIN strategies—providing clear explanations and example SQL snippets to help developers improve query performance and reduce resource consumption.

MySQLSQLperformance
0 likes · 10 min read
19 Essential MySQL Optimization Techniques Every Developer Should Know
Python Crawling & Data Mining
Python Crawling & Data Mining
Jun 26, 2019 · Databases

Why Your MySQL Queries Run Slow and How to Fix Common Index Issues

This article explains why MySQL queries can become slow—covering occasional delays from dirty‑page flushing or lock contention and persistent slowness caused by missing, unused, or mis‑chosen indexes—while offering practical tips such as checking process lists, correcting index usage, and refreshing statistics.

MySQLSQLindex
0 likes · 12 min read
Why Your MySQL Queries Run Slow and How to Fix Common Index Issues
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 24, 2019 · Databases

Using Window Functions in MySQL: From Session Variables and GROUP_CONCAT to Native ROW_NUMBER()

This article demonstrates how to achieve ranking and pagination in MySQL using pre‑8.0 techniques such as session variables and GROUP_CONCAT, then shows the simpler native window function syntax introduced in MySQL 8.0, with complete examples, sample data, and queries for finding low‑scoring students.

MySQLSQLWindow Functions
0 likes · 9 min read
Using Window Functions in MySQL: From Session Variables and GROUP_CONCAT to Native ROW_NUMBER()
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 20, 2019 · Big Data

Comprehensive Guide to Flink SQL: Background, New Features, Programming Model, Operators, Functions, and a Practical NBA Scoring Leader Example

This article provides an in‑depth overview of Flink SQL, covering its origins, the latest 1.7.0 and 1.8.0 enhancements, the underlying programming model, common operators and built‑in functions, and a complete end‑to‑end example that analyzes NBA scoring‑leader data using Flink SQL.

Apache FlinkFlink SQLSQL
0 likes · 27 min read
Comprehensive Guide to Flink SQL: Background, New Features, Programming Model, Operators, Functions, and a Practical NBA Scoring Leader Example
ITPUB
ITPUB
Jun 18, 2019 · Databases

Why MySQL LIMIT Pagination Slows Down and 6 Proven Optimization Techniques

This article examines why MySQL LIMIT pagination becomes slower as the offset grows, presents six practical methods—including direct LIMIT, primary‑key indexing, ordered index scans, prepared statements, sub‑queries, and joins—provides benchmark results on large tables, and distills actionable guidelines for designing covering and composite indexes to achieve fast, stable pagination.

Index OptimizationLIMITMySQL
0 likes · 12 min read
Why MySQL LIMIT Pagination Slows Down and 6 Proven Optimization Techniques
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 17, 2019 · Big Data

Understanding Spark SQL: Concepts, Queries, Data Sources, and Practical Examples

This article introduces Spark SQL fundamentals, including its architecture, DataFrame and Dataset abstractions, query methods, interoperability with RDD, user-defined functions, integration with Hive, data source handling, and provides step‑by‑step Scala code examples for loading data, performing aggregations, and solving common analytical tasks.

DataFramesHiveSQL
0 likes · 15 min read
Understanding Spark SQL: Concepts, Queries, Data Sources, and Practical Examples
Programmer DD
Programmer DD
Jun 6, 2019 · Databases

Why Your SQL Queries Are Slow: 15 Real‑World Causes & Fixes

This article examines a wide range of factors that can cause MySQL queries to run slowly—including network latency, OS and hardware bottlenecks, storage I/O scheduling, CPU power settings, RAID cache behavior, index design, implicit type conversion, execution plan errors, large data volumes, metadata locks, concurrent row updates, data skew, inefficient pagination, table schema choices, InnoDB dirty‑page flushing, and undo log retention—offering concrete examples and mitigation strategies for each scenario.

MySQLSQLslow query
0 likes · 19 min read
Why Your SQL Queries Are Slow: 15 Real‑World Causes & Fixes
dbaplus Community
dbaplus Community
Jun 5, 2019 · Databases

How to Scale SQL Databases for 20,000+ Concurrent Users: Single Instance, Sharding, and Read‑Write Separation

This article explains how to handle 20,000+ concurrent SQL requests by moving from a simple single‑instance setup to multi‑instance sharding and finally to read‑write separation, detailing the architectural decisions, routing algorithms, and practical limits for high‑traffic e‑commerce systems.

High ConcurrencySQLperformance
0 likes · 7 min read
How to Scale SQL Databases for 20,000+ Concurrent Users: Single Instance, Sharding, and Read‑Write Separation
dbaplus Community
dbaplus Community
Jun 5, 2019 · Databases

Boost Oracle Hierarchical Query Performance: Filtering, CBO, and Parallel Strategies

This article examines common performance pitfalls in Oracle hierarchical (CONNECT BY) queries, compares filtering after tree generation versus during traversal, explains why CBO estimates can be wildly inaccurate, and demonstrates how to rewrite queries with pipelined table functions and parallel hints for dramatic speed gains.

CBOHierarchical QueryOracle
0 likes · 9 min read
Boost Oracle Hierarchical Query Performance: Filtering, CBO, and Parallel Strategies
21CTO
21CTO
Jun 5, 2019 · Databases

12 Proven SQL Tricks to Supercharge Your Database Performance

This article presents twelve practical SQL optimization techniques—from using proper comparison operators and LIMIT clauses to indexing strategies and query consistency—to dramatically improve database query speed and overall application performance.

Query PlanningSQLSQL tips
0 likes · 5 min read
12 Proven SQL Tricks to Supercharge Your Database Performance
Tencent Database Technology
Tencent Database Technology
Jun 4, 2019 · Databases

From SEQUEL to JSON: Tracing the Evolution of SQL Standards

This article chronicles the origins, standardization process, historical milestones, learning resources, and conformance challenges of SQL standards, highlighting key ISO/IEC versions, the roles of major vendors, and the growing complexity of the language over more than three decades.

ANSIDatabase StandardsISO
0 likes · 11 min read
From SEQUEL to JSON: Tracing the Evolution of SQL Standards
Java Captain
Java Captain
May 31, 2019 · Databases

Common MySQL Query Performance Issues and Optimization Techniques

This article examines frequent MySQL performance problems such as inefficient LIMIT pagination, implicit type conversion, sub‑query updates, mixed ordering, EXISTS usage, condition push‑down limits, early result set reduction, and intermediate result set optimization, providing rewritten SQL examples that dramatically improve execution speed.

MySQLQuery OptimizationSQL
0 likes · 11 min read
Common MySQL Query Performance Issues and Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
May 30, 2019 · Databases

Oracle GoldenGate Migration Guide: Oracle to MySQL Data Replication

This article provides a comprehensive step‑by‑step guide for migrating data from Oracle to MySQL using Oracle GoldenGate, covering architecture overview, environment setup, table and data migration, configuration of source and target processes, handling of common issues, data validation, and reference resources.

Database ReplicationOGGOracle GoldenGate
0 likes · 22 min read
Oracle GoldenGate Migration Guide: Oracle to MySQL Data Replication
Programmer DD
Programmer DD
May 29, 2019 · Backend Development

MyBatis Pitfalls and Best Practices: A Guide for Java Developers

Discover the most common MyBatis pitfalls—from # vs $ usage, handling nulls, resultMap quirks, and dynamic SQL issues—to master safe query practices, optimize performance, and avoid runtime errors, while comparing its strengths and weaknesses against Hibernate for effective Java backend development.

JavaMyBatisORM
0 likes · 23 min read
MyBatis Pitfalls and Best Practices: A Guide for Java Developers
dbaplus Community
dbaplus Community
May 26, 2019 · Databases

Why Is MySQL Query Slow? Common Causes and How to Diagnose Them

This article explains why a MySQL statement may run slowly—whether only occasionally or every time—by examining redo‑log flushing, lock contention, missing or misused indexes, optimizer mis‑estimates, and provides practical commands to identify and resolve each issue.

MySQLQuery OptimizationSQL
0 likes · 12 min read
Why Is MySQL Query Slow? Common Causes and How to Diagnose Them
Programmer DD
Programmer DD
May 15, 2019 · Backend Development

Why MyBatis Runs Extra SQLs and How to Tune Its Cache

This article explains why MyBatis may execute unexpected additional SQL statements, reveals the default caching behavior, shows the required XML configuration and Serializable implementation, and offers practical steps to prevent cache clearing on inserts for more efficient backend data access.

JavaMyBatisORM
0 likes · 3 min read
Why MyBatis Runs Extra SQLs and How to Tune Its Cache
Alibaba Cloud Developer
Alibaba Cloud Developer
May 8, 2019 · Artificial Intelligence

How SQLFlow Lets You Build AI Models with Just a Few SQL Commands

SQLFlow, an open‑source project from Ant Financial, bridges SQL engines and AI frameworks so that users can train and predict machine‑learning models with simple SQL statements, dramatically lowering the technical barrier for analysts and engineers across diverse data platforms.

Artificial IntelligenceGoSQL
0 likes · 14 min read
How SQLFlow Lets You Build AI Models with Just a Few SQL Commands
AntTech
AntTech
May 7, 2019 · Artificial Intelligence

SQLFlow: Bridging SQL Engines and AI Platforms for End‑to‑End Machine Learning

SQLFlow is an open‑source project that connects diverse SQL engines (MySQL, Hive, SparkSQL, etc.) with AI frameworks (TensorFlow, PyTorch, XGBoost, etc.) through extended SQL syntax, enabling analysts to train and predict models using only a few SQL statements while aiming for high scalability and performance.

AI integrationGoSQL
0 likes · 13 min read
SQLFlow: Bridging SQL Engines and AI Platforms for End‑to‑End Machine Learning
Aikesheng Open Source Community
Aikesheng Open Source Community
May 7, 2019 · Databases

Understanding MySQL 8.0 Index Skip Scan (ISS)

MySQL 8.0 introduces Index Skip Scan (ISS), allowing queries that filter on non‑leftmost columns of a composite index to use the index without creating additional indexes, improving performance especially when the leftmost column has few distinct values, as demonstrated with example tables and execution plans.

ISSIndex Skip ScanMySQL
0 likes · 4 min read
Understanding MySQL 8.0 Index Skip Scan (ISS)
Aikesheng Open Source Community
Aikesheng Open Source Community
May 6, 2019 · Databases

How MySQL Finally Supports CHECK Constraints and Why It Matters for Data Integrity

This article explains why MySQL lacked CHECK constraints for years, demonstrates the data quality issues caused by missing checks, shows how to work around them with unsigned types, and provides step‑by‑step examples of using the new CHECK constraint in MySQL 8.0.16+ while highlighting its absence in earlier versions.

CHECK constraintDomain integrityMySQL
0 likes · 6 min read
How MySQL Finally Supports CHECK Constraints and Why It Matters for Data Integrity
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 24, 2019 · Big Data

Hive SQL Optimization Techniques and Best Practices

This article provides a comprehensive guide to Hive SQL performance tuning, covering optimization goals, common pitfalls, execution flow, table and job settings, map, shuffle, reduce, and query-level improvements such as join, bucket join, group‑by, and count‑distinct optimizations.

HadoopHiveOptimization
0 likes · 11 min read
Hive SQL Optimization Techniques and Best Practices
DataFunTalk
DataFunTalk
Apr 24, 2019 · Big Data

Practical Experience with Druid SQL and Security at Meituan: Challenges, Improvements, and Best Practices

This article presents Meituan's real‑world experience with Apache Druid, detailing the platform’s current usage, the usability, security and stability challenges faced, the principles and architecture of Druid SQL, the enhancements made to schema inference, logging, query safety, and the custom security extensions implemented to achieve fine‑grained access control and SSO integration.

DruidOLAPPlatform
0 likes · 14 min read
Practical Experience with Druid SQL and Security at Meituan: Challenges, Improvements, and Best Practices
Tencent Database Technology
Tencent Database Technology
Apr 18, 2019 · Databases

MySQL Execution Process and SemiJoin Optimization Techniques

This article explains MySQL's execution stages, defines SemiJoin, details how IN subqueries can be transformed into SemiJoin queries, outlines conversion constraints, provides example transformations, and describes the various execution strategies MySQL may use for SemiJoins.

MySQLQuery OptimizationSQL
0 likes · 13 min read
MySQL Execution Process and SemiJoin Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 17, 2019 · Databases

SQL Refactoring Guide Based on Distributed Middleware

This article explains how distributed middleware processes simple SQL, ER‑based joins, and cross‑database joins, analyzes their performance impacts, and provides practical recommendations for optimizing SQL statements by using shard conditions, limiting clauses, low‑cardinality columns, and table ordering.

Cross-DB JoinER JoinPerformance Optimization
0 likes · 10 min read
SQL Refactoring Guide Based on Distributed Middleware
Python Crawling & Data Mining
Python Crawling & Data Mining
Apr 15, 2019 · Databases

Master SQL Basics: A Concise Review Guide for Data Analysts

This guide provides a concise review of fundamental database concepts—including definitions of databases, RDBMS, SQL, and tables—and walks through essential SQL query techniques, data manipulation commands, schema definition statements, and control language basics, offering practical examples for data analysts.

DDLDMLSQL
0 likes · 9 min read
Master SQL Basics: A Concise Review Guide for Data Analysts
Java Captain
Java Captain
Apr 12, 2019 · Databases

Understanding MySQL Indexes in InnoDB: Structures, Types, and Optimization Techniques

This article explains MySQL indexes—defining what they are, classifying them by structure, storage, and logic, illustrating InnoDB clustered and secondary index structures with examples, and covering advanced concepts such as covering indexes, the leftmost‑prefix rule, and index condition pushdown to improve query performance.

Covering IndexDatabase IndexesInnoDB
0 likes · 10 min read
Understanding MySQL Indexes in InnoDB: Structures, Types, and Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 10, 2019 · Databases

MySQL 8.0.14 Group Replication Read/Write Consistency: Parameters, Levels, and Use Cases

MySQL 8.0.14 introduces a read/write consistency feature for Group Replication, explaining why MGR can still be inconsistent, detailing the group_replication_consistency parameter with its five levels, their advantages, disadvantages, and appropriate application scenarios, plus example session settings.

Consistency LevelsGroup ReplicationMySQL
0 likes · 7 min read
MySQL 8.0.14 Group Replication Read/Write Consistency: Parameters, Levels, and Use Cases
Java Captain
Java Captain
Apr 6, 2019 · Backend Development

MyBatis Q&A: #{} vs ${}, Pagination Techniques, Caching, Lazy Loading, Executors, and Custom Plugin Development

This article explains MyBatis fundamentals including the difference between #{} and ${} placeholders, various pagination approaches, logical versus physical pagination, first‑ and second‑level caching, lazy‑loading mechanisms, executor types, pagination plugin principles, and how to create a custom MyBatis plugin with code examples.

CachingMyBatisSQL
0 likes · 8 min read
MyBatis Q&A: #{} vs ${}, Pagination Techniques, Caching, Lazy Loading, Executors, and Custom Plugin Development
Java High-Performance Architecture
Java High-Performance Architecture
Mar 28, 2019 · Databases

Mastering MySQL Indexes: From Hash Tables to B+ Trees and Beyond

This article explains the main index structures used in MySQL—including hash tables, ordered arrays, search trees, and B+ trees—covers why InnoDB prefers B+ trees, the benefits of auto‑increment primary keys, and key concepts such as covering indexes, the left‑most prefix rule, and index‑pushdown for query optimization.

B+ TreeMySQLSQL
0 likes · 7 min read
Mastering MySQL Indexes: From Hash Tables to B+ Trees and Beyond
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 22, 2019 · Big Data

Weekly Knowledge Points: Apache Flink Continuous Queries, Kafka Connectors, SQL Overview, JOIN Operator, and Table API

This weekly briefing introduces Apache Flink's continuous query mechanism, demonstrates how to integrate Kafka as a DataStream connector, provides an overview of Flink SQL features, explains the implementation and optimization of dual‑stream JOIN operators, and showcases the Table API with end‑to‑end examples.

Apache FlinkSQLTable API
0 likes · 3 min read
Weekly Knowledge Points: Apache Flink Continuous Queries, Kafka Connectors, SQL Overview, JOIN Operator, and Table API
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 21, 2019 · Big Data

Apache Flink Table API Tutorial and End‑to‑End Examples

This article provides a comprehensive tutorial on Apache Flink's Table API, explaining its concepts, core features, and a wide range of operators such as SELECT, WHERE, GROUP BY, UNION, JOIN, and various window functions, while offering complete Scala code examples, custom sources, sinks, and an end‑to‑end job that computes page‑view counts per region using event‑time tumbling windows.

FlinkSQLScala
0 likes · 36 min read
Apache Flink Table API Tutorial and End‑to‑End Examples
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 20, 2019 · Databases

Understanding JOIN Operators: From Traditional Databases to Apache Flink Streaming

This article explains the purpose and types of SQL JOIN operators, demonstrates their syntax and semantics with examples, compares traditional database joins to Apache Flink's streaming two‑stream join implementation, and discusses optimization techniques such as state management, shuffle handling, and join reordering.

Apache FlinkSQLdatabase
0 likes · 22 min read
Understanding JOIN Operators: From Traditional Databases to Apache Flink Streaming
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 19, 2019 · Big Data

Comprehensive Overview of SQL and Apache Flink SQL Features with Practical Code Examples

This article provides an in-depth introduction to SQL, its history and ANSI standards, then details Apache Flink's SQL capabilities—including SELECT, WHERE, GROUP BY, UNION, JOIN, window functions, and user-defined functions—accompanied by extensive code examples and a complete end‑to‑end Flink job implementation.

Apache FlinkSQLUser Defined Functions
0 likes · 34 min read
Comprehensive Overview of SQL and Apache Flink SQL Features with Practical Code Examples
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 18, 2019 · Databases

Improving MyCat Pitfalls with the Distributed Middleware DBLE: Technical Review and Comparison

This article reviews the shortcomings of MyCat in handling sharding, joins, inserts, and session variables, demonstrates how the DBLE middleware addresses those issues with better correctness, performance, security, and operational management, and discusses code‑quality improvements and automated testing practices.

DBLESQLdistributed systems
0 likes · 19 min read
Improving MyCat Pitfalls with the Distributed Middleware DBLE: Technical Review and Comparison
Programmer DD
Programmer DD
Mar 18, 2019 · Databases

Why Database Indexes Are the Secret Weapon for Faster Queries

Database indexes, akin to a dictionary’s table of contents, dramatically speed up data retrieval, and this article explains what indexes are, how composite indexes work, the left‑most prefix rule, and the difference between clustered and non‑clustered indexes, using clear analogies and examples.

Composite IndexSQLclustered index
0 likes · 8 min read
Why Database Indexes Are the Secret Weapon for Faster Queries
Liangxu Linux
Liangxu Linux
Mar 17, 2019 · Databases

How to Find and Remove Duplicate Rows in SQL Tables

This guide explains how to define duplicate rows, use GROUP BY and HAVING to locate them, and apply temporary tables and DELETE statements to remove duplicates while preserving the row with the smallest ID.

DELETEGROUP BYHAVING
0 likes · 11 min read
How to Find and Remove Duplicate Rows in SQL Tables