Database Management System – Introduction

Database: Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schemas, reports etc. For Example, university database organizes the data about students, faculty, and admin staff etc. which helps in efficient retrieval, insertion and deletion of data from it.

what is data?

In a database, even a smallest piece of information becomes data. For example, Student is a data, course is a data, and Color is a data, height, weight, food everything is data. In short, all the living and non-living objects in this world is a data.

Database Management System: The software which is used to manage database is called Database Management System (DBMS). For Example, MySQL, Oracle etc. are popular commercial DBMS used in different applications.

DBMS allows users the following tasks:

Data Definition: It helps in creation, modification and removal of definitions that define the organization of data in database.

Data Updation: It helps in insertion, modification and deletion of the actual data in the database.

Data Retrieval: It helps in retrieval of data from the database which can be used by applications for various purposes.

User Administration: It helps in registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity, dealing with concurrency control and recovering information corrupted by unexpected failure.

Dbms is actualy a tool used to perform any kind of operation on data in database. Dbms also provides protection and security to database. It maintains data consistency in case of multiple users

Components of Database System

The database system can be divided into four components.

#reference

• Users : Users may be of various type such as DB administrator, System developer and End users.
• Database application : Database application may be Personal, Departmental, Enterprise and Internal
• DBMS : Software that allow users to define, create and manages database access, Ex: MySql, Oracle etc.
• Database : Collection of logical data.

Functions of DBMS

• Provides data Independence
• Concurrency Control
• Provides Recovery services
• Provides Utility services
• Provides a clear and logical view of the process that manipulates data.

Advantages of DBMS

• Segregation of applicaion program.
• Minimal data duplicacy.
• Easy retrieval of data.
• Reduced development time and maintainance need.

Disadvantages of DBMS

• Complexity
• Costly
• Large in size

#reference