BestHub
Sign in
Tagged articles
2776 articles
Page 25 of 28
Java Captain
Java Captain
Dec 30, 2018 · Backend Development

Using MyBatis3 Annotations to Replace XML Configuration: A Comprehensive Guide

This article provides a step‑by‑step tutorial on using MyBatis3 annotation‑based CRUD, mapping, and provider annotations to replace XML configuration in a Spring Boot project, covering basic annotations, result mapping, dynamic SQL, Maven dependencies, configuration files, entity classes, database scripts, controller code, and testing procedures.

CRUDJavaMyBatis
0 likes · 11 min read
Using MyBatis3 Annotations to Replace XML Configuration: A Comprehensive Guide
Java Captain
Java Captain
Dec 26, 2018 · Backend Development

Understanding MyBatis Initialization: Configuration Creation and Design Patterns

This article explains the complete MyBatis initialization process, detailing how the XML configuration file is parsed into a Configuration object, how SqlSessionFactory and SqlSession are built, and highlights the Builder design pattern used throughout the setup, with code examples for manual configuration loading.

Builder PatternInitializationJava
0 likes · 13 min read
Understanding MyBatis Initialization: Configuration Creation and Design Patterns
21CTO
21CTO
Dec 23, 2018 · Databases

Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data

This article examines a MySQL data‑update mishap caused by misplaced quotation marks, showing how such syntax errors turn intended string assignments into zero values, and explains the underlying expression evaluation that leads to all rows being updated to 0.

Data lossDatabaseQuote Error
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data
ITPUB
ITPUB
Dec 21, 2018 · Databases

Why Misplaced Double Quotes Turn MySQL UPDATE Results into Zero

A developer ran a series of UPDATE statements that appeared correct, but due to misplaced double‑quotation marks the WHERE clause was parsed incorrectly, causing every row's column to be set to 0; the article explains MySQL's expression evaluation, shows binlog analysis, and offers practical debugging tips.

DebuggingImplicit ConversionSQL
0 likes · 7 min read
Why Misplaced Double Quotes Turn MySQL UPDATE Results into Zero
Java Captain
Java Captain
Dec 21, 2018 · Backend Development

How to Prepare for Java Backend Developer Interviews: Frameworks, Distributed Systems, and Performance Optimization

This article provides practical guidance for Java backend interview preparation, emphasizing solid Java fundamentals, hands‑on framework experience, distributed system knowledge, database performance tuning, core data‑structure and concurrency concepts, Linux log troubleshooting, and how to showcase real project achievements.

DistributedInterviewJava
0 likes · 13 min read
How to Prepare for Java Backend Developer Interviews: Frameworks, Distributed Systems, and Performance Optimization
dbaplus Community
dbaplus Community
Dec 16, 2018 · Databases

How to Design an Effective SQL Audit System for Better DB Performance

This article explains why SQL auditing is essential, outlines its core principles, dimensions, scoring model, and workflow, and provides practical guidance on building a self‑service, visualized, and automated audit solution that improves database reliability and developer productivity.

DBADatabase AuditingPerformance
0 likes · 14 min read
How to Design an Effective SQL Audit System for Better DB Performance
Efficient Ops
Efficient Ops
Nov 28, 2018 · Databases

Master MySQL Indexes: When and How They’re Used for Queries

This article explains how MySQL decides whether an index can be used for range queries, LIKE patterns, and sorting, detailing key_len calculation, index key vs. filter vs. table filter concepts, and practical examples with BETWEEN and ORDER BY.

Database PerformanceIndex OptimizationQuery Planning
0 likes · 11 min read
Master MySQL Indexes: When and How They’re Used for Queries
ITPUB
ITPUB
Nov 27, 2018 · Databases

Boost MySQL Performance: Field Types, JOIN vs Subqueries, UNION, and Transactions

This guide presents four practical MySQL performance‑boosting techniques—selecting optimal column types, replacing sub‑queries with JOINs, using UNION instead of temporary tables, and employing transactions with BEGIN/COMMIT/ROLLBACK—to make queries faster and ensure data integrity.

Database TuningJoinPerformance Optimization
0 likes · 6 min read
Boost MySQL Performance: Field Types, JOIN vs Subqueries, UNION, and Transactions
Xianyu Technology
Xianyu Technology
Nov 27, 2018 · Big Data

Millisecond-Scale Multi-Dimensional Data Filtering with HybridDB for MySQL

HybridDB for MySQL delivers millisecond‑scale, multi‑dimensional filtering on billions of rows with hundreds of metrics by combining a high‑performance columnar engine, automatic composite indexes, and a fused MPP‑DAG pipeline, turning half‑day push preparation into seconds while supporting full SQL, spatial, and JSON data.

Columnar StorageHybridDBOLAP
0 likes · 8 min read
Millisecond-Scale Multi-Dimensional Data Filtering with HybridDB for MySQL
ITPUB
ITPUB
Nov 24, 2018 · Databases

Why Did My Oracle SQL Run in Parallel? Uncovering Hidden Parallelism and Fixing It

