What is Database Management System in Computer and It’s Types

In this article, you will get full info about what is database management system in Computer.

Do you know what database management system ? Did you know that in today’s world there is so much demand for data and information? Data and information in a short time, you can only find them by searching the Internet. All you have to do is type your own questions into a mobile browser or Google search.

In a few seconds, you will find the answer to your question. Large companies know their employees (name, salary, ID number, address). Information about children studying at universities such as name, registration number, address, city, school, etc. It is available on the Internet today. But where there are people present on the Internet, very few people know this. But soon you will receive the answer.

Now all Aadhaar cards are being made in India, which means around a crore of Adhar cards have been made. All this information is also available on the internet. These banks and online stores (trains, flights, hotels) change a lot of data every day.

Bank transactions are made through computers and mobile devices. The data remains, but transactions also occur for millions of people. Now you have one more question in mind. Where are the details of all these transactions?

Sometimes you have to wonder where is all this data and information? Is there AC space on the Internet? Or is it a person sitting and writing? The answer to all of this is the database. Learn more that the Internet is nothing more than a database, so let’s find out what is database management system.

What is Database

What is Database management system in Computer
What is Database management system in Computer

Database (DB), this information is the data federation, where related information is collected and stored. The information is stored in a database.

Organized means keeping a sentence as if you were putting a book on a table, in the same way, information and databases are stored in a database. To store data, some software is used. The best example is the MS-Excel. Here all the data is stored on a hard disk, like a digital memory device.

Databases provide information that you can access and manage (change).

Let’s understand with an example, “An MS-Excel sheet containing the details of your 100 students” “Details like registration number, name, address, city name, father’s name, date of birth. Here we can call this excel sheet a database.

DB means that you can access data and data in the database whenever you want. Now let’s understand what access means. There is a university where there are many students, they have passed some 5,000 exams.

Now that their results have been uploaded to the database via computer, it could also be the university’s official website. Then it is loaded there. Now it has become a database of student results.

These results are published when the results are published. Then the students start giving their list numbers and see the result. This process is called accessing the database.

There are many databases such as Google, agencies, government databases where they store your information.

What is Database Management System

It is a software system through which a user creates, defines, manages and controls a database. DBMS is a set of programs used to maintain a database (DB).

Now let’s understand the meaning of “Maintenance” where you can do all these things like edit, edit, delete, access and update data in DB.

You know what a DBMS database management system is. Again, DBMS is a software package. With this software, you can create a database. Since you have created a database called Student, you should now add the student details to it.

If you accidentally enter incorrect information, you must edit the student’s description. After a few days, you may find out that someone’s data is wrong, but you should also delete it. If you want to find the name and address of a student from a list number, he says access.

Now you must understand what DBMS does. Take this example, you can put it in any organization, the same thing happens there.

Database example

However, there are many DBMS software, some of which are

1. Dbase

Of all the DBMSs, the database was created first. It was used in microcomputers. This software was the most successful DBMS of its time. All of these components are present in DBASE, such as the database engine, the query system, a forms engine, and a programming language used to run all three. The file extends from the .dbf extension.

Ashton-Tate, a company called Debase published in 1980, used DBMST to run the microcomputer operating system. Later it was Apple- Used || And as it began to happen on IBM PCs, both were powered by the DOS operating system. Dbase was also awarded the best-selling software of the year for many years. When Debase-||| PP was released, it started running on UNIX and VMS too.

2. FoxPro

There is a programming language based on text-based methodology, as well as this database management system. It is an object-oriented programming language. It was first published by Fox Software.

However, Microsoft developed FoxPro to run on MS-DOS, Windows, and Unix versions. It is currently called Visual FoxPro, but production stopped a few years later in 2007.

3. IMS

The classified model is followed to store data in the IMS database. This is quite different from the DB2 and relational models that this DBMS uses to manage data on demand.

4. Oracle

Oracle is also called Oracle RDBMS. It is a management system for relational databases of objects. Today, it is widely used, the name of this software company is Oracle Corporation. Larry Ellison and two of his friends were co-founders of this corporation.

5. MySQL

It is a management system for relational databases of objects. Named after the daughter of its co-founder Michael Widenius, SQL means structured query language. This DBMS software company is called MySQL AB, which was formed in 1995. It is now owned by Oracle Corporation.

6. DB2

This is a database product. This RDBMS stands for Relational Database Management System. DB2 is used to store, analyze, and retrieve data in a database. db2 also follows the object-oriented concept.

Database Operations

All operations occur at the bottom of the database. Understand them in detail one by one.

1. Insert

If you store some data, it is called an insert operation. Since there is a student database, you can enter the data name, name, roll, brand, city.

2. Delete

If you delete data or a record from the database, this operation is called a delete operation. It can be used to remove some programming languages.

3. Updates

If the data is already available and you continue to make changes, this is called update. I will still take the same example if the family of a student moves to another place, you need to change the address of the database, this is called update.

4. Search/access

Searching for the same information or searching for a group of information is called a search or access operation. For example, to see the results, to check the balance, to see if there is a train ticket available, everything is a search operation.

Database Model Type

The data model tells you how to store, organize, and manage data in a database and what the logical structure of the database should look like.

I understand that with an example, you were asked to write information about your family’s details. In this way you can write, you can also write by creating a table. You can also write the third aunt’s father’s name and the children’s names below it without making a second table.

These three methods were a data model. Similarly, these three models are used in the design of databases.

  1. Hierarchical Model
  2. Network Model
  3. Relational Model

1. Hierarchical Model

The structure of this model resembles the structure of a tree. In this model, the tree structure is followed to add records to each other. The tree consists of nodes and branches.

This means that since the trees are dry they also contain it. This tree itself represents the logical structure of the database. The structure of this model is shown below.

2. Network Model

 

The network model is quite powerful but admirable. Because all the nodes/tables are connected. This model can be represented in the graphic structure. Below you can see the departments, students, courses, and professors or variables connected to each other.

3. Relational Model

 

This model is very powerful and simple. Much more flexible and natural. The structure table of this data model would be similar. The table is called the relationship in the language of the database. That is why its name is also related to the related model. It is like a table, so it has rows and columns.

In the relational model, the rows are called records, and the columns are called fields. This model was e while IBM. Proposed with F code, which is called a single field in this model, and the tables are connected to each other using these keys. A student’s table contains a list number, the primary key.

Database Components

It consists of three main components.

1. Database user

This is the user who accesses and searches for DB from anywhere. Just like you are a user like this, you do some search in Google. It has no information about what is inside and how it is stored.

2. DBA

The complete form of DBA is a database administrator, it is called the administrator which runs the entire system. It understands the needs of the user and manages and updates accordingly.

3. Application program

This is a DBMS software program. It is used to manage the entire database. If you look at the above, you will find information about what is DBMS. There was information on the ingredients.

Also Read: What is Android Version, History, Future & Latest Version

My final opinion on what is database management system

I hope you liked this article about what is database management system in Computer. I have always tried to provide readers with complete information on the database so that they do not have to search for any other site or the Internet regarding your article.

This will save them time and they will also get all the information in one place. If you have a question about this article or want it to get a little better, you can write comments about the database.

If you like this post or learn something about what is database management system, share this post with your friends on social media like Facebook, Twitter, and other social media sites. Thank you!

Also Read: What Is Kali Linux And How To Download

LEAVE A REPLY

Please enter your comment!
Please enter your name here