BestHub
Sign in
Tagged articles

SQL

2820 articles · Page 21 of 29
Laravel Tech Community
Laravel Tech Community
Sep 29, 2020 · Databases

Comprehensive MySQL Database Operations: Export, Import, DDL, DML, and User Management

This guide provides step‑by‑step instructions for exporting entire MySQL databases or individual tables, importing data, performing common DDL and DML operations such as creating, altering, renaming, and dropping databases and tables, managing fields, and configuring user permissions, all illustrated with concrete command‑line examples.

DDLDMLExport
0 likes · 9 min read
Comprehensive MySQL Database Operations: Export, Import, DDL, DML, and User Management
Java Backend Technology
Java Backend Technology
Sep 27, 2020 · Databases

How to Speed Up MySQL Pagination: Practical Optimizations and Benchmarks

This article examines why naïve LIMIT‑OFFSET pagination on a multi‑million‑row MySQL table becomes increasingly slow, presents several optimization techniques—including simple LIMIT usage, sub‑query id lookup, ID‑range queries, and temporary‑table tricks—along with concrete benchmark results to guide developers toward faster data paging.

MySQLPerformanceSQL
0 likes · 10 min read
How to Speed Up MySQL Pagination: Practical Optimizations and Benchmarks
Programmer DD
Programmer DD
Sep 26, 2020 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database

This guide walks you through downloading and installing DBeaver, setting up connections to various databases—including PostgreSQL, Oracle, and NoSQL platforms—using JDBC drivers, and creating ER diagrams, providing step‑by‑step instructions and screenshots to help you manage and visualize your data efficiently.

DBeaverDatabase ManagementER Diagram
0 likes · 7 min read
Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database
DataFunTalk
DataFunTalk
Sep 24, 2020 · Databases

Understanding OLAP vs. OLTP and the Fundamentals of Data Warehousing

This article explains the core differences between OLTP and OLAP, evaluates whether traditional OLTP databases like MySQL can handle analytical workloads, introduces benchmark queries, and provides a comprehensive overview of data‑warehouse concepts such as data sources, fact and dimension tables, multi‑dimensional modeling, and common cube operations.

AnalyticsData WarehouseHTAP
0 likes · 21 min read
Understanding OLAP vs. OLTP and the Fundamentals of Data Warehousing
Top Architect
Top Architect
Sep 22, 2020 · Databases

Understanding MySQL Query Execution and Optimization Techniques

This article explains MySQL’s logical architecture, query processing stages, client‑server protocol, query cache, parsing, optimization, execution engine, and provides practical performance‑tuning advice such as index design, data‑type choices, covering indexes, limit pagination, and handling UNION and JOIN operations.

Database PerformanceIndexesMySQL
0 likes · 35 min read
Understanding MySQL Query Execution and Optimization Techniques
Code Ape Tech Column
Code Ape Tech Column
Sep 22, 2020 · Backend Development

Mastering MyBatis Parameter Passing: From Single Values to Collections

This guide explains every common way to pass parameters in MyBatis—including single values, multiple arguments via indexes, @Param, Map, POJO, List, and array—showing mapper signatures, XML mappings, and sample code to help interview preparation and real‑world development.

JavaMyBatisParameter Passing
0 likes · 6 min read
Mastering MyBatis Parameter Passing: From Single Values to Collections
Java Captain
Java Captain
Sep 22, 2020 · Databases

MySQL Basics: DDL/DML/DCL/TCL Commands, Normal Forms, and Table Pivoting

This article provides a comprehensive overview of fundamental MySQL concepts, covering DDL, DML, DCL, and TCL commands, detailed explanations of first to third normal forms, common anomalies, and practical examples of converting between horizontal and vertical table structures using SQL scripts.

DDLDMLMySQL
0 likes · 13 min read
MySQL Basics: DDL/DML/DCL/TCL Commands, Normal Forms, and Table Pivoting
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 21, 2020 · Databases

Comprehensive MySQL Tutorial: Basics, Commands, Data Types, Constraints, Functions, Joins, Stored Procedures, and Transactions

This article provides a detailed, step‑by‑step guide to MySQL covering its purpose, installation, directory layout, common commands, data types, table creation and modification, constraints, functions, subqueries, joins, custom functions, stored procedures, transaction control, and user management, illustrated with extensive code examples and screenshots.

MySQLSQLStored Procedures
0 likes · 31 min read
Comprehensive MySQL Tutorial: Basics, Commands, Data Types, Constraints, Functions, Joins, Stored Procedures, and Transactions
Liangxu Linux
Liangxu Linux
Sep 20, 2020 · Databases

Master MySQL: Installation, Configuration, and Advanced Query Techniques

This guide provides a comprehensive overview of MySQL, covering its definition, installation steps for Windows and Linux, connection commands, database and user management, permission handling, table creation and alteration, CRUD operations, and essential data types, all illustrated with practical code examples.

