Name: 使用MySQL構建大數據應用 (Using MySQL to Build Big Data Applications)
Uploaded: 2021-01-14T05:48:12.000Z
Duration: 26 min 22 s
Description: 【看影片學英語】數萬部 YouTube 影片，搭配英漢字典即點即查，輕鬆掌握單字發音與用法，長久累積看電影不必再看字幕。

動名詞

to 不定詞

Sorry, there could be two problems that you are addressing. Either it's an problem of scaling

as in, my system already has a lot of data and I..

make the existing features more performant or

in the sense that you already have Big Data

and you are asked to make use of that in some way

to the business users in your organization or give aggregated reports

to your customers about how they are performing

and I'm going to focus today, on this side (reporting)

So what is the problem with with the Big Data?

Basically, it's as if you have a very large table

and in order to do the reporting that you need to do

you need to gather all this information from this table and process it in some way

However, what does that mean in terms of the underlying physics of it.

and in order to get the certain rows from the table on the hard disk

you have to go over many different places in the hard disk

So, if it is a large amount of data (that) would obviously be more time consuming.

If the data is fragmented across different places on the hard disk that would mean you have to spin more.

you need to get that data into the CPU (roughly)

To process it (the data). To manipulate it into whatever way you need it to (be)

So, this problem has actually been going on for a very long time

How are we able to, with existing hardware technologies,

get more data faster to be able to process it and turn it into a report

Many years ago, a person called Ralph Kimbal

who is the main or one of the two main contributors to the data warehousing

he came up with.. data warehousing.. I wouldn't say movement, but technology

where he said basically, no matter what the technology is

is we'll always have to go through a large number of rows

(in a way) that we are able to produce reports without

字幕列表影片播放

使用MySQL構建大數據應用 (Using MySQL to Build Big Data Applications)

table

date

problem

hard