Home » DBMS

Differences between DBMS and RDBMS?



Here, we are going to learn what is DBMS and RDBMS and what are the differences between DBMS and RDBMS?
Submitted by Preeti Jain, on March 30, 2018

DBMS

  • DBMS stands for database management system.
  • DBMS introduced during 1960's by Edgar F. Codd.
  • DBMS represent data as a file.
  • DBMS don't provide normalization facility.
  • In case of DBMS there is no relationship between tables.
  • DBMS has several components like query optimizer, database language, database engine.
  • There are many types of DBMS like
    1. Object Oriented Database Management system (OODBMS).
    2. Relational Database Management System (RDMS).
    3. Hierarchical Database Management System.
    4. Network Database Management System.
  • DBMS is basically made for small organization (it means handles limited amount of data).
  • DBMS is single support (i.e. it is for a single user and it does not work remotely).

RDBMS

  • RDBMS stands for Relational database management system.
  • RDBMS introduced during 1970's by codd.
  • RDBMS represent data in a tabular form.
  • RDBMS provides normalization facility.
  • In case of RDBMS there is relationship between two or more than two tables.
  • RDBMS has three components like Data Structure, Data Integrity, Data Manipulation.
  • There are many types of RDBMS like
    • Oracle.
    • Mysql.
    • Microsoft SQL Server.
    • PostgreSQL.
    • IBM DB2.
  • RDBMS is basically made for large organization (it means handles unlimited amount of data).





Was this page helpful? Please share with your friends...

Are you a blogger? Join our Blogging forum.




Comments and Discussions





Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing » Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates


© https://www.includehelp.com (2015-2018), Some rights reserved.




close Like other websites, this site uses cookies to deliver relevant ads based on your interest, by using our website, you acknowledge that you have read our privacy policy.