Shadowing Practice: Database vs Data Warehouse vs Data Lake | Explaining the Differences - Learn English Speaking with Video
Les maken...
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.
📺 Zelfde Kanaal
✨ Aanbevolen Video
B21
220 zinnen
How Modern Data Teams Work (Engineer, Analyst, Scientist, Architect, ML)
Business EnglishUniversity StudentsWorking Adults
C11
77 zinnen
The Secret Sauce Behind NoSQL: LSM Tree
Business EnglishUniversity StudentsWorking Adults
B21
9 zinnen
What is a Server? Servers vs Desktops Explained
Business EnglishUniversity StudentsWorking Adults
C115
29 zinnen
Amazon Athena explained in 120 seconds💡
Business EnglishUniversity StudentsWorking Adults
B23
206 zinnen
What is Master Data Management? MDM Explained for Beginners
Business EnglishUniversity StudentsWorking Adults
C12
279 zinnen
Microservices with Databases can be challenging...
Business EnglishUniversity StudentsWorking Adults
C11
339 zinnen
Introduction to HPLC - Lecture 1: HPLC Basics
Business EnglishUniversity StudentsWorking Adults
B21
364 zinnen
Claude Cowork Tutorial: Build Monthly Reports in Minutes
Business EnglishUniversity StudentsWorking Adults
C166 zinnen
Database vs Data Warehouse vs Data Lake | What is the Difference?
Business EnglishUniversity StudentsWorking Adults
B21
83 zinnen
User Flow vs Task Flow in UX Design
Business EnglishUniversity StudentsWorking Adults
C12
4 zinnen
What is Event Driven Architecture (EDA)?
Business EnglishUniversity StudentsWorking Adults
B21
169 zinnen
World’s most advanced robotic warehouse (AI automation)
Business EnglishUniversity StudentsWorking Adults
Woordenschat en spreektips bij deze les
Deze video bevat 42 zinnen en 674 woorden om na te spreken. Het gesproken deel duurt 4:14. De spreker praat in een natuurlijk tempo van ongeveer 159 woorden per minuut, dicht bij een alledaags gesprek. Slechts 78% van de woorden hoort bij de 3.000 meest gebruikte Engelse woorden, dus de woordenschat is pittig.
Belangrijke woorden in deze video
15 minder gangbare woorden uit de video, met uitspraak en betekenis:
- database /ˈdeɪtəˌbeɪs/ (zelfstandig naamwoord) — database, databank. 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/ (zelfstandig naamwoord) — pakhuis, opslagplaats. A facility for storing large amounts of merchandise or products.
- literacy /ˈlɪtəɹəsi/ (zelfstandig naamwoord) — alfabetisering, alfabetisme. The ability to read and write.
- cloud /ˈklaʊ̯d/ (zelfstandig naamwoord) — wolk. A visible mass of water droplets suspended in the air.
- skill /skɪl/ (zelfstandig naamwoord) — bekwaamheid, vaardigheid. 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/ (zelfstandig naamwoord) — fragment. Something that is extracted or drawn out.
- topic /ˈtɑpɪk/ (zelfstandig naamwoord) — onderwerp, thema. A subject; a theme; a category or general area of interest.
- confused /kənˈfjuːzd/ (bijvoeglijk naamwoord) — verward, in de war. unable to think clearly or understand
- ideal /aɪˈdi(ə)l/ (bijvoeglijk naamwoord) — ideaal, optimaal. Pertaining to ideas, or to a given idea.
- essentially /ɪˈsɛnʃəli/ (bijwoord) — essentieel. In essence: by nature.
- connect /kəˈnɛkt/ (werkwoord) — verbinden. 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͡ʒɚ/ (zelfstandig naamwoord) — passagier. 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/ (werkwoord) — verzamelen, opstapelen. To gather together; amass.
- ongoing /ɒnˈɡəʊ.ɪŋ/ (bijvoeglijk naamwoord) — lopend, in uitvoering. Continuing, permanent, lasting.
- unlikely /ʌnˈlaɪkli/ (bijvoeglijk naamwoord) — onwaarschijnlijk. Not likely; improbable; not to be reasonably expected.
Phrasal verbs die je zult horen
- stand up (werkwoord) — opstaan. To rise from a lying or sitting position.
Uitspraak om op te letten
De spreker gebruikt 14 samentrekkingen en verkorte vormen, zoals you're, aren't, they're. Spreek ze kort uit, zoals je ze hoort.
- De klanken “sh” en “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/
- Lange woorden — let op de klemtoon: literacy /ˈlɪtəɹəsi/, analytics /ˌæn.əˈlɪt.ɪks/, analytical /ˌæn.əˈlɪt.ɪ.kəl/, primarily /ˈpɹaɪ.mə.ɹə.li/, essentially /ɪˈsɛnʃəli/
Zo oefen je met deze video
- Luister de hele video één keer zonder te spreken en noteer de woorden die je niet kent.
- Begin op 0,75× snelheid, spreek zin voor zin na en ga terug naar normale snelheid zodra het makkelijk gaat.
- Neem jezelf op en vergelijk met het origineel; let daarbij op woorden als database, warehouse, literacy.
Wat is de Shadowing-techniek?
Shadowing is een wetenschappelijk onderbouwde taalleermethode die oorspronkelijk is ontwikkeld voor professionele tolkentraining en gepopulariseerd door polyglot Dr. Alexander Arguelles. De methode is eenvoudig maar krachtig: je luistert naar native Engelse audio en herhaalt het onmiddellijk hardop — als een schaduw die de spreker volgt met slechts 1–2 seconden vertraging. In tegenstelling tot passief luisteren of grammaticadrills, dwingt shadowing je hersenen en mondspieren om echte spraakpatronen tegelijkertijd te verwerken en te reproduceren. Onderzoek toont aan dat het de uitspraaknauwkeurigheid, intonatie, ritme, verbonden spraak, luisterbegrip en spreekvaardigheid aanzienlijk verbetert — waardoor het een van de meest effectieve methoden is voor IELTS Speaking-voorbereiding en echte Engelse communicatie.