BestHub
Sign in
Tagged articles
2769 articles
Page 20 of 28
JD Tech Talk
JD Tech Talk
Nov 17, 2020 · Databases

JUST Engine: Novel Spatio‑Temporal Indexes and Data Models for Large‑Scale Urban Data Management

The article introduces the JUST engine, a spatio‑temporal data platform that extends GeoMesa with three new indexes (Z2T, XZ2T, time_range), defines nine common and three specialized data models, provides default indexing strategies, and offers detailed SQL usage guidelines for efficient querying of massive urban datasets.

Big DataGeoMesaJUST engine
0 likes · 25 min read
JUST Engine: Novel Spatio‑Temporal Indexes and Data Models for Large‑Scale Urban Data Management
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 17, 2020 · Databases

How to Use CHECK Constraints in MySQL 8

This article explains MySQL 8’s newly supported CHECK constraints, outlines usage restrictions, and provides step‑by‑step examples—including simple age validation and complex gender‑age logic—showing how to create, test, alter, and drop constraints while highlighting practical considerations.

CHECK constraintMySQL8data validation
0 likes · 7 min read
How to Use CHECK Constraints in MySQL 8
Suning Technology
Suning Technology
Nov 16, 2020 · Databases

How ClickHouse Powers Real-Time User Profiling for Millions of Users

This article explains how Suning built a massive user‑tag platform using ClickHouse and RoaringBitmap to enable second‑level user profiling for over 600 million users, covering tag generation, storage, query architecture, and performance optimizations for marketing campaigns.

BitmapTag Platformclickhouse
0 likes · 13 min read
How ClickHouse Powers Real-Time User Profiling for Millions of Users
Laravel Tech Community
Laravel Tech Community
Nov 15, 2020 · Databases

MySQL Lock Types and Deadlock Causes with Practical Examples

This article explains MySQL's three lock levels—table, row, and page—describes next‑key, gap, and record locks, analyzes why deadlocks occur, and provides multiple real‑world examples and prevention strategies, including code snippets for reproducible scenarios.

InnoDBLocksconcurrency
0 likes · 12 min read
MySQL Lock Types and Deadlock Causes with Practical Examples
ITPUB
ITPUB
Nov 13, 2020 · Databases

Master MySQL Indexes: How Explain Optimizes Query Performance

This guide explains why MySQL queries become slow, how to diagnose issues with slow‑query logs, Explain and Show Profile, details the structure and types of indexes, interprets each column of the Explain output, and demonstrates practical optimization steps with real SQL examples.

Database Performanceindexesmysql
0 likes · 14 min read
Master MySQL Indexes: How Explain Optimizes Query Performance
php Courses
php Courses
Nov 13, 2020 · Backend Development

Understanding ThinkPHP Query Method and Database Connection Initialization

The article explains how ThinkPHP’s query method works with raw SQL, distinguishes between execute for writes and query for reads, details MySQL master‑slave replication considerations, and describes the framework’s database connection initialization, including read/write separation logic and related code examples.

BackendPHPThinkPHP
0 likes · 6 min read
Understanding ThinkPHP Query Method and Database Connection Initialization
360 Tech Engineering
360 Tech Engineering
Nov 6, 2020 · Big Data

Guide to Flink SQL: Features, Scenarios, and Productization

Flink SQL, the high‑level SQL interface for Apache Flink, offers language‑independent, dependency‑free, easy‑to‑use stream processing with advanced features such as DDL, UDFs, time semantics, windowing, pattern matching, and built‑in connectors, supporting data synchronization, batch‑stream fusion, Hive integration, and various product enhancements.

Data IntegrationFlinkReal-Time
0 likes · 11 min read
Guide to Flink SQL: Features, Scenarios, and Productization
Architect
Architect
Nov 5, 2020 · Databases

Differences Between count(1), count(*), and count(column) in MySQL

This article explains the functional and performance differences among MySQL's count(1), count(*), and count(column) functions, illustrates how NULL handling varies, and provides a concrete example demonstrating their results and execution efficiency under different table schemas.

_countdatabasemysql
0 likes · 5 min read
Differences Between count(1), count(*), and count(column) in MySQL
dbaplus Community
dbaplus Community
Nov 3, 2020 · Big Data

