Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/articles/database/)
-   -   What is the Difference between DBMS and RDBMS? (http://www.go4expert.com/articles/difference-dbms-rdbms-t304/)

shabbir 17May2005 14:14

What is the Difference between DBMS and RDBMS?
 
A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored.

RDBMS is a Relational Data Base Management System Relational DBMS. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables. This excludes the databases that don't support a tabular structure or don't enforce relationships between tables.

Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.

Yes you can say DBMS does not impose any constraints or security with regard to data manipulation it is user or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the rdbms is more with this regard bcz rdbms define the integrity constraint for the purpose of holding ACID PROPERTY.

I have found many answers on many websites saying that
DBMS are for smaller organizations with small amount of data, where security of the data is not of major concern and RDBMS are designed to take care of large amounts of data and also the security of this data.
and this is completely wrong by definition of RDBMS and DBMS

More Database Articles



100+ SQL Server, Oracle and MySQL basic questions and answers
Database interview questions for beginner
Difference between Stored procedures and User Defined functions[UDF]
Basics of Database Normalization
What you should know for Query Optimization

coderzone 20Sep2005 22:27

Re: What is the Difference between DBMS and RDBMS?
 
Quote:

Originally Posted by shabbir
I have found many answers on many websites saying that
Quote:

DBMS are for smaller organizations with small amount of data, where security of the data is not of major concern and RDBMS are designed to take care of large amounts of data and also the security of this data.
and this is completely wrong by definition of RDBMS and DBMS

I also found the same and I think the difference that you have mentioned is the genuine ones.

eddiecraig 16Nov2007 12:28

Re: What is the Difference between DBMS and RDBMS?
 
hi shabbir,
thanks for explaining about the differnce between dbms and rdbms...

eddiecraig 16Nov2007 12:30

Re: What is the Difference between DBMS and RDBMS?
 
hi shabbir,
thanks for explaining about the differnce between dbms and rdbms...

ahabeebur 22Nov2007 23:46

Re: What is the Difference between DBMS and RDBMS?
 
hi shabbir,

TnX ,,, :)

micman 25Jan2008 22:36

Re: What is the Difference between DBMS and RDBMS?
 
short and clear!

sachinsasneh 4Jul2008 10:39

Re: What is the Difference between DBMS and RDBMS?
 
thanks for given in simple and short language..

seangtz 4Jul2008 12:21

Re: What is the Difference between DBMS and RDBMS?
 
Thx for sharing useful information.

XXxxImmortalxxXX 7Jul2008 16:14

Re: What is the Difference between DBMS and RDBMS?
 
thanks for the info mate

VasanPonnusamy 9Jul2009 16:10

Re: What is the Difference between DBMS and RDBMS?
 
Thanks a lot..
Vasan Ponnusamy

stylishkishore 26Jul2009 20:11

Re: What is the Difference between DBMS and RDBMS?
 
actually i didnt understood what shabbir is saying..i mean..i understood the difference..but i didnt understood the last point..that is according to definition it is wrong..

can anybody clearley explain it..

satyupjum 15Dec2009 15:43

Hello
 
Excellent ! I like it very much





krazytechno 12Mar2010 23:05

Re: What is the Difference between DBMS and RDBMS?
 
The major differences between DBMS and RDBMS are: DBMS is mainly a storage area and it does not employ any tables for storing the data or does not use any special function keys or foreign keys for the retreival of the data. RDBMS has the major difference of solving the queries easily as they are stored in table format and use many functional keys in solving the queries. They follow the Codd's rule..

smithshn 6May2010 00:51

Re: What is the Difference between DBMS and RDBMS?
 
DBMS stands for Data Base Management System.
It shows how to insert,update or delete the records.

While RDBMS stands for Relational Database Management System.
It shows the relation between the tables.
In RDBMS it follows the ACID property
A: Automation
C: Concurrent
I: Integration
D: Durability

akshar25 9Jul2010 15:51

Re: What is the Difference between DBMS and RDBMS?
 
A database can not be distributed but RDBMS can be distributed.............

Jeff Moden 12Jul2010 04:47

Re: What is the Difference between DBMS and RDBMS?
 
I'd be very interested in where the definitions you suggest for DBMS and RDBMS came from. Do you have any citations to support what you have written?

Although I very much appreciate such citations from any who may read this, I'm particularly interested in a response from the author who has been conspicuously absent in the comments.

--Jeff Moden

Jeff Moden 12Jul2010 04:49

Re: What is the Difference between DBMS and RDBMS?
 
Quote:

Originally Posted by coderzone (Post 1250)
I also found the same and I think the difference that you have mentioned is the genuine ones.

Please and by all means... share those citations with the rest of us.

Jeff Moden 12Jul2010 04:59

Re: What is the Difference between DBMS and RDBMS?
 
Shabbir,

Some very powerful definitions about what a DBMS and an RDBMS are have been made in your article and they have made without citation. Since it's highly unlikely that you're the inventor or either term, citations are important. I think your definitions are likely correct definitions and I'd really like to cite your article in some of my own reasearch, but without such citations from you to support this article, they amount to nothing more than hear-say and conjecture.

Is there any change that you could post such citations? Thanks.

--Jeff Moden

shabbir 12Jul2010 08:44

Re: What is the Difference between DBMS and RDBMS?
 
