Today we will tell you about What is DBMS in this blog and try to understand all its points, so read this blog completely.
What is DBMS
DBMS stands for Database Management System. The word database is made up of two different words, i.e. data and base.
The database allows easy and efficient storage, recovery, and modification of data even if the amount of data is being tampered with, basically, a database is a computerized record storage system.
Database refers to a collection of data organized by similar data that is persistent logically, which is stored based on the same context. For example, an employee has ‘similar data’ in the database. There is a similar type of information for all employees and each employee entry.
Organized information (i.e., database) serves as the basis, from which the desired information can be retrieved, and decisions can be made by restoring or processing it.
In short, the database not only stores the notification but also integrates the information so that when the database is suspicious, users can be useful.
Database Management System (DBMS) is a related data set and a set of programs to use the data. There is information relevant to a collection in data collection, which is generally known as a database.
The main purpose of DBMS is to provide a way of storing and recovering a convenient and efficient information database.
A database is a collection of related information stored so that it is available to many users for various purposes.
A management system on the other hand is a collection of programs that allow users to create and maintain databases.
DBMS can be “defined” as an interface between the application program and the operating system to use or manipulate the database.
DBMS is a software system that allows access to the data contained in the database. The objective is to provide a convenient and effective way to define, store and retrieve the information contained in the database.
The DBMS interface with the application program so that the data contained in the database can be used by multiple applications and users.
The main objective of DBMS is to provide a friendly and efficient environment for receiving and storing information. It allows guests to store data, update and recover data in its basic terms.
DBMS makes database maintenance information and recovery easy. A DBMS user also assists in determining the detailed algorithms to find out about accurate physical representations of data and sorting data, updating, and recovering.
Typically, DBMS is a large software package that provides features that allow users to obtain and modify databases including diverse functions. On the one hand, it is an intermediary between the database, the computer, and the physical operating system on the other.
Components Of DBMS
Database managers are programs that provide interfaces between the system and the physical databases and applications sent to the system.
This system includes data, hardware that stores data physically, software that uses a hardware file system to store data and retrieve data that standard methods provide, and users change data.
Some points are mentioned below:-
In DBMS, generally, three parts wide users are considered. This application is a programmer, end-user, and DBA (Database Administrator). Application programmers develop application programs. These programs can manipulate the database in every possible way.
The end-user accesses the database through the application programmer using the query language provided by the database system or through the application programmer. Database administrators are the people responsible for the design, creation, and maintenance of databases.
The database management system includes all these software DBMS, operating system, network software (if required) and application programs, etc.
The hardware of the system can be anything from your PC to your network of computers. It also includes various storage devices ( such as hard disks ) and input and output devices (such as monitors, printers, etc.)
Data stored in a database includes numeric data that include whole numbers and floating-point numbers and non-numeric data such as characters, data, or arguments (true or false). More advice systems cannot cope with complex data agencies such as printers, images, and data types.
Application Of DBMS
Some of the important application fields of DBMS are:-
- Banking:- For maintaining customer information, accounts, loans and banking transactions.
- Universities:- For maintaining student records, course registration and grades.
- Railway Reservation:- For checking the availability of reservation in different trains, tickets, etc.
- Airlines:- For reservation and schedule information.
- Telecommunication:- For keeping records of calls made, generating monthly bills
- Finance:- For storing information about holidays, sales and purchase of financial
- Sales:- For customer, product and purchase information.
Advantages of Database System
Some of the major advantages provided by the DBMS are:-
- Data Redundancy
- Sharing of data
- Improvment in data security
- Maintenance of data
Data refers to the repetition of data redundancy. In a non-database system, each application leads to redundancy in persistent data that I generate, holding a separate customer detail file in the context of a file-based system from the journal issuing department.
Sharing of Data:-
Data sharing allows existing applications to access the data in the database. It also helps to develop new applications, which will use the same store data. Because only shared data, it is possible to meet new application data requirements without additional stored data or minor modifications.
Improvment in data security:-
In traditional systems, applications are developed improperly, usually with different organizational systems receiving different components of operational data. Implementing security in such an environment can be very difficult. Security restrictions are easier to enforce by setting up a database management system because the data is stored centrally.
The DBMS can ensure that the only way to access the database is through the official channel. Therefore, every time attempts are made to access sensitive data, data security can be checked. To ensure security, the DBMS provides security tools such as a username and password.
Maintenance of data:-
data integrity refers to ensuring that the data in the database is accurate. since in DBMS, the data is centralized and is used by a number at a time, it is essential to enforce integrity controls.
Disadvantage of Database system
Some of the major Disadvantages provided by the DBMS are:-
- Problems Associated with Centralization
- Cost of Software
- Cost of Hardware
- The complexity of backup and recovery
Problems Associated with Centralization:-
Centralization increases the security problems and disruption due to the downtimes and failures.
Cost of Software:-
Today’s there are several software which is very costly. Hence from an economic point of view, it is the drawback.
Cost of Hardware:-
It incurred in the application of DBMS is its major disadvantage. The cost of the H/W is also one of the major drawbacks.
The complexity of Backup and Recovery:-
DBMS provides the centralization of the te data, which requires adequate backups of the data so that in case of failure, the data can be recovered. Hence the backup problem is also a drawback.
This blog What is DBMS has been helpful for you, then tell in the comment. And also share it with your friends.