Amazon Redshift

From Wikipedia, the free encyclopedia

Template:Short description Script error: No such module "other uses of".

Page Module:Infobox/styles.css has no content.

Amazon Redshift
[[Programmer|DeveloperTemplate:Pluralize from text]]Amazon.com
Initial releaseOctober 2012; 13 years ago (2012-10)
Template:Infobox software/simple
EnginePage Template:Plainlist/styles.css has no content.Template:EditAtWikidata
Operating systemCross-platform
Available inEnglish
Typewave
LicenseProprietary
Websiteaws.amazon.com/redshift/
RepositoryPage Template:Plainlist/styles.css has no content.

Script error: No such module "Check for conflicting parameters".

Template:DMCA 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. 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.[3] Redshift uses parallel processing and compression to decrease command execution time.[4]

Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version.[5][6] An initial preview beta was released in November 2012[7] and a full release was made available on February 15, 2013.

Amazon has listed a number of business intelligence software proprietors as partners and tested tools in their "APN Partner" program,[8] including Actian, Actuate Corporation, Alteryx, Dundas Data Visualization, IBM Cognos, InetSoft, Infor, Logi Analytics, Looker, MicroStrategy, Pentaho,[9] 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".[10]

See also

References

Page Template:Reflist/styles.css has no content.

  1. ^ Page Module:Citation/CS1/styles.css has no content."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. ^ Page Module:Citation/CS1/styles.css has no content."Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Archived from the original on June 5, 2013. Retrieved July 8, 2013.
  3. ^ Page Module:Citation/CS1/styles.css has no content."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.
  4. ^ Page Module:Citation/CS1/styles.css has no content."System and architecture overview - Amazon Redshift". docs.aws.amazon.com. Archived from the original on October 16, 2020. Retrieved October 1, 2020.
  5. ^ Page Module:Citation/CS1/styles.css has no content."Redshift and PostgreSQL". AWS. Amazon. Archived from the original on November 15, 2019. Retrieved July 26, 2015.
  6. ^ Page Module:Citation/CS1/styles.css has no content."Unsupported PostgreSQL features". AWS. Amazon. Archived from the original on November 15, 2019. Retrieved July 14, 2016.
  7. ^ Page Module:Citation/CS1/styles.css has no content."Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Archived from the original on May 31, 2013. Retrieved July 8, 2013.
  8. ^ Page Module:Citation/CS1/styles.css has no content."Amazon Redshift Partners", AWS Partner Network, Amazon, February 6, 2017, archived from the original on February 6, 2017.
  9. ^ Page Module:Citation/CS1/styles.css has no content."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.
  10. ^ Page Module:Citation/CS1/styles.css has no content.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.

Lua error in package.lua at line 80: module 'Module:Navbox/configuration' not found.