Before understanding What is DBMS?, we should know what a database is because DBMS performed on the database so first, we have to understand the database.
A database is actually a place where related piece of information is stored and various operations can be performed on it.
The basic definition of the database is,
Database is a shared collection of logically related data.
So in the database, we store data and that data should be logically related to each other.
Why we need a database?
It’s simple, we need database because in every field we need data means if we run a company we need data or if we run a college we need data, so we need data in every field that’s why we need database so that we can easily store our data in someplace where we can easily access that data.
Also Read: Advantages and Disadvantages of Database
What is DBMS?
DBMS is a database management system.
It is a system that manages database means DBMS helps users to access the database easily where users can easily store, modify and extract information from a database as per the requirements.
Why we use DBMS?
That’s a good question why we use DBMS, can’t we use the database directly. So the answer is yes, we can use database directly, but it’s not easy for a normal user to access the database easily. So we use a DBMS system in which users can easily access, manage and update the database.
Actually, in the database, data is stored in files physically and DBMS software provides us a logical view of data in table form where we can easily perform various operations on data in the database.
DBMS is actually a tool that is used to perform any kind of operation on data in the database.
Is DBMS software or not?
Actually many people are confused, DBMS is software or not. So the answer is, DBMS is not software it’s a system that is used as a domain in the software industry.
There are many software that provides a DBMS system, that why we use the term DBMS software.
Some DBMS Software examples: –
- Oracle RDBMS
- IBM DB2
- Microsoft SQL Server
- SAP Sybase ASE
- Microsoft Access