CRUDMySQLQueries
0 likes · 16 min read
Master MySQL: Installation, Configuration, and Advanced Query Techniques
Code Ape Tech Column
Code Ape Tech Column
Sep 20, 2020 · Databases

20 Principles for MySQL Index Optimization

This article presents twenty practical rules for optimizing MySQL indexes—including when to use or avoid indexes, how to write queries that can leverage them, the importance of index selectivity, prefix indexes, covering indexes, and common pitfalls—to help developers write faster, more efficient SQL statements.

Database PerformanceIndex OptimizationMySQL
0 likes · 16 min read
20 Principles for MySQL Index Optimization
IT Xianyu
IT Xianyu
Sep 19, 2020 · Backend Development

Using MyBatis Dynamic SQL Tags (if, choose, trim, foreach, bind) for Conditional Queries and Updates

This article explains how MyBatis dynamic SQL tags such as if, choose, trim, foreach, and bind can be used to build flexible SELECT, INSERT, UPDATE, and DELETE statements, showing code examples, test cases, and best‑practice tips for handling optional parameters and batch operations in Java backend development.

Dynamic SQLJavaMyBatis
0 likes · 20 min read
Using MyBatis Dynamic SQL Tags (if, choose, trim, foreach, bind) for Conditional Queries and Updates
Java Architect Essentials
Java Architect Essentials
Sep 17, 2020 · Databases

Optimizing Large-Scale SQL Queries with Stored Procedures and Indexing

The article details how a half‑hour SSRS report query on a massive MES database was transformed into a sub‑second operation by analyzing the original SQL, eliminating full table scans, adding proper indexes, using temporary tables and a well‑designed stored procedure, while also discussing common pitfalls and best‑practice tips for high‑performance database querying.

IndexingPerformance TuningSQL
0 likes · 20 min read
Optimizing Large-Scale SQL Queries with Stored Procedures and Indexing
dbaplus Community
dbaplus Community
Sep 17, 2020 · Databases

Why SELECT * Can Kill Your Oracle Performance: Real-World Cases

This article examines several production incidents where using SELECT * caused dramatic performance degradation in Oracle databases, detailing shadow‑table differences, LOB handling, temporary‑table transformations, wide‑table scans, and memory‑intensive joins, and explains why the rule to avoid SELECT * is essential.

OraclePerformanceSQL
0 likes · 6 min read
Why SELECT * Can Kill Your Oracle Performance: Real-World Cases
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 17, 2020 · Databases

Understanding MySQL Join Types and Optimization Techniques

This article explains MySQL's various join algorithms—including Simple Nested Loop, Index Nested Loop, Blocked Nested Loop, and unsupported Hash and Merge joins—detailing their mechanisms, performance trade‑offs, and optimization strategies such as MRR, BKA, join buffers, and driver‑table selection.

BKADatabase PerformanceMRR
0 likes · 11 min read
Understanding MySQL Join Types and Optimization Techniques
Java Backend Technology
Java Backend Technology
Sep 17, 2020 · Databases

Why OFFSET/LIMIT Pagination Fails and How to Use Fast Cursor Pagination

This article explains why traditional OFFSET/LIMIT pagination becomes inefficient with large tables, illustrates its performance drawbacks with real examples, and introduces a high‑performance cursor‑based pagination method that leverages indexed primary keys to dramatically speed up data retrieval.

Cursor PaginationOFFSETSQL
0 likes · 6 min read
Why OFFSET/LIMIT Pagination Fails and How to Use Fast Cursor Pagination
Programmer DD
Programmer DD
Sep 14, 2020 · Databases

Master MySQL Performance: Practical Tips for Scaling and Optimization

This article explores MySQL performance limits, concurrency settings, query‑time best practices, table design choices, index classifications, and a comprehensive set of SQL optimizations—including batch processing, operator rewrites, and pagination tricks—to help developers eliminate slow queries and build scalable database solutions.

IndexingMySQLOptimization
0 likes · 15 min read
Master MySQL Performance: Practical Tips for Scaling and Optimization
Code Ape Tech Column
Code Ape Tech Column
Sep 13, 2020 · Backend Development

Why MyBatis Mapper Methods Cannot Be Overloaded and How to Locate Their Corresponding SQL in XML

This article explains, from source‑code analysis, why MyBatis mapper methods cannot be overloaded, shows the resulting BeanCreationException, walks through the MyBatis‑SpringBoot auto‑configuration that builds SqlSessionFactory, and demonstrates how to trace a mapper method to the exact SQL statement defined in the XML mapping file.

JavaMyBatisSQL
0 likes · 8 min read
Why MyBatis Mapper Methods Cannot Be Overloaded and How to Locate Their Corresponding SQL in XML
Code Ape Tech Column
Code Ape Tech Column
Sep 6, 2020 · Backend Development

