Architecture of Database Management System

Introduction to Database Management System

A database management system (DBMS) is a technology used for creating and managing databases.

Using DBMS software we can organize i.e. create, fetch, delete, or update data in a database.

DBMS software is designed to store and retrieve data in a database in both a convenient and efficient manner.

Some popular DBMS applications are MySQL, MariaDB, etc.

Some basic terms in DBMS

1. Database

Database refers to a shared collection of logically related data and its description. The database provides the flexibility of concurrent access to stored data.

Metadata: Data about data or The description of the data stored in the database is known as the metadata or data dictionary. 

In simple words, a database is a self-describing collection of integrated records.

2. Data

Data refers to the known facts and figures, which have implicit meaning and can be recorded.

3. Information

It is the meaningful form of the data. We get information when we process and organize the raw facts, which is more meaningful and useful.

4. Record

The record refers to a group of related fields such that each field contains one item of information. It is the horizontal row in a table in the database.

Advantages of DBMS

1. Controlled Data Redundancy: When a number of copies of the same data are created then that data is said to be redundant. For example, If a person has to update his address then he has to update it a number of times. Using DBMS we can control the data redundancy.

2. Controlled Data Inconsistency: When a number of copies of the same data are created and all the copies do not match then it leads to data inconsistency. DBMS controls the data redundancy the data inconsistency is controlled automatically by DBMS.

3. No Unauthorized Access: DBMS does not allow unauthorized access to the database.

4. Increased Concurrency: The access to the same data by multiple users at the same time is known as concurrency. Concurrency Control Services are provided by the DBMS which allows concurrent access of data without the loss of integrity.

5. Improved Data Integrity: Data Integrity means the reliability and quality of data stored in the database. The DBMS allows defining and enforcing data integrity constraints like uniqueness of data, datatypes, etc.

Share on: