Friday, July 28, 2023

Introduction to Database Management System

 A Database Management System (DBMS) is a collection of programs that enables user to create and maintain a database. The DBMS is a general-purpose software system that facilitates the processes of defining, constructing, manipulating and sharing the database among various user and applications.

More About DATA, Information and Knowledge:

Knowledge refers to the useful use of information. As you know that information can be transported, stored, and shared without any problems and difficulties, but the same cannot be said about knowledge. Knowledge necessarily involves personal experience and practice.

Database systems are meant to handle an extensive collection of information. Management of data involves both defining structures for storage of information and providing mechanisms that can do the manipulation of those stored information. Moreover, the database system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access.

Why to use DBMS?

To develop software applications in less time.

Data independence and efficient use of data.

For uniform data administration.

For data integrity and security.

For concurrent access to data, and data recovery from crashes.

To use user-friendly declarative query language.

Where being DBMS Used?

Airlines: reservations, schedules, etc

Telecom: calls made, customer details, network usage, etc

Universities: registration, results, grades, etc

Sales: products, purchases, customers, etc

Banking: all transactions etc

Advantages of DBMS:

A DBMS manages data and has many benefits. These are:

Data independence: Application programs should be as free or independent as possible from details of data representation and storage. DBMS can supply an abstract view of the data for insulating application code from such facts.

Efficient data access: DBMS utilizes a mixture of sophisticated concepts and techniques for storing and retrieving data competently. This feature becomes important in cases where the data is stored on external storage devices.

Data integrity and security: If data is accessed through the DBMS, the DBMS can enforce integrity constraints on the data.

Data administration: When several users share the data, integrating the administration of data can offer significant improvements. Experienced professionals understand the nature of the data being managed and can be responsible for organizing the data representation to reduce redundancy and make the data to retrieve efficiently.

Components of DBMS:

Users: Users may be of any kind such as DB administrator, System developer, or database users.

Database application: Database application may be Departmental, Personal, organization's and / or Internal.

DBMS: Software that allows users to create and manipulate database access,

Database: Collection of logical data as a single unit.



Introduction to Database Management System

 A Database Management System (DBMS) is a collection of programs that enables user to create and maintain a database. The DBMS is a general-...