Slashdot Mirror


Web Analytics Databases Get Even Larger

CurtMonash writes "Web analytics databases are getting even larger. eBay now has a 6 1/2 petabyte warehouse running on Greenplum — user data — to go with its more established 2 1/2 petabyte Teradata system. Between the two databases, the metrics are enormous — 17 trillion rows, 150 billion new rows per day, millions of queries per day, and so on. Meanwhile, Facebook has 2 1/2 petabytes managed by Hadoop, not running on a conventional DBMS at all, Yahoo has over a petabyte (on a homegrown system), and Fox/MySpace has two different multi-hundred terabyte systems (Greenplum and Aster Data nCluster). eBay and Fox are the two Greenplum customers I wrote in about last August, when they both seemed to be headed to the petabyte range in a hurry. These are basically all web log/clickstream databases, except that network event data is even more voluminous than the pure clickstream stuff."

6 of 62 comments (clear)

  1. The good news... by Yoozer · · Score: 5, Funny

    At least these won't get out in the open that easily because someone copied them to an USB drive and lost it somewhere.

    1. Re:The good news... by Jurily · · Score: 2, Funny

      At least these won't get out in the open that easily because someone copied them to an USB drive and lost it somewhere.

      Imagine a Beowulf cluste- OW! OW!

  2. Re:Web Analytics Databases Get Every Larger? by jez9999 · · Score: 3, Funny

    Yesy. It mighty take a whiley to get used to, but I thinky it's quite a plusy overall.

  3. Sure, they get every larger... by lunchlady55 · · Score: 2, Funny

    ...but do they move every zig?

  4. Re:Another win for PostgreSQL... by pfleming · · Score: 2, Funny

    Does the black hole effect help with compression?

  5. Still get lame recomendations by se7en11 · · Score: 4, Funny

    With all that user data, you'd think they would know me better by now. But I still get these lame recommendations.

    "You might be interested in action DVDs because you bought one in the past" - BRILLIANT!!