What are the benefits and disadvantages of a RDBMS?

Find out about the benefits and disadvantages of RDBMS are and get examples of when relational database management systems are the best database system tools to use in this tip.

Mark Whitehorn, University of Dundee

Published: 15 May 2009

What are disadvantages of a RDBMS?

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate Email Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

As a confirmed database freak I'd have to say none. As a reasonable human (hopefully I qualify on both counts) then of course relational database management system (RDBMS) have disadvantages as well as benefits.

A good way to think about RDBMSes is that they are the right tool for some jobs and the wrong for others. So, if you need to store and manipulate transactional data, you need it to be secure and yet allow multiple people to have simultaneous access to it, then an RDBMS is an excellent tool. If you need a word processor, then an RDBMS is going to be sub-optimal.

database management system (DBMS)

RDBMS (relational database management system)

object-oriented database management system (OODBMS)

What is the difference between DBMS and RDBMS?

Insightsoftware acquisition of Izenda targets embedded BI

Data scientist shortage leaves organizations uncertain

Air Force's data overhaul makes analytics a priority

Here's why Amazon's global expansion won't come easy

How Amazon became a force in SMB lending

Amazon Care expands as demand for big tech regulation grows

OpenText releases Cloud Editions content services updates

Adobe courts small businesses with Acrobat Pro package

Know when to use a headless CMS and when it's not worth it

Supreme Court sides with Google in Oracle API copyright suit

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

S/4HANA Cloud SaaS ERP: Buying team overview

SAP forms financial services partnership with Dediq

Unpatched applications threaten SAP security

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL