Amazon Redshift

Amazon Redshift is an Internet hosting service and data warehouse product which 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 big data data sets stored by a column-oriented DBMS principle. To be able to handle large scale data sets and database migrations[2] 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.[3] PostgreSQL 8.0.2 was released in 2005 and PostgreSQL has seen massive development since then. Many PostgreSQL features are not supported.[4]

Business intelligence tools

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

Business intelligence partners

Data integration partners

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

System integration and consulting partners

History

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

References

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

  This article uses material from the Wikipedia page available here. It is released under the Creative Commons Attribution-Share-Alike License 3.0.


Amazon_Redshift
 
Connect with defaultLogic
What We've Done
Led Digital Marketing Efforts of Top 500 e-Retailers.
Worked with Top Brands at Leading Agencies.
Successfully Managed Over $50 million in Digital Ad Spend.
Developed Strategies and Processes that Enabled Brands to Grow During an Economic Downturn.
Taught Advanced Internet Marketing Strategies at the graduate level.


Manage research, learning and skills at defaultLogic. Create an account using LinkedIn or facebook to manage and organize your IT knowledge. defaultLogic works like a shopping cart for information -- helping you to save, discuss and share.


  Contact Us