Best Columnar Databases
Columnar databases store data by columns rather than by rows. The data storage format in these solutions makes them faster and more efficient for instant analytical queries. These databases are used mainly in data warehouses to handle and process massive volumes of data from multiple sources by serving as a basis for business intelligence tools. These databases support document creation, retrieval via query, updating and editing, and deletion of information. Columnar stores, because of their data storage format, help minimize resource usage related to queries on big data sets. Businesses interested in implementing a database for data warehousing and big data processing may opt for a columnar database.
There are other database types similar but slightly different than columnar databases software including object-oriented databases software, graph databases, key-value databases, and more.
To qualify for inclusion in the Columnar Databases category, a product must:
Best Columnar Databases At A Glance
G2 takes pride in showing unbiased reviews on user satisfaction in our ratings and reports. We do not allow paid placements in any of our ratings, rankings, or reports. Learn about our scoring methodologies.
BigQuery is a fully managed, AI-ready data analytics platform that helps you maximize value from your data and is designed to be multi-engine, multi-format, and multi-cloud. Store 10 GiB of data and
31,798,732 Twitter followers
Snowflake makes enterprise AI easy, efficient and trusted. Thousands of companies around the globe, including hundreds of the world’s largest, use Snowflake’s AI Data Cloud to share data, build applic
228 Twitter followers
Tens of thousands of customers use Amazon Redshift, a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your
2,220,322 Twitter followers
ClickHouse is the fastest and most resource efficient real-time database and data warehouse. ClickHouse is optimized to serve a wide range of data-intensive workloads, from powering interactive user-f
15,785 Twitter followers
MariaDB frees companies from the costs, constraints and complexity of proprietary databases, enabling them to reinvest in what matters most – rapidly developing innovative, customer-facing application
453,669 Twitter followers
An Open-Source Database System
Vertica is the unified analytics platform, based on a massively scalable architecture with a broad set of analytical functions spanning event and time series, pattern matching, geospatial, and built-i
21,592 Twitter followers
StarTree Cloud is a fully-managed user-facing real-time analytics Database-as-a-Service (DBaaS) designed for OLAP at massive speed and scale. Based on Apache Pinot™, StarTree Cloud provides enterprise
2,262 Twitter followers
The real-time database for analytics, search, and AI. Store any type of data and combine the simplicity of SQL with the scalability of NoSQL. CrateDB is an open source, multi-model, distributed and co
4,187 Twitter followers
We power the time-aware data-driven decisions that enable fast-moving organizations to realize the full potential of their AI investments and outpace competitors. Our technology delivers transforma
4,161 Twitter followers
Apache Parquet is a columnar storage format available to any project in the Hadoop ecosystem, regardless of the choice of data processing framework, data model or programming language.
66,061 Twitter followers
A scalable, distributed database that supports structured data storage for large tables. Use HBase when you need random, realtime read/write access to Big Data.
66,061 Twitter followers
Apache Kudu is a free and open source column-oriented data store of the Apache Hadoop ecosystem.
66,061 Twitter followers
Apache Druid is an open source real-time analytics database. Druid combines ideas from OLAP/analytic databases, timeseries databases, and search systems to create a complete real-time analytics soluti
4 Twitter followers
Apache ORC is a self-describing type-aware columnar file format for Hadoop workloads.
66,061 Twitter followers