This article walks through diagnosing unexpected Oracle parallel execution, resolving DBLINK‑induced plan anomalies after a database upgrade, and fixing ORA‑00604 errors caused by missing domain indexes, providing step‑by‑step queries, parameter checks, and corrective ALTER statements to restore normal performance.

DBLINKDomain IndexOracle
0 likes · 12 min read
Why Did My Oracle SQL Run in Parallel? Uncovering Hidden Parallelism and Fixing It
Programmer DD
Programmer DD
Nov 17, 2018 · Databases

How InnoDB Indexes Work: From Data Pages to B+ Trees

This article explains how InnoDB stores data pages, builds page directories, and uses B+‑tree indexes—including clustered, secondary, and composite indexes—to enable fast record lookup, while also covering MyISAM indexing differences and the SQL statements for creating and dropping indexes.

B+TreeInnoDBSQL
0 likes · 27 min read
How InnoDB Indexes Work: From Data Pages to B+ Trees
Programmer DD
Programmer DD
Nov 7, 2018 · Big Data

Choosing the Right SQL Engine for Big Data: A Practical Guide

This article explores various SQL engines and storage options for big‑data workloads, compares their performance and capabilities, shows practical code examples, and offers guidance on writing efficient SQL in complex data environments.

Big DataHiveSQL
0 likes · 6 min read
Choosing the Right SQL Engine for Big Data: A Practical Guide
Java Backend Technology
Java Backend Technology
Nov 5, 2018 · Databases

Top 10 MySQL Errors Every DBA Should Know and How to Fix Them

This article presents ten classic MySQL error scenarios—from connection limits and replication conflicts to permission issues and timeout settings—explaining their causes, illustrating them with screenshots, and offering concrete configuration tweaks and procedural steps to resolve each problem efficiently.

Database ErrorsPerformanceSQL
0 likes · 9 min read
Top 10 MySQL Errors Every DBA Should Know and How to Fix Them
MaGe Linux Operations
MaGe Linux Operations
Oct 30, 2018 · Databases

Top 10 MySQL Error Cases and How to Fix Them

This article presents ten classic MySQL error scenarios—from connection limits and replication conflicts to permission issues and character‑set problems—explaining their root causes, diagnostic commands, and step‑by‑step solutions to help beginners and DBAs troubleshoot efficiently.

Error HandlingSQLdatabase troubleshooting
0 likes · 16 min read
Top 10 MySQL Error Cases and How to Fix Them
dbaplus Community
dbaplus Community
Oct 16, 2018 · Databases

Master MySQL Window Functions: From Basics to Advanced Use Cases

This tutorial explains why and how to use MySQL window functions, covering their concepts, syntax, various function families, practical examples such as ranking, distribution, lead/lag, first/last, and aggregations within dynamic windows, plus detailed SQL snippets and visual illustrations.

AnalyticsDatabaseSQL
0 likes · 13 min read
Master MySQL Window Functions: From Basics to Advanced Use Cases
Efficient Ops
Efficient Ops
Oct 10, 2018 · Databases

Boost Your Database Reliability with Xiaomi’s Open‑Source SQL Optimizer SOAR

Xiaomi is open‑sourcing its Go‑based SQL Optimizer and Rewriter (SOAR) at OSCAR Days, a tool that automatically checks SQL quality, suggests index improvements, rewrites queries, provides EXPLAIN analysis, and integrates with editor plugins and a web self‑audit platform to boost database reliability and developer productivity.

GoSQLopen-source
0 likes · 5 min read
Boost Your Database Reliability with Xiaomi’s Open‑Source SQL Optimizer SOAR
Beike Product & Technology
Beike Product & Technology
Sep 28, 2018 · Databases

Using ClickHouse for Large‑Scale User Behavior Analysis at Beike Zhaofang

This article details how Beike Zhaofang leveraged the ClickHouse columnar OLAP database for large‑scale user behavior analysis, covering its architecture, key features, performance benchmarks against other engines, data ingestion pipelines, custom UDFs for funnel and retention metrics, deployment setup, and future enhancements.

ClickHouseFunnel AnalysisOLAP
0 likes · 13 min read
Using ClickHouse for Large‑Scale User Behavior Analysis at Beike Zhaofang
21CTO
21CTO
Sep 26, 2018 · Big Data

Unlock Powerful Data Insights with Redash: Quick Intro and Setup Guide

This article introduces the open‑source BI platform Redash, outlines its wide‑range data source support and visualization capabilities, and provides step‑by‑step Docker‑Compose installation instructions along with practical usage tips for building dashboards.

BIData visualizationDocker
0 likes · 6 min read
Unlock Powerful Data Insights with Redash: Quick Intro and Setup Guide
Java Backend Technology
Java Backend Technology
Sep 8, 2018 · Databases

Master MySQL Quickly: Essential Tips, Best Practices, and Common Pitfalls

This comprehensive guide walks you through mastering MySQL by covering server configuration choices, storage engine selection, data type recommendations, index strategies, backup methods, logging options, and practical advice on triggers, views, stored procedures, and character set handling, all aimed at boosting performance and avoiding common mistakes.

DatabaseIndexesPerformance
0 likes · 26 min read
Master MySQL Quickly: Essential Tips, Best Practices, and Common Pitfalls
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 21, 2018 · Databases

Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials

