Cassandra vs. teradata comparison

Our visitors often compare Cassandra and Teradata with Oracle, Microsoft SQL Server and Amazon Redshift. Data recovery clean room Editorial information provided by DB-Engines Name Cassandra X exclude from comparison Teradata X exclude from comparison Description Wide-column store based on ideas of BigTable and DynamoDB Optimized for write access DBMS mainly used for data warehousing Database model Wide column store Relational DBMS DB-Engines Ranking measures the popularity of database management systems Trend Chart Score 136.44 Rank #7 Overall #1 Wide column stores Score 74.17 Rank #12 Overall #8 Relational DBMS Website Technical documentation­docs Developer Apache Software Foundation Apache top level project, originally developped by Facebook Teradata Initial release 2008 1979 Current release 3.9, September 2016 License Open Source Apache version 2 commercial Cloud-based Only available as a cloud service no no Implementation language Java Server operating systems BSD

Windows Linux Data scheme schema-free yes Typing predefined data types such as float or date yes yes Secondary indexes restricted only equality queries, not always the best performing solution yes special ‘join index’ to physically pre-join tables SQL Support of (almost full) SQL standard (DML, DDL and DCL statements) no yes APIs and other access methods Proprietary protocol CQL (Cassandra Query Language, an SQL-like language) and an API based on Apache Thrift .NET Client API

PL/1 Server-side scripts Stored procedures no yes Triggers yes yes Partitioning methods Methods for storing different data on different nodes Sharding no “single point of failure” Sharding shared nothing architecture Replication methods Methods for redundantly storing data on multiple nodes selectable replication factor Representation of geographical distribution of servers is possible Master-master replication MapReduce Offers an API for user-defined Map/Reduce methods yes no Consistency concepts Methods to ensure consistency in a distributed system Eventual Consistency

Immediate Consistency can be individually decided for each write operation Foreign keys Referential integrity no yes Transaction concepts Support to ensure data integrity after non-atomic manipulations of data no Atomicity and isolation are supported for single operations ACID Concurrency Support for concurrent manipulation of data yes yes Durability Support for making data persistent yes yes User concepts Access control Access rights for users can be defined per object fine grained access rights according to SQL-standard More information provided by the system vendor Cassandra Teradata Specific characteristics Apache Cassandra is the leading NoSQL, distributed database management system driving…

and for displaying vendor-provided information such as key customers, competitive advantages and market metrics. Database view 3rd party products and services 3rd parties CData: Connect to Big Data & NoSQL through standard Drivers.

We invite representatives of 3rd party vendors to contact us for presenting information about their offerings here. Data recovery fort lauderdale More resources Cassandra Teradata DB-Engines blog posts