What is DBMS | What is data in DBMS?

What is DBMS | What is data in DBMS? 

This course mainly deals with tying on these

few things in order to understand this

course you have to understand clearly

about the meaning of these things.

First one is a data so What is data?

We have various kinds of definitions but

then know by coming to this course what I

mean by data is it could be any fact that

can be recorded and stored right so data is any fact

that can be recorded if he has recorded

that just a data okay according to this

course and if you want to see any

examples about data you may think of

data as some text right your you know

your facts can be written in terms of

some text like names name is a fact

isn't it or some numbers like your

address phone number and all or it can

be even some images right he may just

miss the picture that we take right that

could also be a data or it can be videos

like you know right now you're watching

right videos are there are various terms

like speech so these are all data if

they can be recorded then it is data and

then from this we are going to define

database so a database is collection of

related data which means if you if you

take a collection of text or if you take

a collection of numbers or if you take

collection of images or if it a

collection of videos they are all

columns now you know database so

database in according to this definition

of this Corsi whatever terms these are

they have various definitions you can

find them in Internet

but coming to this course these are

defined this way okay so database means

it is actually a collection of for all

these related data right so it is

collection collection of related data

okay now you can you know traditionally

the databases have been applied only for

the data which are either text or

numbers for example if you want to store

something about a student right then you

are going to store the name which is

text and maybe he says and maybe his

marks and maybe his address right and

all these are going to be you know text

and numbers or maybe if you if you want

to reserve some ticket right online then

how is that you are going to do it again

the text and numbers are going to be

used traditionally it has the numbers

and you know text so there are various

types of databases now one type of

database will contain only text and

numbers and it is also called as

traditional database okay and and

recently we know with the with videos

being uploaded and downloaded but at a

very frequent pace there has been a

database created which is a database so

for those videos or they might even

contain database of speech or they might

contain database of songs or movies

anything like that and that is called as

multimedia database right multimedia

will be present in that and I know

recently you have seen this there has

been lot of you know there have been lot

of these satellites and the satellites

are going to take the images of Earth

and they're going to send you back or

even we have we have sent many rockets

and which are going to take the space

space if it was right so they are all

called answer you know geographic

information systems which will contain

mainly images right so depending on what

we are trying to do there are various

types of and there are even you know

real-time databases so real-time

databases means I know these these are

generally used in the production right

or if you have a store if you have a

supermarket and now you know you are

selling some goods you want to keep

track of how many how many items are

remaining of each type so that you want

to play some order if the attached talk

is over right there are called as

real-time so there are various types of

databases and you know sometimes we have

other debt databases

you know if the database size is going

to be very huge then it is called as

data warehouse so data warehouse is also

a kind of database so

what is the main difference between the

database and data warehouses data

warehouse is also a kind of database in

which the data is going to be very

hughes and historical which means we are

going to have data stored about a

company for the past 100 years and then

we want to see it or we want to store

let us say the share the stock market

the stock stock market rates and all and

we want to predict the future by looking

at the past for the past hundred years

if you are looking at that huge data a

hundred years data right then it is

going to be historical data and it's

going to be very close in that case the

database is also called as data

warehouse right so these are the various

examples of databases so are you

following it data is just a fact which

can be recorded and these are all the

examples of data and database means it

is a collection of data which is related

right for example you know YouTube is

having this multimedia database right

what we may is having multimedia

database and NASA is having GIS right

geographic information system database

so which means they are going to have

the data which is related to various

things but then once you decide upon

some database you have to put only the

things which are related to the database

right so every insertion and deletion

will be only the only concerning the

data which is related to what you had

defined ok and then once you have come

up with database you are going to store

it on the computer mainly see earlier

databases permanent manually then what

is the database a book you can take it

as database then how do we do manipulate

it using a pen right because it is it

was managed manually right and later now

we are going to computerize everything

so every database is currently present

on the computer now whenever you have a

computer and data present on this there

should be some programs which should be

defined isn't it you have defined some

programs right and those programs should

typically be able to do this so like it

has to define which means you have to

define the data

types these structures and data time is

integer characters trick like that okay

you have to define the data which are

which you are going to place in this and

then maybe you have to construct

construct the database using the

software right so constructing mills how

are you going to place the data on the

hard disk or the storage device and then

manipulate so manipulating means you

know that adding and deleting data from

the database so whenever you have this

database now you need this software

which should be able to define the

database constructed and maybe

manipulated right so for this reason we

had to write some programs and no

earlier operating system used to provide

some some some sort of form you know

provision to do all this but what

happened is putting this burden on the

operating system is going to be very

very you know a constraint I'm in the

sense we don't want the operating system

to be very huge right because boot time

is going to be very high so we don't

want to put this burden on the operating

system as well operating system is

already managing many things right and

moreover if you give this responsibility

operating system the problem is whenever

you want to go to your database you are

supposed to call the operating system

and operating system whenever it is

called it will it will switch the switch

from user mode to kernel mode which is

very secured right and in most of the

cases we don't need that much

functionality we want the fastness right

there for users who ever are defining

the database they just want to access

the database very fast

they don't want many services which are

now given the operating system in that

case a user will write his own programs

which will be able to access his own

database and everything will be running

in the user mode right and the set of

programs which will be doing all these

things on the database which is defined

is called as database management system

so DBMS is set of programs right it is

actually a set of programs which are

used to define construct

and manipulate the database that is what

you can understand by DBMS the term DBMS

so DBMS is just software databases the

data collection of data and data is any

fact okay and what are the various types

of DBMS you have so you there are

various companies which are providing

different types of databases we shall

see all of them okay one by one when we

go into the topic right and then once

you take this database define and the

collection of programs which are going

to act on that data will see why it is

not that you have one particular

database system which can access any

data depending on the type of data the

database system the derivative

management system also has to vary right

there for the collection of database and

the database management system these two

are generally combined it called as

database systems DBS right so data bills

is the collection of data and it is set

of programs so the data plus the

programs which are used to manipulate

this data is collectively called as

database systems so if you want to

understand it you can take a think of it

this way database you can think of it as

a book one book and database management

system you can think of it as a pen

right in the real you know without

computers right so coming to computers

these are nothing but the data which is

stored on the computers and these are

the set of programs which are used to

manipulate it and company they are

called as database systems right okay.