Use case
Databases for Analytics (OLAP)
Large scans and aggregations over historical data for BI and reporting. The leading options are Snowflake, ClickHouse and Google BigQuery.
85 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.
Real-time analytics database for sub-second slice-and-dice over streaming event data.
Veteran MPP columnar analytics database from the C-Store lineage, now owned by Rocket Software.
Extensible Rust query engine library on Apache Arrow for building databases and data systems.
Microsoft's Kusto engine: fast KQL analytics over logs, telemetry and time series at petabyte scale.
In-memory MPP columnar analytics database from Germany, tuned for fast BI with little tuning.
Real-time OLAP store from LinkedIn for user-facing analytics at very high query rates.
Pioneering open-source column-store from CWI, still a lean research-grade analytical SQL database.
Embedded, in-process OLAP engine powered by ClickHouse, used mainly from Python.
Serverless SQL warehouses on the Databricks lakehouse, powered by the Photon C++ engine.
Columnar storage engine for fast analytics on fast-changing data, paired with Impala or Spark.
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.
GPU-native columnar SQL database with visual analytics, fully open-sourced by NVIDIA in 2026.
Managed ClickHouse platform that turns SQL pipes into low-latency, versioned HTTP APIs.
Sybase's pioneering columnar warehouse, now SAP IQ and the engine behind HANA Cloud's data lake.
Postgres extension that mirrors tables into Iceberg columnstores for real-time analytics via DuckDB.
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.
GPU- and vector-accelerated database for real-time spatial, time-series and vector analytics.
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.
In-memory OLAP aggregation engine for bank risk analytics, renamed Atoti Server by ActiveViam.
Commercial cloud and enterprise distribution of Apache Doris from its core maintainers.
Experimental Rust columnar analytics engine built to scan billions of rows per second on one machine.
Streaming data lake for log-scale event data, with ClickHouse-based SQL over object storage.
Commercial in-memory columnar SQL engine for .NET that speeds up reporting over hundreds of millions of rows.
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.
Spark's SQL and DataFrame engine for large-scale batch, streaming and lakehouse processing.
Fast distributed SQL query engine for federated analytics across lakes and databases.
The standard spatial extension for PostgreSQL: geometry, geography, rasters and topology in SQL.
IBM's enterprise RDBMS for Linux, UNIX, Windows and z/OS, with BLU columnar and pureScale clustering.
SAP's in-memory columnar HTAP database, the mandatory engine under S/4HANA.
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.
Open-source distributed SQL from Yandex combining row and column tables, topics and vector search.
PostgreSQL-based MPP data warehouse, closed-sourced by Broadcom in 2024 and sold in Tanzu Data.
Pure-JavaScript in-memory SQL engine for browsers and Node.js that queries arrays, JSON, CSV and Excel files.
Serverless AWS query service running Trino-based SQL directly over data in S3.
Hybrid SQL/RDF engine that runs many of the largest public SPARQL endpoints.
Fast open-source SPARQL engine that serves all of Wikidata or OpenStreetMap from one machine.
One of the original relational databases, still sold by Actian for long-lived enterprise systems.
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.
PostgreSQL extension that embeds DuckDB's vectorized engine for fast analytics and data-lake queries.
Rust-native, Spark Connect-compatible engine for SQL, DataFrame and streaming jobs without the JVM.
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.
Faceted-search and discovery engine (MDEX) that Oracle bought in 2011; now a frozen Oracle Commerce component.
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.
China's leading home-grown RDBMS; DM9 (2026) adds distributed, HTAP and AI features.
MySQL-compatible cloud-native HTAP database on object storage, with vector search and snapshots.
Sparse-array store for genomic variant data, built on TileDB and shipped inside GATK4.
Array database for massive multidimensional rasters, with SQL-style queries and OGC WCPS services.
Chinese distributed document database with native ACID storage, SQL instances and S3 API, used in many banks.
Baidu's MySQL-compatible distributed HTAP database on RocksDB and Raft, with full-text and vector indexes.
Carlo Strozzi's 1998 shell-based relational database of plain-text tables and Unix pipe operators.
Apache parallel database for semi-structured JSON data with SQL++, LSM storage and spatial/text indexes.
Schema-less multi-model engine from Germany's Cortex AG, now sold as CortexEngine within Cortex-IP.
Paradigma Software's multi-engine server: ValentinaDB, DuckDB and SQLite plus report and form servers.
MPP in-memory RDF graph database for OLAP-style SPARQL analytics, now Altair Graph Lakehouse under Siemens.
Distributed shared-nothing SQL database built to serve the Rubin Observatory's petascale sky catalogs.
Oracle's managed MySQL with an in-memory columnar engine for analytics, lakehouse, ML and vector search.
Chinese commercial database family: GBase 8a analytics, 8s transactional cluster, 8c distributed.
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.
Oracle's engineered system for Oracle Database, with smart storage offload for OLTP and analytics.
Serverless DataFrame database from Man Group: Pandas in, versioned columnar data on S3 out.
Embeddable multidimensional array storage engine for dense and sparse data on object storage.
Zero-ETL graph query engine that runs Cypher and Gremlin directly on your lakehouse and SQL tables.
deprecated, discontinued & research · 61
related
license legend · Open source (permissive) · Open source (copyleft) · Source-available · Proprietary