Amazon Redshift

From Wikipedia, the free encyclopedia
Jump to: navigation, search

Amazon Redshift, a hosted data warehouse product, forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data-warehouse company ParAccel (later acquired by Actian).[1] Redshift differs from Amazon's other hosted database offering, Amazon RDS, in its ability to handle analytics workloads on large-scale datasets stored by a column-oriented DBMS principle. To be able to handle large scale datasets Amazon makes use of massive parallel processing.

Amazon Redshift is based on PostgreSQL 8.0.2. PostgreSQL 9.x includes features not supported in Amazon Redshift. In addition, there are important differences between Amazon Redshift SQL and PostgreSQL 8.0.2.[2] PostgreSQL 8.0.2 was released in 2005 and PostgreSQL has seen massive development since then. Many PostrgreSQL features are not supported.

Business intelligence tools[edit]

In principle, Amazon Redshift can handle all connections from other applications based upon ODBC and JDBC connections.[3] Amazon has listed a number of business intelligence tools as partners and tested tools in their APN Partner program.[4]

Business intelligence partners[edit]

Data integration partners[edit]

Amazon Redshift also has partners providing data integration tools.[4]

System integration and consulting partners[edit]

  • 2ndWatch
  • 47Lining
  • Accenture
  • Agilisium
  • Beeva
  • BrightLight
  • Capgemini
  • Classmethod
  • ClearScale
  • Cloud Kinetics
  • Cloudpack
  • Cognizant
  • Full360
  • Iolap
  • Isobar
  • Ispirer
  • Magnus Data
  • Northbay
  • Slalom

Query and data modeling partners[edit]

  • Aginity Workbench
  • Aqua Data Studio
  • RazorSQL
  • Toad

History[edit]

An initial preview beta was released on November 2012[7] and a full release was made available on February 15, 2013.

References[edit]

  1. ^ "Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Retrieved July 8, 2013. 
  2. ^ "Redshift and PostgreSQL". AWS. Amazon. 
  3. ^ Louwers, Johan (Feb 2014), Amazon Redshift cloud based data warehouse service (Blogger) (World Wide Web log), NL: Google .
  4. ^ a b "Amazon Redshift Partners", AWS Partner Network, Amazon, 2017-02-06, archived from the original on 2017-02-06 .
  5. ^ https://aws.amazon.com/redshift/partners-detail/pentaho/ "Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift."
  6. ^ http://www.pentaho.com/amazon-web-services#tab-1 "then transformed, refined, and immediately pushed into Amazon Redshift."
  7. ^ "Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Retrieved July 8, 2013.