DBMS > Apache Druid vs. Cassandra vs. ScyllaDB
System Properties Comparison Apache Druid vs. Cassandra vs. ScyllaDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Apache Druid Xexclude from comparison||Cassandra Xexclude from comparison||ScyllaDB Xexclude from comparison|
|Description||Open-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality data||Wide-column store based on ideas of BigTable and DynamoDB Optimized for write access||Cassandra and DynamoDB compatible wide column store|
|Primary database model||Relational DBMS|
Time Series DBMS
|Wide column store||Wide column store|
|Secondary database models||Key-value store|
|Developer||Apache Software Foundation and contributors||Apache Software Foundation Apache top level project, originally developped by Facebook||ScyllaDB|
|Current release||25.0.0, January 2023||4.1.0, December 2022||ScyllaDB Open Source 5.0, July 2022|
|License Commercial or Open Source||Open Source Apache license v2||Open Source Apache version 2||Open Source Open Source (AGPL), commercial license available|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||Linux|
|Data scheme||yes schema-less columns are supported||schema-free||schema-free|
|Typing predefined data types such as float or date||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|
|Secondary indexes||yes||restricted only equality queries, not always the best performing solution||yes cluster global secondary indices|
|SQL Support of SQL||SQL for querying||SQL-like SELECT, DML and DDL statements (CQL)||SQL-like DML and DDL statements (CQL)|
|APIs and other access methods||JDBC|
RESTful HTTP/JSON API
|Proprietary protocol CQL (Cassandra Query Language, an SQL-like language)|
|Proprietary protocol (CQL) compatible with CQL (Cassandra Query Language, an SQL-like language)|
RESTful HTTP API (DynamoDB compatible)
|Supported programming languages||Clojure|
|Server-side scripts Stored procedures||no||no||yes, Lua|
|Partitioning methods Methods for storing different data on different nodes||Sharding manual/auto, time-based||Sharding no "single point of failure"||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||yes, via HDFS, S3 or other storage engines||selectable replication factor Representation of geographical distribution of servers is possible||selectable replication factor Representation of geographical distribution of servers is possible|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Eventual Consistency|
Immediate Consistency can be individually decided for each write operation
Tunable Consistency can be individually decided for each write operation
|Foreign keys Referential integrity||no||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||no Atomicity and isolation are supported for single operations||no Atomicity and isolation are supported for single operations|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no||yes in-memory tables|
|User concepts Access control||RBAC using LDAP or Druid internals for users and groups for read/write by datasource and system||Access rights for users can be defined per object||Access rights for users can be defined per object|
|More information provided by the system vendor|
|Specific characteristics||Apache Cassandra is the leading NoSQL, distributed database management system, well...|
|Competitive advantages||No single point of failure ensures 100% availability . Operational simplicity for...|
|Typical application scenarios||Internet of Things (IOT), fraud detection applications, recommendation engines, product...|
|Key customers||Apple, Netflix, Uber, ING,, Intuit,Fidelity, NY Times, Outbrain, BazaarVoice, Best...|
|Market metrics||Cassandra is used by 40% of the Fortune 100.|
|Licensing and pricing models||Apache licenseÂ Pricing for commercial distributions provided by DataStax and available...|
The Year in Real-Time for Apache Pulsar and Streaming
How to Get the Most Out of Cassandra Summit 2023
The Year in Real-Time for Apache Pulsar and Cassandra
3 Things I Learned from The Apache Cassandra® Corner Podcast
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||DataStax Cassandra: Zero touch operations, configuration and management with true autoscaling|
Aiven for Apache Cassandra: A truly distributed database that can handle large volumes of writes.
Instaclustr: Hosted & Managed Apache Cassandra as a Service
CData: Connect to Big Data & NoSQL through standard Drivers.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Cassandra keeps climbing the ranks of the DB-Engines Ranking Oracle is the DBMS of the Year Winners, losers and an attractive newcomer in Novembers DB-Engines ranking
Oracle is the DBMS of the Year Winners, losers and an attractive newcomer in Novembers DB-Engines ranking
Winners, losers and an attractive newcomer in Novembers DB-Engines ranking
|Conferences and events|
Building scalable real-time apps with AstraDB (DBaaS) and Vaadin
|Recent citations in the news|
Apache Druid 25.0 Delivers Multi-Stage Query Engine and ...
Stream Big, Think Bigger: Analyze Streaming Data at Scale
Imply Announces Major Open Source Contribution for Apache Druid ...
As CIO budgets tighten, Apache Superset looks like a Big Data winner
Apache Druid’s Role in Modern Data Analytics
provided by Google News
Apache Cassandra: Where Is the Open Source Database Headed ...
Supercharging Cassandra NoSQL For Machine Learning
The Linux Foundation Announces Conference Schedule for ...
Progress Software acquires NoSQL data integration engine MarkLogic
Tykhe Block Ventures Holds First Close Of Blockchain Growth Fund
provided by Google News
ScyllaDB Announces Latest Release of Its NoSQL Database
“Generative AI is the latest buzz in the VC industry and will attract ...
ScyllaDB Ranked as one of the Fastest-Growing Company in North ...
ScyllaDB 5.0 set to advance NoSQL database capabilities
ScyllaDB Expands Leadership Team with Red Hat Veteran Amidst ...
provided by Google News
Kubernetes Admin-Apache Druid cluster
DevOps Engineer Fully Remote
Senior Data Engineer (Couchbase, UDB Database, Cassandra)
Sr Database Administrator (Cassandra/No SQL)
MongoDB Database Administration Senior Advisor - Work from Home
Database Administrator (DBA)
Database Administrator - DBA
Senior Database Administrator (Europe)
Backend Software Engineer
Senior Database Administrator (US, Canada)
Full Stack Engineer I
Lead Database Administrator (Europe)
Share this page