This article explains fundamental MySQL concepts including primary, candidate, super and foreign keys, transaction ACID properties, view creation, differences among DROP, DELETE and TRUNCATE, index structures and types, join variations, normalization forms, optimization techniques, replication mechanisms, engine distinctions, and logging formats.

DatabaseIndexesSQL
0 likes · 29 min read
Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials
dbaplus Community
dbaplus Community
Aug 20, 2018 · Databases

Unlock PostgreSQL’s Powerful SQL Features: CTEs, UPSERT, Sampling, and More

This article explores PostgreSQL’s advanced SQL capabilities—including Common Table Expressions (WITH), batch inserts, the RETURNING clause, UPSERT with ON CONFLICT, TABLESAMPLE methods, aggregation functions like string_agg and array_agg, and a range of window functions—providing practical examples, performance insights, and guidance for real‑world use.

CTEPostgreSQLSQL
0 likes · 17 min read
Unlock PostgreSQL’s Powerful SQL Features: CTEs, UPSERT, Sampling, and More
Architect's Tech Stack
Architect's Tech Stack
Aug 12, 2018 · Backend Development

Investigating MyBatis SqlSession.clearCache() Ineffectiveness and Transaction Isolation Level Solution

Through detailed debugging and source code analysis, the author discovers that MyBatis's SqlSession.clearCache() does clear the first‑level cache, but the observed stale query results are caused by MySQL's default REPEATABLE‑READ isolation level, which can be resolved by setting the transaction isolation to READ COMMITTED.

CacheDebuggingJava
0 likes · 8 min read
Investigating MyBatis SqlSession.clearCache() Ineffectiveness and Transaction Isolation Level Solution
360 Quality & Efficiency
360 Quality & Efficiency
Aug 10, 2018 · Databases

Automating MySQL Database Testing with Shell Scripts

This article explains how to use Bash shell scripts on Linux to automate MySQL database testing tasks such as creating tables, inserting, updating, and monitoring dynamic database states, providing step‑by‑step code examples and execution instructions for efficient test automation.

LinuxSQLShell scripting
0 likes · 7 min read
Automating MySQL Database Testing with Shell Scripts
Architects Research Society
Architects Research Society
Jul 27, 2018 · Big Data

Overview of Apache Hive Features, Usage, and Management

Apache Hive is an open‑source data‑warehouse system built on Hadoop that enables users to read, write, and manage large distributed datasets using SQL‑like queries, offering features such as ETL support, various file‑format connectors, extensible UDFs, and integration with tools like Tez, Spark, and MapReduce.

Apache HiveBig DataData Warehouse
0 likes · 5 min read
Overview of Apache Hive Features, Usage, and Management
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 5, 2018 · Databases

Understanding InnoDB Transaction Isolation Levels and Their Impact on Locks and Performance

This article explains the importance of transaction isolation in ACID, describes the four InnoDB isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—covers their locking behavior, effects on replication, and performance trade‑offs, and offers guidance on choosing the appropriate level.

InnoDBLocksSQL
0 likes · 7 min read
Understanding InnoDB Transaction Isolation Levels and Their Impact on Locks and Performance
ITPUB
ITPUB
Jul 3, 2018 · Databases

How T‑TDSQL Implements Dual‑Temporal Data Management in Distributed Environments

This article details the architecture and implementation techniques of T‑TDSQL’s dual‑temporal database system, covering full‑state data reading, history‑table creation, snapshot query syntax, transaction snapshot attributes, visibility algorithms, transaction‑state management, index design, and valid‑time creation, query, update, and delete operations.

MVCCSQLTDSQL
0 likes · 17 min read
How T‑TDSQL Implements Dual‑Temporal Data Management in Distributed Environments
360 Quality & Efficiency
360 Quality & Efficiency
Jun 28, 2018 · Big Data

An Introduction to Apache Hive: Architecture, Workflow, Storage, Advantages, and Comparison with Traditional Databases

This article provides a concise overview of Apache Hive, covering its definition, Hadoop background, architecture, query workflow, storage model, advantages, disadvantages, and a comparison with traditional relational databases, helping readers understand how Hive enables SQL-like queries on data stored in HDFS.

Data WarehouseHadoopHive
0 likes · 5 min read
An Introduction to Apache Hive: Architecture, Workflow, Storage, Advantages, and Comparison with Traditional Databases
dbaplus Community
dbaplus Community
Jun 26, 2018 · Databases

Why Oracle Tablespace Queries Stall and How to Resolve Them Fast

The article walks through two common Oracle performance problems—slow tablespace‑information queries and sluggish ASH data collection—explaining root causes, showing diagnostic steps, and providing exact SQL and PL/SQL scripts to gather statistics, clean up partitions, and restore fast query response.

ASHOraclePerformance tuning
0 likes · 11 min read
Why Oracle Tablespace Queries Stall and How to Resolve Them Fast
ITPUB
ITPUB
Jun 14, 2018 · Databases

How T‑TDSQL Enables Real‑Time Incremental Reconciliation and Temporal Flashback

