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 > Apache Phoenix vs. IBM Cloudant vs. Spark SQL vs. SQream DB vs. VoltDB

System Properties Comparison Apache Phoenix vs. IBM Cloudant vs. Spark SQL vs. SQream DB vs. VoltDB

Editorial information provided by DB-Engines
NameApache Phoenix  Xexclude from comparisonIBM Cloudant  Xexclude from comparisonSpark SQL  Xexclude from comparisonSQream DB  Xexclude from comparisonVoltDB  Xexclude from comparison
DescriptionA scale-out RDBMS with evolutionary schema built on Apache HBaseDatabase as a Service offering based on Apache CouchDBSpark SQL is a component on top of 'Spark Core' for structured data processinga GPU-based, columnar RDBMS for big data analytics workloadsDistributed In-Memory NewSQL RDBMS infoUsed for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory
Primary database modelRelational DBMSDocument storeRelational DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.06
Rank#123  Overall
#58  Relational DBMS
Score2.75
Rank#104  Overall
#19  Document stores
Score18.04
Rank#33  Overall
#20  Relational DBMS
Score0.74
Rank#224  Overall
#103  Relational DBMS
Score1.47
Rank#157  Overall
#73  Relational DBMS
Websitephoenix.apache.orgwww.ibm.com/­products/­cloudantspark.apache.org/­sqlsqream.comwww.voltdb.com
Technical documentationphoenix.apache.orgcloud.ibm.com/­docs/­Cloudantspark.apache.org/­docs/­latest/­sql-programming-guide.htmldocs.sqream.comdocs.voltdb.com
DeveloperApache Software FoundationIBM, Apache Software Foundation infoIBM acquired Cloudant in February 2014Apache Software FoundationSQream TechnologiesVoltDB Inc.
Initial release20142010201420172010
Current release5.0-HBase2, July 2018 and 4.15-HBase1, December 20193.5.0 ( 2.13), September 20232022.1.6, December 202211.3, April 2022
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialOpen Source infoApache 2.0commercialOpen Source infoAGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaErlangScalaC++, CUDA, Haskell, Java, ScalaJava, C++
Server operating systemsLinux
Unix
Windows
hostedLinux
OS X
Windows
LinuxLinux
OS X infofor development
Data schemeyes infolate-bound, schema-on-read capabilitiesschema-freeyesyesyes
Typing infopredefined data types such as float or dateyesnoyesyes, ANSI Standard SQL Typesyes
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
Secondary indexesyesyesnonoyes
SQL infoSupport of SQLyesnoSQL-like DML and DDL statementsyesyes infoonly a subset of SQL 99
APIs and other access methodsJDBCRESTful HTTP/JSON APIJDBC
ODBC
.Net
JDBC
ODBC
Java API
JDBC
RESTful HTTP/JSON API
Supported programming languagesC
C#
C++
Go
Groovy
Java
PHP
Python
Scala
C#
Java
JavaScript
Objective-C
PHP
Ruby
Java
Python
R
Scala
C++
Java
JavaScript (Node.js)
Python
C#
C++
Erlang infonot officially supported
Go
Java
JavaScript infoNode.js
PHP
Python
Server-side scripts infoStored proceduresuser defined functionsView functions (Map-Reduce) in JavaScriptnouser defined functions in PythonJava
Triggersnoyesnonono
Partitioning methods infoMethods for storing different data on different nodesShardingShardingyes, utilizing Spark Corehorizontal and vertical partitioningSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
Multi-source replication
Source-replica replication
nonenoneMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsHadoop integrationyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonononono infoFOREIGN KEY constraints are not supported
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoatomic operations within a document possiblenoACIDACID infoTransactions are executed single-threaded within stored procedures
Concurrency infoSupport for concurrent manipulation of datayesyes infoOptimistic lockingyesyesyes infoData access is serialized by the server
Durability infoSupport for making data persistentyesyesyesyesyes infoSnapshots and command logging
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnono
User concepts infoAccess controlAccess Control Lists (using HBase ACL) for RBAC, integration with Apache Ranger for RBAC & ABAC, multi-tenancyAccess rights for users can be defined per databasenoUsers and roles with access to stored procedures

More information provided by the system vendor

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

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

More resources
Apache PhoenixIBM CloudantSpark SQLSQream DBVoltDB
DB-Engines blog posts

Cloudera's HBase PaaS offering now supports Complex Transactions
11 August 2021,  Krishna Maheshwari (sponsor) 

show all

Recent citations in the news

Supercharge SQL on Your Data in Apache HBase with Apache Phoenix | Amazon Web Services
2 June 2016, AWS Blog

Azure #HDInsight Apache Phoenix now supports Zeppelin
16 August 2018, azure.microsoft.com

Bridge the SQL-NoSQL gap with Apache Phoenix
4 February 2016, InfoWorld

Apache Calcite, FreeMarker, Gora, Phoenix, and Solr updated
27 March 2017, SDTimes.com

Azure HDInsight Analytics Platform Now Supports Apache Hadoop 3.0
18 April 2019, eWeek

provided by Google News

Cloudant Best (and Worst) Practices — Part 1
18 March 2019, IBM

Intro to Enterprise Cloud Storage: How to Set Up a Cloudant Database
1 December 2014, Linux.com

IBM Expands Cloud Database Services with Kubernetes
26 September 2019, EnterpriseAI

IBM Code Engine and IBM Cloudant: Serverless Data and Infrastructure
16 August 2021, IBM

IBM to Purchase Cloudant Database as a service (DBaaS) Provider
22 March 2014, App Developer Magazine

provided by Google News

Use Amazon Athena with Spark SQL for your open-source transactional table formats | Amazon Web Services
24 January 2024, AWS Blog

What is Apache Spark? The big data platform that crushed Hadoop
3 April 2024, InfoWorld

Cracking the Apache Spark Interview: 80+ Top Questions and Answers for 2024
1 April 2024, Simplilearn

Performance Insights from Sigma Rule Detections in Spark Streaming
1 June 2024, Towards Data Science

Simba Technologies(R) Introduces New, Powerful JDBC Driver With SQL Connector for Apache Spark(TM)
17 March 2024, Yahoo Singapore News

provided by Google News

I SQream, you SQream, we all SQream for … data analytics?
5 October 2023, Fierce Network

SQream Announces Strategic Integration for Powerful Big Data Analytics with Dataiku
9 February 2024, insideBIGDATA

SQream Joins Samsung Cloud Platform Ecosystem
26 July 2023, Datanami

GPU data warehouse startup SQream lands $39.4M funding round
24 June 2020, SiliconANGLE News

SQream Technologies raises $39.4 million for GPU-accelerated databases
24 June 2020, VentureBeat

provided by Google News

Unveiling Volt Active Data's game-changing approach to limitless app performance
16 October 2023, YourStory

 VoltDB Launches Active(N) Lossless Cross Data Center Replication
31 August 2021, PR Newswire

VoltDB Turns to Real-Time Analytics with NewSQL Database
30 January 2014, Datanami

VoltDB Upgrades Power, Security of Its In-Memory Database
1 February 2017, eWeek

VoltDB Adds Geospatial Support, Cross-Site Replication
28 January 2016, The New Stack

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

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

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Present your product here