Hey guys, it's Navjyotsinh Jadeja and
in today's lecture as you can see we are
gonna talk on OLTP versus OLAP and
it's a very important topic as a part of
data mining data science tutorial series.
So let us understand what is OLTP and
what is OLAP? OLTP is your regular
databases your oracle sequel servers
etc whereas OLAP is your data warehouse
so it's OLTP stands for online
transaction processing
so it's your day-to-day you know data
whereas OLAP is your analytics which
comes from combining multiple sources of
data in order to understand what is the
OLAP you refer to a data warehouse
lecture in the channel it will be quite
helpful okay now let us differentiate
OLTP versus OLAP in terms of
different parameters so in terms of data
or whatever thing de we are storing in
OLTP is day to day data your
day-to-day transactions your relational
files etc and you know whereas when we
talk about OLAP it's a it's a very long
period of time its historical data is
consolidated data right and as I said
you know in terms of characteristics
that actually helps you understand very
quickly from the data definition
it's a day by day or day to day data so
their function is that itself whereas
when we talk about OLAP the overall
function or the characteristics is to
support the decisions so when we have
over a period of time lot of data and you
know the servers when we analyze it
based on that we can take decision so
OLAP does that. In terms of users who use
the OLTP system day-to-day clerical
staffs, your managers, your IT etc but
when I talk about OLAP it is very
specific the knowledge mining team or
they you know hire authorities or the
management they are the one who get to
access it. When we talk about number of
users they are very high in OLTP because
it's available to
most of the people everybody is putting in
you know day to day transactions
queries are getting fired and lot of the
things where OLAP is very limited
it's very low number and it's
comparatively in the hundreds when we
talk about the usage in OLTP, OLTP is
access repetitively and lot of
data is fed in and out through the you
know your databases where as we talked
about OLAP it's very ad hoc basis very
partial basis only when you want to
actually perform or get a new set of
data from the warehouse that is when you
perform OLAP operations when you talk
about units of work it is very short
very simple as I said your queries your
interactions with the databases are the
units whereas when we talk about the
OLAP it is very complex query it
requires lot of you know complexity in
order to get the different decisions.
Now in terms of access when we talk what is
the access which you get in the OLTP
basically in the transaction processing
you can read, write, index
do whatever you want in terms of the
data whereas in OLAP you can only
read most of the time you perform the
scans think of the data which we want
from the warehouse in terms of a copy
from it and we only get to read from
that when we talk about the data sizes
is very small from about 100 MB 200 GB
when we talk about OLTP but as I
mentioned OLAP is a huge historical
consolidated form of the data so when we
talk about that it is very huge in size
in terms of large hundred TB's right.
This is a quick understanding of what we do
in terms of OLTP again a quick revision
so OLTP the major task is it's a
relational database
it's a day-to-day operation of
purchasing the basic inventory the
banking, the payroll
etc when we talk about OLAP the major
task is the warehouse the storage the
you know consolidation and it is used
for analysis and decision support
and where the differences are in terms
of users and system orientation so in
terms of the customer versus the market
then we have the data contents so we
have the you know current and detailed
whereas in the OLAP we have the
historical and consolidated and in terms
of the you know the design it's ER based
in the OLTP whereas we have the schemas
in terms of OLAP in the further lectures
we'll talk about different schemas in
the OLAP also plus when we talk about
the view in OLTP as we mentioned earlier
it's a local view current view whereas
in the terms of OLAP it is integrated
so this is again the same thing in a way
where you understand with little bit
more examples so this is it for the
OLTP versus OLAP. If you like the lecture
please
you know comment to what you like if you
have any queries you can always talk in
in the comments and if you like our
efforts please like share & subscribe
the channel
Thank you so much
