DataBase Management System (DBMS)
A DBMS is a software that allows us to create, define and manipulate database, allowing users to store, process and analyze data easily. DBMS provides us with an interface or a tool, to perform various operations to create a database, storing of data and for updating data, etc. DBMS also provides protection and security to the databases. It also maintains data consistency in case of multiple users.
Examples of DBMS softwares are : Foxpro, dbase.
1. Data stored into Tables
Data is never directly stored into the database. Data is stored into tables, created inside the database. DBMS also allows to have relationship between tables which makes the data more meaningful and connected.
2. Reduced Redundancy
In the modern world hard drives are very cheap, but earlier when hard drives were too expensive, unnecessary repetition of data in database was a big problem But DBMS follows Normalisation which divides the data in such a way that repetition is minimum.
On live data, it is being continuously updated and added, maintaining the consistency of data can become a challenge. But DBMS handles it by itself.
4. Support Multiple user and Concurrent Access
DBMS allows multiple users to work on it(update, insert, delete data) at the same time and still manages to maintain the data consistency.
DBMS provides users with a simple query language, using which data can be easily fetched, inserted, deleted and updated in a database.
The DBMS also takes care of the security of data, protecting the data from unauthorized access. In a typical DBMS, we can create user accounts with different access permissions, using which we can easily secure our data by restricting user access.
7. DBMS Supports Transactions
It allows us to better handle and manage data integrity in real world applications where multi-threading is extensively used.
· Segregation of application program
· Minimal data duplication or Data Redundancy
· Easy retrieval of data using the Query Language
· Reduced development time and maintenance
The Database Management System can be divided into five major components as follows:
4 . Procedures / Methods
5.Database Access Languages
Hardware: The computer, hard disk, I/O channels for data, and any other physical component involved in storage of data
Software: This main component is a program that controls everything. The DBMS software is capable of understanding the Database Access Languages and interprets into database commands for execution.
Data: It is that resource for which DBMS is designed. DBMS creation is to store and utilize data.
Procedures/Methods: They are general instructions to use a database management system such as installation of DBMS, manage databases to take backups, report generation, etc.
DataBase Access Languages: They are the languages used to write commands to access, insert, update and delete data stored in any database.
Examples of popular DBMS: Dbase, FoxPro