Home » DBMS

Database Management System: Introduction, Needs, Advantages

In this tutorial, we will learn about the database, database management system, the needs of database approach, and DBMS advantages. By Prerana Jain Last updated : May 26, 2023

Database

A database is a collection of related data. In database any user can efficiently access the data which users want to retrieve. It can be anything from a simple collection of roll numbers, names, addresses and phone numbers of students to a complex collection of sound, images, and even video or film clippings. Though they are generally computerized, instances of non-computerized database from everyday life can be cited in abundance. A dictionary, a phone book, a collection of recipes and a TV guides are the examples of non computerized database. The examples of computerized database include customer files, employee rosters, books catalogue, equipment inventories and sales transactions.

Database Management System (DBMS)

It is a collection of interrelated data usually called database and a set of programs to access, update and manage those data which form part of management system. In word, it is a software package to facilitate creation and maintenance of computerized database.

It is general purpose software that facilitates creation the following...

1. Defining: It specifies the data types and structures and some constraints for data to be stored.
2. Constructing: It Helps us to construct a new database and storing data in a storage medium.
3. Manipulating: Its helps us to manipulate existing data involving new queries, updating and generating reports.
4. Sharing: Its allowing the multiple users and programs to access data simultaneously. It allows multiple users to work on the same time.

Examples: Ms Access, Dbase, FileMaker, ORACLE etc.

Needs of Database Approach

• Before database approach, information on a computer is stored in OS files. To allow users to manipulate the information, the system has a number of applications programs that manipulate files. This is known as File processing system.
• File based system uses all early attempt to computerize the manual filling Systems However, rather than a centralized approach , to steer data decentralized approach where each department store and control its data.

Advantages of Database Management System

1. Reduction of redundancies: In this there is a centralized control of data and DBA (database administrator) which avoids unnecessary duplication of data. It also eliminates the extra processing necessary.
2. Elimination of inconsistencies: The main advantage of avoiding duplication is the elimination of inconsistencies that tend to present in redundant data files. Redundancies of data in the DBMs are controlled and multiple copies of data are consistent.
3. Shared data: A database allow the sharing of data under its control by any number of application programs or users.
   Example: the application for the public relations and payroll departments can share the same data.
4. Integrity: Data Integrity means that the data contained in the database in both accurate and consistent. DBMS provides the function of security and some types of checks which main the data integrity.
5. Security: Data is of vital importance to an organization and may be confidential. Such confidential data must not be accessed by unauthorized persons. The DBA who has the ultimate responsibility or the data in the DBMS can ensure that proper access procedure is allowed.
6. Conflict resolution: Since the database is under control of the DBA, he/she should resolve the conflicting requirements of various users and applications.

Reference: Database

---