Reader small image

You're reading from  AWS Certified Cloud Practitioner Exam Guide

Product typeBook
Published inJan 2022
PublisherPackt
ISBN-139781801075930
Edition1st Edition
Tools
Concepts
Right arrow
Author (1)
Rajesh Daswani
Rajesh Daswani
author image
Rajesh Daswani

Rajesh Daswani is a senior solutions architect, AWS course content creator, and corporate trainer with over 20 years' experience in core IT infrastructure services and cloud computing. He has delivered corporate training programs and online training for several clients across the UK, USA, and India and published courses for Packt Publishing. Rajesh now delivers courses for the IaaS Academy, an online training provider that delivers on-demand cloud computing training and practice exam simulators to help students and IT professionals ace IT certification exams. You will also find extensive blog articles and exam tips on the IaaS Academy website to help you with your study and revision.
Read more about Rajesh Daswani

Right arrow

Understanding the use cases for Amazon Redshift and data warehousing

A data warehousing solution is a specialized database solution designed to pull data from other relational databases and enable complex querying and analytics to be performed across different datasets. For example, you can combine data across customer orders, inventory data, and financial information to analyze product trends, demands, and return on investments.

Clients of Amazon Redshift include business intelligence (BI) applications, reporting, and analytics toolsets.

Online Analytical Processing (OLAP)

Amazon Redshift is designed for analytics and is optimized for scanning many rows of data for one or multiple columns. Instead of organizing data as rows, Redshift transparently organizes data by columns; it converts the data into columnar storage for each of the columns. Let's look at what this means.

In a traditional database, data for each record is stored as rows. The columns represent the...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
AWS Certified Cloud Practitioner Exam Guide
Published in: Jan 2022Publisher: PacktISBN-13: 9781801075930

Author (1)

author image
Rajesh Daswani

Rajesh Daswani is a senior solutions architect, AWS course content creator, and corporate trainer with over 20 years' experience in core IT infrastructure services and cloud computing. He has delivered corporate training programs and online training for several clients across the UK, USA, and India and published courses for Packt Publishing. Rajesh now delivers courses for the IaaS Academy, an online training provider that delivers on-demand cloud computing training and practice exam simulators to help students and IT professionals ace IT certification exams. You will also find extensive blog articles and exam tips on the IaaS Academy website to help you with your study and revision.
Read more about Rajesh Daswani