Amazon Redshift Analytics Database features--essential or column storage

Source: Internet
Author: User

Amazon Redshift is a fast, fully managed, petabyte-scale data Warehouse that enables you to cost-effectively and easily analyze all your data with existing business intelligence tools. From a minimum of 0.25 USD per hour (without any obligation) up to $ (PB) per terabyte/TB/year, the cost is less than one-tenth of the traditional solution. Customers typically compress 3 times times, which is to reduce their cost to 333 USD per TB (uncompressed) annually.

Q: What is the performance of Amazon Redshift compared to the most traditional data warehouse storage and analysis databases?

Amazon Redshift uses a variety of innovative technologies to improve its performance by nearly 10 times times compared to traditional data warehousing and analytics databases:

      • column data storage : Amazon Redshift organizes data in columns, not as a series of rows. Unlike row-based systems for transactional processing, column-based systems are suitable for data warehouse storage and analysis, where queries often involve aggregating large datasets. Because only the columns that are involved in the query are processed, and the column data order is stored on the storage medium, the column-based system requires much less I/O, which significantly improves query performance.
      • Advanced Compression : Column data stores are more compressed than row-based data stores because similar data is stored sequentially on the hard disk. Amazon Redshift has a number of compression technologies that are often compressed to a large extent compared to traditional relational data stores. In addition, Amazon Redshift does not require an index or materialized view as compared to a traditional relational database system, so it uses less space. When you load data into an empty table, Amazon Redshift automatically samples your data and chooses the most appropriate compression scheme.
      • massively parallel Processing (MPP): Amazon Redshift automatically allocates data and query load across all nodes. Amazon Redshift can easily add nodes to your data warehouse and maintain fast query performance as your Data warehouse grows.

Amazon Redshift Analytics Database features--essential or column storage

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.