BestHub
Sign in
Tagged articles
2782 articles
Page 21 of 28
Code Ape Tech Column
Code Ape Tech Column
Aug 29, 2020 · Databases

20 Essential MySQL Index Optimization Rules Every Developer Should Know

This article outlines twenty practical principles for optimizing MySQL indexes, covering topics such as LIKE wildcards, UNION/IN/OR usage, negative conditions, composite index prefix rules, range queries, function avoidance, covering indexes, prefix indexes, pagination strategies, and common misconceptions, all illustrated with SQL examples and performance tips.

Database PerformanceIndex OptimizationMySQL
0 likes · 16 min read
20 Essential MySQL Index Optimization Rules Every Developer Should Know
Architects Research Society
Architects Research Society
Aug 29, 2020 · Databases

Why Data Scientists Should Learn PostgreSQL

The article explains why SQL is essential for data scientists, introduces PostgreSQL as a powerful open‑source relational database suited for large‑scale data science, outlines its key features, advantages and disadvantages, and provides practical learning resources for beginners.

DatabaseLearning ResourcesPostgreSQL
0 likes · 9 min read
Why Data Scientists Should Learn PostgreSQL
IT Architects Alliance
IT Architects Alliance
Aug 29, 2020 · Databases

Why OFFSET/LIMIT Pagination Breaks at Scale and How to Use High‑Performance Keyset Pagination

The article explains why traditional OFFSET and LIMIT pagination becomes inefficient for large tables due to full‑table scans, demonstrates the performance gap with real‑world examples, and presents keyset (cursor‑based) pagination as a fast, index‑driven alternative with practical query patterns.

Database OptimizationKeyset PaginationOFFSET LIMIT
0 likes · 6 min read
Why OFFSET/LIMIT Pagination Breaks at Scale and How to Use High‑Performance Keyset Pagination
Code Ape Tech Column
Code Ape Tech Column
Aug 26, 2020 · Databases

Master MySQL Basics: Interview Q&A on Relational Databases

This article provides a comprehensive interview‑style overview of MySQL fundamentals, covering relational database concepts, data types, storage engines, SQL syntax, version checking, normal forms, views, stored procedures, and performance tips, all essential for backend developers and database professionals.

Data TypesDatabase DesignInterview
0 likes · 20 min read
Master MySQL Basics: Interview Q&A on Relational Databases
JavaEdge
JavaEdge
Aug 25, 2020 · Databases

Mastering MySQL Temporary Tables: Creation, Usage, and Deletion

This guide explains what MySQL temporary tables are, how they exist only for the current connection, provides step‑by‑step SQL examples for creating, inserting, querying, and dropping a temporary table, and discusses practical scenarios such as high‑concurrency writes.

DatabaseMySQLperformance
0 likes · 3 min read
Mastering MySQL Temporary Tables: Creation, Usage, and Deletion
Selected Java Interview Questions
Selected Java Interview Questions
Aug 24, 2020 · Databases

Performance Evaluation of Multi‑Table Joins in MySQL and Oracle with Large Data Sets

This article investigates the practical limits of joining more than three tables in MySQL by designing experiments with up to 1.5 billion rows, comparing indexed and non‑indexed queries, and contrasting the results with Oracle's performance, while providing full SQL scripts for data generation and analysis.

Data GenerationDatabase OptimizationJoin Performance
0 likes · 11 min read
Performance Evaluation of Multi‑Table Joins in MySQL and Oracle with Large Data Sets
21CTO
21CTO
Aug 19, 2020 · Databases

How to Use MySQL Polygon Types for Precise Location Check‑In

This tutorial explains how to obtain geographic coordinates, store them as MySQL POLYGON types following OGC standards, insert campus area data, and query with spatial functions and SPATIAL indexes to determine whether a user is within a defined check‑in region.

GISMySQLPolygon
0 likes · 7 min read
How to Use MySQL Polygon Types for Precise Location Check‑In
Top Architect
Top Architect
Aug 18, 2020 · Databases

Comprehensive Guide to MySQL SQL Optimization Techniques

