BestHub
Sign in
Tagged articles
35 articles
Page 1 of 1
ITPUB
ITPUB
Feb 7, 2026 · Databases

Why MySQL Excels at Transactions but Falters in Analytics – DuckDB to the Rescue

The article examines why MySQL’s transaction layer remains robust while its analytical capabilities lag, outlines enterprise demands for simultaneous OLTP and OLAP workloads, introduces DuckDB’s lightweight yet powerful engine, describes AliSQL’s integration of DuckDB for full MySQL compatibility, and presents TPCH benchmark results showing a dramatic performance boost for analytical queries.

AliSQLDuckDBOLAP
0 likes · 23 min read
Why MySQL Excels at Transactions but Falters in Analytics – DuckDB to the Rescue
Senior Brother's Insights
Senior Brother's Insights
Oct 27, 2025 · Databases

How Does MySQL Power High‑Performance OLTP Workloads?

This article explains what OLTP (Online Transaction Processing) is, outlines its key characteristics, and details how MySQL—through ACID‑compliant transactions, the InnoDB storage engine, various indexing strategies, fast locking mechanisms, query optimization, and high‑availability features—effectively supports high‑concurrency, low‑latency transactional workloads.

Database TransactionsInnoDBOLTP
0 likes · 9 min read
How Does MySQL Power High‑Performance OLTP Workloads?
Lin is Dream
Lin is Dream
May 25, 2025 · Databases

Master MySQL Row-to-Column Pivot: From Basics to Advanced Aggregations

This article walks through using MySQL to pivot rows into columns, covering storage concepts, practical CASE‑WHEN aggregation techniques, and detailed SQL examples for sum, count, average and max calculations, while also discussing performance considerations for medium‑scale and large‑scale data workloads.

Data WarehouseOLAPOLTP
0 likes · 7 min read
Master MySQL Row-to-Column Pivot: From Basics to Advanced Aggregations
Architecture Digest
Architecture Digest
Nov 3, 2024 · Backend Development

Using Easy-Query ORM for Strongly Typed OLTP and OLAP Queries in Java

This article introduces Easy-Query, a Java ORM that offers strong‑typed OLTP and OLAP query capabilities, demonstrates how to define entity classes with many‑to‑many and one‑to‑one relationships, and provides multiple code examples for complex queries, DTO generation, and automatic inclusion of related data.

Easy-QueryJavaOLAP
0 likes · 11 min read
Using Easy-Query ORM for Strongly Typed OLTP and OLAP Queries in Java
Tencent Cloud Developer
Tencent Cloud Developer
Jul 12, 2024 · Databases

Chinese Database History: From Banking Systems to the Railway Ticket OLTP Challenge

The Tencent Cloud TVP series chronicles China’s fifty‑year database evolution, from early banking deposit‑withdrawal systems and the demanding 1990s railway ticket OLTP challenge to the influx of global vendors, highlighting rapid market growth driven by national projects and foreshadowing the internet‑era big‑data opportunities.

1990sChinaDatabase History
0 likes · 8 min read
Chinese Database History: From Banking Systems to the Railway Ticket OLTP Challenge
Baidu Geek Talk
Baidu Geek Talk
Nov 29, 2023 · Databases

How Baidu Built an HTAP Table Storage System to Tackle Massive Data Analytics

This article examines Baidu Search's content storage team's HTAP table storage system, detailing the challenges of supporting massive OLAP workloads on an OLTP‑oriented backend, the architectural split into Neptune and Saturn, storage‑engine optimizations such as row partitioning and dynamic columns, and a SQL‑like KQL framework for compute and scheduling.

HTAPKQLOLAP
0 likes · 13 min read
How Baidu Built an HTAP Table Storage System to Tackle Massive Data Analytics
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 29, 2023 · Databases

When to Use Distributed vs. Centralized Databases: Analysis, Benchmarks, and Best Practices

This article examines the trade‑offs between centralized and distributed OLTP databases, presents industry usage statistics, performance benchmarks, practical questions for migration, and detailed guidance on sharding, SQL design, and operational considerations to help decide when a distributed solution is truly needed.

