<a href=”http://searchdatamanagement.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid91_gci1190777_mem1,00.html”>DBMS vs RDBMS</a>.
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.