Greenplum’s 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 presence in Fox subsidiary MySpace. I just ran across a “review” of Greenplum by FIM’s Brian Dolan, neatly summarizing his views about Greenplum’s strengths, weaknesses, and uses inside Fox. Highlights include:
DELIVERABLES: Our research analytics team uses Greenplum Database to conduct tens of thousands of real-time [statistical] tests against millions of users every day, analyzing each visitor’s reaction to ads against more than 2,000 variables. This analysis is turned into reports for the BI, database administrators, systems engineering and product teams.
VENDOR SUPPORT: We’ve had nothing but positive interactions with the Greenplum team, from first sales call through to implementation and support. The technical team has been able to answer all of our questions, and we have the utmost respect for the engineering minds behind Greenplum Database.
WEAKNESSES: The ability to prioritize and balance queries at run time is a weakness. This would allow more effective sharing of resources between power users and reporting tasks. Second, the query optimizer is still immature.
Also, when Greenplum briefed on its Enterprise Data Cloud vision, it gave me a couple of details about what Fox was doing in that area. For starters, Brian Dolan has a team of analysts, single-digit in number, each with his/her private Greenplum sandbox, just like the vision says they should have. Second, it so happens that Fox has some customer/partner-facing data marts fed by the Greenplum database, but those are run on PostgreSQL rather than Greenplum.