Database ArchitectureOLTPcentralized databases
0 likes · 12 min read
When to Use Distributed vs. Centralized Databases: Analysis, Benchmarks, and Best Practices
DataFunSummit
DataFunSummit
Oct 24, 2023 · Databases

MatrixOne Storage Format Design Overview

This article introduces Shen Jiangwei, a MatrixOne storage engine engineer, and outlines his presentation on the design of MatrixOne's storage format, covering its motivation, data structures, performance and compatibility guarantees, and the system's cloud‑native OLTP/OLAP/Streaming capabilities.

MatrixOneOLAPOLTP
0 likes · 2 min read
MatrixOne Storage Format Design Overview
Java Architecture Diary
Java Architecture Diary
Sep 19, 2023 · Databases

Getting Started with Lealone: High‑Performance Java OLTP Database

This guide introduces Lealone, a Java open‑source high‑performance relational database for OLTP, outlines its key features, provides step‑by‑step instructions for downloading, starting, and using the server and client, shows JDBC CRUD examples, GUI client setup, and links to the author's technical blogs and source notes.

JDBCLealoneOLTP
0 likes · 10 min read
Getting Started with Lealone: High‑Performance Java OLTP Database
ITPUB
ITPUB
Aug 7, 2023 · Databases

What Exactly Is a Distributed Database? Definitions, Features, and Architecture Explained

This article defines distributed databases, examines their external traits such as write‑heavy, low‑latency, massive concurrency, massive storage and high reliability, explores internal architectures like client‑side sharding, proxy middleware and unit‑based designs, compares them with Amazon Aurora, and summarizes key takeaways.

OLTPReliabilitydistributed databases
0 likes · 19 min read
What Exactly Is a Distributed Database? Definitions, Features, and Architecture Explained
Architects Research Society
Architects Research Society
Jun 20, 2023 · Databases

Understanding the Differences Between OLAP and OLTP Systems

OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) are two distinct data processing systems—OLAP optimized for complex, multidimensional analysis and business intelligence, while OLTP handles high‑volume, real‑time transactional workloads—each serving different purposes, and often used together to drive data‑driven decision making.

Data WarehousingOLAPOLTP
0 likes · 10 min read
Understanding the Differences Between OLAP and OLTP Systems
Architects' Tech Alliance
Architects' Tech Alliance
Nov 1, 2022 · Databases

2022 China Database Industry Report: Emerging Hardware and Architectural Innovations

The September 2022 China Database Industry Analysis report highlights a wave of hardware‑driven innovations—including multi‑core CPUs, heterogeneous GPUs/TPUs/DPU, programmable FPGAs, CXL‑DDR5, persistent memory, NVMe‑oF, and RDMA‑based storage—that enable massive data storage and high‑concurrency real‑time computing across a range of novel database architectures and products.

GPUHardware accelerationOLTP
0 likes · 10 min read
2022 China Database Industry Report: Emerging Hardware and Architectural Innovations
JavaEdge
JavaEdge
Jun 21, 2022 · Databases

Why OLTP and OLAP Differ: Understanding Data Warehouses and Star Schemas

This article explains the fundamental differences between transactional (OLTP) and analytical (OLAP) database workloads, describes how data warehouses isolate analytical queries, and introduces star and snowflake schema designs for efficient reporting and business intelligence.

Data WarehouseOLAPOLTP
0 likes · 9 min read
Why OLTP and OLAP Differ: Understanding Data Warehouses and Star Schemas
dbaplus Community
dbaplus Community
Apr 1, 2022 · Databases

How iQIYI Built a Scalable OLTP Data Center to Eliminate Data Silos

This article details iQIYI's design and implementation of a unified OLTP data center that consolidates data across business lines, solves data‑island issues, ensures strong consistency between MongoDB and Elasticsearch, and provides high‑availability, massive‑scale storage for billions of records.

Data ArchitectureElasticsearchMongoDB
0 likes · 12 min read
How iQIYI Built a Scalable OLTP Data Center to Eliminate Data Silos
iQIYI Technical Product Team
iQIYI Technical Product Team
Feb 11, 2022 · Databases