This article explains how T‑TDSQL leverages full‑temporal storage and snapshot‑difference techniques to perform incremental data extraction, precise account reconciliation, online flashback, and data replay, illustrating the underlying SQL commands, error‑handling tables, and practical benefits for internet finance workloads.

Data ReconciliationData ReplayIncremental Computation
0 likes · 14 min read
How T‑TDSQL Enables Real‑Time Incremental Reconciliation and Temporal Flashback
ITPUB
ITPUB
Jun 14, 2018 · Databases

Mastering Oracle Partitioning: Concepts, History, Best Practices & New Features

This article presents a comprehensive overview of Oracle partitioning, covering basic concepts, the evolution of partition features across versions, practical best‑practice scenarios, and the latest enhancements in Oracle 12c, 12.2, and 18c that improve performance, manageability, and availability.

Best PracticesDatabaseOracle
0 likes · 17 min read
Mastering Oracle Partitioning: Concepts, History, Best Practices & New Features
Java Architect Essentials
Java Architect Essentials
Jun 4, 2018 · Databases

Fundamental SQL Commands and Database Design Basics

This article provides a concise introduction to essential SQL concepts, covering database creation, manipulation, table design, constraints, indexes, and common DDL statements, making it a useful reference for beginners and experienced developers alike.

ConstraintsDDLIndexes
0 likes · 7 min read
Fundamental SQL Commands and Database Design Basics
ITFLY8 Architecture Home
ITFLY8 Architecture Home
May 31, 2018 · Databases

Master Relational Database Design: From Basics to Normalization

This article walks through choosing a web framework and database, introduces relational databases, explains design steps such as requirement analysis, table creation, primary key selection, relationship modeling (one‑to‑many, many‑to‑many, one‑to‑one) with SQL examples, and covers normalization forms, integrity rules, and indexing strategies.

Database DesignForeign KeyRelational Database
0 likes · 19 min read
Master Relational Database Design: From Basics to Normalization
dbaplus Community
dbaplus Community
May 20, 2018 · Databases

How to Use MariaDB System-Versioned Tables for Easy Data Recovery

This guide explains MariaDB 10.3 system-versioned tables, showing how to create them with PERIOD FOR SYSTEM_TIME, query historical rows using FOR SYSTEM_TIME clauses, restore previous data via export/import, partition history to reduce storage, and safely manage versioning in production environments.

Data RecoveryMariaDBSQL
0 likes · 10 min read
How to Use MariaDB System-Versioned Tables for Easy Data Recovery
dbaplus Community
dbaplus Community
May 16, 2018 · Databases

Master MySQL: Essential Commands, Indexes, Stored Procedures & Triggers

This guide provides a comprehensive overview of MySQL fundamentals—including CRUD statements, table creation, index management, data manipulation, transaction control, stored procedures, and trigger creation—complete with syntax examples and practical tips for reliable database development.

CRUDDatabaseSQL
0 likes · 26 min read
Master MySQL: Essential Commands, Indexes, Stored Procedures & Triggers
JD Tech
JD Tech
May 11, 2018 · Databases

MySQL 8.0 User Management, Password Policies, and Role Management

This article explains the new MySQL 8.0 features for user and role management, including changes to authentication plugins, password encryption, dynamic SET PERSIST configuration, password expiration and reuse policies, and detailed SQL examples for creating users, granting privileges, and managing roles.

Password policyRolesSET PERSIST
0 likes · 14 min read
MySQL 8.0 User Management, Password Policies, and Role Management
Tencent Cloud Developer
Tencent Cloud Developer
May 9, 2018 · Artificial Intelligence

From Mathematics to Machine Learning: A Personal Journey Through Recommendation, Security, and AIOps

A mathematician‑turned‑engineer recounts his 2015‑2022 path from undocumented recommendation systems at Tencent, through high‑precision security models, reinforcement‑learning game AI, quantum‑ML studies, to large‑scale AIOps time‑series anomaly detection, offering practical lessons for anyone transitioning into machine learning.

Anomaly DetectionRecommendation SystemsSQL
0 likes · 16 min read
From Mathematics to Machine Learning: A Personal Journey Through Recommendation, Security, and AIOps
ITFLY8 Architecture Home
ITFLY8 Architecture Home
May 8, 2018 · Databases

21 Essential MySQL Performance Tips Every Developer Should Know

This article presents a comprehensive set of MySQL optimization techniques—including query‑cache tuning, proper use of EXPLAIN, indexing strategies, avoiding costly functions, and leveraging prepared statements—to help developers eliminate database bottlenecks and boost web‑application performance.

Database TuningIndexesSQL
0 likes · 21 min read
21 Essential MySQL Performance Tips Every Developer Should Know
Efficient Ops
Efficient Ops
May 7, 2018 · Databases

Unveiling MySQL Query Optimization: Architecture, Execution, and Practical Tips

This article demystifies MySQL query optimization by explaining the server's logical architecture, the end‑to‑end query processing flow, the role of the client/server protocol, query cache, parsing, optimizer, execution engine, and result delivery, and then offers concrete performance‑tuning recommendations on schema design, data types, indexing strategies, and specific query patterns such as COUNT(), JOIN, LIMIT pagination, and UNION.

