Hey guys, it's Navjyotsinh Jadeja and
welcome to today's lecture yes you can
see we have come up with a new
presentation style and today we're gonna
talk on data mart. Data mart is a very
important concept as far as data mining
subject is concerned. In earlier video we
have compared data warehouse and Data
Mart in a video and also in one of the
video we have mentioned about data
warehouse. So there are a lot of people
asking me about a separate video on Data
Mart so today we have got it. So what are
we going to cover in here today,
What exactly is data mart? Why do we need
a data mart? Different types of data mart.
Implementing a data mart and what
are the advantages and benefits of Data
Mart and if you can see this properly
guys this is specifically designed for
preparing the exam or revising the
topics. So please keep this in mind and
refer the video completely till the end.
So let us understand what is data mart?
So basically a data mart is something
which is a subset of the data warehouse
within an organization and it is
specific to the department or a unit
which we are focusing on all right and
it is subject oriented database or in
some cases it is also known as HPQS
which is High Performance Query
Structures and that is one of the
benefits which we'll be discussing in
the later part of the video. Now the
question arises why do we need data mart
when we already have a database we
already have a data warehouse? So the
question is databases have become huge
it stores a lot of data. Every day data
keeps on piling so the databases are
growing and also the warehouses are
coming up with more and more data. So
what do we do how do we retrieve
information in a way where it is subject
specific or a department specific and
that to with a quick response time so we
have data mart to come up with a
solution to this kind of problems all
right and now let's understand what
are different types of data mart? This is
important because this will help you
understand how to choose which type of a
data mart are so the first thing is we have
the dependent and independent data mart
so let us see each of them one step at a
time. So the dependent data mart is
something which comes from the data
enterprise data I mean when we have the
data within the organization and that's
what we are taking as an account to form
a data mart then it is known as
dependent data mart and it works in a
top-down manner whereas independent Data
Mart does not depend on our data itself
so the Data can be coming from the
outside sources also and that is why it
works in a bottom-up manner where
cumulatively those data mart's form into
a collective data warehouse right. So how
do we actually implement a data mart? So
that's the question lot of people are
asking and if you are a you know data
mining scientist or data scientist you
are trying to think so the following
things we need to include while
implementing a data mart. First of all we
have to design so in this step we
understand the requirement just like any
other software in the data mining also
we need to understand what are the
requirements? Why are we trying to form a
data which is you know our form of a
mart and we can apply data mining plus we
also have to understand what could be
the different data sources which will be
taken into account and finally how the
logical and physical layout would look
like so once you do that you move on to
the second step of building this ideas.
Once we try to build this we have
different sources like Oracle provides
you know Oracle data warehouse support
and a lot of other software's also so
you can use them and then you can use
those tools to make your own or build
your own data mart. Once that is done the
third step is to transfer so in here you
actually decide how to populate the mart.
So what should be the frequency of data
transfer? How often will you update
and all this and once that is done the
last in the most important step comes to
access so here all comes together and
this is what we have as in the structure
and this is what our data mart would
look like. So if you understand there are
four steps from the starting just like a
software we design then we build then we
transfer and finally we could access the
data so this is how we implement the
data mart. Now the important question what
are the advantage or benefits of the data
mart so first of all it has information
which is specifically detailed only so
it does not have a whole lot of
information just like the warehouse it
is specific detail information it
increases the response time as I said
earlier also guys because this is
specific to a department very short
amount of data or a very comparatively
less data it increases the end-user
response time it is condensed form of
data warehouse so the properties remain
the same but the size gets reduced. It
reduces the cost because as you
understand data mining takes up lot of
resources in terms of you know cost
because we have lot of resources
required to perform data mining
operations and if you are doing it using
data mart it reduces the costs and
energy less the sources are same as I
said earlier so it ultimately reduces
the overall cost and resources also. So
this is the list of advantages and
benefits which we have in here for the
data mart so this is the concept wherein
we are trying to make sure that you
understand the data mart in a complete
way I hope you like our effort please
like share and subscribe the channel and
if you have any queries please feel free
to comment in the comment section.
Thank you so much
