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

AI, graph databases among top BI and analytics trends

Leading trends in BI and analytics include machine learning, multi-cloud and graph databases. IT expert William McKnight details ...

MicroStrategy 2019 platform touts 'zero-click' analytics

MicroStrategy's latest BI platform supports a 'zero-click' analytics future with help from new voice and vision capabilities. The...

Analytics trends we'll see in 2019

BI and analytics software looks to evolve further in 2019, as tools will keep getting easier to use and more AI-powered ...

SearchAWS

AWS Backup service targets native workloads

AWS Backup gives customers management and orchestration tools to simplify snapshots for a variety of Amazon services. The move ...

Hotel chain bets on AWS migration for cloud IT strategy

Choice Hotels has placed its technological future in the hands of AWS. Choice's CTO says it's the right move at the right time, ...

CloudWatch Logs Insights won't replace third-party tools -- yet

Organizations struggle to gain insights from their deluge of log data. An updated CloudWatch service can help, but don't expect ...

SearchContentManagement

Open source search engines attract developers

The enterprise search market is evolving and offering new options, such as open source and AI. Discover the benefits of these ...

Successful chatbot content strategies rely on tools, AI

Chatbots aren't a panacea curing customer support issues. Organizations must hone their content quality, organization and ...

Be aware of new OneDrive and SharePoint security features

SharePoint and OneDrive shops can implement recent security features to improve the content sharing process. Discover what's new ...

SearchOracle

Key new features coming in Oracle Database 19c

With Oracle Database 19c, Oracle is aiming to boost the stability of its flagship software's latest generation. But 19c also ...

The real Oracle cloud strategy that may work vs. AWS and Azure

Oracle's database software is at the heart of its efforts to move users to its cloud. And that strategy might work, despite ...

Why to give third-party Oracle database monitoring tools a try

Oracle DBAs can use features in Oracle Enterprise Manager under database licenses. But third-party tools may aid efforts to ...

SearchSAP

UX analysis is key to S/4HANA migration at AES

User experience software from Knoa helped an energy company choose what transactions to migrate from SAP ECC 6 on an Oracle ...

SAP Leonardo makes progress with new branding strategy

Leonardo initially suffered from high expectations, but SAP is unearthing opportunities in new industries to improve its branding...

SAP intelligent enterprise, C/4HANA are trends to watch in 2019

Industry experts sound off on what SAP trends customers should watch in 2019. They also don't mince words about where SAP should ...

SearchSQLServer

SQL Server 2019 improves Linux, container support

The SQL Server 2019 release includes new big data integration features, a collection of database engine enhancements and improved...

Faster R&D pace complicates SQL Server upgrades for users

Microsoft is updating SQL Server and Azure SQL Database more quickly than it did in the past -- and keeping up with the new ...

Microsoft data platform gets new cloud, on-prem features

Microsoft released a second preview of SQL Server 2019 and said users can now run applications in either on-premises SQL Server ...

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.