Database PerformanceSQLindexing
0 likes · 35 min read
Unveiling MySQL Query Optimization: Architecture, Execution, and Practical Tips
360 Quality & Efficiency
360 Quality & Efficiency
Apr 27, 2018 · Databases

Common MySQL Commands and Comparison with Oracle

This article presents essential MySQL command-line operations, database and table management statements, and compares equivalent SQL syntax in Oracle, covering date handling, string functions, and notable differences such as pagination and auto‑increment behavior.

Database CommandsOracleSQL
0 likes · 5 min read
Common MySQL Commands and Comparison with Oracle
MaGe Linux Operations
MaGe Linux Operations
Apr 26, 2018 · Databases

Find Duplicate Rows in MySQL: Simple Queries for Beginners

This article shows how to identify and remove duplicate rows in a MySQL table by defining duplication, using GROUP BY with HAVING, creating temporary tables with MIN, and applying various techniques—including UNION, nested subqueries, and joins—to handle single‑column and multi‑column duplicate detection.

Data cleaningGROUP BYHAVING
0 likes · 11 min read
Find Duplicate Rows in MySQL: Simple Queries for Beginners
ITPUB
ITPUB
Apr 16, 2018 · Databases

Why Do Oracle DBMS_JOBS Show a 4000‑01‑01 Next Date? Debugging Stuck Jobs

This guide explains why an Oracle DBMS_JOB can end up with a next execution date of 4000‑01‑01, how to interpret its status fields, diagnose the underlying errors, and restore the job using manual execution and log‑based troubleshooting steps.

DBMS_JOBSDatabase AdministrationJob Scheduling
0 likes · 5 min read
Why Do Oracle DBMS_JOBS Show a 4000‑01‑01 Next Date? Debugging Stuck Jobs
ITPUB
ITPUB
Apr 8, 2018 · Databases

How to Check and Manage Oracle RAC Instances and Services with SRVCTL

This guide shows how to use SRVCTL commands and SQL queries to view the status of Oracle RAC databases, instances, services, node applications, ASM instances, and disk groups, as well as how to start and stop the entire RAC cluster safely.

ClusterDatabase ManagementOracle
0 likes · 10 min read
How to Check and Manage Oracle RAC Instances and Services with SRVCTL
Java Captain
Java Captain
Apr 6, 2018 · Databases

Understanding MySQL Indexes and Using EXPLAIN for Query Optimization

This article explains how MySQL indexes work, why queries can become slow, how to interpret the EXPLAIN output—including id, select_type, table, type, possible_keys, key, key_len, ref, rows, and extra columns—and provides practical examples and optimization cases to improve query performance while balancing the cost of maintaining indexes.

Database PerformanceSQLindex
0 likes · 13 min read
Understanding MySQL Indexes and Using EXPLAIN for Query Optimization
ITPUB
ITPUB
Mar 30, 2018 · Databases

Step‑by‑Step Oracle Multi‑Master Replication Setup with Full SQL Scripts

This guide walks through configuring Oracle multi‑master data replication, covering site creation, group objects, propagator and receiver setup, purge scheduling, database link creation, replication group definition, table registration, conflict handling, and finally resuming replication, all illustrated with complete SQL code examples.

DatabaseOracleSQL
0 likes · 7 min read
Step‑by‑Step Oracle Multi‑Master Replication Setup with Full SQL Scripts
ITPUB
ITPUB
Mar 26, 2018 · Databases

30 Essential SQL Query Optimization Tips to Avoid Full Table Scans

This article presents thirty practical SQL tuning guidelines—ranging from avoiding certain WHERE‑clause operators and functions to proper index usage and set‑based alternatives—that help prevent full table scans and improve overall database performance.

Best PracticesDatabase PerformanceIndexes
0 likes · 11 min read
30 Essential SQL Query Optimization Tips to Avoid Full Table Scans
Architect's Tech Stack
Architect's Tech Stack
Mar 23, 2018 · Databases

MySQL Interview Questions and Answers: ACID, Isolation Levels, Storage Engines, Indexes, Locks, and More

This article compiles essential MySQL interview topics, covering ACID transaction properties, isolation levels and their issues, storage engine differences, index types, query execution order, lock mechanisms, temporary tables, normalization, read‑write splitting, performance tuning, and recovery logs, providing concise explanations and examples for each concept.

LockPerformanceSQL
0 likes · 36 min read
MySQL Interview Questions and Answers: ACID, Isolation Levels, Storage Engines, Indexes, Locks, and More
ITPUB
ITPUB
Mar 23, 2018 · Databases

Why Classic MySQL Pagination “Optimization” Often Fails and When It Actually Helps

This article investigates the classic MySQL pagination “optimization” technique, reproduces tests on a low‑end server, compares plain LIMIT queries with the sub‑query rewrite on both clustered and non‑clustered indexes, and explains why the method sometimes improves performance and sometimes adds overhead.

SQLindexmysql
0 likes · 15 min read
Why Classic MySQL Pagination “Optimization” Often Fails and When It Actually Helps
ITPUB
ITPUB
Mar 19, 2018 · Databases

Why Oracle EM Fails with a Static Listener and How to Fix It