This article explains why SQL optimization is a cost‑effective way to boost system performance, outlines fundamental principles, common pitfalls such as leading wildcards, IN/OR/NULL misuse, and provides practical tips on indexing, execution order, hints, DML batching, pagination, and table design for MySQL databases.

DatabaseMySQLQueryOptimization
0 likes · 21 min read
Comprehensive Guide to MySQL SQL Optimization Techniques
Programmer DD
Programmer DD
Aug 18, 2020 · Databases

Why SELECT Columns After GROUP BY Are Restricted: MySQL Modes Explained

This article explains the SQL standard limits on SELECT columns after GROUP BY, demonstrates how MySQL's ONLY_FULL_GROUP_BY mode enforces those limits, explores various SQL modes, and clarifies why aggregated queries cannot reference non‑grouped columns directly.

GROUP BYMySQLONLY_FULL_GROUP_BY
0 likes · 11 min read
Why SELECT Columns After GROUP BY Are Restricted: MySQL Modes Explained
Programmer DD
Programmer DD
Aug 17, 2020 · Databases

Understanding ClickHouse MergeTree Partitioning and Merging Rules

This article explains how ClickHouse's MergeTree engine creates partition directories, the naming convention for partitions, and the automatic and manual merging processes that consolidate parts while tracking block numbers and merge levels.

ClickHouseDatabaseMergeTree
0 likes · 7 min read
Understanding ClickHouse MergeTree Partitioning and Merging Rules
Java Captain
Java Captain
Aug 15, 2020 · Databases

Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication

This article provides a detailed collection of SQL Server commands and techniques covering database creation, table and index management, common DML statements, advanced set operators, various join types, grouping, pagination, maintenance tasks, replication setup, linked‑server usage, and a synchronization stored procedure.

Database AdministrationLinked ServerSQL Server
0 likes · 22 min read
Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication
IT Architects Alliance
IT Architects Alliance
Aug 12, 2020 · Big Data

Introduction to Confluent KSQL for Real-Time Stream Processing

This article introduces Confluent KSQL, a SQL‑based real‑time stream processing engine for Kafka, covering its architecture, stream vs table concepts, query lifecycle, Docker‑based setup, DDL commands, example joins, windowed aggregations, connectors, and its advantages and limitations.

Big DataDockerKSQL
0 likes · 9 min read
Introduction to Confluent KSQL for Real-Time Stream Processing
DataFunTalk
DataFunTalk
Aug 10, 2020 · Big Data

Understanding Flink SQL Architecture, Optimizations, and Internal Mechanisms

This article explains the evolution of Apache Flink's SQL support, detailing the Blink Planner architecture, the end‑to‑end Flink SQL workflow, logical and physical planning, code generation, stream‑specific optimizations such as retraction and mini‑batch, and future development directions.

Blink PlannerFlinkOptimization
0 likes · 20 min read
Understanding Flink SQL Architecture, Optimizations, and Internal Mechanisms
MaGe Linux Operations
MaGe Linux Operations
Aug 8, 2020 · Databases

Master SQLite in Python: From Setup to Pandas Integration

This tutorial walks Python developers through using the built‑in sqlite3 library to create, query, and manage SQLite databases, demonstrates how to connect with SQL clients like DBeaver, and shows seamless integration with Pandas data frames for advanced data handling.

PythonSQLitesql
0 likes · 8 min read
Master SQLite in Python: From Setup to Pandas Integration
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 7, 2020 · Databases

Four Common MySQL Insert Statements and Their Usage

This article explains the four frequently used MySQL data‑insertion statements—INSERT, INSERT SELECT, REPLACE INTO, and INSERT … ON DUPLICATE KEY UPDATE—detailing their syntax, options, behavior, and performance considerations for reliable database operations.

InsertMySQLON DUPLICATE KEY UPDATE
0 likes · 7 min read
Four Common MySQL Insert Statements and Their Usage
Laravel Tech Community
Laravel Tech Community
Aug 6, 2020 · Databases

MySQL Index Types, Creation Methods, and Optimization Strategies

This article explains MySQL's B‑Tree index structure, describes various index types such as primary, unique, normal, full‑text, and composite indexes, and provides practical techniques for creating efficient indexes, choosing column order, using prefix and covering indexes, and optimizing query sorting.

