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

How the Salesforce acquisition will affect Tableau users

In the wake of Salesforce's acquisition of Tableau, it remains to be seen whether Tableau users will be pushed to the cloud and ...

Google acquisition of Looker to boost Google Cloud analytics

By acquiring Looker, Google will enhance its analytics and BI capabilities available through Google Cloud, while becoming a ...

6 tips for effective customer data mining

Digging into customer analytics can improve sales opportunities -- but how does an organization balance that against data privacy...

SearchAWS

AWS re:Inforce agenda underscores cloud security challenges

AWS re:Inforce this month in Boston is the first dedicated security conference by the industry's largest cloud provider. Here's ...

AWS partner program targets cloud migration of ISV workloads

A new AWS cloud migration program is geared to bring ISV application workloads to the platform, and offers a financial incentive ...

IT skills shortage leads to AWS certification demand

AWS certifications help engineers advance their careers and help businesses find qualified candidates. Learn why demand for ...

SearchContentManagement

Nuxeo Insight Cloud adds AI content services to platform

Nuxeo adds AI content services to its content management suite in hopes of spurring citizen data scientists to create custom data...

Content collaboration tools sharpen focus on customer demands

Content collaboration software is necessary to create and share content among business users in and out of the office. Here are ...

NLG tools powered by AI energize, customize, optimize content

Though in its early stages, natural language generation automates content collaboration platforms to streamline employee ...

SearchOracle

How to connect to a pluggable database in Oracle Multitenant

Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they...

Creating an Oracle Multitenant container database and PDBs

Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the ...

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

SearchSAP

SAP NS2 execs on why secure cloud services are the future

In this Q&A, SAP NS2 executives discuss how the company helps national defense, intelligence and security entities move to the ...

New Onapsis service helps uncover SAP security issues

Security firm Onapsis released its Business Risk Illustration, which helps companies assess and deal with SAP security ...

Demand-driven replenishment added to SAP IBP

New demand-driven planning methodology in SAP Integrated Business Planning helps organizations create better supply chain ...

SearchSQLServer

Key features to create a SQL Server audit trail in databases

SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database ...

Check SQL Server Query Store performance impact before using

Many IT teams hesitate to use SQL Server Query Store due to performance concerns. Consultant Andy Warren offers tips on how to ...

SQL Server vs. MySQL: Learn the differences

MySQL and Microsoft SQL Server relational databases have their pros and cons. Weigh the differences between SQL Server and MySQL ...

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.