Actually, it is a type of software with which to create a database,and in that database, tasks like data insert, update and delete are performed only with the help of this.It provides an interface through which data can be inserted and modified in the database. Apart from this, the database is accessed when needed by an application.
For example, when you create your account on Facebook, all the information you enter is stored in Facebook. To see these information, you can use Facebook's application or website, which are linked to that database.
Components of Database Management System
- Hardware
- Software
- Database
- User
- Procedure
Hardware - Our computer system comes in the hardware that is used to store and access our database.. Hard disks are mostly used to store data in computer systems.
Software - This includes our actual DBMS software. The data contained in the computer system keeps the data between the database and the user constant.
Database - A database is a set of information that is organized in such a way that information can be easily accessed, managed and updated.In the database, we can select Desire data quickly and easily.
User - In this there are many users who access the data according to their needs. Capability and requirement of each user is different.
Procedure - This means that there are procedures, rules and instructions for running the pressures and which type of database to use in the system.Such as database login, logout, backup of the case, and handling the case.
Advantages of Database Management System
Controlling data redundancy - Minimize Data Reduction - Each program in a file based system has its own private file. In this case, duplicate files of the same data are created in many places. In DBMS, all the data in one location is integrated into one database file, Meaning that data is recorded at only one place and is not repeated.Data sharing - In DBMS, data can be shared by the authorization of the organization.DBMS administrator controls the data and empowers users to access the data. Many users can be given the right to access the same piece of information simultaneously. The remote user also shares the same data.
Data Redundancy- Redundancy is achieved by controlling data readiness, meaning that a single type of data is prevented from being stored repeatedly in the database. is achieved by controlling data readiness, meaning that a single type of data is prevented from being stored repeatedly in the database. - Redundancy is achieved by controlling data readiness, meaning that a single type of data is prevented from being stored repeatedly in the database.
Data integration - In DBMS, data is stored in tables in the database. A database can have more than one table and relationships can be created between tables. This makes it easy to retrieve and update the database.
Data security - In DBMS, data is stored in tables in the database. A database can have more than one table and relationships can be created between tables. This makes it easy to retrieve and update the database.
Recovery procedure - In DBMS, the data is completely handled by the database administrator And only the database administrator makes sure that how much or how much of the database is to be given access to which user or not.
Disadvantages of database management system
Cost of Implementing - Implementing database system can cost more. Which can cost a lot of money.Effort to Transfer Data - Difficult to face data transfer from existing system to database And it can also take a lot of time.
Risk of database file - if the database fails, even if for a relatively short period, then the entire company will also be affected and the company will have to suffer many kinds of losses.
