Traditional Database Systems

Using database management system we can store and retrieve data efficiently and whenever we require. There are two main types of database management systems i.e.

  1. RDBMS
  2. NoSQL

RDBMS

  1. RDBMS stands for Relational Database Management System.
  2. RDBMS relies on storage of data in a tabular form.
  3. RDBMS tables have an identifier called primary key
  4. RDBMS database supports Normalization
  5. RDBMS defines its own integrity constraint to fulfil ACID (Atomocity, Consistency, Isolation and Durability) properties.
  6. RDBMS stores data values in the form of tables along with relationship between two data values from different tables.
  7. MS-SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access supports concepts of RDBMS
  8. RDBMS is based on the relational model as introduced by E. F. Codd.
  9. RDBMS data is stored in database objects called tables.
  10. Table is a collection of related data entries and it consists of columns and rows.
  11. Tables generally stores only structured data.

Simple Table Representation of RDBMS

database table - rdbms