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 E-mail 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.

RDBMS (relational database management system)

database management system (DBMS)

object-oriented database management system (OODBMS)

What is the difference between DBMS and RDBMS?

Please create a username to comment.

Geospatial data a means for deeper understanding

Important resources in a data scientist education

Tellius introduces SaaS version of its analytics platform

Learn the scope of Amazon subscription services

Amazon healthcare initiatives wake up an industry slow to change

What Amazon's culture and practices can teach your company

Microsoft products address digital workplace security

Why version control is necessary in digital asset management

How to use social networking CMS to create social media sites

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Clariba partners with SAP clients for intelligent enterprise

SAP Business One ERP helps SMBs shift with changing markets

SAP Cloud Platform apps deal with pandemic problems

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

Dig Deeper on Database management system (DBMS) architecture, design and strategy

RDBMS (relational database management system)

database management system (DBMS)

object-oriented database management system (OODBMS)

What is the difference between DBMS and RDBMS?

Related Q&A from Mark Whitehorn

Join the conversation

1 comment

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.