B+TreeDatabase OptimizationMySQL
0 likes · 12 min read
MySQL Index Types, Creation Methods, and Optimization Strategies
dbaplus Community
dbaplus Community
Aug 3, 2020 · Databases

Why Oracle OOM Happens: Hidden Lock Leak and How to Diagnose It

This article explains the meaning of Java OOM errors, presents a real‑world case where an Oracle database lock caused a slow memory leak leading to OOM, details the lock types and modes, provides SQL to identify and kill offending sessions, and offers best‑practice tips to avoid lock‑related performance issues.

DatabaseLocksJavaOracle
0 likes · 10 min read
Why Oracle OOM Happens: Hidden Lock Leak and How to Diagnose It
MaGe Linux Operations
MaGe Linux Operations
Aug 1, 2020 · Databases

What Are the Core Components of MySQL? A Deep Dive

This article breaks down MySQL’s architecture into its five key parts—connector, parser, optimizer, executor, and storage engine—explaining each component’s role from establishing connections and handling permissions to query parsing, execution planning, and data storage, with example commands and code snippets.

Database ArchitectureMySQLQuery Processing
0 likes · 3 min read
What Are the Core Components of MySQL? A Deep Dive
DevOps Coach
DevOps Coach
Aug 1, 2020 · Databases

Boost PostgreSQL Performance: Essential DBA Tricks Every Developer Should Know

This article presents a collection of practical PostgreSQL DBA techniques—including selective updates, bulk‑load optimizations, CTE‑based deduplication, partial and BRIN indexes, correlation tuning, and transactional DDL tricks—to help developers reduce database bottlenecks, improve query speed, and avoid common performance pitfalls.

BRINCTEDevOps
0 likes · 33 min read
Boost PostgreSQL Performance: Essential DBA Tricks Every Developer Should Know
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 30, 2020 · Big Data

Understanding Bucket Sampling Queries in Hive

This article explains Hive's bucket sampling syntax, demonstrates how to use the TABLESAMPLE clause with various bucket parameters, provides concrete SQL examples, and clarifies the underlying hash‑based mechanism that determines which rows are returned.

Big DataBucket SamplingHive
0 likes · 4 min read
Understanding Bucket Sampling Queries in Hive
ITPUB
ITPUB
Jul 29, 2020 · Databases

Why Database Normalization Matters: A Practical Guide to 1NF, 2NF, and 3NF

This article explains the concepts of the first, second, and third normal forms in relational databases, shows concrete table examples, discusses why normalization is important for consistency and storage efficiency, and explores denormalization trade‑offs and modern JSON support in MySQL and NoSQL systems.

1NF2NF3NF
0 likes · 10 min read
Why Database Normalization Matters: A Practical Guide to 1NF, 2NF, and 3NF
Tencent Database Technology
Tencent Database Technology
Jul 27, 2020 · Databases

Demystifying the TPC‑C Benchmark: Model, Schema, and New‑Order Transaction Walkthrough

This article explains the TPC‑C benchmark, covering its purpose, data model, database schema, the five transaction types, and a detailed step‑by‑step walkthrough of the New‑Order operation with accompanying SQL illustrations, while also summarizing workload characteristics and providing reference links.

Database DesignDatabase PerformanceNew-Order
0 likes · 7 min read
Demystifying the TPC‑C Benchmark: Model, Schema, and New‑Order Transaction Walkthrough
ITPUB
ITPUB
Jul 27, 2020 · Databases

Why Database Normalization Matters: Understanding 1NF, 2NF, and 3NF with Real Examples

This article explains the concepts of the first, second, and third normal forms, shows how to identify violations with concrete table examples, discusses why normalization is important for consistency and storage efficiency, and explores anti‑normalization techniques that trade redundancy for performance.

1NF2NF3NF
0 likes · 11 min read
Why Database Normalization Matters: Understanding 1NF, 2NF, and 3NF with Real Examples
JavaEdge
JavaEdge
Jul 26, 2020 · Databases

How to Choose and Use Prefix Indexes for String Columns in MySQL

This article explains why and how to create prefix indexes for string fields in MySQL, compares full‑column and prefix indexes with concrete examples, shows how to pick an optimal prefix length using cardinality statistics, and discusses alternative solutions such as reverse storage and hash fields.

Database OptimizationMySQLPrefix Index
0 likes · 12 min read
How to Choose and Use Prefix Indexes for String Columns in MySQL
Laravel Tech Community
Laravel Tech Community
Jul 25, 2020 · Databases

Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps

This article presents a thorough overview of MySQL optimization, covering the query execution process, philosophical principles, risk assessment, required participants, optimization dimensions, commonly used diagnostic tools, emergency and regular tuning procedures, hardware and system level adjustments, as well as detailed configuration parameters for both the server and the database engine.

Database OptimizationMySQLPerformance tuning
0 likes · 14 min read
Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps
Architecture Digest
Architecture Digest
Jul 25, 2020 · Databases

A Comprehensive Guide to Using JetBrains DataGrip for Database Management

This article provides a detailed walkthrough of JetBrains DataGrip, covering installation, connection setup, UI customization, SQL editing features, data import/export, and numerous productivity shortcuts, helping developers efficiently manage and interact with various relational databases.

DataGripDatabase ManagementDatabase Tools
0 likes · 11 min read
A Comprehensive Guide to Using JetBrains DataGrip for Database Management
Alibaba Terminal Technology
Alibaba Terminal Technology
Jul 22, 2020 · Frontend Development

Inside Alibaba’s Data Experience: Advanced SQL Editors, BI Platforms, and 3D Visualizations

This article details how Alibaba’s Data Experience team builds a comprehensive stack—from a high‑performance SQL editor and low‑code BI platform to sophisticated data visualizations, intelligent analytics, digital art, Web3D rendering, and robust data‑security measures—showcasing the architecture, design principles, and future directions of their end‑to‑end data‑driven product ecosystem.

BILow‑codeWeb3D
0 likes · 25 min read
Inside Alibaba’s Data Experience: Advanced SQL Editors, BI Platforms, and 3D Visualizations
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 22, 2020 · Databases

Understanding and Resolving MySQL Character Set and Data Corruption Issues

This article explains why MySQL data can become garbled due to mismatched character sets during insertion or retrieval, explores various scenarios such as client‑side encoding errors, mixed encodings within tables, and LATIN1 storage, and provides detailed solutions including setting proper client encodings, using strict SQL_MODE, and exporting/importing data to unify character sets.

Character SetData CorruptionEncoding
0 likes · 15 min read
Understanding and Resolving MySQL Character Set and Data Corruption Issues
Senior Brother's Insights
Senior Brother's Insights
Jul 20, 2020 · Databases

Discover Why PostgreSQL Could Be the Underrated Database You Need

This article introduces PostgreSQL, the powerful open‑source object‑relational database, highlights its rising popularity in DB‑Engines rankings, compares its advanced features and performance advantages over MySQL, and outlines many of its unique capabilities such as rich data types, sophisticated indexing, and robust replication.

Data TypesPostgreSQLfeature comparison
0 likes · 6 min read
Discover Why PostgreSQL Could Be the Underrated Database You Need
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 20, 2020 · Databases

InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management

This tutorial walks through the test environment and demonstrates how InnoDB Cluster's built‑in functions—such as get_cluster, describe, list_routers, set_option, options, set_instance_option, set_primary_instance, switch_to_multi_primary_mode, switch_to_single_primary_mode, status, and dissolve—simplify the deployment, monitoring, and administration of MySQL group replication, complete with code snippets and visual results.

Group ReplicationInnoDB ClusterMySQL
0 likes · 10 min read
InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management
MaGe Linux Operations
MaGe Linux Operations
Jul 19, 2020 · Databases

Optimizing Zabbix with MySQL: Version Tips, Permissions, and Partitioning Strategies

This guide details recommended MySQL versions for Zabbix, proper grant statements for read/write and read‑only users, essential MySQL configuration tweaks, SQL techniques for item and function updates, read‑write splitting, upgrade procedures, backup strategies, and comprehensive partition maintenance scripts to improve performance and manage data growth.

