Comparison of DBMS and RDBMS

5 pts.
Database engineering
What is the difference between DBMS and RDBMS?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You will need to register to read the article, but registration is free, and Storage Magazine is a good one.

That link’s answer seems kind of cryptic to me. I would say the difference between a relational versus a non-relational (flat-file) database is the fact that your data is stored in different tables and related through common columns. In a non-relational database, all of your data for each record is stored in one column so you can only have one row for each column.

Why does that matter? What happens when an employee has more than one email address. In a flat-file database, you need to add another column called “EMAIL_ADDR_2”. In a relational database, you add another address to the “EMAIL” table and relate it by “EMPLOYEE_ID”. No column additions are necessary.

All DBMS’s including the subset RDBMS are designed to manage data.

All of the database tools you are likely to think of are RDBMS – relational database management systems
db/2, mySQL, sql/server, Oracle – to name a few.

However, not all DBMS’s are RDBMS’s. The Mainframe DBMS’s that are ‘Network’ or ‘hierarchical databases’ are not relational (ie: IBM’s IMS database). These systems use rigid structures based on pointers from parent to child data. These database are inherently faster but less flexible than RDBMS’s.

RDBMS’s are based on related tables.

Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    I think the question should have been "what is the difference between a Relational Database Management System (RDBMS) and a non-Relational Database Management System", because a DBMS is a system that lets you create, update, and administer a database, so any RDBMS is also a DBMS (for relational databases).
    84,630 pointsBadges:
  • Prufrock
    RDBMS has nothing to do with "related tables" although it's a popular misconception that it does. The R in RDBMS means "Relaltional", which refers to Relations, not Relationships. A relation is a mathematical concept upon which E.F.Codd based the relational database model that he invented in 1969. SQL DBMSs use a tabular (AKA "bag" or "multiset") model rather than Codd's relational model. For that reason among other reasons, DBMSs like Oracle, DB2 and MySQL are not true RDBMSs. However, they have for a long time been marketed under the name "relational" and are popularly known as such even though they are quite different in many ways from the way an actual RDBMS should work. It is more accurate to use the term "SQL DBMS" rather than "RDBMS" for SQL-based systems.
    35 pointsBadges:
  • Djeepp
    I stand corrected and pwned!
    340 pointsBadges:

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: