From the course: Introduction to Amazon Redshift: Data Management Essentials

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

How relational databases retrieve data

How relational databases retrieve data - Amazon Web Services (AWS) Tutorial

From the course: Introduction to Amazon Redshift: Data Management Essentials

Start my 1-month free trial Buy for my team

How relational databases retrieve data

“

- [Instructor] Without knowing your exact project or needs, I'm going to make some assumptions that you've landed on storing your data within a relational database. Some database engines you might be looking at include Microsoft SQL Server. Maybe you're looking at running an Oracle database server or maybe Postqres for a free open source option. Now, all these database servers work a bit differently and have different features, but under the hood, they're storing your data in large continuous blocks to the disk drive of your server. So to make this simple, let's say that you have a single table in your database, and that table stores all the e-commerce orders for your organization. And for brevity, let's assume this table just has an order number, a date the order was placed, the state the order is being delivered to and the order total. Now, a real table of orders will include a lot more data and have other tables…

Contents