Free For All

Re: difference between dbms and rdbms

ambrose1 — Sat, 04 Jul 2009 16:42:08 GMT

Thank u friends for answering my queries................

Re: difference between dbms and rdbms

Rangapure.S.Swapnil — Sat, 04 Jul 2009 07:09:37 GMT

DBMS:1)In dbms no relationship concept
2)It supports Single User only
3)It treats Data as Files internally
4)It supports 3 rules of E.F.CODD out off 12 rules
5)It requires low Software and Hardware Requirements.
6)FoxPro, IMS are Examples

RDBMS:
1)It is used to establish the relationship concept between two database objects, i.e, tables
2)It supports multiple users
3)It treats data as Tables internally
4)It supports minimum 6 rules of E.F.CODD
5)It requires High software and hardware requirements.
6)SQL-Server, Oracle are examples

http://www.allinterview.com/showanswers/56803.html

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 difine the integrity constraint for the purpose of holding ACID PROPERTY.

Re: difference between dbms and rdbms

ramireddyindia — Sat, 04 Jul 2009 06:59:04 GMT

http://www.geekinterview.com/question_details/28436

Re: difference between dbms and rdbms

akhhttar — Sat, 04 Jul 2009 06:56:50 GMT

Hi,

I copied following article text from "http://searchdatamanagement.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid91_gci1331735_mem1,00.html?ShortReg=1&mboxConv=searchDataManagement_RegActivate_Submit&" . Otherwise You should have an account on this website to view this article.

DBMS: Database management system

RDBMS: Relational database management system

So, a DBMS is something and an RDBMS is a specific type of something. OK, we haven't gotten far, but it's a start and we just need to dig a little deeper.

We'll start with DBMS and for that an analogy is very helpful, so think about the relationship between a document and a word processor.

You want to produce a document. It might be a letter to your boss asking for a raise. So you fire up a word processor (maybe Microsoft Word) and you use it to produce your document.

Now you want to produce a database. It might be a database to store the orders that your enterprise receives. So you fire up a DBMS (maybe Microsoft's SQL Server) and you use it to produce your database. So a DBMS is simply a bit of software that database developers use to create databases.

Now most word processors generally work in the same way as other processors, but databases differ. There are several fundamentally different kinds of databases that have been produced over the years – hierarchical, network, relational, object and so on. That's the bad news. The good news is that today all of the major DBMSs (Oracle, DB2, SQL Server, Access) are relational. So, any DBMS that you are realistically going to meet is also going to be an RDBMS. So, all RDBMSs are also DBMSs and, in practical terms, any DBMS you are likely to meet will be an RDBMS. And of course, if you're in the market, there are guidelines to follow for how to choose a database engine.

Thank you

Muhammad Akhtar Shiekh

difference between dbms and rdbms

ambrose1 — Sat, 04 Jul 2009 03:21:12 GMT

Hello Friends,

Can u tell me the 3 major difference between dbms and rdbms

Thanks in Advance