All language subtitles for 36 - Exercise OLTP vs OLAP English

I thought it would be fun to complement this theoretical course with a small exercise around OLAP versus

old TP because they are kind of abstract concepts, so let's dive into it exercise.

So the format here is that we are going to be guessing which ones are all Tepes and which ones are all

apeace.

So a database is being used to log orders and customers to a database is being used to figure out what

new products we should offer.

Three, a database is being used to derive statistics for reporting to the executives and for a database

is being used to keep track of logged in users.

So pause the video right here.

Think about it.

Write down one, two, three, four.

And what are you think one is an all tip or an oil AP and two and three and four.

And when you come back, we'll run through them.

All right.

So we're back.

One was a database is being used to log orders and customers.

So let's go look at that.

Well, that's an old TPE.

So it's a transactional database.

An old.

Why is it a transactional database?

Why is it old?

Well, it is all because it's being used to drive the day to day of a business.

All right, let's take a look at two, a database is being used to figure out what new products we should

offer.

Let's go take a quick look.

O l a p.

All right, so too was OLP, why is it an analytical platform?

Well, as I said, a database that's being used to figure out what new products we should offer to look

to the future to do kind of like an analysis on where we are and what we're doing that's typically used

for analysis.

So it's being used to figure out the day to day driving of the business.

Three, a database is being used to derive statistics for reporting to executives.

That is well, again, we're using a database to derive statistics for reporting to the executives,

so we're trying to figure out, OK, what's going on here, what is in the company, what data, what

statistics do we need to run in order to figure it out?

So we're pumping out data from a database and we're trying to figure out some stuff on top of it.

And then for a database is being used to keep track of the logged in users.

Now, this one was tricky because to keep track of the logged in users, you may think, oh, I can

use that for analytics.

But in essence, it is all TPE because it's being used to drive the day of the business, you're basically

using it to keep track of, OK, this many users are logged in.

This is how many sessions we have.

Eventually, it could be fed into a system that could use it to derive analytics to, for instance,

figure out, OK, this is our daily active user.

But in essence, that database that's keeping track of that stuff at that given point in time is being

used as a transactional database because someone's logging in the record is going in saying I'm logged

in them when they log out at a log out of time.

And by doing that, by that definition, it is all TPE, but it could be used in an overlap way.

All right.

So let's move on to the next video.