Database Management System: DBMS- InShort

What is a DBMS (Database Management System)?

Database Management System (DBMS) is a software for storing and retrieving users’ data while considering appropriate security measures.In large systems, a DBMS helps users and other third-party software to store and retrieve data. DBMS allows users to create their own databases as per their requirement.The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs.

DBMS Softwares

  • MySQL
  • PostgreSQL
  • Microsoft Access
  • SQL Server
  • FileMaker
  • Oracle
  • RDBMS
  • dBASE
  • Clipper
  • FoxPro.

Types of Database Models

  1. Hierarchical Database Model

Hierarchical database model resembles a tree structure, similar to a folder architecture in your computer system. The relationships between records are pre-defined in a one to one manner, between ‘parent and child’ nodes. They require the user to pass a hierarchy in order to access needed data. Due to limitations, such databases may be confined to specific uses.

2. Network Database Model

Network database models also have a hierarchical structure. However, instead of using a single-parent tree hierarchy, this model supports many to many relationships, as child tables can have more than one parent. 

3. Relational Database Model

A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970. A software system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems have an option of using the SQL (Structured Query Language) for querying and maintaining the database.

4. Object Oriented Database Model

Object-oriented databases, the information is represented as objects, with different types of relationships possible between two or more objects. Such databases use an object-oriented programming language for development.

Functions of DBMS

The DBMS performs several important functions that guarantee the integrity and consistency of data in the database. The current generation DBMS supports many functions, such as the following:

  • Stores the definitions of data and their relationships (metadata) in a data dictionary, any changes made are automatically recorded in the data dictionary.
  • Creates the complex structures required for data storage.
  • Transforms entered data to confirm to the data structures.
  • Creates a security system and enforces security within that system.
  • Allow multiple user access to the data within the computer network environment.
  • Performs backup and data recovery procedures to ensure data safety.
  • Promotes and enforces integrity rules to maintain data consistency.
  • Provides access to the data via utility programs and from programming languages interfaces.

Applications of DBMS

  • Railway Reservation System
  • Library Management System
  • Banking
  • Universities and colleges
  • Credit card transactions
  • Social Media Sites
  • Telecommunications
  • Finance

Conclusion

Database implementation plan is essential for any organization that once to boost is sales or increase their customers experience, a good database implementation plan I supposed to have, all the factors and the significance value towards the organization, not forgetting the requirements that are needed. In my opinion, I could have recommended using a computerized, database management system. This is because it is faster to implement and also it requires less amount of time and finance to set up, the future of database lies on the power of the organization .and the funds that they can be able to set aside to implement new database management system.