MySQLPerformance tuningdatabase partitioning
0 likes · 14 min read
Optimizing Zabbix with MySQL: Version Tips, Permissions, and Partitioning Strategies
Architect's Tech Stack
Architect's Tech Stack
Jul 19, 2020 · Databases

MySQL Pagination Query Optimization Techniques and Performance Testing

This article explains various MySQL pagination methods—including simple LIMIT queries, sub‑query optimizations, ID‑range filtering, and temporary‑table approaches—provides detailed performance measurements on a large order_history table, and concludes with practical recommendations while also promoting a comprehensive interview‑question PDF collection.

Database OptimizationMySQLperformance
0 likes · 10 min read
MySQL Pagination Query Optimization Techniques and Performance Testing
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 19, 2020 · Big Data

An Overview of Hive, HBase Integration, Apache Phoenix, and Lealone in the Big Data Ecosystem

This article explains Hive's role as a Hadoop‑based data warehouse, its integration with HBase, the advantages and drawbacks of that combination, introduces Apache Phoenix as a high‑performance SQL layer on HBase, and describes the open‑source NewSQL database Lealone, providing practical usage scenarios and performance comparisons.

Big DataData WarehouseHBase
0 likes · 9 min read
An Overview of Hive, HBase Integration, Apache Phoenix, and Lealone in the Big Data Ecosystem
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 17, 2020 · Databases

Comprehensive MySQL Tutorial: Basics, Data Types, Operators, Functions, and Queries

This article provides a thorough, step‑by‑step guide to MySQL, covering how to install and start the server, create databases and tables, use DDL/DML/DQL statements, understand numeric, date/time and string data types, apply arithmetic, comparison, logical and bitwise operators, and leverage common built‑in functions for efficient data manipulation.

Data TypesDatabaseFunctions
0 likes · 38 min read
Comprehensive MySQL Tutorial: Basics, Data Types, Operators, Functions, and Queries
Laravel Tech Community
Laravel Tech Community
Jul 16, 2020 · Databases

Comprehensive Guide to SQL Syntax, Commands, and Operations

This article provides a comprehensive overview of relational database fundamentals and SQL syntax, covering basic concepts, statement categories (DDL, DML, TCL, DCL), CRUD operations, subqueries, joins, unions, functions, ordering, grouping, constraints, transactions, permission management, stored procedures, cursors, and triggers with illustrative code examples.

DDLDMLDatabase
0 likes · 23 min read
Comprehensive Guide to SQL Syntax, Commands, and Operations
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 16, 2020 · Databases

Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting

This article provides a thorough overview of MySQL performance tuning, covering proper table design according to the three normal forms, various index types and their creation, partitioning strategies, read/write separation, storage engine selection, and practical SQL tips for improving query efficiency.

Database OptimizationMySQLPartitioning
0 likes · 14 min read
Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting
JavaEdge
JavaEdge
Jul 15, 2020 · Databases

Understanding MySQL Transaction Isolation Levels and Best Practices

This article explains MySQL transaction isolation concepts, the four standard isolation levels, their effects on dirty, non‑repeatable, and phantom reads, practical configuration steps, when to use repeatable read, how InnoDB implements isolation, and tips for avoiding long transactions and planning backups.

DatabaseInnoDBIsolation Level
0 likes · 8 min read
Understanding MySQL Transaction Isolation Levels and Best Practices
ITPUB
ITPUB
Jul 15, 2020 · Databases

Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization

This guide compiles essential MySQL optimization techniques—including index cardinality, function indexes, EXPLAIN usage, covering indexes, ICP, slow‑query log analysis, online schema changes, and common SQL pitfalls—to help developers efficiently tune database performance.

Database OptimizationEXPLAINIndexes
0 likes · 19 min read
Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization
dbaplus Community
dbaplus Community
Jul 12, 2020 · Databases

Automating Oracle SQL Review with SOAR: A Step‑by‑Step Guide

To streamline Oracle SQL script reviews, this guide shows how to adapt the open‑source SOAR tool—originally built for MySQL—by defining custom rules, installing Go and Git, compiling the source, and integrating a web UI, enabling automated, 90% coverage of Oracle SQL checks.

DatabaseDevOpsOracle
0 likes · 8 min read
Automating Oracle SQL Review with SOAR: A Step‑by‑Step Guide
Java Captain
Java Captain
Jul 12, 2020 · Databases

