Tagged articles
transaction processing
27 articles · Page 1 of 1

ITPUBNov 13, 2026 · Databases
Professor Bian Haoqiong presents Retina, a new table format layer bringing row-level cross-table MVCC to lakehouses, achieving 10ms data freshness with only 5% query overhead by rethinking transaction replay, visibility, and compaction.
MVCCPixelsRetina
0 likes · 8 min read

This article walks through implementing a financial-grade double-entry bookkeeping system using Spring Boot 3, MyBatis, and MySQL, covering domain modeling with immutable entries and derived balances, a posting engine with idempotency and debit-credit validation, balance calculation via snapshots and incremental deltas, end-of-day trial balance verification, cross-system reconciliation, and production concerns like precision handling, sharding strategies, and hot-account mitigation.
IdempotencyMyBatisMySQL
0 likes · 36 min read

This white‑paper dissects why a monolithic MySQL‑based order service collapses under peak traffic and presents a layered, asynchronous architecture—using Redis for stock pre‑allocation, RocketMQ for transactional messaging, sharding, idempotency, and comprehensive observability—to reliably handle tens of millions of queries per second.
MySQLRedisRocketMQ
0 likes · 34 min read

The article provides a comprehensive, step‑by‑step analysis of how major payment providers design and implement clearing, settlement, and accounting systems, covering subsystem architecture, object‑relationship models, billing rule engines, settlement modes, data flows, error handling, and the full end‑to‑end financial reconciliation process.
accountingclearingfinancial systems
0 likes · 33 min read

The article analyzes real‑world account system architectures across online car rental, offline amusement, tourism stores, housekeeping, ETC, e‑commerce points, and bank acquiring, showing how reusing validated designs reduces development cost, improves reliability, and adapts to diverse business models through configurable rules and multi‑account handling.
Financial ServicesIndustry Case StudySaaS
0 likes · 24 min read

This article explains how, after the direct‑connect policy is removed, banks link their internal payment systems to the NetUnion platform, detailing quick pay, gateway pay, collection, refund, settlement processes and the layered architecture that ensures secure, high‑performance transaction handling.
Payment Integrationbank payment systemclearing platform
0 likes · 16 min read

This comprehensive guide explains what payment channels are, how they are classified, their structural relationships, criteria for selecting the right channel, step‑by‑step integration processes, system design for channel management, and practical tips for handling card BIN, signing records, and exception handling.
Payment Integrationbank card debitchannel management
0 likes · 26 min read

This article dissects the end‑to‑end payment workflow, identifies performance, reliability and data‑consistency bottlenecks across order creation, risk assessment, routing, settlement and payout stages, and presents concrete architectural patterns, code snippets and monitoring strategies to achieve sub‑second latency and 99.99% availability under massive traffic spikes.
System Monitoringbackend architecturepayment system
0 likes · 14 min read

This comprehensive guide explains the fundamentals of payment systems, covering definitions, development history, transaction flow, key terminology, account structures, payment tools, organizational roles, clearing and settlement mechanisms, and product classifications to help readers grasp the entire payment ecosystem.
Payment Infrastructureclearing and settlementfinancial systems
0 likes · 45 min read

This article outlines a conceptual model for complex payment and refund scenarios, detailing payment methods, channels, platforms, various payment types, refund options, and key design considerations such as multiple payment details, merged payments, distributed locks, and state consistency.
backend designconceptual modelpayment
0 likes · 5 min read

The article details how to design and implement a cloud‑native payment fund account system on Tencent Cloud, covering account definitions, fund flow and multiple account types, TDSQL storage, separated fund and account services, robust security, distributed transactions, auditing, reconciliation, and high‑availability measures for high‑concurrency merchant payments.
ConsistencyDistributed DatabaseSecurity
0 likes · 35 min read

This article walks through the complete internet payment chain—from selecting an e‑commerce platform and placing an order, through the checkout, payment gateways, banking networks, and finally settlement at the central bank—illustrating each component and its role in a modern payment system.
e-commercepayment architecturepayment systems
0 likes · 10 min read

This article explains how RocketMQ's six core features—asynchronous decoupling, peak‑shaving, distributed transaction messages, message filtering, scheduled messages, and ordered delivery—enable Alibaba's Double 11 platform to handle billions of transactions and hundreds of thousands of orders per second while maintaining system stability and reliability.
Double 11Message QueueRocketMQ
0 likes · 7 min read