Design and Implementation of iQIYI Content Platform Data Center (OLTP)

The paper describes iQIYI’s Content Platform Data Center (OLTP), a unified data hub that solves microservice data‑island problems by providing hundred‑billion‑scale storage, high‑QPS reads/writes, field‑level change notifications, final consistency between MongoDB and Elasticsearch, active‑active high availability, and a generic SDK, now serving 26 business lines with thousands of QPS and hundreds of millions of rows.

Data ConsistencyData centerMicroservices
0 likes · 11 min read
Design and Implementation of iQIYI Content Platform Data Center (OLTP)
Architects' Tech Alliance
Architects' Tech Alliance
Mar 12, 2021 · Databases

Understanding OLTP and OLAP Workloads and Oracle Database Performance Best Practices

This article explains the characteristics of OLTP and OLAP workloads, compares their I/O patterns, and provides Oracle database performance best‑practice guidelines, including storage planning, SAN architecture, operating‑system queue‑depth settings, and SwingBench testing results for optimal configuration.

Database PerformanceI/O optimizationOLAP
0 likes · 11 min read
Understanding OLTP and OLAP Workloads and Oracle Database Performance Best Practices
ITPUB
ITPUB
Oct 19, 2020 · Databases

Why MySQL InnoDB Chooses B+ Trees: A Deep Dive into Index Design

This article explains why MySQL's default InnoDB storage engine uses B+ trees instead of B trees or hash indexes, covering storage engine basics, query performance, I/O considerations, and the structural advantages that make B+ trees ideal for OLTP workloads.

B+TreeInnoDBOLTP
0 likes · 16 min read
Why MySQL InnoDB Chooses B+ Trees: A Deep Dive into Index Design
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
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 PerformanceDatabase design
0 likes · 7 min read
Demystifying the TPC‑C Benchmark: Model, Schema, and New‑Order Transaction Walkthrough
AntTech
AntTech
Oct 7, 2019 · Databases

OceanBase TPC‑C Benchmark: SQL Optimization and Storage‑Procedure Techniques

This article, the third in a five‑part series on OceanBase’s record‑breaking TPC‑C results, explains the SQL‑level challenges faced during the benchmark and details the optimizations—including stored procedures, LLVM‑based compilation, array binding, prepared statements, and updatable views—that enabled the performance gains.

OLTPOceanBaseSQL Optimization
0 likes · 11 min read
OceanBase TPC‑C Benchmark: SQL Optimization and Storage‑Procedure Techniques
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 29, 2019 · Databases

Differences Between OLTP and OLAP: Characteristics, Resource Requirements, and Use Cases

The article explains the two main types of data processing—OLTP for real‑time transactional workloads and OLAP for analytical data‑warehousing tasks—detailing their distinct characteristics, resource demands, typical features, major vendor products, and a five‑point comparison of their design and usage.

Data WarehousingOLAPOLTP
0 likes · 6 min read
Differences Between OLTP and OLAP: Characteristics, Resource Requirements, and Use Cases
Big Data Technology Architecture
Big Data Technology Architecture
Aug 21, 2019 · Big Data

Key Big Data Terminology: Offline vs Real-time Computing, Real-time vs Ad Hoc Queries, OLTP vs OLAP, Row vs Column Storage

This article explains fundamental big‑data concepts by comparing offline (batch) and real‑time (stream) computing, distinguishing real‑time queries from ad‑hoc queries, clarifying OLTP versus OLAP workloads, and outlining the differences between row‑based and column‑based storage architectures.

Big DataColumn StorageOLAP
0 likes · 5 min read
Key Big Data Terminology: Offline vs Real-time Computing, Real-time vs Ad Hoc Queries, OLTP vs OLAP, Row vs Column Storage
Architects' Tech Alliance
Architects' Tech Alliance
Jul 15, 2019 · Databases

The Evolution of China's Database Industry: From Early Computing to the Cloud Era