Optimizing Existence Checks: Replace COUNT(*) with SELECT 1 LIMIT 1

The article explains why using COUNT(*) to test record existence is inefficient and demonstrates an optimized approach that replaces COUNT(*) with SELECT 1 LIMIT 1 in SQL and a corresponding null‑check in Java, improving database performance especially when many rows match the condition.

JavaOptimizationperformance
0 likes · 3 min read
Optimizing Existence Checks: Replace COUNT(*) with SELECT 1 LIMIT 1
AntTech
AntTech
Jul 10, 2020 · Artificial Intelligence

SQLFlow: End‑to‑End AI Workflow Construction Using SQL

SQLFlow is an open‑source system that lets users describe and execute end‑to‑end AI tasks—including data extraction, preprocessing, model training, evaluation, prediction, and explanation—entirely with SQL, simplifying workflow construction across multiple databases and machine‑learning engines while supporting scalable execution on Kubernetes.

AI workflowSQLFlowkubernetes
0 likes · 19 min read
SQLFlow: End‑to‑End AI Workflow Construction Using SQL
FunTester
FunTester
Jul 9, 2020 · Backend Development

Multithreaded Test Case Execution and Database Standards

The article shares practical experiences on running test cases concurrently using Java multithreading and a custom thread pool, and outlines MySQL database naming, null handling, and schema design guidelines, including full code examples for the case runner and thread pool implementation.

Database DesignJavaMySQL
0 likes · 7 min read
Multithreaded Test Case Execution and Database Standards
Big Data Technology Architecture
Big Data Technology Architecture
Jul 8, 2020 · Big Data

Apache Flink 1.11.0 Release: New Features and Optimizations

Apache Flink 1.11.0 introduces a suite of major enhancements—including unaligned checkpoints, a unified source interface, CDC support in Table API/SQL, performance‑boosted PyFlink, a new application deployment mode, and numerous UI, Docker, and catalog improvements—aimed at increasing usability, scalability, and integration across streaming and batch workloads.

FlinkSource InterfaceStream Processing
0 likes · 18 min read
Apache Flink 1.11.0 Release: New Features and Optimizations
Java Backend Technology
Java Backend Technology
Jul 7, 2020 · Databases

Why Your SQL Queries Are Slow: 10 Hidden Factors and How to Fix Them

This article analyzes the various system‑level and database‑level reasons why SELECT, UPDATE, INSERT, or DELETE statements become slow, covering network issues, OS and hardware constraints, MySQL configuration, indexing, execution plans, and query design, and offers practical mitigation strategies.

DatabaseMySQLslow-query
0 likes · 18 min read
Why Your SQL Queries Are Slow: 10 Hidden Factors and How to Fix Them
JavaEdge
JavaEdge
Jul 4, 2020 · Databases

How MySQL Executes a Query: From Connection to Execution Engine

This article explains MySQL’s internal workflow, covering the Server layer components, Storage Engine layer, connection handling, query cache behavior, lexical and syntax parsing, optimization decisions, and execution steps, including tips for long‑connection management and common pitfalls.

Connection ManagementDatabase InternalsMySQL
0 likes · 9 min read
How MySQL Executes a Query: From Connection to Execution Engine
dbaplus Community
dbaplus Community
Jul 4, 2020 · Databases

Mastering Oracle 19c Hot Clone: A Complete Step‑by‑Step Guide

This article explains the background of Oracle 19c hot clone, lists the prerequisites, details the three‑phase cloning process, provides exhaustive local, remote, subset and refreshable PDB scenarios with exact SQL commands, highlights common errors and their solutions, and concludes with best‑practice recommendations.

Hot CloneOraclePdb
0 likes · 21 min read
Mastering Oracle 19c Hot Clone: A Complete Step‑by‑Step Guide
Youzan Coder
Youzan Coder
Jul 1, 2020 · Big Data

Mastering HiveCube: Efficient Multi‑Dimensional Aggregation with Grouping Sets

