The Business Intelligence Blog

One Petabyte of mixed relational and unstructure data. That’s neat.

More from the Sybase Press Release -

Sybase, Inc. (NYSE: SY), the largest enterprise software and services company exclusively focused on managing and mobilizing information, today announced that the Sybase® IQ analytics server has set a new Guinness World Record™ by powering the world’s largest data warehouse on a Sun™ SPARC® Enterprise M9000 server. This accomplishment was achieved using Sybase IQ, BMMsoft ServerSM and the Sun Microsystems® Data Warehouse Reference Architecture. This winning combination enables more data to be stored in less space, searched and analyzed in less time, while consuming 91 percent less energy and generating less heat and carbon dioxide than conventional solutions.

Powered by the category-leading column-oriented database Sybase IQ, the data warehouse is certified to support a record-breaking one petabyte of mixed relational and unstructured data—more than 34 times larger than the largest industry standard benchmark1 and twice the size of the largest commercial data warehouse known to date2. In total, the data warehouse contains six trillion rows of transactional data and more than 185 million content-searchable documents, such as emails, reports, spreadsheets and other multimedia objects.
..
..
Designed from the ground up as an analytics server, Sybase IQ produces its impressive results because of a unique architecture combining a column-oriented data structure with patented indexing and a scalable grid. Sybase IQ offers extraordinarily high performance at a lower cost than a traditional, row-oriented database. And, unlike traditional row-based data warehouses, the stored data in Sybase IQ is compressed by up to 70 percent of its input size, creating the most optimal and elegant analytics solutions.

“The results of this benchmark showcase Sybase IQ’s capabilities to handle real-world scenarios, querying vast amounts of data representing the transactions processed across the worldwide financial trading networks over multiple years.” said Francois Raab, president, InfoSizing, the consulting firm that oversaw the benchmarking of the record. “Sybase IQ has proven its production strength in handling the volume of multimedia documents representative of the electronic communication between half a million financial traders.”

Having used MySQL extensively for my personal blog and also on other pet projects that I have done, I’m perfectly sure that MySQL just like SQLite is certainly a cost-effective(!!) replacement for costly RDBMS systems. Having said that, MySQL isn’t perfect already. It certainly needs a good GUI front-end and needs some streamlining on the licenses, which is turning out to be a crazy affair these days.

Its interesting to see that Sun picked MySQL than the PostgreSQL that has become popular offlate. The industry would certainly be interested to see how Sun will turn this Open Source Platform into a business model. Interesting days ahead but MySQL Developer should drink an extra beer this weekend.

From Sun Ceo, Jonathan Schwartz’s Blog -

Both sets of customers confirmed what we’ve known for years - that MySQL is by far the most popular platform on which modern developers are creating network services. From Facebook, Google and Sina.com to banks and telecommunications companies, architects looking for performance, productivity and innovation have turned to MySQL. In high schools and college campuses, at startups, at high performance computing labs and in the Global 2000. The adoption of MySQL across the globe is nothing short of breathtaking. They are the root stock from which an enormous portion of the web economy springs.

The good news is Sun is already committed to the business model at the heart of MySQL’s success - first investing to grow communities of users and developers, and only then creating commercial services that attract (rather than lock in) paying customers. Over the past few years, we’ve distributed hundreds of millions of licenses and invested to build some of the free software world’s largest communities. From Java to ZFS, Lustre to Glassfish, NetBeans to OpenOffice.org and OpenSolaris, we’ve been patient investors and contributors, both. Free and open software has become a way of life at Sun. MySQL’s has similarly driven extraordinary adoption of their community platform, with more than 100 million downloads over the past 10 years. Their users, as with Sun’s, run MySQL across every major operating system - Linux, Windows, Solaris and the Mac; and every major system platform, from IBM, Intel, AMD, Dell, Sun and HP.