Q

Database management systems: DBMS vs. RDBMS

Our database management systems expert defines the differences between DBMS and RDBMS.

What are the differences between DBMS and RDBMS?

What are the differences between a DBMS and a RDBMS? Well, this is a tricky one to answer. Why? First of all, there

are those that would tell you that there are not any real relational database management system (RDBMS) products available, so the answer should be given in the theoretical, instead of based on real DBMS products. I find this unsatisfactory (even though it is true). The market leading DBMS products today are all SQL DBMS products. They were originally based on the relational database management model - but did not implement the model fully or completely accurately. Anyway, let me answer it based on these SQL DBMS products versus others.

First of all, the SQL DBMS allows the data to be queried based on any column in any table. You do not need to create an index or keys in order to query data (even though indexes will help with performance and primary keys are required to uniquely identify data). So, relational/SQL data is easier to query than hierarchical, CODASYL, or some other model.

Secondly, because the relational model is based on set theory its accuracy and usefulness have a basis in mathematics. Indeed, a basis in mathematics that is centuries old and proven. This is a strong reason.

Additionally, a relational database describes data in terms of its natural structure only - that is, it excludes all details having to do with machine representation.

That should give you some taste for the benefits of relational database management systems over other types. If you wish to do additional research I can recommend a very good, concise book on the topic. It is titled The Database Relational Model by C.J. Date (Addison-Wesley, ISBN 0-201-61294-1).

 

 

This was first published in May 2006

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

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

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

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close