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.

University of Dundee

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.

This was last published in May 2009

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

All
News
Get Started
Evaluate
Manage
Problem Solve

Related Q&A from Mark Whitehorn

What are primary, super, foreign and candidate keys in a DBMS?

Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences ... Continue Reading

When does a NoSQL DB trump a traditional database?

The unstructured data types common in big data systems are often better managed by a NoSQL database than relational software, Mark Whitehorn says. Continue Reading

Cloud database security: Why it's a good idea to be paranoid

IT managers should ask cloud providers some pointed questions about the security of data stored in cloud databases, says expert Mark Whitehorn. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Data Management/Data Warehousing experts

View all Data Management/Data Warehousing questions and answers

SearchBusinessAnalytics

Augmented data analytics overshadows traditional BI process

Automated functionality is being added to BI software to help users find and analyze data. This handbook looks at the benefits ...

Augmented BI tools speed insights with less manual labor

Through AI, machine learning and NLP, augmented analytics reduces the manual labor of traditional BI work to more quickly and ...

Most in-demand data science skills include ML, Python

Experts detail the skills employers want most in data scientists -- notably machine learning and programming languages -- and why...

SearchAWS

What the AWS and open source spat means for users and enterprises

Explore the concerns at the center of the AWS vs. open source debate and how they play into a larger conflict between the open ...

Azure-to-AWS migration tool aims to lure Microsoft workloads

Customers might appreciate the flexibility of a new AWS tool that pulls in Azure VM workloads but should be mindful of the big ...

Centralize DevOps and development on AWS with CodeStar

Learn how to set up AWS CodeStar to centralize your dev toolchain. The service is built to be a place for developers to start, ...

SearchContentManagement

How cloud services can empower the future of work

The Akumina Employee Experience Platform and Templafy show how cloud services are changing the way employees work, whether the ...

Business objects are the future of content services platforms

The focus of enterprise content management must shift from a CSP-based approach to a business object services model in order to ...

5 unusual ways to use AI in content management

AI offers great opportunity for enhancing enterprise content management. Here are some more unusual use cases for AI that ...

SearchOracle

Oracle cloud adoption and hybrid cloud adoption pros and cons

More businesses are adopting cloud systems or thinking about it. But cloud and hybrid cloud setups have pluses and minuses that ...

Oracle Digital Assistant unifies use of enterprise chatbots

With Oracle Digital Assistant, users are able to create digital assistants with multiple chatbots that handle different tasks to ...

Oracle Database 19c new features and what users need to know

Oracle Database 19c is the last update to the 12c Release 2 line of Oracle's database software. This handbook examines its new ...

SearchSAP

Verizon works to integrate its supply chain management system

Verizon chief procurement officer John Vazquez explains why the company is integrating several SAP systems to help manage more ...

SAP partner program promises to focus on customer happiness

SAP's partner program shifts from sales emphasis to customer happiness; to lead the efforts, SAP named Karl Fahrbach as the ...

Overview of SAP HANA features and how it's being used today

There has been a lot of hype around SAP HANA since it became available nearly a decade ago, but what is it exactly and what role ...

SearchSQLServer

SQL Server performance tuning best practices for DBAs

Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning ...

Pros and cons of using SQL Server audit triggers for DBAs

Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But ...

How to resolve and avoid deadlocks in SQL Server databases

Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and ...

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

Related Q&A from Mark Whitehorn

Have a question for an expert?

Join the conversation

1 comment

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.