Use case
Databases for Data warehouse
Central store for analytics across the business, usually SQL and columnar. The leading options are Snowflake, ClickHouse and Google BigQuery.
50 active · ordered by fit for this category, then WhichDB Score
Fully managed cloud data warehouse with separate storage and compute, now spanning AI and apps.
Open-source columnar OLAP database known for very fast aggregations over billions of rows.
Google's serverless, pay-per-query data warehouse built on Dremel and Colossus.
In-process columnar SQL database: the SQLite of analytics, running inside your app or notebook.
AWS's MPP columnar data warehouse, available as provisioned RA3 clusters or Serverless.
Serverless cloud data warehouse built on DuckDB, with hybrid local-plus-cloud execution.
Veteran MPP columnar analytics database from the C-Store lineage, now owned by Rocket Software.
In-memory MPP columnar analytics database from Germany, tuned for fast BI with little tuning.
Pioneering open-source column-store from CWI, still a lean research-grade analytical SQL database.
Serverless SQL warehouses on the Databricks lakehouse, powered by the Photon C++ engine.
OLAP engine that pre-computes cubes and aggregate indexes for sub-second SQL on huge datasets.
Real-time MPP analytical database with MySQL compatibility, search indexes and lakehouse access.
MPP OLAP database with a fast vectorized engine, real-time upserts and native lakehouse queries.
Rust-built cloud data warehouse on object storage, open source with a managed Databend Cloud.
Sybase's pioneering columnar warehouse, now SAP IQ and the engine behind HANA Cloud's data lake.
Low-latency analytical database with a Postgres-compliant dialect, as cloud service or self-hosted Core.
Azure analytics service combining MPP dedicated SQL pools, serverless SQL and Spark.
T-SQL warehouse in Microsoft Fabric that stores every table as Delta Parquet in OneLake.
Compressed columnar analytics engine on a MySQL front end, now sold by IgniteTech as Infobright AI.
PostgreSQL-compatible MPP warehouse that runs on its appliance, any cloud or Kubernetes.
Hyperscale data warehouse on NVMe compute-adjacent storage, rebranded as the OcientAIQ platform.
Actian's vectorized columnar analytics database, born from CWI's X100; renamed Analytics Engine in 2026.
Hosted columnar analytics platform with a spreadsheet-style interface, owned by SymphonyAI since 2023.
IBM's MPP analytics edition of Db2 with BLU columnar acceleration, as software or SaaS.
Microsoft's flagship RDBMS: T-SQL, columnstore, Always On, and now native vectors and JSON.
The enterprise heavyweight: RAC, Data Guard and a converged engine for SQL, JSON, graph and vectors.
Fast distributed SQL query engine for federated analytics across lakes and databases.
IBM's enterprise RDBMS for Linux, UNIX, Windows and z/OS, with BLU columnar and pureScale clustering.
The original MPP data warehouse, now VantageCloud with open table formats and in-database analytics.
Distributed SQL query engine from Meta for interactive queries over data lakes and many sources.
The original SQL-on-Hadoop warehouse, now mostly valued for its Metastore and Iceberg support.
Low-latency MPP SQL engine for Hadoop, Kudu and Iceberg tables, developed largely by Cloudera.
PostgreSQL-based MPP data warehouse, closed-sourced by Broadcom in 2024 and sold in Tanzu Data.
Serverless AWS query service running Trino-based SQL directly over data in S3.
Postgres extensions from Snowflake that read and write Iceberg tables and lake files, executed via DuckDB.
IBM's FPGA-accelerated MPP warehouse, now offered as NPS on-prem, in Cloud Pak and as a service.
Oracle's engineered system for Oracle Database, with smart storage offload for OLTP and analytics.
Oracle's multidimensional OLAP cube server, the long-time engine behind financial planning and reporting.
Iceberg-native lakehouse query engine with reflections for acceleration, owned by SAP since 2026.
Java ROLAP engine that answers MDX queries by generating SQL against your relational warehouse.
Lakehouse compute engine that runs SQL on Iceberg, Delta and Hudi in your own cloud account.
Open-source MPP warehouse forked from Greenplum and rebased on a newer PostgreSQL kernel.
Korean Oracle-compatible RDBMS with RAC-style Active Cluster, popular for Oracle exits in Asia.
Chinese commercial database family: GBase 8a analytics, 8s transactional cluster, 8c distributed.
Chinese PostgreSQL-derived RDBMS with Oracle, MySQL and SQL Server compatibility modes.
Self-driving Oracle Database on Exadata: auto-patching, auto-scaling, and Select AI, on OCI and other clouds.
Commercial Trino platform: self-managed Starburst Enterprise and the Starburst Galaxy SaaS.
Parallel, vectorized SQL analytics engine on PostgreSQL roots, once an FPGA appliance, now cloud software.
Spark's SQL and DataFrame engine for large-scale batch, streaming and lakehouse processing.
China's leading home-grown RDBMS; DM9 (2026) adds distributed, HTAP and AI features.
deprecated, discontinued & research · 20
related
license legend · Open source (permissive) · Open source (copyleft) · Source-available · Proprietary