Original subtitles

‫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.