How Ctrip Boosted Hotel Data Warehouse Performance 400% with ClickHouse

Ctrip’s hotel data team tackled a 3 TB daily data load by building a ClickHouse cluster on VMware, creating custom sync and execution tools, applying query optimizations, and handling merge and memory errors, ultimately achieving over 400% performance gains across multiple reporting themes.

Big DataETLclickhouse
0 likes · 7 min read
How Ctrip Boosted Hotel Data Warehouse Performance 400% with ClickHouse
DataFunTalk
DataFunTalk
Nov 1, 2020 · Big Data

Flink 1.11 Integration with Hive: New Features and Real‑time Data Warehouse

The article explains how Flink 1.11 deepens its integration with Hive, covering background, new connector features, simplified dependency management, enhanced Hive dialect, streaming writes and reads, temporal table joins, and how these capabilities enable a unified batch‑streaming data warehouse.

Batch‑Streaming IntegrationFlinkStreaming
0 likes · 16 min read
Flink 1.11 Integration with Hive: New Features and Real‑time Data Warehouse
Liangxu Linux
Liangxu Linux
Nov 1, 2020 · Databases

100 MySQL Interview Q&A: Indexes, Transactions, and Schema Design Essentials

This article compiles 100 common MySQL interview questions covering index structures, hash vs B‑tree trade‑offs, clustering, transaction isolation levels, lock types, primary key choices, storage engines, data types, binlog formats, pagination strategies, and best practices for schema design and query optimization.

Storage EngineTransactionsindexes
0 likes · 21 min read
100 MySQL Interview Q&A: Indexes, Transactions, and Schema Design Essentials
Su San Talks Tech
Su San Talks Tech
Nov 1, 2020 · Databases

Common MySQL Pitfalls and How to Avoid Them

This article examines common MySQL pitfalls—including signed vs. unsigned integers, auto‑increment key requirements, varchar length versus byte count, case‑insensitive collations, and storing emoji characters—providing concrete SQL examples, error screenshots, and configuration tips to help developers avoid unexpected errors.

Database designauto_incrementcollation
0 likes · 9 min read
Common MySQL Pitfalls and How to Avoid Them
Top Architect
Top Architect
Oct 30, 2020 · Backend Development

Implementing Search with Redis: A Backend Development Case Study

This article demonstrates how to replace complex SQL search queries with a Redis‑based solution by caching intermediate result sets using sets and sorted sets, optimizing performance through multi‑command transactions, and adding pagination, offering a practical backend development pattern for high‑traffic e‑commerce search.

paginationperformance optimizationsearch
0 likes · 9 min read
Implementing Search with Redis: A Backend Development Case Study
Architect's Tech Stack
Architect's Tech Stack
Oct 29, 2020 · Databases

Comprehensive Guide to Using DataGrip for Database Management

DataGrip, JetBrains' database IDE, supports most major relational databases and offers an intuitive interface for configuring connections, executing queries, editing data, creating tables, exporting/importing data, and leveraging advanced features such as keyword navigation, code completion, and result set filtering, making database management efficient.

Data ManagementDataGripIDE
0 likes · 10 min read
Comprehensive Guide to Using DataGrip for Database Management
ITPUB
ITPUB
Oct 28, 2020 · Databases

Top MySQL Interview Questions: Data Types, Indexes, Joins, and Performance Tuning

This article compiles essential MySQL interview questions covering data types, storage engines, locks, transactions, triggers, index creation and usage, join types, and practical SQL optimization techniques with concrete examples and code snippets for developers to master database fundamentals.

indexesinterviewmysql
0 likes · 35 min read
Top MySQL Interview Questions: Data Types, Indexes, Joins, and Performance Tuning
Programmer DD
Programmer DD
Oct 28, 2020 · Databases

Master MySQL Performance: Essential Database Optimization Techniques

This guide explains how to identify bottlenecks and boost MySQL performance through both soft (query, index, schema) and hard (hardware, configuration, sharding, caching) optimizations, offering practical commands, best‑practice tips, and visual illustrations for each step.

