Difference between Dbms and Rdbms

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ruby17
    Member
    • Sep 2008
    • 56

    Difference between Dbms and Rdbms

    DBMS


    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


    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.
  • Darwon
    Junior Member
    • Dec 2007
    • 7

    #2
    DBMS stands for Database Management System which is a general term for a set of software dedicated to controlling the storage of data.

    RDBMS:- RDMBS stand for Relational DataBase Management System. This is the most common form of DBMS.There can be relationships between the tables.

    Comment

    • MonikaJoshi
      Junior Member
      • Aug 2014
      • 14

      #3
      DBMS stands for Data Base Management System. DBMS is used to store data in files.
      RDBMS stands for Relational Data Base Management System. RDBMS is used to store data in tabular form.



      ----------------------------------------

      Comment

      Working...