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).
- For more information on DBMS, read Gartner ranks the data warehouse, DBMS market leaders.
Dig Deeper on Database management system (DBMS) architecture, design and strategy
Related Q&A from Craig S. Mullins
Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ... Continue Reading
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. 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.