Database Optimizationindexesmysql
0 likes · 9 min read
Master MySQL Performance: Essential Database Optimization Techniques
Programmer DD
Programmer DD
Oct 27, 2020 · Databases

How to Find and Delete Duplicate Records in MySQL Efficiently

This article explains how to identify duplicate rows in a MySQL table using GROUP BY and HAVING, shows several SELECT queries to list duplicates, and provides multiple DELETE strategies—including sub‑queries and multi‑column handling—to safely remove excess records while keeping one copy.

DELETEGROUP BYduplicate records
0 likes · 9 min read
How to Find and Delete Duplicate Records in MySQL Efficiently
Programmer DD
Programmer DD
Oct 25, 2020 · Databases

Mastering MySQL Deletion: DELETE vs TRUNCATE vs DROP Explained

This article compares MySQL's three data‑removal commands—DELETE, TRUNCATE, and DROP—detailing their execution speed, underlying mechanisms, impact on disk space and auto‑increment values, and best‑practice usage with code examples and optimization tips.

DELETEDROPTRUNCATE
0 likes · 7 min read
Mastering MySQL Deletion: DELETE vs TRUNCATE vs DROP Explained
Architect
Architect
Oct 24, 2020 · Databases

Why Adding LIMIT to DELETE Statements Is a Good Practice in MySQL

The article explains that using LIMIT with DELETE in MySQL improves safety, reduces lock time, prevents long‑running transactions, and enhances performance, and it provides syntax, examples, and expert opinions to illustrate the benefits of this habit.

DELETEDatabase PerformanceLIMIT
0 likes · 7 min read
Why Adding LIMIT to DELETE Statements Is a Good Practice in MySQL
Open Source Linux
Open Source Linux
Oct 23, 2020 · Databases

Boost MySQL Performance: 8 Proven Query Optimization Techniques

This article explores eight common MySQL performance pitfalls—including inefficient LIMIT usage, implicit type conversion, subquery updates, mixed sorting, EXISTS clauses, condition push‑down, early result narrowing, and intermediate result push‑down—and provides rewritten SQL examples that dramatically reduce execution time.

CTEindexingmysql
0 likes · 13 min read
Boost MySQL Performance: 8 Proven Query Optimization Techniques
ITPUB
ITPUB
Oct 18, 2020 · Databases

Boost MySQL Pagination Speed: Practical Query Optimizations and Benchmarks

This article examines MySQL pagination on a multi‑million‑row table, compares plain LIMIT queries with subquery, ID‑range, and temporary‑table techniques, provides SQL examples and performance measurements, and offers recommendations for fast, scalable paging.

mysqlpaginationperformance
0 likes · 10 min read
Boost MySQL Pagination Speed: Practical Query Optimizations and Benchmarks
Architecture Digest
Architecture Digest
Oct 15, 2020 · Databases

Understanding MySQL Indexes: B‑Tree, B+Tree, and Index Design Principles

This article explains how MySQL indexes work, compares binary trees, B‑Tree and B+Tree structures, describes their implementation in MyISAM and InnoDB storage engines, and provides practical guidelines for creating efficient single‑column, composite, and covering indexes to improve query performance.

B+TreeDatabase OptimizationStorage Engines
0 likes · 17 min read
Understanding MySQL Indexes: B‑Tree, B+Tree, and Index Design Principles
21CTO
21CTO
Oct 13, 2020 · Databases

Master Python‑MariaDB Integration: Connect, Query, and Manage Data Efficiently

This guide walks you through installing the MariaDB Python connector, establishing a secure connection, executing SELECT and INSERT statements, handling transactions and errors, and properly closing the connection, providing a complete workflow for Python developers working with MariaDB databases.

ConnectorError HandlingMariaDB
0 likes · 4 min read
Master Python‑MariaDB Integration: Connect, Query, and Manage Data Efficiently
Top Architect
Top Architect
Oct 13, 2020 · Databases

Why Reusing Stored Procedures Is Tricky: Counting Results and Maintaining Code

The article examines the difficulties of reusing SQL Server stored procedures to obtain simple boolean checks, illustrates a concrete example of counting jobs with temporary tables, discusses maintenance pitfalls, and concludes that business logic is often better implemented outside stored procedures.