This article traces the development of China's database sector from the 1950s Soviet‑inspired mainframes through the rise of OLTP, foreign database dominance, government‑backed research projects, and the emergence of modern cloud‑native solutions like PolarDB, OceanBase and TiDB, highlighting technical, economic and policy factors that shaped each decade.

ChinaDatabase HistoryOLTP
0 likes · 23 min read
The Evolution of China's Database Industry: From Early Computing to the Cloud Era
dbaplus Community
dbaplus Community
Mar 5, 2019 · Databases

How HTAP and DRDS HTAP Enable Real‑Time OLTP/OLAP Integration

This article explains the concepts of OLTP, OLAP and HTAP, describes the DRDS HTAP architecture—including its engine and storage layers, Fireworks Spark‑based engine, optimizer stages, and streaming capabilities—and demonstrates cross‑database MPP queries and streaming joins while outlining suitable use cases and limitations.

DRDSDatabase ArchitectureHTAP
0 likes · 17 min read
How HTAP and DRDS HTAP Enable Real‑Time OLTP/OLAP Integration
Efficient Ops
Efficient Ops
Jan 8, 2019 · Databases

How We Cut Data Deletion Time from Hours to Minutes in a High‑Volume OLTP System

Through a step‑by‑step case study of a high‑traffic OLTP system, this article explains how evolving deletion logic—from simple full‑table scans to indexed intermediate tables and parallel processing—reduced daily expired‑data cleanup from several hours to under an hour, while addressing ORA‑01555 and clustering‑factor issues.

OLTPOracleSQL Optimization
0 likes · 11 min read
How We Cut Data Deletion Time from Hours to Minutes in a High‑Volume OLTP System
AntTech
AntTech
Nov 27, 2018 · Databases

OceanBase: Achieving Extreme Database Performance on Commodity Hardware

This article explains how Ant Group's financial‑grade distributed relational database OceanBase delivers extreme performance on ordinary servers by optimizing its storage engine, CPU usage, and system scalability, and it highlights the impressive throughput and latency gains demonstrated during the 2018 Double‑11 shopping festival.

CPU efficiencyOLTPOceanBase
0 likes · 8 min read
OceanBase: Achieving Extreme Database Performance on Commodity Hardware
Baidu Waimai Technology Team
Baidu Waimai Technology Team
May 16, 2017 · Big Data

Analysis of OLTP/OLAP Integrated Solutions: Apache Phoenix, Apache Trafodion, and Splice Machine

This article examines the convergence of OLTP and OLAP by introducing Apache Phoenix, Apache Trafodion, and Splice Machine, compares their technical features, and describes how Baidu Waimai adopted a Phoenix‑based solution to address scalability and performance challenges in its operational data store.

Apache PhoenixApache TrafodionBig Data
0 likes · 12 min read
Analysis of OLTP/OLAP Integrated Solutions: Apache Phoenix, Apache Trafodion, and Splice Machine
dbaplus Community
dbaplus Community
Mar 17, 2016 · Databases

Why MySQL Outpaces PostgreSQL in Modern Web Applications

The article compares PostgreSQL and MySQL, highlighting PostgreSQL’s strengths in analytics and Oracle compatibility but criticizing its OLTP performance, while emphasizing MySQL’s superior scalability, feature set, and growing ecosystem, and discusses the broader trend of moving away from Oracle‑centric architectures.

IOE MigrationOLTPPostgreSQL
0 likes · 12 min read
Why MySQL Outpaces PostgreSQL in Modern Web Applications
ITPUB
ITPUB
Mar 15, 2016 · Databases

Choosing the Right MySQL OLTP Architecture: PXC, MHA, or Dual‑Master?

Before migrating enterprise OLTP workloads to open‑source MySQL, this guide evaluates three high‑availability architectures—Percona XtraDB Cluster, MHA, and native dual‑master—by outlining key pre‑migration questions, their advantages, drawbacks, and practical deployment considerations.

OLTPPercona XtraDB Clusterhigh availability
0 likes · 9 min read
Choosing the Right MySQL OLTP Architecture: PXC, MHA, or Dual‑Master?