Скачать или смотреть DBMS vs RDBMS. What is DBMS? What is RDBMS? | DB Basics #1

DBMS vs RDBMS:
In this this video session, I will brief you an about DBMS & RDBMS and then list down difference between DBMS & RDBMS.

Detailed Article @ http://www.mytecbits.com/microsoft/sq...

My Website: http://www.mytecbits.com



DBMS vs RDBMS:
a. To Start with, DBMS was introduced during 1960s and RDBMS during 70's.
b. DBMS Initially followed the navigational model of data storage, then evolved as network model and hierchical model.
c. RDBMS followed the relationship between tables in the form of keys and indexes.
d. Because of the navigational model in DBMS, fetching data is slower for complex and large amount of data.
e. On the other hand, Data fetching is much faster in RDBMS because of the relationship between tables.
f. So, DBMS is used for small applications and RDBMS is used for complex and enterprise applications.
g. Data redundancy is very common in DBMS leading to difficulty in maintaining the data. In RDBMS, keys and indexes are used to avoid redundancy.
h. Some examples for DBMS are dBase, Microsoft Access, LibreOffice Base and Fox Pro.
i. The popular examples of RDBMS are, SQL Server, Oracle, MySQL, MariaDB and SQLite.