2024年3月23日发(作者：)

数据库管理系统

Database Management System – An easy way to manage your data

Introduction Students who have a course of Database Management should

know the fundamentals of this subject. Then what is database management

system? You can easily access, managed and updated the related data that are

accumulated and organised in a manner so that you can do it easily. A database

can be anything, for example, information about your college. In a simple way, we

can say Database is a place where a similar type of information is cached and a

variety of operations can be executed on it. Every organisation has their large

amounts of data in their database. A database management system (DBMS) is a

software tool that organises those data in a database.

A DBMS consists of three elements which are given below: The physical

database: It is the collection of files that consist of the data. The database engine:

It is a software that makes possible to connect and alter the contents of the

database. The database scheme: It is the requirement of the logical structure of

the data stored in the database. It can be divided into four components which are

mentioned below: Users: Users may vary like DB administrator, System developer

and End users. Database application: It can be Personal, Departmental, Enterprise

and Internal DBMS : Software that grants users to specify, produce and organises

database access, Ex: MySql, Oracle etc. Database: It is a set of logical data. This

DBMS has numerous number of merits as compared to traditional computer file

processing approach.

Some advantages of DBMS are given below: 1. Controlling Data Redundancy:

In traditional computer file processing or non-database systems, every

application program has its own files. It is quite feasible in case of DBMS, all the

data of an organisation is accumulated into a single database and cannot be

duplicated.

2. Data Consistency: If the DBMS has decreased redundancy to a least level,

the database system imposes consistency. It implies that when a data item exists

numerous times in the database and is updated, the DBMS repeatedly updates

every occurrence of a data item in the database. 3. Data Sharing: In this system,

data can be shared by allowed users of the company. It manages the data and

allow the users to access the data. Many users can be allowed to access the same

set of information at the same time. The distant users can also share the same

data. Also, the data of same database can be shared between various application

programs. 4. Data Integration: In this management system, data in database is

stored in tables. A single database consists of multiple tables and relationships

can be built between tables or related data entities. It enables easier data retrieve

and update of the data.

There are other various advantages of DBMS which helps in easier data

management in an organisation. So in learning stage or during study time, a

student can learn this subject properly if he or she wants a career in this field.