Slashdot Mirror

← Back to Stories (view on slashdot.org)

World's Largest Databases Ranked

Posted by CowboyNeal on from the cylinder-sizing dept.

prostoalex writes "Winter Corp. has summarized its findings of the annual TopTen competition, where the world's largest and most hard-working (in terms of load) databases are ranked. The results are in, and this year the contestants were ranked on size, data volume, number of rows and peak workload. I wrote up a brief summary of the top three winners in each category for those too lazy to browse the interactive WinterCorp chart."

4 of 356 comments (clear)

  1. Google by ScribeOfTheNile · · Score: 5, Interesting

    I would've expected to see Google in there somewhere.

  2. SQL Server? by B5_geek · · Score: 5, Interesting

    Does the SQL Server mean MS-SQL?

    I would have liked to see SQL vs non-SQL ranking too.

    --
    "The price good men pay for indifference to public affairs is to be ruled by evil men." ~Plato (427-347 BC)
  3. What surprised me... by MyNameIsFred · · Score: 5, Interesting

    I have none, nada, zip experience in big databases. But it surprised me that the peak workloads were measured in 100s of concurrent queries. If I had to make a wild guess, I would have guessed 10s of thousands. My blessed ignorance destroyed.

  4. Re:29 TB is the biggest? by mountainhouse · · Score: 5, Interesting

    I think the NCR Teradata approach is one of the most interesting. It is made up of a number of nodes (each quad Intel processor systems with separate memory and disk), each broken down into a number of logical machines. Data is hashed across all the nodes in the systems based on the data's indexing. So if two tables have the same indexing the join takes place at the "logical machine" level, and then the result is spooled together. The largest systems approach 300 nodes, with over 2,000 logical machines and 150 Tb of disk (some used to duplicate tables in case of node failure).

    Personally, it has it's drawbacks, but if the indexing is right, you can join hundred million row tables at amazing speed. Based on my experience in data warehousing, it's performance Oracle can't touch (no, I'm not paid by NCR...just a user).

    http://www.teradata.com

    Overview:
    http://www.teradata.com/t/go.aspx/?id =84960