Database Management System

A DBMS is a software that allows creation, definition and manipulation of database. Dbms is actualy a tool used to perform any kind of operation on data in database. Dbms also provides protection and security to database(Manage the Data). It maintains data consistency in case of multiple users. Here are some examples of popular dbms  MySql, Oracle, Sybase, Microsoft Access and IBM DB2 etc.

Function Of Database Management System

Database Management System (DBMS) performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are

·         Data Dictionary Management

·         Data Storage Management

·         Data Transformation and Presentation

·         Security Management

·         Multi user Access Control

·         Backup and Recovery Management

·         Data Integrity Management

·         Database Access Languages

·         Application Programming Interfaces

·         Database Communication interfaces

Component Of Database Management System

There are five major components in the database system environment and their interrelationship are.

1)    Hardware : Hardware is the one of the most important component of the database system environment. It refers to all of the system’s physical devices like computers (PCs, workstations, servers, and supercomputers), storage devices, printers, network devices and other devices .

2)     Software: The most readily identified software is the DBMS itself, to make the database system function fully, three types of software are needed: operating system software, DBMS software, and application programs and utilities.

3)    Data: It is the most important component of DBMS environment from the end users point of view. As shown in observes that data acts as a bridge between the machine components and the user components. The database contains the operational data and the meta-data, the 'data about data'.

4)    Users:  There are a number of users who can access or retrieve data on demand using the applications and interfaces provided by the DBMS. Various type of users DB administrator, System developer and End users.

5)    Procedures: Procedures refer to the instructions and rules that govern the design and use of the database. The users of the system and the staff that manage the database require documented procedures on how to use or run the system.

Advantages Of Database Management System(DBMS)

·         Improved data sharing:

·         Improved data security

·         Better data integration

·         Minimized data inconsistency

·         Improved data access

·         Improved decision making

·         Increased end-user productivity

Disadvantages Of Database Management System(DBMS)

·         Complexity

·         Costly

·         Large in size