email iconemail phone iconcall

Relational Databases vs. NoSQL

Your roadmap to understanding whether NoSQL is right for you.

Technology that can scale, perform and deliver continuous availability is the difference between today’s successful online applications and those that fail. Relational databases (RDBMS) have struggled to keep up with the wave of modernization, leading to the rise of NoSQL as the most viable database option for online Web and mobile applications.

The path to understanding whether a NoSQL technology like DataStax Enterprise is right for your business as either a complementary technology to an RDBMS or as a complete replacement is a three step approach.

Step 1: Learn

Learn the difference between relational systems and Cassandra and the types of use cases it can solve. This content is applicable to both database developers, database administrators, and architects.

Get Started with NoSQL

Compare DataStax Enterprise to Relational Systems

  • When to Choose NoSQL Over an RDBMS (Video)
  • Comparing DataStax Enterprise and Oracle (White Paper)
  • Comparing Cassandra/DataStax Enterprise and Oracle RAC (Article)
  • Why Migrate from MySQL to DataStax Enterprise? (White Paper)
  • A Comparison of DataStax Enterprise and RDBMS’s (Comparison Matrix)
  • How to Model Data in NoSQL/Cassandra vs. an RDBMS (Recorded Webinars)
  • Learning CQL: The SQL-like Language for Cassandra (Video  |  Documentation)

Develop Dynamic Online Applications with Cassandra

  • DataStax Academy: Free online training for developers; tutorials on data modeling, coding, and more. Learn More

Step 2: Migrate

There are a number of ways to move existing data into Cassandra on a one-time or continual basis. The information below will help guide you in migrating data from RDBMS’s to Cassandra.

Implement a Migration Strategy from Relational to NoSQL

  • How to Implement a NoSQL strategy (White Paper)
  • Migrating from Oracle to DataStax Enterprise (White Paper)
  • Migrating from MySQL to DataStax Enterprise (White Paper)
  • Available Methods for Moving RDBMS Data to DataStax Enterprise (Article)
  • Using Sqoop to Move RDBMS Data to DataStax Enterprise (Article  |  Documentation)

Step 3: Succeed

Learn how to manage and optimize DataStax Enterprise clusters for maximum performance and uptime.

Manage and Scale a Successful DataStax Implementation

  • Using DataStax OpsCenter to Manage DataStax Enterprise (White Paper | Video)
  • Using DataStax DevCenter to Develop CQL Queries (Video)
  • Cassandra Management Tips and Techniques (Video)

DataStax vs. RDBMS

Top 10 Ways DataStax Enterprise Compares to RDBMS’s

Product Capability DataStax Enterprise Oracle RDBMS Oracle MySQL Microsoft SQL Server
Core Architecture Masterless (no single point of failure) Master-slave (single points of failure) Master-slave (single points of failure) Master-slave (single points of failure)
High Availability Always-on continuous availability General replication with master-slave General read-only scale out replication; simple master-master SQL Server replication, clustering & mirroring
Data Model Dynamic; structured and unstructured data Legacy RDBMS; Structured data Legacy RDBMS; Structured data Legacy RDBMS; Structured data
Scalability Model Big data/Linear scale performance Oracle RAC or Exadata Manual sharding with MySQL Manual sharding, general partitioning, etc.
Multi-Data Center Support Multi-directional, multi-cloud availability Nothing specific Nothing specific Nothing specific
Security Full security support Full security support Full security support Full security support
Enterprise Search Integrated search on Cassandra data. Handled via Oracle search Full-text indexes only Full-text indexes only
Enterprise Analytics Integrated streaming, real-time, and batch analytics with workload isolation. Analytic functions in Oracle RDBMS via SQL MapReduce Some analytic functions. No Hadoop support Basic analytic functions
In-Memory Database Option Built-in in-memory option Columnar in-memory option MySQL cluster In-memory option
Enterprise Management & Monitoring DataStax OpsCenter & automated management services Oracle Enterprise Manager MySQL Enterprise Monitor SQL Server Enterprise Studio

More Details

Get a detailed look into the differences between DataStax Enterprise and RDBMS’s