Amazon Redshift Explained

Amazon Redshift
Developer:Amazon.com
Operating System:Cross-platform
Language:English
License:Proprietary

Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.[1] It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel (later acquired by Actian),[2] to handle large scale data sets and database migrations.[3] 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 16 petabytes of data on a cluster[4] compared to Amazon RDS Aurora's maximum size of 128 tebibytes.[5]

Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version.[6] [7] An initial preview beta was released in November 2012[8] and a full release was made available on February 15, 2013. The service can handle connections from most other applications using ODBC and 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 compression to decrease command execution time.[11] This allows Redshift to perform operations on billions of rows at once.[12] 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 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, 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.

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

External links

Notes and References

  1. Web site: Bye-bye, Big Red? Escaping Oracle's not that easy. infoworld.com. November 4, 2013. January 15, 2020. January 15, 2020. https://web.archive.org/web/20200115181052/https://www.infoworld.com/article/2612856/bye-bye--big-red--escaping-oracle-s-not-that-easy.html. live.
  2. Web site: Amazon Redshift: ParAccel in, costly appliances out. ZDNet. July 8, 2013. June 5, 2013. https://web.archive.org/web/20130605000041/http://www.zdnet.com/amazon-redshift-paraccel-in-costly-appliances-out-7000008111/. live.
  3. Web site: Improve data processing performance on AWS Redshift by 200%. Ardentisys.com. April 14, 2017. November 15, 2019. https://web.archive.org/web/20191115085000/https://www.ardentisys.com/cloud-management/improve-aws-redshift-performance. live.
  4. Web site: Amazon Redshift FAQs - Cloud Data Warehouse - Amazon Web Services. 2020-09-20. Amazon Web Services, Inc.. en-US. September 17, 2020. https://web.archive.org/web/20200917082646/https://aws.amazon.com/redshift/faqs/. live.
  5. Web site: Quotas and constraints for Amazon Aurora. 2022-04-01. An Aurora cluster volume can grow to a maximum size of 128 tebibytes (TiB). August 27, 2021. https://web.archive.org/web/20210827190221/https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_Limits.html. live.
  6. Web site: AWS . Redshift and PostgreSQL . Amazon . July 26, 2015 . November 15, 2019 . https://web.archive.org/web/20191115085004/https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html . live .
  7. Web site: Unsupported PostgreSQL features. AWS. Amazon. July 14, 2016. November 15, 2019. https://web.archive.org/web/20191115084956/https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-features.html. live.
  8. Web site: Amazon Debuts Low-Cost, Big Data Warehousing. Information Week. July 8, 2013. May 31, 2013. https://web.archive.org/web/20130531074545/http://www.informationweek.com/software/information-management/amazon-debuts-low-cost-big-data-warehous/240142712. live.
  9. Web site: February 1, 2014 . Amazon Redshift cloud based data warehouse service . johanlouwers.blogspot.co.uk . Johan . Louwers . February 2, 2014 . October 13, 2017 . https://web.archive.org/web/20171013013354/http://johanlouwers.blogspot.nl/2014/02/amazon-redshift-cloud-based-data.html . live . .
  10. Web site: Little . Cinny . The Forrester Wave™: Cloud Data Warehouse Solutions, Q4 2018 . Forrester . 18 December 2020 .
  11. Web site: System and architecture overview - Amazon Redshift. 2020-10-01. docs.aws.amazon.com. October 16, 2020. https://web.archive.org/web/20201016002650/https://docs.aws.amazon.com/redshift/latest/dg/c_redshift_system_overview.html. live.
  12. Web site: 2020-08-26. 4 Amazon Redshift Use Cases: Collect, store, analyze & share data. 2020-10-01. intermix.io. en-US. October 31, 2020. https://web.archive.org/web/20201031212027/https://www.intermix.io/blog/amazon-redshift-use-cases/. live.
  13. .
  14. Web site: APN - Amazon Redshift Partners - Pentaho. "Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift.". Amazon. AWS. February 6, 2017. November 15, 2019. https://web.archive.org/web/20191115084949/https://aws.amazon.com/redshift/partners-detail/pentaho/. live.
  15. Web site: Amazon Web Services. "then transformed, refined, and immediately pushed into Amazon Redshift.". Pentaho.com. February 6, 2017. April 1, 2018. https://web.archive.org/web/20180401031827/http://www.pentaho.com/amazon-web-services#tab-1. live.
  16. Web site: Krazit . Tom . Amazon Web Services reportedly named its cloud database RedShift in order to tweak Oracle . GeekWire . January 2, 2018 . 9 March 2022 . March 9, 2022 . https://web.archive.org/web/20220309051912/https://www.geekwire.com/2018/amazon-web-services-reportedly-named-cloud-database-redshift-order-tweak-oracle/ . live .

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "Amazon Redshift".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.