The article explains that Oracle Enterprise Manager requires listeners with dynamic registration, shows how a static listener on a non‑default port causes a "database is down" error, and provides step‑by‑step commands to modify the local_listener parameter so both listeners register dynamically and EM works correctly.

DatabaseDynamic RegistrationEnterprise Manager
0 likes · 9 min read
Why Oracle EM Fails with a Static Listener and How to Fix It
21CTO
21CTO
Mar 14, 2018 · Databases

Unlock Faster Queries: Master Window Functions and CTEs in MySQL & MariaDB

Both MySQL 8 and MariaDB 10.2 introduce robust window functions and Common Table Expressions (CTEs), enabling developers to write more efficient, maintainable queries; this article explains their syntax, demonstrates practical examples, compares implementations, and highlights performance and readability benefits across popular database systems.

CTEMariaDBSQL
0 likes · 13 min read
Unlock Faster Queries: Master Window Functions and CTEs in MySQL & MariaDB
ITPUB
ITPUB
Mar 13, 2018 · Databases

Optimizing Large-Scale Oracle Queries with Temporary Tables

This article examines a high‑volume Oracle query scenario, explains why using multiple IN clauses on millions of rows leads to costly full‑table scans, and presents three alternative strategies—including a single‑SQL join, UNION ALL view, and temporary‑table approaches—along with practical examples and performance considerations.

Database PerformanceOracleSQL
0 likes · 10 min read
Optimizing Large-Scale Oracle Queries with Temporary Tables
ITPUB
ITPUB
Feb 26, 2018 · Databases

15 Common SQL Performance Pitfalls and Proven Fixes

This article outlines the most frequent SQL performance mistakes—such as misusing UPDATE, over‑selecting columns, unnecessary double queries, and improper use of GUIDs—and provides concrete, actionable techniques like CASE expressions, temporary tables, batch operations, and table‑valued functions to dramatically improve query speed and concurrency.

Best PracticesDatabase TuningOptimization
0 likes · 14 min read
15 Common SQL Performance Pitfalls and Proven Fixes
ITPUB
ITPUB
Feb 22, 2018 · Databases

How to Diagnose and Resolve Oracle TX Row Lock Contention

This guide explains Oracle's TX row lock mechanism, shows how to identify blocking sessions, locate the exact locked rows using system views and ROWID functions, and provides practical steps to prevent and mitigate TX lock waiting issues.

Database ConcurrencyOracleSQL
0 likes · 8 min read
How to Diagnose and Resolve Oracle TX Row Lock Contention
MaGe Linux Operations
MaGe Linux Operations
Feb 3, 2018 · Databases

Master MySQL: From Basics to Advanced Operations and Essential Tools

This comprehensive guide introduces MySQL fundamentals, walks through installation on Windows and Linux, explains core commands for connecting, creating databases, managing users and privileges, performing table CRUD operations, handling data types, and provides a curated list of analysis, backup, performance, HA, and GUI tools for MySQL.

CRUDData TypesInstallation
0 likes · 23 min read
Master MySQL: From Basics to Advanced Operations and Essential Tools
ITPUB
ITPUB
Jan 27, 2018 · Databases

Why NewSQL Matters: From Relational Roots to Modern HTAP

This article traces the evolution of database systems—from early navigational models and Codd's relational theory through the rise of NoSQL and sharding, to the resurgence of NewSQL and the emerging HTAP paradigm—highlighting technical motivations, design trade‑offs, and future directions.

DatabaseHTAPNewSQL
0 likes · 21 min read
Why NewSQL Matters: From Relational Roots to Modern HTAP
ITPUB
ITPUB
Jan 16, 2018 · Databases

10 Groundbreaking Database Systems Launched in 2017

A 2017 roundup highlights ten innovative database releases—including a time‑series extension for PostgreSQL, a multi‑model Azure service, Google’s globally distributed Spanner, Amazon’s Neptune graph service, and several open‑source cloud‑native databases—detailing their key features, architectures, and intended use cases.

DistributedSQLTime-series
0 likes · 10 min read
10 Groundbreaking Database Systems Launched in 2017
ITPUB
ITPUB
Jan 11, 2018 · Databases

Master MySQL Character Sets & Collations: When and How to Configure Them

This article explains MySQL character sets and collations, their relationship, how to view supported options, and step‑by‑step methods for configuring them at server, database, table, and column levels, plus guidance on when each setting should be applied.

SQLcollationmysql
0 likes · 14 min read
Master MySQL Character Sets & Collations: When and How to Configure Them
ITPUB
ITPUB
Dec 27, 2017 · Databases

Understanding MySQL Transaction Isolation Levels with Real‑World Examples

This article explains the four MySQL transaction isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—by creating a sample table and running step‑by‑step command‑line sessions that demonstrate dirty reads, non‑repeatable reads, phantom reads, and the practical limits of InnoDB's MVCC implementation.

DatabaseInnoDBSQL
0 likes · 9 min read
Understanding MySQL Transaction Isolation Levels with Real‑World Examples
dbaplus Community
dbaplus Community
Dec 12, 2017 · Databases

MariaDB ColumnStore: Future‑Ready OLAP Architecture, Limits & Migration Tips

