SQL SERVER – Difference Between DBMS and RDBMS

What is the difference between DBMS and RDBMS?

DBMS – Data Base Management System

RDBMS – Relational Data Base Management System or Relational 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 adds the additional condition that the system supports a tabular structure of 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.

DBMS does not impose any constraints or security with regard to data manipulation it is used or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the RDBMS is more with this regards because RDBMS defines the integrity constraint for the purpose of holding ACID PROPERTY. RDBMS may be or may not be Client Server Database System.

Examples :

DBMS – File System, XML

RDBMS – SQL Server, Oracle

Reference : Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
SQLAuthority News – Famous Quotes From Bill Gates – Part 2
Next Post
SQL SERVER – 2008 – High Availability – Hot Add CPU

Related Posts

61 Comments. Leave new

  • sir please tell me how to find functional dependency in any relation,

    is their any algorithm or it purely determine on analysis of table by data by filling it with dummy data.

    Reply
  • hi sir,

    i read your articles,it’s a fantastic,but i request you to give the article for complex querry…..

    Reply
  • Drakshayani Kittad
    November 26, 2010 8:45 pm

    Hey Pinal,

    I am a fresher BE(IT). As a beginer I read your articals and they helped me a lot.
    Thank You.

    Reply
  • Drakshayani Kittad
    November 26, 2010 9:02 pm

    Please sir send me query examples of triggers,procedurs .

    Reply
  • If
    DBMS – File System, XML

    RDBMS – SQL Server, Oracle

    what about
    MS-Access , Foxpro , Excel ?
    kindly reply in detail

    Reply
  • Dear Sir,

    I wish to know a fundamental and details about Clustering, this is very important to me. Can I please get any articles and details about it from you. Please give the details on my mail id.

    Thanks,

    Ankesh Kumar

    Reply
  • is ms-access or Excel are RDBMS?

    Reply
  • hello sir i need detailed sssi concept…pls mail to my id

    Reply
  • hello sir,
    i am new to .net and sql server plz send me basics of RDBMS,and Sql server information

    Reply
  • Dear Sir,

    Is it possible to represent your topics with pictorial representation as well when you post?

    Reply
  • Dear sir,

    Can u provide me some information about inner join script and outer join script in sql?
    Looking forward to your reply.

    Reply
  • Hi Sir,
    Your blog is really really awesome.
    Thanks a ton for posting all interview questions related to SQL Server.
    Please can you forward me SQL BI (SSIS,SSAS,SSRS)Interview questions too.
    Im in a high need of them, appreciate your help sir.
    Thanks in advance.

    Swetha Jella.

    Reply
  • what is database..?
    what is schema…?

    Reply
  • hello good morning sir.
    my name is ranjan and i am studying in bca from ignou. i have rdbms practical exam in my course and i know sql will the same sql work up for rdbms exam too. will all the practical thing will remain the same.

    Reply
  • Hi sir,
    Your Posts Regarding SQL Server are awesome. i Have read that matter from many other’s websites. can u include anything else in this article rather than tabular representation and ensuring for Security constrains

    Reply
  • Hiiii
    Am hemima am very thankful that you have given us a good resource in order to improve our knowledge based on sql server

    thank you

    Reply
  • Teekam Singh
    March 1, 2012 4:59 pm

    Hello Sir,

    I have setup merge replication with pull subscription. when snapshot is aplying i am continously getting an error as:

    The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.

    Please help me..

    Reply
  • love&love

    Reply
  • thanks

    Reply
  • If DBMS – File System, XML, RDBMS – SQL Server, Oracle
    what about
    MS-Access , Foxpro , Excel ? kindly reply in detail
    Also what is difference between database and schemas

    Reply

Leave a Reply Cancel reply

Menu
Exit mobile version