Pages

Oct 18, 2010

DBMS vs RDBMS

DBMS
  • DBMS data is stored in the form of rows and columns
  • Data stored in dbms is temporarly
  • DBMS is DATA BASE MANAGEMENT SYSTEM
  • In DBMS keys are not used.
  • In DBMS duplication of rows ans columns.
  • In DBMS rows and columns are independent.
  • DBMS is for single user only.
  • DBMS does not satisfies codd's rules.
  • Eg: DBMS: Sysbase foxpr
RDBMS
  • RDMS data stored in the form of tables                   
  • where as in rdbms is permanently              
  • RDBMS is RELATIONAL DATABASE MANAGEMENT SYSTEM.
  • In RDBMS keys are used.
  • But in RDBMS there is no duplication of rows and columns.
  • But in RDBMS rows and columns are dependent.      
  • RDBMS is for multi-user.
  • RDBMS satisfies codd's rules.
  • Eg: RDBMS: Oracle, SQl  server

31 comments:

  1. So good diff between dbms and rdbms

    ReplyDelete
  2. I have a doubt...
    In sybase or Foxpro , can't we input relations among datas?

    ReplyDelete
  3. thank you!!!!!!!!!!

    ReplyDelete
  4. prity singh ya it;s helpful.............

    ReplyDelete
  5. that was really very helpful......

    ReplyDelete
  6. Very crisp and easy to understand...Thank u! Great work...Keep it up!

    ReplyDelete
  7. not good coz all the difference are not clear in addition to this they are not justified either...

    ReplyDelete
  8. really wonderful....

    ReplyDelete
  9. it is confusing and no key defferences explain

    ReplyDelete
  10. Composed for simple understanding & made easy for beginners. Thanks a lot!!

    ReplyDelete
  11. I love your enthuiasm and writing style. I am looking forward on reading the next hub. Rated up.

    Tnpsc Current Affairs

    Best Tnpsc Coaching Centre in Chennai

    Tnpsc Coaching Centre

    ReplyDelete
  12. Excellent Post, It’s really helpful article

    ReplyDelete
  13. Excellent Post, It’s really helpful article

    ReplyDelete
  14. Sharma Academy consists of the best minds from academics. Thhis is top quality coaching institutes of Central India. The institute has achieved status of distinction following the path envisioned by its founder. The institute has been very successful in making potential aspirants realize their dreams which is evident from the success stories of the previous years. It is Perfect Coaching for MPPSC in Indore. Providing Best MPPSC Coaching in Indore, MPPSC Notes, MPPSC Syllabus, MPPSC Online Coaching Available.

    ReplyDelete
  15. Sharma Academy is Central Indias largest provider of Mppsc Notes and Mppsc Study Material.

    ReplyDelete