Adding compression to large, uncompressed columns will have a big impact on cluster performance. Compression accomplishes two things: Reduce storage utilization . Because file compression reduces the size footprint of...

Amazon Redshift launched with disruptive pricing. To compare the cost, we’re looking at the price for storing 1TB of data for one year ($ / TB / Year). With a...

Table of Contents The Simplified Problem A Better Solution A Real-World Example Lessons Learned Query optimization that dramatically reduces runtime for queries which use window functions . The Simplified Problem...

Wish Wish is a mobile commerce platform. It provides online services that include media sharing and communication tools, personalized and other content, as well as e-commerce. During the last few...

At Integrate.io, with much of our infrastructure on AWS, we try to make use of the various AWS services available to us. One of these is Amazon Opsworks.

A first look at the new RA3 Amazon Redshift node type Table of Contents Introduction Specs Copy Performance I/O Performance Real-world performance Separation of Storage and Compute Conclusion Introduction Today...

Is a NoSQL database better than one that follows the relational model, or vice versa?

AWS announced yesterday that they are rolling out a newer generation DS2 Amazon Redshift that has 50% better performance compared to what they previously offered, at the exact same price.

Everything from cloud-based data warehousing solutions like Amazon Redshift to data storage techniques like database replication have evolved due to these massive strides in technology.