Before learning about a Database Management system, we have to learn what is Database.
A database is a group of inter-related data. It helps to track, retrieve, insert, and delete information easily and efficiently.
Database Management System (DBMS) is an assortment of programs and applications that are used to manage the database.
DBMS has a various set of the user who extracts and manipulate the data for a range of business and personal requirements.
It might be used by an administrator who basically ensures that the data stored in the system is secured and limits the free access to other users.
Some designers access the database to handle the design aspect of the same and make it more flexible and more data-pro to the users.
The last sect is the end-users who access the DBMS to collect and analyze the existing data for their needs.
Some examples of Database Management System
- Microsoft Access
- SQL Server
- File Maker
We can take a school database for example.
This school database is maintaining information about students, sections, grades, staff, etc. The database will be arranged as follows
- Student file: It stores all the information like name, residential address, phone number of parents of each student
- Section file: It stores the information of sections of each class
- Grade file: It stores the data of scores of each student
- Staff file: It stores the information about all the faculties of the school
Types of Database management system (DBMS)
- Relational database management system: It is one of the easiest database management systems. In this system data stores in rows and columns of the table
- Hierarchical database management system: In this database data is organized in a tree-like structure
- Flat-files database management system: In this system data stores in a plain file
- Object database management system: In this system data stored in the form of an object.
The DBMS architecture classification
The DBMS architecture can be classified as
- 1-tier: The user directly works on the DBMS and is solely responsible for all the actions he carries out on it.
- 2-tier: Here an application acts as a barrier through which the user can access the database. He cannot directly alter the data and hence is comparatively secure.
- 3-tier: Based on how the users are using the existing data in the server this system will divide it into 3 tiers being Presentation tier, Application tier, and Database tier. Depending on the complexity of data that prevails and the way it is used, companies build multi-tier DBMS that restrains the users from making any changes and ensures the existence of proper controls to keep it safe.
Advantages and Disadvantages of DBMS
- Increases the data quality and ensures that the data is maintained by the business structure and its needs.
- Because of its centralized nature, it is easily maintainable.
- Reduces program maintenance and data hacking.
- Allows the authorized users of an organization to share data with multiple users.
- Protects the database. If there are multiple users, it allows to maintain data consistency
- Allows users to insert, modify, and delete the data in the database.
- This system is a little costly because the cost of hardware and software of the database management system is high.
- Many organizations stores data in a single database. If the database is destructed due to a reason like an electric failure the data may be lost or corrupted.
- If many users use the same program at a time, some data can be lost.
Functions of DBMS
- Create structured databases and supporting platforms for enhanced performance.
- Appropriate backup and data recovery operations to be set.
- Adequate security and anti-virus measures.
- Read and modify existing data if required.
Bigger organizations have complex databases. They must be able to support several users at one time, including several supporting applications and involves several databases.
What are the sectors use DBMS?
The sectors that use DBMS are schools, universities, banking sectors, airlines, telecommunications, finance sectors, HR management sectors, manufacturing sectors, and other industries.
Get more definitions about database management system (DBMS) and other ERP related terms here.