Tagged articles

HTAP

124 articles · Page 2 of 2
Tencent Cloud Developer
Tencent Cloud Developer
Nov 2, 2020 · Databases

Overview of Tencent TBase: Distributed HTAP Database Architecture and Capabilities

Tencent’s TBase is an enterprise‑grade, PostgreSQL‑based distributed HTAP database that combines strong consistency, high‑concurrency OLTP and high‑performance OLAP within a single cluster, using a GTM‑coordinated two‑phase commit, flexible data distribution, parallel query optimization, and extensive security and scaling features.

Data AnalyticsHTAPPostgreSQL
0 likes · 22 min read
Overview of Tencent TBase: Distributed HTAP Database Architecture and Capabilities
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.

Data ModelingData WarehouseHTAP
0 likes · 21 min read
Understanding OLAP vs. OLTP and the Fundamentals of Data Warehousing
AntTech
AntTech
Sep 2, 2020 · Databases

OceanBase Distributed Relational Database Enables Insurance Business Innovation

The presentation outlines OceanBase's evolution, technical advantages such as high availability, scalability, performance, multi‑tenant HTAP capabilities, and its successful deployment in the insurance industry, demonstrating how a self‑developed distributed relational database can transform core financial services.

FinTechHTAPInsurance
0 likes · 12 min read
OceanBase Distributed Relational Database Enables Insurance Business Innovation
dbaplus Community
dbaplus Community
Jul 21, 2020 · Databases

What Are the Different Types of OLAP and How Do They Impact Performance?

This article provides a comprehensive overview of OLAP systems, classifying them by data volume and modeling approach, comparing MOLAP, ROLAP, HOLAP and HTAP, reviewing popular open‑source products, and detailing architectural, query‑optimization, vectorization, storage and resource‑management techniques that affect analytical warehouse performance.

Data WarehouseHTAPMOLAP
0 likes · 30 min read
What Are the Different Types of OLAP and How Do They Impact Performance?
MaGe Linux Operations
MaGe Linux Operations
Jun 26, 2020 · Databases

What Makes TiDB a Cloud‑Native HTAP Database? An In‑Depth Overview

TiDB is an open‑source, cloud‑native distributed relational database that combines OLTP and OLAP capabilities, offers horizontal elasticity, strong ACID transactions, MySQL compatibility, and is suited for high‑availability, large‑scale, real‑time analytics scenarios across various industries.

Cloud NativeHTAPMySQL Compatibility
0 likes · 9 min read
What Makes TiDB a Cloud‑Native HTAP Database? An In‑Depth Overview
360 Quality & Efficiency
360 Quality & Efficiency
Jun 19, 2020 · Databases

TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips

This article introduces TiDB, an open‑source distributed HTAP database compatible with MySQL, explains its architecture—including TiDB Server, PD, TiKV, and TiSpark—covers deployment requirements, highlights key advantages such as elastic scaling, fault‑tolerance, strong consistency, and provides practical tips and common pitfalls for production use.

HTAPMySQL CompatibilityTiDB
0 likes · 13 min read
TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips
dbaplus Community
dbaplus Community
May 31, 2020 · Databases

Inside TBase: Architecture, Distributed Transactions, and Cloud‑Native Security

This article provides a comprehensive technical overview of Tencent Cloud's TBase database, covering fundamental database classifications, TBase's cloud‑native architecture, distributed transaction mechanisms, storage and compute separation, security layers, backup strategies, and real‑world deployment cases.

Cloud NativeData ReplicationDatabases
0 likes · 40 min read
Inside TBase: Architecture, Distributed Transactions, and Cloud‑Native Security
Tencent Cloud Developer
Tencent Cloud Developer
Apr 13, 2020 · Databases

TBase Database Technology Salon: April Special Live Broadcast Announcement

Tencent Cloud is hosting a three‑month online technical salon, featuring dozens of senior database experts who will nightly dissect the architecture, implementation and best practices of domestic databases such as TDSQL, TBase and CynosDB/CDB, with April’s TBase sessions open for reservation via QR code and offering live‑stream giveaways.

Cloud ComputingDatabaseHTAP
0 likes · 4 min read
TBase Database Technology Salon: April Special Live Broadcast Announcement
Java Backend Technology
Java Backend Technology
Mar 21, 2020 · Databases

How Zhihu Scaled to Trillions of Rows with TiDB: Lessons from Moneta

Zhihu’s Moneta service, handling over 1.3 trillion rows and billions of daily writes, migrated from MySQL sharding to TiDB, achieving millisecond query latency, high availability, and horizontal scalability, while sharing architectural choices, performance metrics, migration challenges, and future expectations for TiDB 3.0.

Database ScalingHTAPLarge-Scale Data
0 likes · 16 min read
How Zhihu Scaled to Trillions of Rows with TiDB: Lessons from Moneta
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 28, 2020 · Databases

TiDB Technical Deep Dive – Storage, Compute, and Scheduling Architecture

This article provides a comprehensive technical overview of TiDB, covering its HTAP design, TiKV storage engine with RocksDB and Raft replication, the mapping of relational tables to key‑value pairs, MVCC implementation, transaction handling, and the PD scheduler that balances replicas, leaders, and hot spots across a distributed cluster.

