Course contentsShow
← Data Science
Lesson 20 of 2,1451. Foundations of Data ScienceFree lesson

Primary Data Sources: Databases and Data Warehouses

Learn about structured data stored in relational databases and centralized data warehouses.

Primary Data Sources: Databases and Data Warehouses

What you'll learn: Where data scientists get their structured data from and how organizations store it systematically.

What Are Databases and Data Warehouses?

Think of a database as a digital filing cabinet where organizations store their day-to-day information in an organized way. When you shop online, your order details go into a database. When you check your bank balance, that information comes from a database. These systems use structured data (remember: organized in rows and columns with clear types) stored in tables that connect to each other through relationships—hence the term "relational databases."

A data warehouse, on the other hand, is like a massive library that collects copies of information from many different filing cabinets across an entire organization. Instead of handling today's transactions, it stores historical data optimized for analysis. Data scientists love warehouses because they can query years of information from multiple departments in one place without slowing down the live systems people use daily.

Why This Matters for Data Science

When you begin data collection and acquisition (from your lifecycle knowledge), databases and warehouses are often your first stop. They contain the clean, structured data you need for analysis—customer records, sales transactions, product inventories, and more. These sources already organize information with defined categorical and numerical variables, making your data cleaning and preparation work much easier than dealing with messy external sources.

The Key Difference

Databases = operational (today's work)
Data Warehouses = analytical (understanding patterns over time)

Key Takeaway: Databases store current operational data in structured tables, while data warehouses centralize historical data from across an organization specifically for analysis—making them primary sources for data science projects.