跟讀練習: Database vs Data Warehouse vs Data Lake | Explaining the Differences - 通過影片學習英語口語
選擇練習模式
每種模式都會開啟全屏練習室。
42 句
如果句子過短或過長，請點選 Edit 進行調整。
1
We live in a world that runs on data.
2
It's how Amazon and Netflix know which movies and products to recommend, how Starbucks manages a global supply chain,
3
and how Uber connects drivers with passengers in real time.
4
But the thing is, data skills aren't just for tech companies or professional analysts anymore.
5
Everyone works with data to some degree, and everyone can benefit from data literacy skills.
6
In this video, we're covering an important topic that will help you take your data literacy to the next level.
7
Alright, so accessing data is one thing, but organizing and storing it is a completely different beast.
8
So at a high level, some of the most common storage modes that you're likely to encounter include flat files, databases, data warehouses, and data lakes.
9
Now, there are other, less common storage methods and hybrid variations of these as well, but our goal here is really just to paint some broad strokes
10
and help you understand the key similarities and differences between them.
11
Now, the simplest method of data storage is a flat file,
12
which is typically a static tabular data extract saved either to a local drive or cloud storage like Google Drive or OneDrive.
13
And this is very common for one off projects or quick ad hoc analyses that don't require multiple data sources, ongoing maintenance or complex data models.
14
The most common types of flat files you'll see are CSVs and Excel workbooks.
15
Now, a database is a collection of related tables stored in a database management system, or DBMS.
16
Databases are typically used for recording and collecting data tied to a single application or business process,
17
like capturing transactional records or real-time website activity.
18
And they're usually optimized for online transactional processing,
19
known as OLTP, meaning that they're built to receive and store data as efficiently as possible, but aren't really ideal for querying or analysis.
20
Common database options include MySQL, Amazon RDS, Microsoft Access or SQL Server, and many, many more.
21
A data warehouse, on the other hand, is a database
22
or a collection of data sourced from multiple databases that's typically structured to support specific analytics needs
23
and is optimized for online analytical processing, or OLAP.
24
That basically just means it's built in a way
25
that makes it very easy and very fast for users to access the data they need for analytical purposes.
26
examples of data warehouse tools include Amazon Redshift, Google BigQuery, Snowflake, Teradata, and others.
27
And finally we have data lakes which are essentially a repository of both structured
28
and unstructured data sources often stored in their raw unprocessed state.
29
So we're talking about everything from CSV files to MP4s, PDFs, text documents, and so on.
30
Instead of getting Being cleaned and prepped on the way in, data is typically extracted from the lake and transformed for specific purposes,
31
often relating to machine learning or AI.
32
Some examples of data lakes include Amazon S3, Azure Data Lake, Google Cloud, and more.
33
Now, if you're feeling a little overwhelmed about what this all means, no need to worry.
34
I've worked in data analytics and business intelligence for over 15 years, and I still get confused by this stuff.
35
The good news is that unless you plan to become a data engineer, it's extremely unlikely that you would be the one building or configuring databases or warehouses.
36
In fact, in most cases, data engineers or architects are the ones primarily responsible for standing up these systems
37
and building the pipelines and automations that help the data flow from one place to another.
38
If you enjoyed this content and want to see more, we've got a brand new Data Literacy Foundations course, and it's entirely free.
39
You can check it out at mavenanalytics.io.
40
So whether you're an individual looking to build confidence, a leader seeking to empower and upskill your team, or a data professional just trying to to stay ahead of the curve,
41
this is the course for you.
42
We've got a lot to cover, so let's dive in.
同頻道
FOR YOU
推薦影片
C115
29 句
Amazon Athena explained in 120 seconds💡
Daily ConversationUniversity StudentsWorking Adults
C12
43 句
SDLC Vs STLC: Software Development Life Cycle and Software Testing Life Cycle
Daily ConversationUniversity StudentsWorking Adults
B21
375 句
Configure storage accounts | AZ-104 | Episode 16
Daily ConversationUniversity StudentsWorking Adults
C12
4 句
What is Event Driven Architecture (EDA)?
Daily ConversationUniversity StudentsWorking Adults
C11
9 句
What is a Server? Servers vs Desktops Explained
Daily ConversationUniversity StudentsWorking Adults
B24
83 句
What are KPIs and Metrics? | Data Fundamental for Beginners
Daily ConversationUniversity StudentsWorking Adults
C13
53 句
System Design Was HARD - Until You Knew the Trade-Offs
Daily ConversationUniversity StudentsWorking Adults
B21
220 句
How Modern Data Teams Work (Engineer, Analyst, Scientist, Architect, ML)
Daily ConversationUniversity Students
C11
77 句
The Secret Sauce Behind NoSQL: LSM Tree
Daily ConversationUniversity StudentsWorking Adults
C12
102 句
What is Docker? Docker container concept explained || Docker Tutorial 1
Daily ConversationUniversity StudentsWorking Adults
C13
68 句
what is a database index?
Daily ConversationUniversity StudentsWorking Adults
C12
175 句
What is a PLC and how does it work?
Daily ConversationUniversity StudentsWorking Adults
本課的詞彙與口語要點
這段影片共有 42 個句子、674 個單詞可供跟讀。 講話部分時長為 4:14。 說話人語速自然，每分鐘約 159 個詞，接近日常對話。 只有 78% 的單詞屬於英語最常用的 3,000 詞，詞彙難度較高。
影片中的重點詞彙
影片中 15 個不太常見的單詞，附發音和釋義：
- database /ˈdeɪtəˌbeɪs/ (名詞) — 資料庫 /資料庫. A collection of (usually) organized information in a regular structure, usually but not necessarily in a machine-readable format accessible by a computer.
- warehouse /ˈwɛə(ɹ)haʊs/ (名詞) — 倉庫 /倉庫. A facility for storing large amounts of merchandise or products.
- literacy /ˈlɪtəɹəsi/ (名詞) — 認字 /認字, 識字 /識字. The ability to read and write.
- cloud /ˈklaʊ̯d/ (名詞) — йүн, 雲 /雲. A visible mass of water droplets suspended in the air.
- skill /skɪl/ (名詞) — 技巧, 技能. A capacity to do something well; a technique, an ability, usually acquired or learned, as opposed to abilities that are regarded as innate.
- extract /ˈɛkstɹækt/ (名詞) — 精. Something that is extracted or drawn out.
- analytics /ˌæn.əˈlɪt.ɪks/ (名詞) — 分析學 /分析學. The principles governing any of various forms of analysis.
- topic /ˈtɑpɪk/ (名詞) — 主題 /主題, 話題 /話題. A subject; a theme; a category or general area of interest.
- confused /kənˈfjuːzd/ (形容詞) — 困惑. unable to think clearly or understand
- ideal /aɪˈdi(ə)l/ (形容詞) — 理想的. Pertaining to ideas, or to a given idea.
- capture /ˈkæp.(t)ʃɚ/ (動詞) — 捕獲 /捕獲, 佔領 /佔領. To take control of; to seize by force or stratagem.
- essentially /ɪˈsɛnʃəli/ (副詞) — 本質上 /本質上, 基本上. In essence: by nature.
- connect /kəˈnɛkt/ (動詞) — 連線 /連線. To join (to another object): to attach, or to be intended to attach or capable of attaching, to another object.
- passenger /ˈpæs.ɪn.d͡ʒɚ/ (名詞) — 乘客, 旅客. One who rides or travels in a vehicle, but who does not operate it and is not a member of the crew.
- collect /ˈkɑlɪkt/ (動詞) — 庋藏, 收藏. To gather together; amass.
影片中出現的短語動詞
- stand up (動詞) — 站起來 /站起來, 起來 /起來. To rise from a lying or sitting position.
需要注意的發音
說話人用了 14 次縮略和弱讀形式，例如 you're, aren't, they're。請按聽到的簡短形式來說。
- “sh” 和 “zh” 音: capture /ˈkæp.(t)ʃɚ/, essentially /ɪˈsɛnʃəli/, variation /ˌvɛəɹiˈeɪʃn̩/, automation /ˌɔ.təˈmeɪ.ʃən/, transactional /trænˈzækʃ(ə)nəl/
- 長單詞——注意重音位置: literacy /ˈlɪtəɹəsi/, analytics /ˌæn.əˈlɪt.ɪks/, analytical /ˌæn.əˈlɪt.ɪ.kəl/, primarily /ˈpɹaɪ.mə.ɹə.li/, essentially /ɪˈsɛnʃəli/
如何用這段影片練習
- 先完整聽一遍影片，不要開口，記下不認識的單詞。
- 先用 0.75 倍速逐句跟讀，熟練之後再回到正常速度。
- 錄下自己的聲音並與原聲對比，特別注意 database, warehouse, literacy 這類單詞。
什麼是跟讀法？
跟讀法 (Shadowing) 是一種有科學依據的語言學習技巧，最初開發用於專業口譯員的培訓，並由多語言者Alexander Arguelles博士普及。這個方法簡單而強大：您在聽英語母語原聲的同時立即大聲重複——就像是一個延遲1-2秒緊跟說話者的影子。與被動聽力或語法練習不同，跟讀法強迫您的大腦和口腔肌肉同時處理並模模擬實的講話模式。研究表明它能顯著提高發音準確性，語調，節奏，連讀，聽力理解和口語流利度——使其成為雅思口語備考和真實英語交流最有效的方法之一。