HTAPKV storageRaft
0 likes · 31 min read
TiDB Technical Deep Dive – Storage, Compute, and Scheduling Architecture
Alibaba Cloud Developer
Alibaba Cloud Developer
Feb 27, 2020 · Databases

How Cloud‑Native Distributed Databases Are Shaping the Future of Enterprise Data

This article reviews the evolution, market trends, core components, architectural challenges, and emerging technologies of cloud‑native distributed database systems, highlighting Alibaba Cloud's solutions such as POLARDB, AnalyticDB, and AI‑driven management platforms that enable elastic, high‑availability, and intelligent data services for modern enterprises.

Alibaba CloudBig DataDistributed Databases
0 likes · 26 min read
How Cloud‑Native Distributed Databases Are Shaping the Future of Enterprise Data
dbaplus Community
dbaplus Community
Oct 30, 2019 · Databases

How TiDB Transformed Real‑Time Data Warehousing at Yiguo Group

This article details how Yiguo Group migrated from a single‑server SQL Server setup to a distributed TiDB + TiSpark architecture, highlighting performance gains, HTAP capabilities with TiFlash, ETL differences, and future data‑platform considerations.

HTAPReal-time Data WarehouseTiDB
0 likes · 9 min read
How TiDB Transformed Real‑Time Data Warehousing at Yiguo Group
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
dbaplus Community
dbaplus Community
Nov 4, 2018 · Databases

How Spark Turns Traditional Databases into Powerful OLAP Engines

This article examines why traditional relational databases like MySQL struggle with analytical workloads, compares ROLAP and MOLAP approaches, explains Spark’s architecture and its advantages for OLAP, and details how Alibaba Cloud’s DRDS HTAP leverages a Spark‑based engine to deliver real‑time distributed query processing.

Data WarehouseDatabasesHTAP
0 likes · 11 min read
How Spark Turns Traditional Databases into Powerful OLAP Engines
Efficient Ops
Efficient Ops
Sep 27, 2018 · Databases

How SequoiaDB’s Multi-Model Architecture Redefines Cloud‑Native Distributed Databases

SequoiaDB, a financial‑grade open‑source distributed database, combines a multi‑model engine with a compute‑storage separation architecture to deliver full MySQL, PostgreSQL and SparkSQL compatibility, elastic scaling, HTAP capabilities, and robust multi‑site disaster recovery for cloud‑native enterprise workloads.

Compute-Storage SeparationDistributed DatabasesHTAP
0 likes · 12 min read
How SequoiaDB’s Multi-Model Architecture Redefines Cloud‑Native Distributed Databases
High Availability Architecture
High Availability Architecture
May 21, 2018 · Big Data

Interview with Baidu’s Chief Big Data Architect Ma Ruyue on OLAP, HTAP, and Emerging Big Data Technologies

In this interview, Baidu’s senior big‑data architect Ma Ruyue discusses his career transition from Hadoop to online databases, the design philosophy behind Baidu’s Palo ROLAP system, the future of HTAP, and his views on the evolving big‑data ecosystem including Spark, AI, and containerization.

Distributed ComputingHTAPdata architecture
0 likes · 11 min read
Interview with Baidu’s Chief Big Data Architect Ma Ruyue on OLAP, HTAP, and Emerging Big Data Technologies
dbaplus Community
dbaplus Community
Mar 18, 2018 · Databases

What’s New in the Database World? March 2018 Release Roundup

The March 2018 DBAplus Newsletter compiles the latest releases across RDBMS, NoSQL, NewSQL, time‑series and big‑data ecosystems, highlighting new features, performance improvements, compatibility updates and key technical links for Oracle, MySQL, MariaDB, SQL Server, DB2, PostgreSQL, TiDB, CockroachDB, InfluxDB, Hadoop and several Chinese‑made databases.

Big DataDatabase ReleasesDatabases
0 likes · 21 min read
What’s New in the Database World? March 2018 Release Roundup
ITPUB
ITPUB
Jan 27, 2018 · Databases

Why NewSQL Matters: From Relational Roots to Modern HTAP

This article traces the evolution of database systems—from early navigational models and Codd's relational theory through the rise of NoSQL and sharding, to the resurgence of NewSQL and the emerging HTAP paradigm—highlighting technical motivations, design trade‑offs, and future directions.

DatabaseHTAPNewSQL
0 likes · 21 min read
Why NewSQL Matters: From Relational Roots to Modern HTAP
High Availability Architecture
High Availability Architecture
Dec 19, 2017 · Databases

Interview with Liu Qi, Co‑founder and CEO of PingCAP, on TiDB’s Origin, Roadmap, and Database Trends

PingCAP co‑founder and CEO Liu Qi discusses the motivation behind creating TiDB, its evolution into a HTAP NewSQL database, key development priorities such as SQL enhancements, storage engine innovation, cloud‑native integration, and shares insights on open‑source project management and future database trends.

Cloud NativeHTAPNewSQL
0 likes · 9 min read
Interview with Liu Qi, Co‑founder and CEO of PingCAP, on TiDB’s Origin, Roadmap, and Database Trends