What is DBMS and what is its function?

6
DBMS

You must have heard about DBMS, its full name is Database Management System. As the name suggests, it manages the entire database. From creating, handling and deleting data, all the work is done by the database management system. A software that can Create, Manage, Control, Delete and Update data.

Through DBMS, both the user and the programmer can handle their data, that is, both can create, manage and update the data. It has many benefits of its own, about which it is very important for you to know. Let us know what is DBMS and what happens in it in full detail.

What is DBMS?


Database is a collection of related data. At the same time there is data collection of facts and figures which are processed to generate information.

Most data represent recordable facts. Data helps to produce information which is based on facts. for example. If we have marks of a class then we can conclude that among them who are toppers and who are with average marks.

What is data and its types


This database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information from it.

Full Form of DBMS?


The full form of DBMS is Data Base Management System.

DBMS Full Form in hindi ?


DBMS Full Form in hindi is Database Management System. If the definition of database is understood, then it is a collection of related data which is organized in such a way that it can be easily accessed, managed and updated.

What are the Characteristics of Database System?


1. Being of Self describing nature: A database system not only contains the data but also stores the description of the database structure and constraints along with it. In this the definition is stored in the DBMS catalog, which contains information such as structure of each file, type and storage format of each data and constraint. The information that is stored in the catalog is called meta data.

2. Having Program Data Independence: If I talk about traditional file processing, then the structure of each file is embedded in the application program. Therefore, due to any change in the file, it becomes necessary to make necessary changes in the programs also to access that file. Whereas in DBMS, we have program data independence because in this the structure of data files is stored separately in system catalog, if we compare it with access programs then.

3. It Supports Multiple Views of Data: A database has many users in which each requires a different view or perspective for the database.

4. Sharing of Database can be between Multiple Users: DBMS allows multiple users to access the database at the same time.

What is the function of DBMS


1. Data Redundancy
Each application has its own individual files in the file system and in such a situation, duplicate files of the same data are created at many places. In DBMS, the same type of files are kept at one place, that is, it is not repeated, which reduces the redundancy of the data.

2. Sharing Of Data
In DBMS, data is shared by the authorized user of the organization. In this, the data administrator controls the data and gives rights to the user to access the data.

3. Data Consistency
Through DBMS, the same type of data can be prevented from being stored repeatedly in the database.

4. Integration Of Data
In DBMS all the data is in tables and in a database there are more than one table. Relationships can be created between all these tables, which makes it easy to retrieve and update data.

5. Data Security
The data in DBMS is completely controlled by the data administrator. In this, the administrator makes sure that which user has to give data and how much data is to be given. On which part of the database the user has to give access and which part is not, it is all controlled by the database administrator. This increases the security of the database and the data does not fall into the wrong hands.

6. Remove Procedures
You all know that a computer is a kind of machine and it can malfunction at any time and hardware or software failure can happen at any time, in such a situation the data can be destroyed. Through DBMS, you can easily recover the data in such condition.

Some Potential Disadvantages of Database Management System (DBMS)


1. Cost Of Implementation
The cost of implementing a database system can be high and can be very costly.

2. Effort Of Transfer Data
Transferring the database in the current system can be very difficult and it can also take a lot of time.

3. Risk of having Database Fails
If the data spreads even for a short time, then it will affect the company and the company may have to suffer many losses.

Types of Database Management System


1. Network Database
In this type of database, the data is represented as a record and the link between the data is shown.

2. Relational Database
In this data is stored in the form of tables. Where data is stored in Column and Rows. It is also known as structural database.

3. Hierarchical Database
In this, the data is represented in the form of Parent and Child which are in the tree structure.

What are the components of Database Management System?


1. Tables
In DBMS all the data is kept in tables. Data collection, filtering, editing, retrieval, etc., are all done on tables. Tables are made up of Rows and Columns inside which all the data is stored.

2. Field
Each column inside the table is called a field. In this, specific part of each data is stored like customer number, customer name, street address, state etc.

3. Record
The data contained in rows inside a table is called a record. A record is a type of entry that can contain a person’s name, phone number, etc.

4. Queries
Query is called to extract data from a table or database according to the need. For example, if you want to extract the list of friends living in the same city, then it will be called a query.

5. Forms
You can enter data in the table but it is not easy to modify and store it. Therefore forms are used to overcome this time. Just like tables, data is entered in forms.

6. Reports
When you print the database records on paper, it is called report.

What is the Function of Database Management System?


1. Create Data: Data is created through DBMS, that is, it is stored in the table.

2. Manage Data: In this, the data is managed so that it can be accessed easily.

3. Update Data: In this data can be updated as per the need.

4. Delete Data: The data which is not needed in this is deleted.

5. Data Backup: In this, data is backed up so that it can be recovered in case of system failure.

6. Data Recovery: In this, data is recovered when there is a system failure.

what did you learn today


I hope that you must have liked my article What is DBMS (What is DBMS in Hindi). It has always been my endeavor to provide complete information to the readers about what is the function of DBMS so that they do not have to search any other sites or internet in the context of that article.

This will also save their time and they will also get all the information in one place. If you have any doubts about this article or you want that there should be some improvement in it, then you can write low comments for this.

If you liked this post What is DBMS in Hindi or got to learn something then please share this post on social networks like Facebook, Twitter and other social media sites.