Database management system(DBMS)

DBMS

DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner

Frequently used DBMS

Management Systems (DBMSS) Database Management Systems are software applications designed for databases administration. MS SQL, MYSQL and PostgreSQL are the three most popular DBMSs in the industry. Each of them has its particular features and should be used in a specific field. For many people who have heard of them but lack a comprehensive understanding about those three options, we introduce them one by one as below.

Pros:

databases are managed by dbms so no need to manage in excel .

assign crud previlege to different users and manage user, so no need to worry about some random person come and cruding database.

more secure.

maintaining filegroups make it easy to recover and ssd can be used to those data which are searched frequently.

different operations can be performed by using query which is very hard in databases like excel

cons:

used every where so some knows about vulnerable points, prone to attackers while user don’t think excel is a thing to hack.

hard to work with, user should have very good knowledge to understand and apply the concept to make it work