COMPARISION OF DBMS AND RDBMS
Home > IT Answers > Database > COMPARISION OF DBMS AND RDBMS
Pravi
5 pts.
0
Q:
COMPARISION OF DBMS AND RDBMS
Database engineering, DBMS, RDBMS
what is the difference between DBMS and RDBMS
ASKED: Mar 24 2009  3:58 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24570 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
DBMS vs RDBMS.
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.
Phil
Last Answered: Mar 24 2009  9:28 PM GMT by Philpl1jb   24570 pts.
Latest Contributors: Djeepp   340 pts., Technochic   40210 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29820 pts.  |   Mar 24 2009  8:24PM GMT

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).

 

Prufrock   20 pts.  |   Mar 26 2009  11:45AM GMT

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.

 

Djeepp   340 pts.  |   Mar 27 2009  1:03PM GMT

I stand corrected and pwned!

 
0