Note-This article is in progress
Table of Content-
- What is database or database management systems (DBMS)?
- What are examples of DBMS?
- What is difference between DBMS and RDBMS?
What is database or database management systems (DBMS)?
DBMS (Database Management System ) is a software program (‘'s) designed to define, manipulate, retrieve and manage data in a database.
What are examples of DBMS?
MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBase, Clipper, and FoxPro
What is difference between DBMS and RDBMS?
DBMS – Data Base Management System
RDBMS – Relational Data Base Management System or Relational DBMS
DBMS has to be persistent, does not impose any constraints or security with regard to data manipulation. In DBMS it is programmer responsibility to ensure the ACID PROPERTY
DBMS Examples– File System, XML
RDBMS adds the additional condition that the system supports a tabular structure of the data, with enforced relationships between the tables. RDBMS defines the integrity constraint for the purpose of holding ACID PROPERTY.
RDBMS Examples– SQL Server, Oracle.