What are disadvantages of a RDBMS?
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.
Dig Deeper on Database management system (DBMS) architecture, design and strategy
Related Q&A from Mark Whitehorn
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
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
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.