Amazon Redshift Tutorials || Secure,high-performing,Petabyte scale Data-warehouse Solution from AWS
In today's session , we are going to discuss about Secure,Fast,Petabyte scale Data-warehouse Solution offered by AWS i.e. Amazon Redshift.
Amazon Redshift is a fast, scalable, secure, and fully managed cloud data warehouse solution. It makes it simple and cost-effective to analyze all data using standard SQL and existing ETL (extract, transform, and load), business intelligence (BI), and reporting tools.
Scalable upto 16 petabytes of data on a cluster compared to Amazon RDS Aurora‘s maximum size of 128 terabytes.
Redshift differs Amazon's other hosted database offering, Amazon RDS, in its ability to handle analytic workloads on big data data-sets stored by a column-oriented DBMS principle.
It uses parallel-processing and compression to decrease command execution time. This allows Redshift to perform operations on billions of rows at once. This also makes Redshift useful for storing and analyzing large quantities of data from logs or live feeds through a source such as Amazon Kinesis Data Firehose.
Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes. AWS-designed hardware and machine learning deliver the best price performance at any scale.
An OLAP-style (Online Analytical Processing) column-oriented database. It is based on PostgreSQL version 8.0. 2.
Features of Amazon Redshift includes : Federated query , Data sharing , AWS Data Exchange with Redshift,Streaming ingestion , Auto-copy for AWS S3 etc.
Three instance types to optimize Amazon Redshift for data warehousing needs: RA3 nodes, Dense Compute nodes, and Dense Storage nodes.
Some common use cases for Redshift include Enterprise Data warehouse , streaming data analytics,ML based predictions,Data Analytics as Service etc.
We can start small for just $0.25 per hour with no commitments, and scale out for just $1,000 per terabyte per year.Pricing includes built-in security, data compression, backup storage, and data transfer.
The pricing estimate can be performed using the calculator below-
https://calculator.aws/#/addService/R...
Please like,share,comments and subscribe to my YouTube Channel
'Cloud With Mohsin'
Happy Learning