This article explains how HiveCube can replace traditional development for multi‑dimensional aggregation in a data‑warehouse, covering background, theory of cube, with‑cube/rollup/grouping‑sets syntax, grouping_id handling, practical implementation tips, performance tuning, and a comparison with conventional methods.

Big DataCubeData Warehouse
0 likes · 19 min read
Mastering HiveCube: Efficient Multi‑Dimensional Aggregation with Grouping Sets
DataFunTalk
DataFunTalk
Jun 30, 2020 · Big Data

Flink Real‑Time Data Warehouse Practices at Shopee Singapore Data Team

This article details Shopee Singapore Data Team’s implementation of a Flink‑based real‑time data warehouse, covering background challenges, layered architecture integrating Kafka, HBase, Druid, Hive, streaming pipelines, job management, monitoring, and future plans to expand Flink SQL support.

Data WarehouseFlinkShopee
0 likes · 15 min read
Flink Real‑Time Data Warehouse Practices at Shopee Singapore Data Team
Java High-Performance Architecture
Java High-Performance Architecture
Jun 30, 2020 · Databases

Mastering SQL: The 6-Step Process Behind Every SELECT Query

This article walks through the complete lifecycle of a SQL SELECT statement—using simple Citizen and City tables—to illustrate the six processing stages (FROM/JOIN, WHERE, GROUP BY, HAVING, SELECT, ORDER BY/LIMIT), showing how each clause transforms the data step by step.

Database FundamentalsQuery ExecutionRelational Databases
0 likes · 5 min read
Mastering SQL: The 6-Step Process Behind Every SELECT Query
Java Captain
Java Captain
Jun 23, 2020 · Databases

SQL Basics: Concepts, Syntax, and Common Commands

This article provides a concise overview of relational database fundamentals, covering key terminology, the structure of SQL statements, essential DDL/DML/TCL/DCL commands, query operators, joins, subqueries, functions, indexing, constraints, transactions, permissions, stored procedures, cursors, and triggers, with practical code examples throughout.

DDLDMLStored Procedure
0 likes · 30 min read
SQL Basics: Concepts, Syntax, and Common Commands
Programmer DD
Programmer DD
Jun 23, 2020 · Databases

Master MySQL Basics: Schemas, Data Types, and Full CRUD Guide

This article provides a comprehensive MySQL tutorial covering schema concepts, data types, service control, database creation, table manipulation, and complete CRUD operations with practical command‑line examples and code snippets for beginners and intermediate users.

CRUDData TypesDatabase
0 likes · 15 min read
Master MySQL Basics: Schemas, Data Types, and Full CRUD Guide
Java Captain
Java Captain
Jun 21, 2020 · Databases

Why Using SELECT * Is Inefficient in MySQL and How Indexes Improve Performance

Although many developers hear the advice to avoid using SELECT * in SQL, this article delves into the underlying reasons—such as increased parsing cost, unnecessary data transfer, extra I/O, and loss of covering-index optimization—while also explaining index concepts and best practices for MySQL performance.

Database PerformanceIndex OptimizationMySQL
0 likes · 10 min read
Why Using SELECT * Is Inefficient in MySQL and How Indexes Improve Performance
FunTester
FunTester
Jun 20, 2020 · Backend Development

Mastering MySQL CASE WHEN and MyBatis Dynamic Queries for Test Case Search

This article walks through building complex test‑case search queries using MySQL CASE WHEN, FIND_IN_SET, and MyBatis dynamic SQL, demonstrates converting asynchronous data fetches to synchronous calls with CountDownLatch in Spring, and provides complete Java bean and configuration examples.

AsyncBackendJava
0 likes · 9 min read
Mastering MySQL CASE WHEN and MyBatis Dynamic Queries for Test Case Search
Java Backend Technology
Java Backend Technology
Jun 20, 2020 · Databases

What’s the Real Execution Order of SQL Queries? A Visual Guide

Although most SQL statements begin with SELECT, the actual execution follows a specific order—WHERE, GROUP BY, HAVING, then SELECT—illustrated by a diagram that also clarifies common misconceptions about filtering window functions, column aliases, and how databases may reorder operations for optimization.

DatabaseLINQOptimization
0 likes · 6 min read
What’s the Real Execution Order of SQL Queries? A Visual Guide