Amazon Redshift

Source: Wikipedia, the free encyclopedia.
Amazon Redshift
Available inEnglish
LicenseProprietary
Websiteaws.amazon.com/redshift/

Amazon Redshift is a

petabytes of data on a cluster[4] compared to Amazon RDS Aurora's maximum size of 128 terabytes.[5]

Amazon Redshift is based on an older version of

JDBC connections.[9]
According to Cloud Data Warehouse report published by Forrester in Q4 2018, Amazon Redshift has the largest number of Cloud data warehouse deployments, with more than 6,500 deployments.[10]

Redshift uses parallel-processing and

logs or live feeds through a source such as Amazon Kinesis Data Firehose.[12]

Amazon has listed a number of

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
.

The "Red" in Redshift's name alludes to Oracle, a competing computer technology company sometimes informally referred to as "Big Red" due to its red corporate color. Hence, customers choosing to move their databases from Oracle to Redshift would be "shifting" from "Red".[16]

See also

References

  1. ^ "Bye-bye, Big Red? Escaping Oracle's not that easy". infoworld.com. November 4, 2013. Archived from the original on January 15, 2020. Retrieved January 15, 2020.
  2. ^ "Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Archived from the original on June 5, 2013. Retrieved July 8, 2013.
  3. ^ "Improve data processing performance on AWS Redshift by 200%". Ardentisys.com. Archived from the original on November 15, 2019. Retrieved April 14, 2017.
  4. ^ "Amazon Redshift FAQs - Cloud Data Warehouse - Amazon Web Services". Amazon Web Services, Inc. Archived from the original on September 17, 2020. Retrieved September 20, 2020.
  5. ^ "Quotas and constraints for Amazon Aurora". Archived from the original on August 27, 2021. Retrieved April 1, 2022. An Aurora cluster volume can grow to a maximum size of 128 tebibytes (TiB)
  6. ^ "Redshift and PostgreSQL". AWS. Amazon. Archived from the original on November 15, 2019. Retrieved July 26, 2015.
  7. ^ "Unsupported PostgreSQL features". AWS. Amazon. Archived from the original on November 15, 2019. Retrieved July 14, 2016.
  8. ^ "Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Archived from the original on May 31, 2013. Retrieved July 8, 2013.
  9. ^ Louwers, Johan (February 1, 2014). "Amazon Redshift cloud based data warehouse service". johanlouwers.blogspot.co.uk. Archived from the original on October 13, 2017. Retrieved February 2, 2014..
  10. ^ Little, Cinny. "The Forrester Wave™: Cloud Data Warehouse Solutions, Q4 2018" (PDF). Forrester. Retrieved December 18, 2020.[permanent dead link]
  11. ^ "System and architecture overview - Amazon Redshift". docs.aws.amazon.com. Archived from the original on October 16, 2020. Retrieved October 1, 2020.
  12. ^ a b "4 Amazon Redshift Use Cases: Collect, store, analyze & share data". intermix.io. August 26, 2020. Archived from the original on October 31, 2020. Retrieved October 1, 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. Archived from the original on November 15, 2019. Retrieved February 6, 2017. Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift.
  15. ^ "Amazon Web Services". Pentaho.com. Archived from the original on April 1, 2018. Retrieved February 6, 2017. then transformed, refined, and immediately pushed into Amazon Redshift.
  16. ^ Krazit, Tom (January 2, 2018). "Amazon Web Services reportedly named its cloud database RedShift in order to tweak Oracle". GeekWire. Archived from the original on March 9, 2022. Retrieved March 9, 2022.

External links