Do you know what is Database and types of database model . You would know that there is so much demand for data and information in today’s world . Data and Information In a short time, you can only find it by searching the Internet. That’s all you have to do, you have to write your questions in Mobile Browser or in Google Search.
Within few seconds you will get the answers to your questions. Major companies know their Employees (Name, Salary, IDno, Address). Information of students studying in college and schools like Name, Roll no, Address, City, Everything is available in Internet nowadays. But where people are present in the Internet, less people know this thing. But you will get the answer soon.
Now all the Aadhar Cards are being made in India , I mean almost crores of Adharcard have been made. All these information are also in the Internet. Banks and Online Reservation (Train, Flight, Hotel) in these also change a lot of data everyday.
Transaction in the bank is done through computer and mobile. There also remains data, but Transaction also happens to millions of people. Now you have another question in your mind. Where is the details store of all these transactions.
Sometimes you must be wondering where all this data and information lives. Is there an AC space in the Internet? Or does a man sit down and write? The answer to all these is Database. Also know that without the database Internet is nothing. So let’s know what a database is today .
What is Database ?
Database (DB), this information is the federation of information, where the related information is collected and kept. Information is kept in the database by being organized (organized).
Organized means to keep the sentence as you keep the books on the table, similarly the information and data are kept in the database . To store information, some software is used. The best example is MS-Excel. Here all the data is kept in digital memory devices such as hard disk .
Information is put something like this in the Database, which you can access the data from Access can do and may be able to Manipulate (change).
Let’s understand with an example, “An MS-Excel sheet where you have details of 100 students.” Details such as Roll NO, name, address, name of the city, father’s name, date of birth. Here we and you can say 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 of their exams are over.
Now their results are uploaded in the database through computer, it can also be that the official website of the university. So it is also uploaded there. Now it has become the database of Students Result.
This result is published when the result of exit date comes. Then students start putting their Roll no and see the result. This process is called Accessing 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, used to maintain the Database (DB).
Now let’s understand the meaning of Maintain “In this you can do all these things like inserting data into DB, Edit, Delete, Access and Update.
You know what Database Management System DBMS is . Again let’s understand, DBMS is a software package. Through this software, you can create a database. Just like you created a database named Student, now you have to add details of the students to it.
If you inadvertently give incorrect data, then you have to edit Student details. After a few days you came to know that someone’s data is wrong, then you will also have to delete. If you want to search his name and address from a students’ Roll no, then he says Access.
Now you must understand what DBMS does. Take this example, you can also put it in a company, the same thing happens there.
By the way, there are many DBMS Software, some of them are
Of all the DBMSs, Dbase was first created. It was used in microcomputers. This software was the most successful DBMS in its time. All these components remain in DBASE such as Database Engine, Query system, a forms engine and a Programming Language is used to run all three. The File remains Extension .dbf.
The company named Ashton-Tate publishes Dbase in 1980, this DBMS was used to run the microcomputer’s OS. Later it was used by Apple- || And it started happening on IBM PC as well, both used to run on dos os. Dbase was also awarded Best Selling Software of the Year for many years. When Dbase- ||| When released, it started running in UNIX and VMS as well.
There is a text-based procedurally oriented programming language here as well as this Database Management System. It is an Object Oriented Programming Language. It was first published by Fox Software.
But Microsoft further developed FoxPro to run in MS-DOS, Windows and Unix versions. Its name is Visual FoxPro at present but its production was discontinued in 2007 after a few years.
The hierarchical model is followed to store data in the IMS Database . Which is quite different from DB2 and Relational Model. This DBMS is used for information management on demand.
Oracle is also called Oracle RDBMS. It is an object-relational database management system. In today’s time it is used a lot, the name of this software company is Oracle Corporation. Larry Ellison and his two friends were the CO-Founder of this corporation.
It is an object-relational database management system. It was named after the daughter of its CO-founderer Michael Widenius and SQL means Structured Query Language. This DBMS Software Company is named mySQL AB which was formed in 1995. It is now owned by Oracle Corporation.
This is a product of a database. This is RDBMS means Relational Database Management System . DB2 is used to store, analyze, and retrieve data in the database. db2 is also following Concept of Object Oriented.
There are all the operations given below the database. Understand them in Detail one by one.
If you store some data, then it is called Insert Operation. Just like there is a Student Database, you insert data there Name, Roll, Mark, City.
If you delete DATA or a record from the database, this operation is called Delete Operation. Some programming languages can also be used to delete.
If information or data is already available 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 elsewhere, then you have to change the address from the database, this is called update.
Searching for the same information or searching for a group of information is called Search or Access Operation. For example, to see a result, to do a balance inquiry, to see if a train ticket is available or not, it is all a search operation.
Database model type
The Data Model tells you how to store, organize and manipulate the data logically in the database and what the logical structure of the database should be like.
I understand you with an example, you were asked to write information about your Familly Detalis. In this way you can write, you can also write by making a table. You can also write without making a second table, and the third mummy father’s name, the names of his children and the names of his children below him.
These three methods were a data model. Similarly, these three models are used in Database Design.
- Hierarchical Model
- Network Model
- Relational Model
1. Hierarchical Model
The Structure of this model looks like Tree Structure. In this model, Tree Structure is followed to add Records to Apasa. The tree consists of Nodes and Branches.
This means that as trees are dry, they also contain it. This tree represents the logical structure of the database itself. Below is a structure of this model.
2. Network Model
The Network Model is quite powerful but also complimented. Because all the Nodes / Tables are linked in it. This model can be represented in Graph Structure. You can see below how the Department, Student, Course and Professor or the variables are linked together.
3. Relational Model
This model is very powerful and simple. Too much Flexible and Natural. The Structure Table of this Data Model would have been the same. The table is called Relation in the language of the database. That is why its name is also Relational Model. It is like a table, so it has Rows and Column.
In the Relational Model, Rows are called Record and Column is called Field . This model was proposed by E. F Codd while he was in IBM. In this model Unique Field is called Key. And the tables are connected together through these keys. A Student Table has a Roll no, Primary key.
The main three component consists of a
1. Database User
This is the user who accesses and searches the DB from anywhere. Just like you are a user like this, you do some search in Google, read after reading. But you do not have information about what is inside and how it is stored.
The full form of DBA is Database Administrator , it is called Manager. Which runs the entire system. It understands the Needs of the user and manages and updates accordingly.
3. Application Program
This is the DBMS Software Program. It is used to manage the entire DB. If you see above, you will get information about what is DBMS. Here was some information about components.
It is my endeavor that what you find in this article database – What is Database in Hindi , you will get complete information in my same article. Today you have become Sikh, what is database system and Database Model in Hindi. To explain a little better, by taking some examples, there is a case to explain you.
Hope you have liked this article, how did you feel, please comment below. If you want to ask any question now, then please write in the comment box below.
If you want to give any other suggestion, then please give it. If you have not subscribed to our blog yet, then definitely subscribe to it, 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.