Quote:

Originally Posted by Jeff Moden (Post 70134)
Shabbir,

Some very powerful definitions about what a DBMS and an RDBMS are have been made in your article and they have made without citation. Since it's highly unlikely that you're the inventor or either term, citations are important. I think your definitions are likely correct definitions and I'd really like to cite your article in some of my own reasearch, but without such citations from you to support this article, they amount to nothing more than hear-say and conjecture.

Is there any change that you could post such citations? Thanks.

--Jeff Moden

Jeff, I have not tried to define here anything but I am trying to explain the terms which is defined in a very simple and lucid terms so that very novice users can understand it.

Regarding the wrong definition you can search sites like answers.com and such others and you will see what I meant.

almond 27Jul2010 01:16

Re: What is the Difference between DBMS and RDBMS?
 
thank you for this topic:p

hadi07009 23Aug2010 16:54

Re: What is the Difference between DBMS and RDBMS?
 
Thanks,thank you so much .

parvathi 16Sep2010 09:57

Re: What is the Difference between DBMS and RDBMS?
 
hello shabbir,
am not still clear with the concept can u explain about how the datas are stored in both dbms and rdbms

parvathi 16Sep2010 09:59

Re: What is the Difference between DBMS and RDBMS?
 
and i want to know one thing, in many web sites i read that the disadvantages of dbms as "it can store large data" but then y we should migrate from dbms to rdbms

shabbir 16Sep2010 10:02

Re: What is the Difference between DBMS and RDBMS?
 
Data Storage is not the differential point by any means.

shabbir 16Sep2010 10:03

Re: What is the Difference between DBMS and RDBMS?
 
Quote:

Originally Posted by parvathi (Post 72813)
and i want to know one thing, in many web sites i read that the disadvantages of dbms as "it can store large data" but then y we should migrate from dbms to rdbms

What is the point? It is advantages and how it is a disadvantage

parvathi 16Sep2010 21:04

Re: What is the Difference between DBMS and RDBMS?
 
hi shabbir,
thanks 4 ur reply.. i hav 1 mre doubt.. wats d reason to migrate from dbms to rdbms..
(in other words wats d problm with dbms)

shabbir 17Sep2010 08:23

Re: What is the Difference between DBMS and RDBMS?
 
Because it makes data to be relational

satadrusaha136 19Sep2010 08:52

Re: What is the Difference between DBMS and RDBMS?
 
Thank you very much keep the good work

seomanju 3Dec2010 16:18

Re: What is the Difference between DBMS and RDBMS?
 
DBMS : that is Data Base Management system
RDBMS : Relational DataBase Management System.

drplc3 16Dec2010 23:00

Re: What is the Difference between DBMS and RDBMS?
 
Quote:

Originally Posted by eddiecraig (Post 20507)
hi shabbir,
thanks for explaining about the differnce between dbms and rdbms...

thanks for explaining about the differnce between dbms and rdbms...

Darrelljones 28Jan2011 00:11

Re: What is the Difference between DBMS and RDBMS?
 
DBMS stands for Database Management System which is a general term for a set of software dedicated to controlling the storage of data.
RDMBS stand for Relational DataBase Management System. This is the most common form of DBMS. Invented by E.F. Codd, the only way to view the data is as a set of tables.

The main advantage of an RDBMS is that it checks for referential integrity (relationship between related records using Foreign Keys). You can set the constraints in an RDMBS such that when a paricular record is changed, related records are updated/deleted automatically.

virender.ets 7Feb2011 16:16

Re: What is the Difference between DBMS and RDBMS?
 
Hi Shabbir,
Thanks for sharing useful information.

seoabhisek 7Feb2011 18:57

Re: What is the Difference between DBMS and RDBMS?
 
dbms is the simple way of storing and retrieving the information, whereas in RDBMS entities r related to each other.there r some relations in the entities of the different table.

Ritu_Pruthi 19Apr2011 19:06

Re: What is the Difference between DBMS and RDBMS?
 
Hello sir,
Can you tell me if i want to be DBA. What software should i study, currently i am enjoying working with sql server 2005. Is it suff. or i should acquire some additional knowledge.

Ritu_Pruthi 19Apr2011 19:08

Re: What is the Difference between DBMS and RDBMS?
 
Plz tell......What is SQL(Admin)? IS it a book or a software. Which link or book should i follow to study this.

juliaandrews 25May2011 17:24

Re: What is the Difference between DBMS and RDBMS?
 
i HAVE NO BRIEF KNOWLEDGE ABOUT IT SO THANKS FOR SHARING INFORMATION.

samualrich123 30Jun2011 00:23

Re: What is the Difference between DBMS and RDBMS?
 
Thanks for sharing this difference because this question is frequently asked in technical interview.It is helpful.

virender.ets 12Jul2011 17:33

Re: What is the Difference between DBMS and RDBMS?
 
I found your information is very useful and correct.
Thanks

kalpna bhawra 23Mar2012 15:08

Re: What is the Difference between DBMS and RDBMS?
 
thankxxxx alot for this information.........

samantha1230 28Mar2012 17:21

Re: What is the Difference between DBMS and RDBMS?
 
I completely agreed with Shabbir, infact I think this one is the best explanation.


All times are GMT +5.5. The time now is 06:13.