Database designStored ProceduresT-SQL
0 likes · 6 min read
Why Reusing Stored Procedures Is Tricky: Counting Results and Maintaining Code
dbaplus Community
dbaplus Community
Oct 12, 2020 · Databases

OpenGauss vs Oracle Tables: Compatibility Test and Practical Insights

This article traces the evolution of openGauss from its Huawei roots and systematically evaluates how well openGauss 1.0.0 supports Oracle’s various table types, providing creation examples, compatibility results, and guidance on work‑arounds for unsupported features.

OraclePartitioningTable Compatibility
0 likes · 15 min read
OpenGauss vs Oracle Tables: Compatibility Test and Practical Insights
Programmer DD
Programmer DD
Oct 12, 2020 · Databases

Mastering Set-Based SQL: From Relational Theory to Practical Queries

This article explains the relational model, its data structures, set-oriented operations, and integrity constraints, then demonstrates core SQL clauses such as SELECT, WHERE, GROUP BY, UNION, INTERSECT, EXCEPT, and various JOIN types with clear examples and diagrams.

GROUP BYJOINSet Theory
0 likes · 12 min read
Mastering Set-Based SQL: From Relational Theory to Practical Queries
Architecture Digest
Architecture Digest
Oct 11, 2020 · Databases

Understanding the Execution Order of SQL Queries

This article explains why SQL queries do not start with SELECT, outlines the typical logical execution order of clauses such as FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT, and discusses how database engines may reorder operations for optimization, with code examples and comparisons to LINQ and pandas.

LINQQuery Executiondatabases
0 likes · 6 min read
Understanding the Execution Order of SQL Queries
Selected Java Interview Questions
Selected Java Interview Questions
Oct 3, 2020 · Databases

SQL Query Optimization Tips and Common Pitfalls

This article presents a comprehensive collection of SQL query optimization techniques, covering index usage, avoiding full table scans, proper handling of NULLs, functions, LIKE patterns, temporary tables, cursors, and other best practices to improve database performance and maintainability.

Database Optimizationindexesperformance tuning
0 likes · 11 min read
SQL Query Optimization Tips and Common Pitfalls
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Oct 2, 2020 · Databases

Essential MySQL Optimization Tips: From EXPLAIN to Advanced Index Strategies

This article presents a comprehensive guide to MySQL performance tuning, covering the use of EXPLAIN, proper handling of IN clauses, selective column queries, limit usage, index best practices, avoiding costly operations, pagination techniques, full‑text search, join optimization, and advanced directives such as FORCE INDEX and STRAIGHT_JOIN.

databaseindexingmysql
0 likes · 12 min read
Essential MySQL Optimization Tips: From EXPLAIN to Advanced Index Strategies
ITPUB
ITPUB
Sep 30, 2020 · Databases

Mastering MySQL Index Usage: When and How Queries Leverage Indexes

This guide explains the conditions under which MySQL can use indexes for range scans, LIKE patterns, BETWEEN clauses, and sorting, detailing key_len calculation, index key vs. filter vs. table filter, and practical examples to demystify index utilization.

Database PerformanceIndex OptimizationQuery Planning
0 likes · 10 min read
Mastering MySQL Index Usage: When and How Queries Leverage Indexes
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.

Database Optimizationmysqlperformance
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.

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

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

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

Stored ProceduresTutorialdatabase
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.

CRUDPermissionsQueries
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 OptimizationQuery Tuning
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.

BackendDynamic SQLMyBatis
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.

Database OptimizationStored Procedureindexing
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.

Oracleperformanceselect
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 PerformanceJOIN optimization
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.

OFFSETcursor paginationsql
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.

BackendMyBatisSpringBoot
0 likes · 8 min read
Why MyBatis Mapper Methods Cannot Be Overloaded and How to Locate Their Corresponding SQL in XML
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 PlatformFlinkStreaming
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 EscalationSQL Server
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.

Dynamic SQLMyBatisbackend-development
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.

AssociationBackendMyBatis
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 SQLMyBatisORM
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 QueryMyBatisjava
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 OptimizationQuery Tuning
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.

Data ScienceLearning Resourcesdatabase
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 designRelational Database
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