This article outlines the objectives, detailed call flow, architectural design, and potential challenges of a unified payment center that consolidates order, payment, and financial services across multiple business lines, providing a secure, extensible, and data‑driven backend solution.
Payment Integrationbackend developmentmicroservices
0 likes · 8 min read

The talk traces the evolution of distributed databases—from early shared‑memory and shared‑nothing designs through New‑SQL breakthroughs—to Tencent’s HTAP‑oriented TDSQL, highlighting its strong‑consistency architecture, anomaly taxonomy, and performance advantages over systems like Google Spanner while addressing modern scalability and hardware challenges.
ConsistencyDatabase ArchitectureHTAP
0 likes · 22 min read

TXRocks is a transactional storage engine based on RocksDB that offers significant space savings compared to InnoDB while maintaining comparable performance, with optimizations including sum operator pushdown and AEP-based secondary caching to address RocksDB's read performance limitations.
AEP cachingInnoDB comparisonLSM-tree
0 likes · 15 min read

In his 2020 talk, Prof. Zhou Xuan outlined the evolution of database systems, highlighted ECNU’s research on distributed transactions, hardware‑aware modular designs, HTAP and system decoupling, and argued that future databases will be increasingly modular, hardware‑adapted, and driven by close academia‑industry collaboration.
cloud computingdatabasehardware acceleration
0 likes · 38 min read

This article introduces the TPC-C benchmark, its origin within the Transaction Processing Performance Council, the evolution from early standards like Debit Credit and TP1 to TPC-A, the structure of the TPC-C model with its nine tables and operations, and the subsequent development of newer standards such as TPC-E.
TPCTPC-CTPC-E
0 likes · 9 min read

This article examines the evolution of bank core systems from monolithic designs to distributed architectures, detailing the technical rationale, modular decomposition, sharding strategies, data routing, transaction processing, and performance considerations essential for modernizing banking IT infrastructure.
core bankingdata routingdistributed systems
0 likes · 44 min read

The article presents a detailed technical overview of OceanBase, explaining why traditional centralized databases cannot meet modern OLTP and OLAP demands, how OceanBase achieves distributed transaction processing with Paxos‑based replication and majority voting for high availability, and how it validates its capabilities through the TPC‑C benchmark.
High AvailabilityOceanBaseTPC-C
0 likes · 18 min read

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.
OLAPOLTPdata warehousing
0 likes · 6 min read

The article details the evolution of MaFengWo's payment center from a basic payment‑refund module (1.0) to a comprehensive, modular platform (2.0), describing its core capabilities, layered architecture, customizable checkout, routing management, monitoring system, and future micro‑service roadmap.
backend architecturemonitoringpayment
0 likes · 15 min read

This article provides an in‑depth technical overview of Alibaba's X‑Engine storage engine, explaining its LSM‑based architecture, compaction optimizations, transaction pipeline, caching strategies, and how these innovations enable low‑cost, high‑throughput OLTP for large‑scale e‑commerce workloads.
LSMPolarDB-Xcompaction
0 likes · 18 min read

This article provides a detailed overview of payment system architecture, covering functional modules, core payment, refund, reconciliation, and settlement workflows, as well as design considerations such as gateway integration, routing, risk assessment, asynchronous processing, and transaction logging for robust backend development.
Risk Assessmentgateway integrationpayment architecture
0 likes · 19 min read

The article chronicles OceanBase’s evolution from a research project to a commercial distributed relational database, detailing the technical challenges of meeting strict transaction, consistency, and availability requirements, the innovative solutions adopted, key milestones, and its impact on Alibaba’s ecosystem and the broader market.
AlibabaOceanBaserelational database
0 likes · 19 min read

CynosDB is Tencent Cloud’s high‑performance, highly‑available NewSQL distributed database that uses a shared‑storage architecture with primary and replica instances, log‑structured storage, RDMA/SPDK transmission, Raft consensus, SSI MVCC, two‑phase locking, and state‑machine replication to provide elastic scaling, fast recovery, and cost‑effective enterprise data management.
CynosDBMVCCNewSQL
0 likes · 17 min read

The article explains how achieving high availability through data redundancy introduces consistency challenges that in turn affect performance, and it reviews partitioning, mirroring, consistency models, replication architectures, and two/three‑phase commit protocols in distributed systems.
Data ConsistencyHigh AvailabilityReplication
0 likes · 18 min read
