DBMS > Aerospike vs. Amazon Redshift vs. ClickHouse vs. HEAVY.AI vs. Neo4j
System Properties Comparison Aerospike vs. Amazon Redshift vs. ClickHouse vs. HEAVY.AI vs. Neo4j
| Editorial information provided by DB-Engines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name | Aerospike  previously called Citrusleaf Xexclude from comparison | Amazon Redshift Xexclude from comparison | ClickHouse Xexclude from comparison | HEAVY.AI Formerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022 Xexclude from comparison | Neo4j Xexclude from comparison | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Description | Flash-optimized In-memory NoSQL Database | Large scale data warehouse service for use with business intelligence tools | A high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering. | A high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardware | Scalable, ACID-compliant graph database designed with a high-performance distributed cluster architecture, available in self-hosted and cloud offerings | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Primary database model | Document store Graph DBMS leveraging Apache TinkerpopKey-value store Spatial DBMS | Relational DBMS | Relational DBMS | Relational DBMS | Graph DBMS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary database models | Time Series DBMS | Spatial DBMS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Website | aerospike.com | aws.amazon.com/redshift | clickhouse.com | github.com/heavyai/heavydb www.heavy.ai | neo4j.com | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Technical documentation | docs.aerospike.com | docs.aws.amazon.com/redshift | clickhouse.com/docs | docs.heavy.ai | neo4j.com/docs | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Social network pages |     | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Developer | Aerospike | Amazon (based on PostgreSQL) | Clickhouse Inc. | HEAVY.AI, Inc. | Neo4j, Inc. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Initial release | 2012 | 2012 | 2016 | 2016 | 2007 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Current release | 7.0, November 2023 | v24.4.1.2088-stable, May 2024 | 5.10, January 2022 | 5.20, May 2024 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| License Commercial or Open Source | Open Source Apache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition available | commercial | Open Source Apache 2.0 | Open Source Apache Version 2; enterprise edition available | Open Source GPL version3, commercial licenses available | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cloud-based only Only available as a cloud service | no | yes | no | no | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed. |
| Neo4j Aura: Neo4j’s fully managed cloud service: The zero-admin, always-on graph database for cloud developers. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Implementation language | C | C | C++ | C++ and CUDA | Java, Scala | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Server operating systems | Linux | hosted | FreeBSD Linux macOS | Linux | Linux Can also be used server-less as embedded Java database. OS X Solaris Windows | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data scheme | schema-free | yes | yes | yes | schema-free and schema-optional | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Typing predefined data types such as float or date | yes | yes | yes | yes | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT. | no | no | no | no | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary indexes | yes | restricted | yes | no | yes pluggable indexing subsystem, by default Apache Lucene | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQL Support of SQL | no | yes does not fully support an SQL-standard | Close to ANSI SQL (SQL/JSON + extensions) | yes | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| APIs and other access methods | JDBC Proprietary protocol TinkerPop Gremlin | JDBC ODBC | gRPC HTTP REST JDBC MySQL wire protocol ODBC PostgreSQL wire protocol Proprietary protocol | JDBC ODBC Thrift Vega | Bolt protocol Cypher query language Java API Neo4j-OGM Object Graph MapperRESTful HTTP API Spring Data Neo4j TinkerPop 3 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Supported programming languages | .Net C C# C++ Erlang Go Java JavaScript (Node.js) Lua Perl PHP Python Ruby | All languages supporting JDBC/ODBC | C# 3rd party library C++ Elixir 3rd party libraryGo 3rd party libraryJava 3rd party libraryJavaScript (Node.js) 3rd party libraryKotlin 3rd party libraryNim 3rd party libraryPerl 3rd party libraryPHP 3rd party libraryPython 3rd party libraryR 3rd party libraryRuby 3rd party libraryRust Scala 3rd party library | All languages supporting JDBC/ODBC/Thrift Python | .Net Clojure Elixir Go Groovy Haskell Java JavaScript Perl PHP Python Ruby Scala | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Server-side scripts Stored procedures | user defined functions with Lua | user defined functions in Python | yes | no | yes User defined Procedures and Functions | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Triggers | no | no | no | no | yes via event handler | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Partitioning methods Methods for storing different data on different nodes | Sharding | Sharding | key based and custom | Sharding Round robin | yes using Neo4j Fabric | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Replication methods Methods for redundantly storing data on multiple nodes | selectable replication factor | yes | Asynchronous and synchronous physical replication; geographically distributed replicas; support for object storages. | Multi-source replication | Causal Clustering using Raft protocol available in in Enterprise Version only | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| MapReduce Offers an API for user-defined Map/Reduce methods | yes Aerospike Aggregation Framework is similar to Map/Reduce | no | no | no | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Consistency concepts Methods to ensure consistency in a distributed system | Eventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configuration | Immediate Consistency | Immediate Consistency | Immediate Consistency | Causal and Eventual Consistency configurable in Causal Cluster setup Immediate Consistency in stand-alone mode | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Foreign keys Referential integrity | no | yes informational only, not enforced by the system | no | no | yes Relationships in graphs | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transaction concepts Support to ensure data integrity after non-atomic manipulations of data | Atomic execution of operations | ACID | no | no | ACID | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Concurrency Support for concurrent manipulation of data | yes | yes | yes | yes | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Durability Support for making data persistent | yes | yes | yes | yes | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| In-memory capabilities Is there an option to define some or all structures to be held in-memory only. | yes | yes | yes | yes | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| User concepts Access control | Access rights for users and roles with Enterprise Edition only | fine grained access rights according to SQL-standard | Access rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication. | fine grained access rights according to SQL-standard | Users, roles and permissions. Pluggable authentication with supported standards (LDAP, Active Directory, Kerberos) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| More information provided by the system vendor | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Aerospike previously called Citrusleaf | Amazon Redshift | ClickHouse | HEAVY.AI Formerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022 | Neo4j | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Specific characteristics | Aerospike is an enterprise-class, NoSQL database solution delivering predictable... » more | Neo4j delivers graph technology that has been battle tested for performance and scale... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Competitive advantages | Optimized for use with SSDs (solid-state hard drives) Scales horizontally and vertically... » more | Neo4j is the market leader, graph database category creator, and the most widely... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Typical application scenarios | Aerospike excels in mission-critical applications that have mixed read/write workloads... » more | Real-Time Recommendations Master Data Management Identity and Access Management Network... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Key customers | Nielsen, Williams-Sonoma, Inmobi, AppNexus, Telco (confidential), Financial Services... » more | Over 800 commercial customers and over 4300 startups use Neo4j. Flagship customers... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Market metrics | Aerospike's combination of speed, scalability, and reliability delivers 10x performance... » more | Neo4j boasts the world's largest graph database ecosystem with more than 140 million... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Licensing and pricing models | Subscription-based Enterprise Edition and free, open-source Community Edition » more | GPL v3 license that can be used all the places where you might use MySQL. Neo4j Commercial... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| News | Aerospike a Winner in 2024 Business Sustainability Awards New Aerospike Release Lets Enterprises Consolidate Expensive Legacy Cache And Database Platforms Aerospike Recognized by Independent Research Firm Among Notable Vendors in Vector Databases Report Aerospike Closes $109M in Growth Capital from Sumeru Equity Partners Aerospike Achieves the new AWS Advertising and Marketing Technology Competency | This Week in Neo4j: Importing Data, NODES, GenAI, Going Meta and more openCypher Will Pave the Road to GQL for Cypher Implementers 7 Tips for Submitting Your NODES 2024 Talk How to Configure Neo4j Aura With AWS PrivateLink This Week in Neo4j: Podcast, GraphRAG, GraphQL, Chatbot and more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
We invite representatives of system vendors to contact us for updating and extending the system information, | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Related products and services | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 3rd parties | CData: Connect to Big Data & NoSQL through standard Drivers. » more | DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale. » more Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics. » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
We invite representatives of vendors of related products to contact us for presenting information about their offerings here. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| More resources | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Aerospike previously called Citrusleaf | Amazon Redshift | ClickHouse | HEAVY.AI Formerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022 | Neo4j | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DB-Engines blog posts | Evaluating Hbase and Aerospike Solutions for Real-time System of Record | Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years Increased popularity for consuming DBMS services out of the cloud | Applying Graph Analytics to Game of Thrones MySQL, PostgreSQL and Redis are the winners of the March ranking The openCypher Project: Help Shape the SQL for Graphs Aerospike to invest tens of millions in Israeli operations, double local workforce Aerospike In-Memory noSQL Database Powers Snapdeal Aerospike Raises $109M For Accelerated Database Development, Market Expansion Aerospike raises $109M for its real-time database platform to capitalize on the AI boom Aerospike's New Release Cuts Costs by Enabling Hundreds of Caches on Small Clusters provided by Google News Integrate Tableau and Okta with Amazon Redshift using AWS IAM Identity Center | Amazon Web Services Amazon Redshift Serverless is now generally available in the AWS China (Ningxia) Region Amazon Redshift adds new AI capabilities, including Amazon Q, to boost efficiency and productivity | Amazon Web ... AWS analytics services streamline user access to data, permissions setting, and auditing | Amazon Web Services Amazon Redshift announces programmatic access to Advisor recommendations via API provided by Google News Why Clickhouse Should Be Your Next Database ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ... Ubuntu 24.04 + Linux 6.9 Intel & AMD Server Performance A 1000x Faster Database Solution: ClickHouse’s Aaron Katz ClickHouse Announces Launch of ClickPipes provided by Google News Big Data Analytics: A Game Changer for Infrastructure HEAVY.AI Launches HEAVY 7.0, Introducing Real-Time Machine Learning Capabilities HEAVY.AI Partners with Bain, Maxar, and Nvidia to Provide Digital Twins for Telecom Networks Making the most of geospatial intelligence The insideBIGDATA IMPACT 50 List for Q4 2023 provided by Google News Neo4j Announces Collaboration with Microsoft to Advance GenAI and Data Solutions USA - English - India - English Neo4j CTO says new Graph Query Language standard will have 'massive ripple effects' Neo Technology Announces Neo4j GraphDays Events in Seattle and Silicon Valley Neo4j Is Planning IPO on Nasdaq, Largest Owner Greenbridge Says Give Your Graph Workload a Cost-Performance Boost with Neo4j and AWS Graviton | Amazon Web Services provided by Google News | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Share this page
