C C++ Java Data Structure Python JavaScript CSS Ajax PL/SQL PHP Puzzles C programs C++ programs Java programs



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).






You may also be interested in...

C/C++ Tips and Tricks...

Was this page helpful? YES NO

Are you a blogger? Join our Blogging forum.


Comments and Discussions