March 5, 2009

Fox Interactive Media’s multi-hundred terabyte database running on Greenplum

Greenplum’s largest named account is Fox Interactive Media — the parent organization of MySpace — which has a multi-hundred terabyte database that it uses for hardcore data mining/analytics. Greenplum has been engaging in regrettable business practices, claiming that it is in the process of supplanting Aster Data at Fox/MySpace. In fact, MySpace’s use of Aster is more mission-critical than Fox’s use of Greenplum, and is increasing significantly.

Still, as Greenplum’s gushing customer video with Fox Interactive Media* illustrates, the Fox/Greenplum database is impressive on its own merits. Indeed, the Fox/Greenplum database seems to be larger than the one MySpace runs on Aster, even though it seems to be used less intensively. Perhaps data is thrown out from the Aster database but never from the Greenplum one, or perhaps the Greenplum database just ingests more data in the first place.

*The Greenplum video features completely different customer personnel than Aster’s. I’m sure of this because all the Fox people on the Greenplum video are male, while all the MySpace techies on Aster’s video are female.

In particular, Fox Interactive uses a database architectural idea I’m hearing ever more about. Within the data warehouse, it creates data mart “sandboxes,” that analysts can use however they wish. They can even create and delete tables without screwing up the underlying data. eBay famously uses a similar approach in its Teradata installation, and I believe Dell’s DATAllegro data warehouse is set up that way as well.

Related links

Categories: Analytic technologies, Aster Data, Data warehousing, Fox and MySpace, Greenplum, Specific users, Theory and architecture, Web analytics 
Subscribe to our complete feed!

Comments

3 Responses to “Fox Interactive Media’s multi-hundred terabyte database running on Greenplum”

  1. eBay’s two enormous data warehouses | DBMS2 -- DataBase Management System Services on April 30th, 2009 6:26 am

    […] Interactive Media/MySpace has multi-hundred terabyte databases running on each of Greenplum and Aster Data […]

  2. More on Fox Interactive Media’s use of Greenplum | DBMS2 -- DataBase Management System Services on June 8th, 2009 12:48 am

    […] most important reference is probably its energetic advocate Fox Interactive Media, even ahead of much larger user Greenplum user eBay, and notwithstanding Aster Data’s large […]

  3. Stakeholder-facing analytics | DBMS2 -- DataBase Management System Services on May 15th, 2010 3:58 am

    […] part of Fox — perhaps MySpace Music? — offers free access to a PostgreSQL extract from its Greenplum database to each of its largest […]

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.