1. How to Escape the MPP Database Schema Management Hell
3/10/2015 2:14:12 PM
How to Escape the MPP Database Schema Management Hell
Massively Parallel Processing,Analytic Queries,MPP Databases,Redshift,Schema Management
App Developer Magazine
How to Escape the MPP Database Schema Management Hell

How to Escape the MPP Database Schema Management Hell

Stuart Parkerson Stuart Parkerson in Enterprise Tuesday, March 10, 2015

Today’s massively parallel processing (MPP) databases’ ability to run large-scale analytic queries very quickly make them great tools for iterative data exploration. And Cloud offerings like Redshift are causing MPP databases to enjoy increasing adoption outside of enterprise IT.

However, schema management and data loading are two areas where MPP databases require an enormous amount of technical expertise and engineering manpower. There are ways to mitigate this problem with solutions offered by companies like Treasure Data, a company that offers a cloud service for the entire data pipeline, including acquisition, storage, and analysis. 

Using Treasure Data alongside MPP databases can significantly lessen the impact of these types of issues. To explain how, Treasure Data’s Kiyoto Tamura has published an article explaining how migrating from a “Redshift only” setup to “Treasure Data + Redshift” setup facilitates the elimination of schema management and data loading challenges.
You can check out Tamura’s full how-to article on the Treasure Data website.

Read more: http://blog.treasuredata.com/blog/2015/02/27/schem...

Subscribe to App Developer Magazine

Become a subscriber of App Developer Magazine for just $5.99 a month and take advantage of all these perks.


  • - Exclusive content from leaders in the industry
  • - Q&A articles from industry leaders
  • - Tips and tricks from the most successful developers weekly
  • - Monthly issues, including all 90+ back-issues since 2012
  • - Event discounts and early-bird signups
  • - Gain insight from top achievers in the app store
  • - Learn what tools to use, what SDK's to use, and more

    Subscribe here