473,324 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

DBMS & RDBMS

Hi All,
This is a very general question, not pertaining to any vendor or
DBMS.
What is the difference between a DBMS & RDBMS ?
Can anyone pls provide a detailed explaination on this.

Awaiting replies............

Satish...

Apr 3 '07 #1
5 5830
satish mullapudi wrote:
Hi All,
This is a very general question, not pertaining to any vendor or
DBMS.
What is the difference between a DBMS & RDBMS ?
Can anyone pls provide a detailed explaination on this.

Awaiting replies............

Satish...
The difference is R. Others may argue also that length is different (4
vs 5).

Can you research further using Google and report your findings?
Jan M. Nelken

Apr 3 '07 #2
The R stands for Relational. does that give you a hint? :)

On Apr 2, 10:52 pm, "Jan M. Nelken" <Unknown.U...@Invalid.Domain>
wrote:
satish mullapudi wrote:
Hi All,
This is a very general question, not pertaining to any vendor or
DBMS.
What is the difference between a DBMS & RDBMS ?
Can anyone pls provide a detailed explaination on this.
Awaiting replies............
Satish...

The difference is R. Others may argue also that length is different (4
vs 5).

Can you research further using Google and report your findings?

Jan M. Nelken

Apr 3 '07 #3
I have found out that an RDBMS implements the relational model
designed by Codd for which he designed 12 rules. These r nicknamed as
" Codd Rules".
Are these rules similar to Normalization rules which we follow ? And
does Referential Integrity has a anything to do with Relational-DB ?

Awaiting ur replies...
satish

jezemine wrote:
The R stands for Relational. does that give you a hint? :)

On Apr 2, 10:52 pm, "Jan M. Nelken" <Unknown.U...@Invalid.Domain>
wrote:
satish mullapudi wrote:
Hi All,
This is a very general question, not pertaining to any vendor or
DBMS.
What is the difference between a DBMS & RDBMS ?
Can anyone pls provide a detailed explaination on this.
Awaiting replies............
Satish...
The difference is R. Others may argue also that length is different (4
vs 5).

Can you research further using Google and report your findings?

Jan M. Nelken
Apr 3 '07 #4
"satish mullapudi" <sa***************@gmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
>I have found out that an RDBMS implements the relational model
designed by Codd for which he designed 12 rules. These r nicknamed as
" Codd Rules".
Are these rules similar to Normalization rules which we follow ? And
does Referential Integrity has a anything to do with Relational-DB ?

Awaiting ur replies...
satish
No, relational is not the same as normalization. However, relational set
theory works best if data is normalized to 3rd normal form. Also, most
relational databases do not support repeating groups within a table (or
record), which is fundamental principal of 3rd normal form (not to have
repeating groups) so to some degree relational "helps" enforce a certain
level of normalization.

The concept of referential integrity pre-dates relational databases.
Relational databases share very similar terminology and SQL syntax, so that
they have similar concepts and syntax for declaring referential integrity
within the database using DDL. Databases which pre-date relational may also
have the concept of referential integrity (such as IDMS), but they use
different terminology and use different mechanisms to define RI in the
physical design.

If you look at Codd's 12 rules, the best way to summarize most of them is to
say that a database is relational to the extent that the physical
implementation of data is hidden from the logical view of the data. In a
relational database, the user accesses data via tables and columns, and does
not have to worry about things like access path or indexes to get the
correct answer (even though DBA's have to worry about it to get good
performance).
Apr 3 '07 #5
Thanx Mark & Jan
satish.
Mark A wrote:
"satish mullapudi" <sa***************@gmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
I have found out that an RDBMS implements the relational model
designed by Codd for which he designed 12 rules. These r nicknamed as
" Codd Rules".
Are these rules similar to Normalization rules which we follow ? And
does Referential Integrity has a anything to do with Relational-DB ?

Awaiting ur replies...
satish

No, relational is not the same as normalization. However, relational set
theory works best if data is normalized to 3rd normal form. Also, most
relational databases do not support repeating groups within a table (or
record), which is fundamental principal of 3rd normal form (not to have
repeating groups) so to some degree relational "helps" enforce a certain
level of normalization.

The concept of referential integrity pre-dates relational databases.
Relational databases share very similar terminology and SQL syntax, so that
they have similar concepts and syntax for declaring referential integrity
within the database using DDL. Databases which pre-date relational may also
have the concept of referential integrity (such as IDMS), but they use
different terminology and use different mechanisms to define RI in the
physical design.

If you look at Codd's 12 rules, the best way to summarize most of them is to
say that a database is relational to the extent that the physical
implementation of data is hidden from the logical view of the data. In a
relational database, the user accesses data via tables and columns, and does
not have to worry about things like access path or indexes to get the
correct answer (even though DBA's have to worry about it to get good
performance).
Apr 3 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Kayda | last post by:
Hi: Simple question--is there a tool that convert SQL script written in SQL Server to the equivalent in another DBMS such as Oracle or DB2? Thanks!! blair
20
by: Dave | last post by:
Hi I have been asked to implement an error logging/management database for the network technicians in our company. The idea is that staff using workstations can enter a database and log any...
1
by: deepanjali | last post by:
hi,i wann know ,wat is difference b/w rdbms and dbms
1
by: Gladie | last post by:
Hi all, Can anybody clearly explain me about the difference between the DBMS and RDBMS?
1
by: Tonny Iversen | last post by:
Hello. I haven't used NetBeans yet and I haven't programmed much Java (I've programmed more in C++), but I have a question: Can I get a data consistancy guarantee when writing to a file from Java...
11
by: gnewsgroup | last post by:
First, just in case, BLL = Business Logic Layer and DAL = Data Access Layer. I guess this is really a question about architecture. I believe there are many architect here. Software...
8
by: jumi | last post by:
Produce an E-R diagram, which documents the entities, attributes, relationships and cardinality involved in the Life Insurance Management System. Create a relational schema to hold the necessary...
12
by: leiw | last post by:
Hello, My company want to use database for ERP, any website to discuss DBMS advantage and disadvantage ? or someone post to here for references ? Thanks
8
AmberJain
by: AmberJain | last post by:
Hello, My new semester has started and I have a subject named DBMS (Database Management System). This is the first time I'm studying databases and so I'm not feeling very enthusiastic about...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.