DBMS > Cassandra vs. ScyllaDB vs. Trafodion
System Properties Comparison Cassandra vs. ScyllaDB vs. Trafodion
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Cassandra Xexclude from comparison||ScyllaDB Xexclude from comparison||Trafodion Xexclude from comparison|
|Description||Wide-column store based on ideas of BigTable and DynamoDB Optimized for write access||Cassandra and DynamoDB compatible wide column store||Transactional SQL-on-Hadoop DBMS|
|Primary database model||Wide column store||Wide column store||Relational DBMS|
|Secondary database models||Key-value store|
|Developer||Apache Software Foundation Apache top level project, originally developped by Facebook||ScyllaDB||Apache Software Foundation, originally developed by HP|
|Current release||4.1.0, December 2022||ScyllaDB Open Source 5.0, July 2022||2.3.0, February 2019|
|License Commercial or Open Source||Open Source Apache version 2||Open Source Open Source (AGPL), commercial license available||Open Source Apache 2.0|
|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.
|Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS|
|Implementation language||Java||C++||C++, Java|
|Server operating systems||BSD|
|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||restricted only equality queries, not always the best performing solution||yes cluster global secondary indices||yes|
|SQL Support of SQL||SQL-like SELECT, DML and DDL statements (CQL)||SQL-like DML and DDL statements (CQL)||yes|
|APIs and other access methods||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||C#|
|All languages supporting JDBC/ODBC/ADO.Net|
|Server-side scripts Stored procedures||no||yes, Lua||Java Stored Procedures|
|Partitioning methods Methods for storing different data on different nodes||Sharding no "single point of failure"||Sharding||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||selectable replication factor Representation of geographical distribution of servers is possible||selectable replication factor Representation of geographical distribution of servers is possible||yes, via HBase|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes||no||yes via user defined functions and HBase|
|Consistency concepts Methods to ensure consistency in a distributed system||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||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no Atomicity and isolation are supported for single operations||no Atomicity and isolation are supported for single operations||ACID|
|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||yes in-memory tables||no|
|User concepts Access control||Access rights for users can be defined per object||Access rights for users can be defined per object||fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||Apache Cassandra is the leading NoSQL, distributed database management system, well...|
|ScyllaDB is a highly-available, highly-scalable, highly-performant NoSQL database....|
|Competitive advantages||No single point of failure ensures 100% availability . Operational simplicity for...|
|Highly-performant (efficiently utilizes full resources of a node and network; millions...|
|Typical application scenarios||Internet of Things (IOT), fraud detection applications, recommendation engines, product...|
|AdTech ( AdGear , FullContact , Numberly , SAS , SteelHouse , Xandr) Customer Data...|
|Key customers||Apple, Netflix, Uber, ING,, Intuit,Fidelity, NY Times, Outbrain, BazaarVoice, Best...|
|Comcast, Samsung, Medium, Disney+ Hotstar, Discord, Zillow, Grab, OlaCabs, Numberly,...|
|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...|
|ScyllaDB Open Source - free open source software (AGPL) ScyllaDB Enterprise - subscription-based...|
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
A New Chapter: Introducing Our New Brand
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|
Instaclustr: Hosted & Managed Apache Cassandra as a Service
CData: Connect to Big Data & NoSQL through standard Drivers.
Aiven for Apache Cassandra: A truly distributed database that can handle large volumes of writes.
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 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
Data management trends: Convergence and more money
provided by Google News
“Generative AI is the latest buzz in the VC industry and will attract ...
ScyllaDB Announces Latest Release of Its NoSQL Database
ScyllaDB Ranked as one of the Fastest-Growing Company in North ...
ScyllaDB 5.0 set to advance NoSQL database capabilities
Monstrously fast + scalable NoSQL database, ScyllaDB, now ...
provided by Google News
The Apache® Software Foundation Announces Annual Report for ...
How Facebook Accelerates SQL at Extreme Scale
Hadoop's growing enterprise presence demonstrated by three ...
provided by Google News
Cassandra Database Administrator
Sr Database Administrator (Cassandra/No SQL)
Database Administrator (DBA)
MongoDB Database Administration Senior Advisor - Work from Home
Backend Software Engineer
Senior Database Administrator (Europe)
Senior WebRTC Engineer (EMEA)
Lead Database Administrator (Europe)
Share this page