Table Size Optimization For Small Datasets In Amazon Redshift

Amazon Redshift is a fast, fully managed, petabyte-scale Data Warehouse (DWH) solution. It is a columnar Database and facilitates massive parallel processing (MPP). In any DWH solution, we always have facts, Dimensions, Xref, etc. types of datasets which vary significantly in size. Hence, It is not wise to use default redshift setting for all sizes of datasets.

To design an efficient redshift based DWH solution one need to be aware of various Static and dynamic variables which control the size and performance of the environment.

Read More..

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s