DBMS Full Form- 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, the database management system does all the work. 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.
This database management system stores data in such a way that it becomes easy to retrieve, manipulate, and produce information from it.
DBMS Full Form
The full form of DBMS is Data Base Management System.
DBMS Full Form 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
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.
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.
Through DBMS, the same type of data can be prevented from being stored repeatedly in the database.
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.
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.
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)
Cost Of Implementation
The cost of implementing a database system can be high and can be very costly.
Effort Of Transfer Data
Transferring the database in the current system can be very difficult and it can also take a lot of time.
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
In this type of database, the data is represented as a record and the link between the data is shown.
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.
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?
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.
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.
The data contained in the 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.
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.
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.
When you print the database records on paper, it is called report.
What is the Function of Database Management System
Data is created through DBMS, that is, it is stored in the table.
In this, the data is managed so that it can be easily accessed.
In this data can be updated as per the need.
The data which is not needed in this is deleted
In this, data is backed up so that it can be recovered in case of system failure.
In this, data is recovered when there is a system failure.
Conclusion (DBMS Full Form)
Through this article, we have tried to give you all types of information related to DBMS, what is DBMS, DBMS Full Form. I hope you liked the information given by us and got to know something new from this article.
If you like the information, then definitely share it and if you have any kind of question related to the post of DBMS Full Form, then you can ask us by commenting.