From the course: Learning Data Science
Unlock this course with a free trial
Join today to access over 24,700 courses taught by industry experts.
Getting data into warehouses using ETL
From the course: Learning Data Science
Getting data into warehouses using ETL
- Many data science concepts build on previous work with relational databases. Companies have been capturing and analyzing data for decades. That's why you need to understand some of the key RDBMS terms. One place that you'll likely run into them is when you're working with data warehouses. An enterprise data warehouse, or EDW, is a special type of relational database that focuses on analyzing the data. Traditional databases are optimized for online transaction processing, or OLTP. A data warehouse is used for online analytical processing, or OLAP. Think of it this way. A typical database is focused on working with data in real time. A data warehouse is focused on analyzing what's already happened. Imagine that you have a website that's selling running shoes. You've hired an engineer for your database. They've created many tables and relationships, and there's a table for a customer address, a table for shoes, a table for shipping options, and so on. Your web server would use SQL…