System Status
Buy Now
  • Email & Apps
  • Office 365
Login
  • MyRackspace Portal
  • Cloud Control Panel
  • Rackspace Webmail Login
  • Cloud Office Control Panel
  • Support Home
  • How-To
  • Developer Documentation
  •  Blogs 
    • Expert Insights Tech Blog
    • Rackspace Blog
    • Solve: Thought Leadership

Support Network

End-to-End Multicloud Solutions.   Solving Together.â„¢   Learn more at Rackspace.com

How–To Home

Managed Operations

  • Introduction
  • FAQ
  • All Articles

Properties of RDBMSs and NoSQL databases

Last updated on:  2021-06-16

Authored by:  Satyakam Mishra


This article presents the characteristics of relational database management systems (RDBMSs) and NoSQL databases.

Prerequisite

For an introduction to relational databases and NoSQL databases, see Types of databases.

Properties of relational databases

Relational Database Management Systems (RDBMS) are efficient and a common choice for storing financial records, logistical information, personnel data, and other information in new databases. Because they are easier to understand and use than NoSQL databases, relational databases also frequently replace legacy hierarchical databases and network databases.

Relational databases have the following properties:

  • Values are atomic.

  • All of the values in a column have the same data type.

  • Each row is unique.

  • The sequence of columns is insignificant.

  • The sequence of rows is insignificant.

  • Each column has a unique name.

  • Integrity constraints maintain data consistency across multiple tables.

Properties of NoSQL databases

NoSQL is a non-schema alternative to SQL and RDBMSs designed to store, process, and analyze extremely large amounts of unstructured data.

NoSQL databases deemphasize the principles of ACID (atomicity, consistency, isolation, and durability). In addition, the process of normalization is not mandatory in NoSQL. Because of the size and speed of modern data, you shoud de-normalize NoSQL databases.

NoSQL databases have the following properties:

  • They have higher scalability.

  • They use distributed computing.

  • They are cost effective.

  • They support flexible schema.

  • They can process both unstructured and semi-structured data.

  • There are no complex relationships, such as the ones between tables in an RDBMS.

The following table shows the types of non-relational databases and the features associated with them:

Type Performance Scalability Flexibility Complexity
Key-value store High High High High
Column store High High Moderate Low
Document store High Variable to high High Low
Graph-based Variable Variable High High

Next step

Reasons to use an SQL database

Use the Feedback tab to make any comments or ask questions. You can also start a conversation with us.

Share this information:

©2020 Rackspace US, Inc.

Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License

See license specifics and DISCLAIMER

About Rackspace
  • About
  • Customer Stories
  • Events
  • Programs
Blogs
  • The Rackspace Blog
  • Expert Insights Tech Blog
  • Solve: Thought Leadership
  • News
  • Contact Information
  • Legal
  • Careers
Site Information
  • Style Guide for Technical Content
  • Trademarks
  • Privacy Statement
  • Website Terms
Support Network
  • Support Network Home
  • Rackspace How-To
  • API Documentation
  • Developer Center
  • ©2020 Rackspace US, Inc.