User:JSchrum1/sandbox
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]
Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version.[7][8] An initial preview beta was released in November 2012[9] 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.[10] 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].
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.[12]
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.
See also
[edit]Docs[16]
Event Notifications[17]
References
[edit]- ^ "Amazon Named Its Database Redshift For A Reason". awsforbusiness.com.
- ^ "Bye-bye, Big Red? Escaping Oracle's not that easy". infoworld.com.
- ^ "Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Retrieved July 8, 2013.
- ^ "Improve data processing performance on AWS Redshift by 200%". Ardentisys.com.
- ^ "Amazon Redshift FAQs - Cloud Data Warehouse - Amazon Web Services". Amazon Web Services, Inc. Retrieved September 20, 2020.
- ^ "What Is Amazon Relational Database Service (Amazon RDS)? - Amazon Relational Database Service". docs.aws.amazon.com. Retrieved September 20, 2020.
- ^ "Redshift and PostgreSQL". AWS. Amazon.
- ^ "Unsupported PostgreSQL features". AWS. Amazon.
- ^ "Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Retrieved July 8, 2013.
- ^ Louwers, Johan (February 1, 2014). "Amazon Redshift cloud based data warehouse service". johanlouwers.blogspot.co.uk..
- ^ "System and architecture overview - Amazon Redshift". docs.aws.amazon.com. Retrieved October 1, 2020.
- ^ a b "4 Amazon Redshift Use Cases: Collect, store, analyze & share data". intermix.io. August 26, 2020. Retrieved October 1, 2020.
- ^ "Amazon Redshift Partners", AWS Partner Network, Amazon, February 6, 2017, archived from the original on February 6, 2017.
- ^ "APN - Amazon Redshift Partners - Pentaho". AWS. Amazon.
Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift.
- ^ "Amazon Web Services". Pentaho.com.
then transformed, refined, and immediately pushed into Amazon Redshift.
- ^ "What is Amazon Redshift? - Amazon Redshift". docs.aws.amazon.com. Retrieved September 20, 2020.
- ^ "Amazon Redshift event notifications - Amazon Redshift". docs.aws.amazon.com. Retrieved September 20, 2020.
 | This is a user sandbox of JSchrum1. You can use it for testing or practicing edits. This is not the sandbox where you should draft your assigned article for a dashboard.wikiedu.org course. To find the right sandbox for your assignment, visit your Dashboard course page and follow the Sandbox Draft link for your assigned article in the My Articles section. |