Bota5ky

AWS学习笔记(十八):QuickSight, Redshift

QuickSight

Amazon QuickSight允许您的企业中的所有人通过使用自然语言提问以了解您的数据,通过交互式控制面板探索,或自动查找由机器学习支持的模式和异常值。

Redshift

  • Redshift is based on PostgreSQL, but it’s not used for OLTP
  • It's OLAP – online analytical processing (analytics and data warehousing)
  • 10x better performance than other data warehouses, scale to PBs of data
  • Columnar storage of data (instead of row based)
  • Massively Parallel Query Execution (MPP)
  • Pay as you go based on the instances provisioned
  • Has a SQL interface for performing the queries
  • BI tools such as AWS Quicksight or Tableau integrate with it
posted @ 2022-05-02 19:49  Bota5ky  阅读(220)  评论(0)    收藏  举报