AWS Redshift Datawarehousing Platform Service
Jump to navigation
Jump to search
An AWS Redshift Datawarehousing Platform Service is a cloud-based data warehousing platform that is an AWS DBMS service.
- Context:
- It can enables the creation and management of an AWS Redshift-based DBMS Instance.
- It can (typically) be based on Postgres.
- …
- Example(s):
- Counter-Example(s):
- See: Column-Oriented DBMS, Data Warehouse, Column-Oriented DBMS, Massive Parallel Processing.
References
2021
- https://hevodata.com/learn/snowflake-vs-redshift-vs-bigquery/#conclusion
- QUOTE: ... Data Warehousing architectures have rapidly changed over the years and most of the notable service providers are now Cloud-based. Therefore, companies are increasingly on the move to align with such offerings on the Cloud as it provides them with a lower upfront cost, enhances scalability, and performance as opposed to traditional On-premise Data Warehousing systems. The purpose of this guide is to compare and contrast the key differences between three of the leading Data Warehouse platforms available in the market today and help you understand the key factors that drive the Snowflake vs Redshift vs BigQuery decision. ...
2017
- (Wikipedia, 2017) ⇒ https://en.wikipedia.org/wiki/Amazon_Redshift Retrieved:2017-10-8.
- Amazon Redshift is an Internet hosting service and data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data-warehouse company ParAccel (later acquired by Actian). Redshift differs from Amazon's other hosted database offering, Amazon RDS, in its ability to handle analytics workloads on big data data sets stored by a column-oriented DBMS principle. To be able to handle large scale data sets and database migrations [1] Amazon makes use of massive parallel processing. Amazon Redshift is based on PostgreSQL 8.0.2. PostgreSQL 9.x includes features not supported in Amazon Redshift. In addition, there are important differences between Amazon Redshift SQL and PostgreSQL 8.0.2. PostgreSQL 8.0.2 was released in 2005 and PostgreSQL has seen massive development since then. Many PostgreSQL features are not supported. [2]
2015
- (Wikipedia, 2015) ⇒ http://en.wikipedia.org/wiki/Amazon_Web_Services#Database Retrieved:2015-8-21.
- Amazon Redshift provides petabyte-scale data warehousing with column-based storage and multi-node compute.
2015b
- http://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html
- QUOTE: Amazon Redshift is based on PostgreSQL 8.0.2. Amazon Redshift and PostgreSQL have a number of very important differences that you must be aware of as you design and develop your data warehouse applications. Amazon Redshift is specifically designed for online analytic processing (OLAP) and business intelligence (BI) applications, which require complex queries against large datasets. Because it addresses very different requirements, the specialized data storage schema and query execution engine that Amazon Redshift uses are completely different from the PostgreSQL implementation. For example, where online transaction processing (OLTP) applications typically store data in rows, Amazon Redshift stores data in columns, using specialized data compression encodings for optimum memory usage and disk I/O. Some PostgreSQL features that are suited to smaller-scale OLTP processing, such as secondary indexes and efficient single-row data manipulation operations, have been omitted to improve performance.