Sybase IQ Sets Guinness World Record for Largest Data Warehouse

http://www.sybase.com
We are here today at the Guinness World Record Headquarters in New York City, and I am with Kathleen Shaub and Irfan Khan. My name is Danny Girton. I am one of the judges at Guinness World Records, and, on behalf of Guinness World Records, it is with great pleasure that we welcome Sybase, Sun and BMM Soft into the World Records family for the worlds largest data warehouse. We congratulate everyone in this record breaking achievement. Thank you, Danny. On behalf of Sybase and our partners, Sun and BMM Soft, I would like to say how honored we really are to join the Guinness family and be part of the 2009 records. If fact, I would like to thank everybody who has been involved with Sybase IQ and this project since its inception, all the developers, the QA teams and all of the customers. Its really been a great experience and we are very proud to be here. Sybase and partners just achieved the world record for the largest data warehouse, thats incredible. Why is this so important? Whats behind this record? Well, today if you take a look at most organizations, they store terabytes of data. We need to give them some future proofing so as they are growing their businesses, and the amounts of data that they physically store, this will absolutely get towards toward the petabyte level. We are actually getting together, we have worked with our partners, a road map and, at the same time, some future proofing of technologies to be able to support and sustain that level of data. Just how big is a petabyte? Well, to give you an idea of scale, its about 6 trillion stock quotes or the contents of about a thousand academic libraries. It has a 1 with 15 zeros after it. Its a pretty big number. That is an incredible amount of data. That must take tons of computer space. Well actually, if we used a conventional database for this record, it would have taken 29 tons of storage hardware to hold all that information. But, we used Sybase IQ, a column based database, which compresses, and so we used only 85% of that amount. Possibly even more importantly, we were able to reduce the carbon emissions from this data warehouse by over 90%. What was the data warehouse made of? Danny, we loaded one petabyte of raw data into a column based database, Sybase IQ, and then we ran that on the Sun M9000 service. Now, this has given us some tremendous capacity because, when you combine that with the BMM Soft column based management suite, we get a great solution and a great data warehouse experience.

Category:

Science & Technology

Tags:

• Sybase IQ
• guinness world record
• column oriented database
• Sybase
• sun servers
• bmmsoft
• carbon footprint
• data warehouse
• colum based database
• petabyte data warehouse
• database