Deep Dive into MyBatis Core Architecture: The Six Swordmen and Essential Components

This article introduces MyBatis's underlying architecture by explaining the six core interfaces—SqlSession, Executor, StatementHandler, ParameterHandler, ResultSetHandler, and TypeHandler—detailing their roles, key methods, caching mechanisms, and how they are instantiated within a Spring Boot environment.

Backend DevelopmentExecutorJava
0 likes · 13 min read
Deep Dive into MyBatis Core Architecture: The Six Swordmen and Essential Components
DataFunTalk
DataFunTalk
Sep 6, 2020 · Big Data

OPPO's Real-Time Data Warehouse Architecture and Practices Based on Apache Flink

OPPO's data platform engineer Zhang Jun shares the design and implementation of OPPO's real‑time data warehouse built on Apache Flink, covering background, top‑level architecture, practical deployment, and future directions such as enhanced SQL development, resource scheduling, and automated configuration.

Data PlatformFlinkReal-Time Data Warehouse
0 likes · 15 min read
OPPO's Real-Time Data Warehouse Architecture and Practices Based on Apache Flink
Architecture Digest
Architecture Digest
Sep 5, 2020 · Databases

Understanding SQL Server Lock Escalation and How to Prevent It

This article explains the fundamentals of SQL Server locking, illustrates how row‑level locks can automatically escalate to table‑level locks during large batch operations, and provides practical techniques—such as batching deletes, adding appropriate indexes, and holding intent locks—to avoid lock escalation and improve concurrency.

Database LocksLock EscalationPerformance Tuning
0 likes · 12 min read
Understanding SQL Server Lock Escalation and How to Prevent It
Code Ape Tech Column
Code Ape Tech Column
Sep 4, 2020 · Backend Development

Master MyBatis Dynamic SQL: Essential Tags and Real-World Examples

This article explains MyBatis dynamic SQL, describing each core XML tag (if, choose/when/otherwise, where, foreach, set, sql, include), showing practical code snippets, and offering advanced tips such as avoiding magic numbers and referencing SQL fragments across mapper files.

Backend DevelopmentDynamic SQLJava
0 likes · 14 min read
Master MyBatis Dynamic SQL: Essential Tags and Real-World Examples
Code Ape Tech Column
Code Ape Tech Column
Sep 3, 2020 · Backend Development

Master MyBatis Result Mapping: From Alias to Nested Associations

This article explains MyBatis result mapping techniques—including alias mapping, camel‑case automatic mapping, explicit resultMap definitions, and advanced one‑to‑one and one‑to‑many associations—providing code examples, configuration details, and performance considerations such as the N+1 query problem.

AssociationJavaMyBatis
0 likes · 16 min read
Master MyBatis Result Mapping: From Alias to Nested Associations
Top Architect
Top Architect
Aug 31, 2020 · Backend Development

MyBatis Dynamic SQL Tags: if, choose, trim, foreach, bind for Conditional Queries, Updates, Inserts, and Batch Operations

This tutorial explains how to use MyBatis dynamic SQL tags such as if, choose, trim, foreach, and bind to build flexible SELECT, UPDATE, INSERT, and batch statements, demonstrating data preparation, conditional query construction, selective updates, conditional inserts, and advanced tag usage with complete Java test examples.

Dynamic SQLJavaMyBatis
0 likes · 20 min read
MyBatis Dynamic SQL Tags: if, choose, trim, foreach, bind for Conditional Queries, Updates, Inserts, and Batch Operations
The Dominant Programmer
The Dominant Programmer
Aug 31, 2020 · Backend Development

How to Count Conditional Records with MyBatis and MySQL

This article shows how to use MyBatis XML mappers to write MySQL queries that count employees meeting specific criteria, such as those in the current month or before today, while explaining required aliasing and date‑format handling.

Count QueryJavaMyBatis
0 likes · 3 min read
How to Count Conditional Records with MyBatis and MySQL
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.

Learning ResourcesPostgreSQLSQL
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.

Keyset PaginationOFFSET LIMITPerformance
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 DesignMySQL
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.

MySQLPerformanceSQL
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 GenerationJoin PerformanceMySQL
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.

IndexingMySQLPerformance
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.

ClickHouseMergeTreePartitioning
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.

Data ReplicationDatabase AdministrationLinked 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.

PythonSQLSQLite
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+TreeMySQLSQL
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.

BRINCTEIndexes
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.

BenchmarkDatabase DesignDatabase Performance
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.

IndexingMySQLPrefix 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.

MySQLPerformance TuningSQL
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.

BISQLWeb3D
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 SetMySQLSQL
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 TypesIndexingPostgreSQL
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 TuningSQL
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.

MySQLPerformanceSQL
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 TypesFunctionsMySQL
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.

DDLDMLSQL
0 likes · 23 min read
Comprehensive Guide to SQL Syntax, Commands, and Operations