This article shares practical experience deploying MariaDB ColumnStore for offline OLAP, covering its MPP‑based architecture, user‑experience benefits, high‑availability options, numerous syntax and data‑type limitations, and detailed scripts for schema conversion and incremental data extraction using pt‑archiver.

ColumnstoreData MigrationMariaDB
0 likes · 17 min read
MariaDB ColumnStore: Future‑Ready OLAP Architecture, Limits & Migration Tips
ITPUB
ITPUB
Dec 12, 2017 · Databases

Understanding PostgreSQL’s Subquery Planner: How Query Optimization Works

This article explains how PostgreSQL transforms and rewrites query trees, why a completed transform‑rewrite tree may not be optimal, and details the subquery_planner’s role, tuple_fraction handling, and the step‑by‑step logical optimization process used to generate efficient execution plans.

DatabasePlanner HookPostgreSQL
0 likes · 7 min read
Understanding PostgreSQL’s Subquery Planner: How Query Optimization Works
ITPUB
ITPUB
Dec 6, 2017 · Databases

Mastering Oracle Data Dictionary: Types, Views, and Practical Queries

This article explains the classification of Oracle data dictionary objects, demonstrates how to query static and dynamic dictionary tables and views, lists common view families and permission views, and provides numerous SQL examples for inspecting users, tables, indexes, sequences, constraints, and PL/SQL objects.

DatabaseOraclePerformance
0 likes · 13 min read
Mastering Oracle Data Dictionary: Types, Views, and Practical Queries
ITPUB
ITPUB
Dec 5, 2017 · Databases

How to Remove Duplicate MySQL Records with a Single Fast SQL Query

This article walks through the problem of duplicate rows in a MySQL table, shows an initial complex SQL attempt, compares a slow PHP‑based cleanup, and finally presents a concise, three‑step DELETE statement that eliminates duplicates in under a second.

Performance OptimizationSQLdata cleanup
0 likes · 6 min read
How to Remove Duplicate MySQL Records with a Single Fast SQL Query
ITPUB
ITPUB
Dec 1, 2017 · Databases

How to Shrink Oracle Indexes for Skewed Columns Using Function Indexes

This article explains why conventional indexes waste space and perform poorly on highly skewed columns, introduces a decode‑based function index that excludes high‑frequency values, details the experimental setup with millions of rows, compares index size and query performance, and outlines the method's limitations.

Data SkewFunction IndexOracle
0 likes · 10 min read
How to Shrink Oracle Indexes for Skewed Columns Using Function Indexes
Senior Brother's Insights
Senior Brother's Insights
Nov 29, 2017 · Databases

Mastering SQL Performance: Proven Optimization Techniques and Best Practices

Learn a comprehensive methodology for SQL performance tuning, from identifying resource bottlenecks and understanding query processing stages to applying practical optimization tactics such as efficient joins, index usage, avoiding costly operations, and best‑practice guidelines that improve execution speed and resource consumption.

DatabaseOptimizationPerformance
0 likes · 13 min read
Mastering SQL Performance: Proven Optimization Techniques and Best Practices
dbaplus Community
dbaplus Community
Nov 29, 2017 · Databases

Why Fewer Permissions Slow Down Oracle SQL: A Deep Dive into EXISTS Subqueries

An Oracle SQL query with five EXISTS permission checks runs dramatically slower when only a few permissions are configured, and the author investigates the root cause using execution plans, SQL Monitor data, and step‑by‑step testing, ultimately revealing how execution counts and row returns drive the unexpected performance degradation.

EXISTSOraclePerformance tuning
0 likes · 11 min read
Why Fewer Permissions Slow Down Oracle SQL: A Deep Dive into EXISTS Subqueries
ITPUB
ITPUB
Nov 27, 2017 · Databases

Essential Database Design and Query Optimization Tips for Faster SQL Performance

This article outlines essential database design principles and a comprehensive set of query optimization techniques, covering row size limits, appropriate data types, field length choices, index usage, avoiding costly WHERE clause patterns, and best practices for temporary tables, transactions, and result set handling to boost SQL performance.

Best PracticesDatabase DesignIndexes
0 likes · 13 min read
Essential Database Design and Query Optimization Tips for Faster SQL Performance
ITPUB
ITPUB
Nov 22, 2017 · Databases

Boost MySQL Bulk Inserts: Proven Techniques & Optimized Syntax

This guide explains the factors that affect MySQL INSERT performance and presents a collection of practical techniques—including multi‑row INSERT, bulk_insert_buffer_size tuning, INSERT DELAYED, LOAD DATA INFILE, table creation with disabled keys, LOCK TABLES, and the proper use of IGNORE and ON DUPLICATE KEY UPDATE—to dramatically speed up large‑scale data loading.

InsertSQLbulk load
0 likes · 11 min read
Boost MySQL Bulk Inserts: Proven Techniques & Optimized Syntax
Qunar Tech Salon
Qunar Tech Salon
Nov 16, 2017 · Databases

Why Upgrade PostgreSQL and How to Perform a Major Version Upgrade Using PGQ

This article explains the importance of upgrading PostgreSQL to benefit from new features and security fixes, compares traditional upgrade methods, introduces the PGQ replication system, and provides a detailed step‑by‑step guide for performing a major version upgrade with minimal downtime.

