What is Database and its Model Types
Do you know what a Database is and the type 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. You have to do so much work; you have to write your questions in Mobile Browser or in Google Search.
Within a
few seconds, you will get the answers to your questions. Major companies know
their Employees (Name, Salary, IDno, and Address). Information of children
studying in college and schools such as 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?
Organized means to keep the sentence as you put 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 kept in the database in such a way that you can easily access the data and manipulate it.
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
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 the 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 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.
Database examples
By the
way, there are many DBMS Software, some of them are
1. Dbase
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 like Database Engine, Query system, a forms engine and a Programming Language
is used to run all three. The extension of this file remains .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 so. 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.
2. FoxPro
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.
Currently, its name is Visual FoxPro but production was discontinued in 2007
after a few years.
3. IMS
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.
4.
Oracle
Oracle
is also called Oracle RDBMS. It is an object-relational database management
system. Today, it is used a lot in this software company name is Oracle
Corporation. Larry Ellison and his two friends were the CO-Founder of this
corporation.
5. MySql
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.
6. DB2
This is
a product of a database. It 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.
Database Operations
There are all the operations given below the database. Understand them in Detail one by one.
1. Insert
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.
2. Delete
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.
3. Update
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.
4. Search / Access
Searching for the same information or finding 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 should be the logical structure of the database.
I
understand you with an example, you were asked to write information about your
Familly Details. 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's
father's name and the names of his children below him.
These
three methods were a data model. In the same way, 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, the Tree Structure is followed to add the records to Apasa. The tree consists of Nodes and Branches.
This means that as trees are dry, so are they. This tree itself represents the logical structure of the database. Below is a structure of this model.
2. Network Model
Network Database 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
Relational Database
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.
Rows are
called Record in Relational Model 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.
Database Components
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.
2. DBA
The full form of DBA is Database Administrator, it is called Manager. Which runs the entire system? It understands the user's Needs 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 the information about what DBMS is. Here was some information about components.
My final opinion on this article
It is my
endeavor that what you find in this article database - What is Database you will get complete information in my single
article. Today you have become Sikh, what is database system and Database Model.
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.
Comments
Post a Comment