Home Tech News What is database and its types

What is database and its types

by Sudhir kumar

[ad_1]

do you know What is Database (What is Database in Hindi) And database model types. You must know that in today’s world There is so much demand for data and information. Data and Information in less time, all you need It is found only by swirling in the Internet. All you have to do is this, you have to write your questions in Mobile’s browser or in Google Search.

You will get answers to your questions immediately within a few seconds. Big companies information of their Employees (Name, Salary, IDno, Address). Information of children studying in colleges and schools like Name, Roll no, Address, City, everything is present in the Internet nowadays. But few people know where it is present in the Internet. But you will get the answer soon.

Now all the Aadhar cards are being made in India, I mean almost crores of Adhar cards have been made. The information of all these is also in the Internet, is it not? Banks and Online Reservation (Train, Flight, Hotel) In these also a lot of data keeps changing everyday.

Transaction in bank It is done through computer and mobile. There is also data, but transactions also happen to millions of people. Now you have another question in your mind. Where are the details of all these transactions stored.

Sometimes you must have wondered where all this data and information resides. Is there any such place in the Internet? Or does a man sit down and write? The answer to all these is Database. Also know that the Internet is nothing without the database. so let’s know today what is database.

What is Database – What is Database in Hindi

Database (DB), this information is the repository of information, where the related information is kept in a collection. Information is kept organized in the database.

What is the database in Hindi

Organized means to keep the punishment like you keep the books You keep the information and data in the same way as punishment on the table. Database is kept in. To store information, some software is used, the best example is MS-Excel. Here all the data is kept in Digital Memory Devices like hard disk.

Information is kept in the database in such a way that you can easily access the data. Access and Manipulate.

Let us understand with an example “a MS-Excel Sheet Where you are the details of 100 students. In details like Roll NO, Name, Address, City Name, Father’s Name, Date of Birth. Here we and you can say that this Excel Sheet is a database.

DB means whatever information and data is in the DataBase, you can access it whenever you want. Now let’s understand what Access means. There is a university, where there are many students, about 5000 their exams are over.

Now their results are uploaded to the database through computer, it may also happen that the official university of the university website is. So it is uploaded there as well. Now it has become the database of Students Result.

When the result date comes, then this result is published. Only then the students start looking for the result by entering their roll no. This process is called accessing the database.

There are many such databases such as Google’s, Company’s, Government’s database, where they store their information.

database management system

It is a software system, through which a user creates, defines, maintains and controls the database. DBMS is a collection of programs and is generally used to maintain Database(DB).

Now let us understand the meaning of Maintain “In this you can do all these things like Inserting Data in DB, Edit, Delete, Access and Update.

you know this Database Management System What is DBMS? Let’s understand again, DBMS is a software package. Through this software you can create database. Like you have created a database named Student, now you have to add the details of the students to it.

If knowingly and unknowingly give wrong data, then you will have to edit the student details. After a few days you came to know that someone’s data is wrong, then you will have to delete it too. If you have to search its name and address from the roll no of a student, then it is called Access.

Now you must have understood what DBMS does. Take this example, you can put it in a company also, the same thing happens there too.

examples of database

Well, there is a lot of DBMS software, some of them are

1. Dbase

Out of all the DBMS, Dbase was created first. It was used in Microcomputers. This software was the most successful DBMS in its time. All these components live in DBASE like Database Engine, Query system, a forms engine And a programming language is used to run all three. This The extension of the file remains .dbf.

A company named Ashton-Tate published Dbase in 1980, this DBMS was used to run in the microcomputer’s os. Later it was used by Apple-|| And it started happening in IBM PC too, both used to run on dos os. For many years, Dbase was also awarded Best Selling Software of the Year. When Dbase-||| When released, it started running in UNIX and VMS also.

2. FoxPro

Here along with a text-based procedurally oriented programming language, it is also a Database Management System. this one Object Oriented Programming Language. For the first time it was published by Fox Software.

But Microsoft later developed FoxPro to run in MS-DOS, Windows and Unix versions. Right now its name is Visual FoxPro but after a few years its production was stopped in 2007.

