What is the difference between DBMS and RDBMS? [Resolved]

Posted by Hariinakoti under Sql Server on 7/16/2012 | Points: 10 | Views : 8507 | Status : [Member] | Replies : 8
Hi Friends,
can any one tell to me what is the difference between DBMS&RDBMS?

Thanks & Regards
Hari



Responses

Posted by: Hariinakoti on: 7/16/2012 [Member] Starter | Points: 25

Up
0
Down

Resolved
RDBMS is one type of dbms in which we use relations ie., tables to store modify n retrieve data.DBMS is basically a piece of s/w. Which is used
perform storing n retrieval of huge data more efficiently oracle ,mysql,sqlserver.


Thanks & Regards
Hari

Hariinakoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Mallesh on: 7/17/2012 [Member] Starter | Points: 25

Up
0
Down
Data base management system (DBMS) consists of collection of interrelated data and a set of programs to aceess that data in a persistant way.
It takes care of storing and accessing data specifically related to the application.

The main objectives of DBMS are

Data Availability -- available to users in a meaning ful format that can easily access.
Data Integrity -- Data base, maintains the data in reliable (correctness) manner.
Data Security -- provides authorization to access the data in different levels at different scenarios.
Data Independence -- It's nothing but 'abstraction' i.e., to store, update and retrieve data in effecient manner without changing the nature of data.

RDBMS is nothing but Relational DBMS, uses a collection of tables to represent both data and the relationship among those data. The relational model is a combination of three components as

Structural Part -- Defines the database as a collection of relations.
Integrity Part -- maintains integrity using various keys like primary key, foreign key, super key and etc...
Manipulative Part -- The relational algebra and relational calculus are the tools used to manipulate the data in database by introducing key features like tuples(rows), attributes(columns), keys, cardinalities, Domains and Degrees.

A relational system may support the following items
1. Data Definition
2. View Definition
3. Data Manipulation
4. Integrity Constraints
5. Authorization
6. Transaction Management
7. Data Recovery

The following are main differences:

1. The speed of operations on data base is very fast in RDBMS compare with ordianry DBMS
2. RDBMS can be implimented by the concept of relationships (logical mapping).
3. The concept behind the RDBMS is 'TABLE' but in 'Flat files' are used in DBMS.

All the Best...


== Mallesh

Hariinakoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 7/18/2012 [Member] Starter | Points: 25

Up
0
Down
Hi
Mallesh

Nice Information


R D Patel

Hariinakoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 7/18/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
nice

Hariinakoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 9/4/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi,
DBMS
1. DBMS is a data base managment system and DBMSis not join the table.
2. 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.
3. DBMS does not support client/server Architecture
4. DBMS Doesnot follow the normalization.
5.It requires low Software and Hardware Requirements.
6.It treats Data as Files internally
7.It supports Single User only
8.DBMS is used for simpler business applications
9.ACID properties of database must be implemented by the user or the developer
RDBMS

1. RDBMS=DBMS+Refrential Integrity
2. RDBMS a relation data base managment system and RDBMS is two table joning the relation
3. 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.
4. RDBMS support client/server Architecture
5. RDBMS follows the normalization
6.It supports multiple users
7.It treats data as Tables internally
8.RDBMS allows simultaneous access of users to data tables.
9.RDBMS imposes integrity constraints.
10.ACID properties of the database are defined in the integrity constraints

Hariinakoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Maheshvishnu on: 9/4/2012 [Member] Starter | Points: 25

Up
0
Down
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.


mahesh

Hariinakoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pgayath on: 9/4/2012 [Member] Starter | Points: 25

Up
0
Down
RDBMS:
* is a relational DBMS.
* It is a combination of DBMS and referential integrity and where we can provide relationship between the tables.
* Follows 12 rules of Codd.
* Supports Client Server architecture.
* Normalization is available
* However large the data is, will be stored in a single table.
* Eg: Student information like Name, Roll No, Address, City, Email ID, Phone No, Course, Marks will be stored in a single table.
* Foxpro, Sybase are DBMS

DBMS:
* It can follow network, heirarchical or other data model
* It is a database system where we cannot provide relationship between the tables.
* does not follows 12 rules of Codd.
* does not supports Client Server architecture.
* Normalization is not available
* Data can be split across tables and relation can be specified to link the tables.
* Eg: Student Name, Roll No, Course, Marks can be stored in "Students" table and Address, City, Email ID, Phone No can be stored in "Contacts" table.
* Oracle, SQL Server
Hope this helps...

Thanks,
Gayathri P

Hariinakoti, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 9/17/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi Harii,
Please mark as answer if it helpful to you..That helps others who search the same..

Hariinakoti, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response