Database UpgradePGQPostgreSQL
0 likes · 11 min read
Why Upgrade PostgreSQL and How to Perform a Major Version Upgrade Using PGQ
ITPUB
ITPUB
Nov 15, 2017 · Databases

Master MySQL JSON: Create, Query, Update, and Index JSON Data in MySQL 5.7+

This guide walks you through using MySQL's native JSON data type—creating tables with JSON columns, inserting simple and complex JSON values, updating nested structures, generating indexed columns from JSON fields, converting strings to JSON, and a comprehensive list of built‑in JSON functions.

DatabaseJSONSQL
0 likes · 6 min read
Master MySQL JSON: Create, Query, Update, and Index JSON Data in MySQL 5.7+
ITPUB
ITPUB
Nov 13, 2017 · Big Data

How Real‑Time Big Data Stream Computing Powers Double 11 E‑Commerce Success

The article explains how NetEase’s real‑time big‑data stream computing platform, Sloth, handles massive, continuously generated data during China’s Double 11 shopping festival, covering use cases, architectural shifts from batch to incremental processing, technical challenges, and the role of stream‑SQL for easier development.

Distributed SystemsReal‑Time ComputingSQL
0 likes · 16 min read
How Real‑Time Big Data Stream Computing Powers Double 11 E‑Commerce Success
ITPUB
ITPUB
Nov 13, 2017 · Big Data

How Real-Time Big Data Streaming Powers Double 11 E‑Commerce Success

The article explains how continuous data generation and real‑time stream processing enable e‑commerce platforms like NetEase Kaola to handle massive Double 11 traffic, showcasing use cases, architectural shifts from batch to incremental computing, and the technical challenges of latency, accuracy, and fault tolerance.

Distributed SystemsReal-time StreamingSQL
0 likes · 15 min read
How Real-Time Big Data Streaming Powers Double 11 E‑Commerce Success
ITPUB
ITPUB
Nov 9, 2017 · Databases

34 Proven Oracle SQL Optimization Tips to Boost Query Performance

This guide presents thirty‑four practical Oracle SQL optimization techniques—from choosing the most efficient table order and rewriting WHERE clauses to leveraging indexes, avoiding SELECT *, using DECODE, and replacing costly operations—helping developers dramatically improve query speed and resource usage.

DatabaseOptimizationOracle
0 likes · 16 min read
34 Proven Oracle SQL Optimization Tips to Boost Query Performance
ITPUB
ITPUB
Nov 7, 2017 · Big Data

Which Tech Giant Dominates Open‑Source on GitHub? 2017 Contribution Analysis

This article examines 2017 GitHub data to compare how major tech companies like Microsoft, Google, Amazon, and others contribute to open‑source projects, revealing surprising rankings, star counts, and the methodology behind the analysis using Google BigQuery and custom SQL queries.

GitHubGoogle BigQuerySQL
0 likes · 8 min read
Which Tech Giant Dominates Open‑Source on GitHub? 2017 Contribution Analysis
ITPUB
ITPUB
Nov 7, 2017 · Databases

Why MySQL Ignored My Index and How to Speed Up Periodic Deletion Queries

The article examines why a MySQL DELETE statement with a composite index on biz_date and status still triggers a full‑table scan, shows EXPLAIN output, tests forced index usage, and ultimately demonstrates that narrowing the date range in the query dramatically reduces rows examined and improves performance.

PerformanceSQLmysql
0 likes · 7 min read
Why MySQL Ignored My Index and How to Speed Up Periodic Deletion Queries
dbaplus Community
dbaplus Community
Oct 31, 2017 · Databases

How I Cut a 5‑Second SQL Query to Under 1 Second in a Critical Release

Facing a last‑minute performance crisis on a major release, the author dissected eight SQL statements, merged four permission‑related queries using Oracle's RANK function, and reduced the responsibility‑lookup time from five seconds to under one second, ensuring the system met its strict latency target.

OracleQuery TuningRank Function
0 likes · 10 min read
How I Cut a 5‑Second SQL Query to Under 1 Second in a Critical Release
Liulishuo Tech Team
Liulishuo Tech Team
Oct 22, 2017 · Big Data

Data-CI: A SQL-Based Data Unit Testing Framework for ETL

The article introduces data-ci, a SQL‑driven unit testing framework that lets engineers write, organize, and automate data validation tests for ETL pipelines, providing assertions, failure callbacks, coverage reporting, and CI integration to improve data quality and reliability.

Big DataData TestingETL
0 likes · 9 min read
Data-CI: A SQL-Based Data Unit Testing Framework for ETL
21CTO
21CTO
Oct 20, 2017 · Databases

Master MySQL Indexes: Boost Query Performance with Smart B+Tree Strategies

This guide explains MySQL B+Tree index structures, their advantages, how to create primary, unique, ordinary, full‑text, composite and prefix indexes, and provides practical rules and tips for designing efficient indexes, query patterns, and sorting strategies to dramatically improve database performance.

B+TreeDatabasePerformance
0 likes · 14 min read
Master MySQL Indexes: Boost Query Performance with Smart B+Tree Strategies