Use case

Databases for Hybrid (HTAP)

Transactions and analytics on the same fresh data without ETL. The leading options are Microsoft SQL Server, Oracle Database and SAP HANA.

33 active · ordered by fit for this category, then WhichDB Score

Microsoft SQL ServerRelational

Microsoft's flagship RDBMS: T-SQL, columnstore, Always On, and now native vectors and JSON.

71.0
Oracle DatabaseRelational

The enterprise heavyweight: RAC, Data Guard and a converged engine for SQL, JSON, graph and vectors.

56.9
SAP HANARelational

SAP's in-memory columnar HTAP database, the mandatory engine under S/4HANA.

39.7
TiDBRelationalopen source

MySQL-compatible distributed SQL with a row store for OLTP and a columnar replica for real-time analytics.

35.9
Azure SQL DatabaseRelationalmanaged

Microsoft's always-current managed SQL Server engine, from free serverless databases to 128 TB Hyperscale.

33.9
SingleStoreRelational

Distributed SQL mixing in-memory rowstore and columnstore for real-time analytics, search and vectors.

29.0
Apache IgniteKey-Valueopen source

A distributed, memory-first SQL database and compute grid; Ignite 3 rebuilt it around Raft and Calcite.

28.3
YDBRelationalopen source

Open-source distributed SQL from Yandex combining row and column tables, topics and vector search.

27.4
CitusRelationalopen source

Postgres extension that shards tables across nodes for multi-tenant SaaS and real-time analytics.

21.1
TiKVKey-Valueopen source

CNCF-graduated, Raft-replicated transactional key-value store in Rust; the storage layer of TiDB.

20.8
OceanBaseRelationalopen source

Alipay-proven distributed SQL with MySQL (and Oracle, in Enterprise) compatibility, HTAP and vector search.

19.4
Actian IngresRelational

One of the original relational databases, still sold by Actian for long-lived enterprise systems.

16.8
Oracle ExadataRelational

Oracle's engineered system for Oracle Database, with smart storage offload for OLTP and analytics.

15.0
InterSystems IRISRelational

Multi-model data platform (SQL, objects, globals, vectors) with built-in interoperability, big in healthcare.

13.3
pg_mooncakeColumnar / OLAPopen source

Postgres extension that mirrors tables into Iceberg columnstores for real-time analytics via DuckDB.

11.2
GridGainRelational

The commercial, enterprise-hardened distribution of Apache Ignite for low-latency SQL and compute.

7.8
Huawei GaussDBRelational

Huawei's distributed enterprise RDBMS built on openGauss, aimed at replacing Oracle in Chinese finance.

6.8
Dameng (DM)Relational

China's leading home-grown RDBMS; DM9 (2026) adds distributed, HTAP and AI features.

6.7
openGaussRelationalopen source

Huawei-originated open-source RDBMS forked from PostgreSQL, with in-memory and column engines.

6.7
MatrixOneRelationalopen source

MySQL-compatible cloud-native HTAP database on object storage, with vector search and snapshots.

6.1
PolarDB-XRelationalopen source

Alibaba's open-source, MySQL-compatible shared-nothing distributed SQL with Paxos and columnar indexes.

5.0
AlloyDB for PostgreSQLRelationalmanaged

Google's Postgres-compatible service with disaggregated storage, a columnar engine and ScaNN vectors.

3.6
Alibaba PolarDBRelationalmanaged

Alibaba Cloud's shared-storage relational service in MySQL-, PostgreSQL- and Oracle-compatible editions.

2.7
BaikalDBRelationalopen source

Baidu's MySQL-compatible distributed HTAP database on RocksDB and Raft, with full-text and vector indexes.

2.3
MySQL HeatWaveRelationalmanaged

Oracle's managed MySQL with an in-memory columnar engine for analytics, lakehouse, ML and vector search.

0.5
GalaxybaseGraph

Chinese native distributed graph database for HTAP graph workloads in banking and energy.

0.0
TDSQL (Tencent)Relationalmanaged

Tencent's financial-grade MySQL-compatible database family: distributed TDSQL and cloud-native TDSQL-C.

0.0
IBM Db2Relational

IBM's enterprise RDBMS for Linux, UNIX, Windows and z/OS, with BLU columnar and pureScale clustering.

45.5
Azure Cosmos DBDocumentmanaged

Microsoft's globally distributed, multi-API NoSQL and vector database with SLA-backed latency.

45.3
TigerGraphGraph

Distributed MPP graph database built for deep-link analytics on very large graphs.

16.6
pg_duckdbRelationalopen source

PostgreSQL extension that embeds DuckDB's vectorized engine for fast analytics and data-lake queries.

14.9
XTDBRelationalopen source

Bitemporal SQL database on object storage that keeps every version of every row.

8.3
Oracle Autonomous DatabaseRelationalmanaged

Self-driving Oracle Database on Exadata: auto-patching, auto-scaling, and Select AI, on OCI and other clouds.

0.0

license legend · Open source (permissive) · Open source (copyleft) · Source-available · Proprietary