DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Aerospike vs. Hive vs. Hyprcubd vs. Ingres

System Properties Comparison Aerospike vs. Hive vs. Hyprcubd vs. Ingres

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAerospike infopreviously called Citrusleaf  Xexclude from comparisonHive  Xexclude from comparisonHyprcubd  Xexclude from comparisonIngres  Xexclude from comparison
DescriptionFlash-optimized In-memory NoSQL Databasedata warehouse software for querying and managing large distributed datasets, built on HadoopServerless Time Series DBMSWell established RDBMS
Primary database modelKey-value storeRelational DBMSTime Series DBMSRelational DBMS
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.13
Rank#72  Overall
#10  Key-value stores
Score84.74
Rank#14  Overall
#9  Relational DBMS
Score0.00
Rank#353  Overall
#34  Time Series DBMS
Score5.50
Rank#68  Overall
#37  Relational DBMS
Websitewww.aerospike.comhive.apache.orghyprcubd.comwww.actian.com/­data-management/­ingres-sql-rdbms
Technical documentationwww.aerospike.com/­docscwiki.apache.org/­confluence/­display/­Hive/­Homedocs.actian.com/­ingres
Social network pagesFacebookLinkedInTwitter
DeveloperAerospikeApache Software Foundation infoinitially developed by FacebookHyprcubd, Inc.Actian Corporation
Initial release201220121974 infooriginally developed at University Berkely in early 1970s
Current release5.6.0.3, May 20213.1.2, August 201911.0, April 2017
License infoCommercial or Open SourceOpen Source infoApache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition availableOpen Source infoApache Version 2commercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCJavaGoC
Server operating systemsLinuxAll OS with a Java VMhostedAIX
HP Open VMS
HP-UX
Linux
Solaris
Windows
Data schemeschema-freeyesyesyes
Typing infopredefined data types such as float or dateyesyesyes infotime, int, uint, float, stringyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono infobut tools for importing/exporting data from/to XML-files available
Secondary indexesyesyesnoyes
SQL infoSupport of SQLnoSQL-like DML and DDL statementsSQL-like query languageyes
APIs and other access methodsJDBC
Proprietary protocol
JDBC
ODBC
Thrift
gRPC (https).NET Client API
JDBC
ODBC
proprietary protocol (OpenAPI)
Supported programming languages.Net
C
C#
C++
Erlang
Go
Java
JavaScript (Node.js)
Lua
Perl
PHP
Python
Ruby
C++
Java
PHP
Python
Server-side scripts infoStored proceduresuser defined functions infowith Luayes infouser defined functions and integration of map-reducenoyes
Triggersnononoyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardinghorizontal partitioning infoIngres Star to access multiple databases simultaneously
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorselectable replication factorIngres Replicator
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoAerospike Aggregation Framework is similar to Map/Reduceyes infoquery execution via MapReducenono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configurationEventual ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of operationsnonoACID
Concurrency infoSupport for concurrent manipulation of datayesyesnoyes infoMVCC
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnono
User concepts infoAccess controlAccess rights for users and roles infowith Enterprise Edition onlyAccess rights for users, groups and rolestoken accessfine grained access rights according to SQL-standard
More information provided by the system vendor
Aerospike infopreviously called CitrusleafHiveHyprcubdIngres
Specific characteristicsAerospike is an enterprise-class, NoSQL database solution delivering predictable...
» more
Competitive advantagesOptimized for use with SSDs (solid-state hard drives) Scales horizontally and vertically...
» more
Typical application scenariosAerospike excels in mission-critical applications that have mixed read/write workloads...
» more
Key customersNielsen, Williams-Sonoma, Inmobi, AppNexus, Telco (confidential), Financial Services...
» more
Market metricsAerospike's combination of speed, scalability, and reliability delivers 10x performance...
» more
Licensing and pricing modelsSubscription-based Enterprise Edition and free, open-source Community Edition
» more

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Aerospike infopreviously called CitrusleafHiveHyprcubdIngres
DB-Engines blog posts

Evaluating Hbase and Aerospike Solutions for Real-time System of Record
17 March 2020,  Srini Srinivasan, Aerospike (sponsor) 

show all

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

Recent citations in the news

Operational Database Management Market Growth, Overview with Detailed Analysis 2021-2027 | – Radford University Athletics
15 October 2021, Radford University Athletics

Aerospike 5.7 Strengthens the Real-Time Data Platform
15 September 2021, Database Trends and Applications

Startup 101: Critical technological decisions
5 October 2021, Geektime

New Aerospike Petabyte Scale Benchmark Runs Real-Time Operational Workloads on Just 20 AWS Nodes with Intel Processors
19 August 2021, Business Wire

Aerospike Adds Expressions to Next-Generation NoSQL Database 5
18 November 2020, Business Wire

provided by Google News

Best Data Warehouse Tools for Managing Your Data | ESF
24 September 2021, Enterprise Storage Forum

Data Collection, Standardization and Usage at Scale in the Uber Rider App
22 September 2021, InfoQ.com

WANdisco LiveData Migrator Now Migrates Apache Hive Metadata to AWS Glue Data Catalog
5 August 2021, PRNewswire

The best open source software of 2021
18 October 2021, InfoWorld

WANdisco sends Hadoop data and metadata to Databricks cloud data lakes – Blocks and Files
24 May 2021, Blocks and Files

provided by Google News

Linking tech to humanity: Hyprcubd integrates collaboration among IoT community
23 December 2020, Startland News

KC's favorite BBQ: Interest in these 10 restaurants surged with curbside curiosity
28 December 2020, Startland News

December sellout: Father-of-four's Tin Pan cinnamon-swirled creations deliver the treat you've been dreaming about
23 December 2020, Startland News

provided by Google News

Actian Launches Ingres as a Fully-Managed Cloud Service
24 September 2021, Integration Developers

PostgreSQL 14 Is Here - A Look At Its Past And Future
1 October 2021, iProgrammer

Top 9 Data Modeling Tools & Software 2021
6 October 2021, IT Business Edge

Actian Unveils Ingres NeXt Initiative
25 May 2021, Database Trends and Applications

Actian Unveils Ingres NeXt Initiative at Actian Hybrid Data Conference 2021
25 May 2021, Business Wire

provided by Google News

Job opportunities

Database Engineer
PayPal, Scottsdale, AZ

Senior Database Administrator
Fidelity Investments, Westlake, TX

Sr. Database Administrator (remote)
AT&T, New York, NY

Database Reliability Engineer
PayPal, Scottsdale, AZ

Sr. QA Engineer
Charles Schwab, Raleigh, NC

Hadoop Admin
CCIT INC, Remote

Data Lake Steward
Regeneron, Remote

Data Engineer Consultant (Airflow, SQL, Python & Hive, Presto, Spark)
Anectotal LLC, Remote

Support Engineer - Big Data
Microsoft, Issaquah, WA

Senior Data Engineer (100% Remote)
Golden Technology Inc, Remote

Database Developer
COMPQSOFT, Elizabeth City, NC

Database Architect (Oracle/ Ingres)
COMPQSOFT, Elizabeth City, NC

GIS Analyst 1
Weston Solutions, Edison, NJ

Systems Analyst
Teradyne Infotech, Farmington Hills, MI

SOFTWARE ENGINEER
University of Washington, Seattle, WA

jobs by Indeed



Share this page

Featured Products

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database machine learning. Try Vertica for free with no time limit.

Present your product here