3. IMS

To store data in IMS database hierarchical model is followed. Which is quite different from DB2 and Relational Model. Usually this DBMS is used for Information Management.

4. Oracle

Oracle to Oracle Also called RDBMS. It is object-relational database management system. It is used a lot in today’s time, the name of this software company is Oracle Corporation. Larry Ellison And two of his friends were the co-founders of this corporation.

5. MySql

It is an object-relational database management system. It was named after the daughter of its co-founder Michael Widenius and SQL means Structured. Query Language. The name of this DBMS Software Company is mySQL AB which was formed in 1995. Now it is owned by Oracle Corporation.

6. DB2

This is a product of a database. It means RDBMS Relational Database Management System Is. DB2 is used to store, analyze and retrieve data in the database. db2 is also following the concept of Object Oriented.

Database Operations Information

All the operations given below are done on the database. Let us understand them in detail one by one.

1. Insert

If you store some data, then it is called Insert Operation. Like there is a student database, you insert data there Name, Roll, Mark, City.

2. Delete

If you delete data or a record from the database, then this operation is called Delete Operation. You can also use some programming language to delete.

3. Update

The information or data that already exists and you are making changes in it, then it is called Update. I will still take the same example, if a student’s family has shifted to another place, then you have to change the address from the database, this is called Update.

4. Search/Access

Finding the same information or finding the group of information, this is called Search or Access Operation. Like seeing a result, checking balance, checking whether train ticket is available or not, all this is a search operation.

database model types

The data model tells you how the data is logically stored, organized and manipulated in the database and what should be the logical structure of the database.

I understand you with an example, you were asked to write down the information of your Family Detalis. You can write something like this, you can also write by making a table. You can also write the second without making a table and third the name of mummy papa, the names of the children below it and the names of their children below them.

These three methods, these are a single data model. Similarly, these three models are used in Database Design.

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

1. Hierarchical Model

Hierarchical Database Model in Hindi

The structure of this model looks like Tree Structure. In this model, Tree Structure is followed to add Records to Apsa. Tree consists of Nodes and Branches.

It means just like the trees are there in the same way. This tree itself represents the logical structure of the database. Below is a structure of this model.

2. Network Model

Network Database Model in Hindi

The Network Model is quite powerful but it is also Complicated. Because in this all the Nodes / Table are linked among themselves. This model can be represented in the Graph Structure. You can see below how the Department, Student, Course and Professor or variables are linked among themselves.

3. Relational Model

Relational Database Model in Hindi

This model is very powerful and simple. It is very flexible and natural. The Structure Table of this Data Model would have been the same. Table is called relation in the language of database. That is why its name is also Relational Model. It is like a Table, so it has Rows and Columns.

In Relational Model, Rows are called Records and Columns are called Field says. This model was proposed by E. F Codd when he was in IBM. In this model, the Unique Field is called Key. And through these keys the tables are connected among themselves. A student table has Roll no, Primary key.

Components of Database

There are three main components

1. Database User

This is the user who accesses and searches the DB from anywhere. Just like you are a similar user, do some search in Google, read after reading. But you do not have the information about what is inside and how it is stored.

2. DBA

Full form of DBA is Database Administrator, it is called Manager. Which runs the whole system. It understands the needs of the user and manages and updates accordingly.

3. Application Program

This is DBMS Software Program. It is used to manage the entire DB. Information about what is DBMS will be available if you look above. This was some information about the components.

my final opinion on this article

It is my endeavor that you will find this article What is Database – What is Database in Hindi You can get complete information about it in one of my articles. Today you have learned what is database system and Database Model in Hindi. To explain it a little better, I have tried to explain it to you by taking some example.

Hope you have liked this article, how did you like it, you must tell by commenting below. If you want to ask any question now, then definitely write in the comment box below.

And if you want to give any suggestion, then do give it. If you have not subscribed to our blog yet, then definitely subscribe, you will continue to get new information and will be updated in the field of technology. Let’s make Digital India Jai ​​Hind, Jai Bharat, thank you.

[ad_2]

Related Articles

Leave a Comment

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

Privacy & Cookies Policy