User:JSchrum1/Amazon Redshift

From Wikipedia, the free encyclopedia
For other uses of redshift, see Redshift (disambiguation).
Amazon Redshift
Developer(s)Amazon.com
Initial releaseOctober 2012; 11 years ago (2012-10)
Operating systemCross-platform
Available inEnglish
LicenseProprietary
Websiteaws.amazon.com/redshift/

Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. The name means to shift away from Oracle,[1] red being an allusion to Oracle, whose corporate color is red and is informally referred to as "Big Red."[2] It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel (later acquired by Actian),[3] to handle large scale data sets and database migrations.[4] Redshift differs from 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. Redshift allows up to 4 petabytes of data on a cluster[5] compared to Amazon RDS's maximum database size of 16TB.[6]

Features[edit]

Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version.[7][8] The service can handle connections from most other applications using ODBC and JDBC connections.[9]

Redshift uses parallel-processing and compression to decrease command execution time.[10] This allows Redshift to perform operations on billions of rows at once.[11] 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.[11]

Amazon offers a tool, known as AWS Database Migration Service, which helps to automate internal and external database transfers to make moving to Amazon from another platform easier.

Users and Partnerships[edit]

Some companies using Redshift include McDonald's, Pfizer, Fox Corporation, NTT Docomo, Intuit, Yelp, Duolingo, and others.[12] One common reason for use among these customers is real-time data analytics,[12] which Redshift can handle more efficiently than Amazon's other database offerings.

Amazon has listed a number of business intelligence software proprietors as partners and tested tools in their "APN Partner" program,[13] including Actian, Actuate Corporation, Alteryx, Dundas Data Visualization, IBM Cognos, InetSoft, Infor, Logi Analytics, Looker (company), MicroStrategy, Pentaho,[14][15] Qlik, SiSense, Tableau Software, and Yellowfin. Partner companies providing data integration tools include Informatica and SnapLogic. System integration and consulting partners include Accenture, Deloitte, Capgemini and DXC Technology.

Timeline[edit]

An initial preview beta was released in November 2012.[16]

A full release was made available on February 15, 2013.

According to Cloud Data Warehouse report published by Forrester in Q4 2018, Amazon Redshift has the largest Cloud data warehouse deployments, with more than 6,500 deployments.[citation needed].

As of October of 2020, over 300,000 external databases have been moved into one of Amazon's databases, including Redshift.[17]

See also[edit]

References[edit]

  1. ^ "Amazon Named Its Database Redshift For A Reason". awsforbusiness.com.
  2. ^ "Bye-bye, Big Red? Escaping Oracle's not that easy". infoworld.com.
  3. ^ "Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Retrieved July 8, 2013.
  4. ^ "Improve data processing performance on AWS Redshift by 200%". Ardentisys.com.
  5. ^ "Amazon Redshift FAQs - Cloud Data Warehouse - Amazon Web Services". Amazon Web Services, Inc. Retrieved September 20, 2020.
  6. ^ "What Is Amazon Relational Database Service (Amazon RDS)? - Amazon Relational Database Service". docs.aws.amazon.com. Retrieved September 20, 2020.
  7. ^ "Redshift and PostgreSQL". AWS. Amazon.
  8. ^ "Unsupported PostgreSQL features". AWS. Amazon.
  9. ^ Louwers, Johan (February 1, 2014). "Amazon Redshift cloud based data warehouse service". johanlouwers.blogspot.co.uk..
  10. ^ "System and architecture overview - Amazon Redshift". docs.aws.amazon.com. Retrieved October 1, 2020.
  11. ^ a b "4 Amazon Redshift Use Cases: Collect, store, analyze & share data". intermix.io. August 26, 2020. Retrieved October 1, 2020.
  12. ^ a b "Amazon Redshift Customers - Cloud Data Warehouse - Amazon Web Services". Amazon Web Services, Inc. Retrieved October 21, 2020.
  13. ^ "Amazon Redshift Partners", AWS Partner Network, Amazon, February 6, 2017, archived from the original on February 6, 2017.
  14. ^ "APN - Amazon Redshift Partners - Pentaho". AWS. Amazon. Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift.
  15. ^ "Amazon Web Services". Pentaho.com. then transformed, refined, and immediately pushed into Amazon Redshift.
  16. ^ "Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Retrieved July 8, 2013.
  17. ^ "In a shot at Oracle, Amazon touts 300,000 database migrations". SiliconANGLE. October 15, 2020. Retrieved October 21, 2020.

Redshift Category:Data warehousing products Category:Cloud databases Category:Computer-related introductions in 2012

Retrieved from "https://en.wikipedia.org/w/index.php?title=User:JSchrum1/Amazon_Redshift&oldid=985008336"