Database Management System
Use of Database Management System
I am working as freelancer. I am a experienced full stack web developer. My lovely stack is MERN but I am open for new tech. I love to work with teammates for achieve goals. I love researches to find specific new things.
What is DBMS?
A Database Management System(DBMS) is a software system that is designed to manage and organize data in a structured manner. It gives a suitable platform for users to create, modify and query a database. It also allows to manage the security and access controls for that database.
Use of DBMS
A DBMS is used to perform operations on data.
Organize and manage Data
DBMS allows data to be stored in a structured manner and provides features like indexing and searching.
Security and Privacy of Data
DBMS offers authentication and authorization features and also provides encryption to protect sensitive data.
Integrity and Consistency of Data
DBMS provides mechanisms that ensure the accuracy and consistency of data. These mechanisms include constraints, triggers and stored procedures that enforce data integrity rules.
Multiuser access to Data
A DBMS allows multiple users to access the same data simultaneously without data corruption.
Data Analysis and Reporting
DBMS allows organizations to extract useful insights from their data and provides features like data visualization and reporting.
Scalability and Flexibility
DBMS can be scaled horizontally by adding more servers or vertically by increasing the capacity of existing servers and providing flexibility in terms of data modelling, enabling organizations to adapt their databases to changing business requirements.
Advantages of DBMS over File-based storage system
A DBMS is used to tackle the challenges of file-based storage systems.
Controlling redundancy and inconsistency
The file system cannot control the redundancy of data as each user defines and maintains the needed files for a specific application to run. Whereas DBMS controls redundancy by maintaining a single repository of data that is defined once and is accessed by many users.
Data Sharing
The file system does not allow data sharing easily but DBMS allows data sharing easily due to a centralized system.
Data concurrency
The file system does not provide any procedure to stop anomalies. Whereas DBMS provides a locking system to stop anomalies to occur.
Data Searching
For every search operation performed on the file system, a different application program has to be written. While DBMS provides inbuilt searching operations.
Data integrity
There may be cases when some constraints need to be applied to the data before inserting it into the database. The file system does not provide any procedure to check these constraints automatically. Whereas DBMS maintains data integrity by enforcing user-defined constraints on data by itself.
System crashing
A file system has no recovery options after the system crash but DBMS provides a recovery manager to retrieve data.
Data Security
A file system provides password mechanisms to protect the database but how long can the password be protected? No one can guarantee that. DBMS has specialized features that help provide shielding to its data.
