Recommended: Click here to run a Free driver update scan »
The significant benchmarks were achieved in large part due to the unique compressioncapability of Sybase IQ, a highly optimized analytics server not only forcompression but also for query performance and lightning speed load performance.Sybase IQ demonstrated capability that allows organizations to easily future-prooftheir data warehouses and analytics systems using technology available today. Theworld s largest data warehouse depends on Sybase IQ s unique compression capabilityto store one petabyte of raw data including unstructured data (emails, documents andmultimedia) using only 160 terabytes of storage. This huge savings in storageachieves a 90 percent reduction in CO2 emissions. Organizations using thisarchitecture will be able to scale their data warehouses well beyond today srequirements at substantially lower storage costs, lower cooling requirements andlower energy costs than alternatives. Smaller data warehouses can also expectsimilar results.
"This is by far the largest Data Warehouse in the world and great achievement andmilestone for Sybase. It provides true validation for the Sybase offerings in thisspace and further reinforces all the efforts we are making in the Middle East in theIntelligent Enterprise practice. Sybase is having a great year so far and with thislatest development we are looking forward to enjoying even more success in the yearsto come", said Tony Achkar, General Manager of Sybase Products Middle East.
Nearly 1,000 organizations use Sybase IQ analytics server to meet their demand forbusiness intelligence, advanced analytics, predictive modeling, stringent regulationcompliance and rapid reporting. The Sybase IQ analytics server allows users toaggregate immense data stores and accelerates analytics processing up to 100 timesfaster than traditional solutions.
Sun provided the Sun SPARC Enterprise M9000 server, which features high performancedual-core SPARC64 VI processors and up to 2 TB memory, and the Sun StorageTek(TM)6540 system that gave Alvion needed storage capacity and snapshot capabilities.
Results of the benchmark were audited and verified by InfoSizing, an independentthird-party auditing firm. As noted in the report, The Sun Data Warehouse ReferenceArchitecture, powered by the Solaris 10 Operating System, a Sybase IQ analyticsserver and BMMsoft DataFusion on a Sun SPARC Enterprise M9000 server interconnectedto three Sun StorageTekTM 6540 systems, demonstrated several significantachievements:
It loaded 1 Petabyte of raw transactional data (6 Trillion stock quote records) ina fully indexed star schema; creating a new, independently verified record for theworld s largest data warehouse. It reached a load speed of 285 billion rows per day (3 Million rows per second)and sustained that database population pace for a period of over 3 weeks. It showed an 85% data compression ratio by storing a Petabyte of raw transactionaldata in less than 260 Terabytes of actual disk space. It demonstrated an average Ready-Time of less than 2 seconds for data freshlyadded to the data warehouse. It replaced half of the T (Transactional) data with over 72 Terabytes of EDM (Emails, Documents and Multimedia) data, creating a data warehouse populated with572 Terabytes of raw EDMT data. It showed a load speed of 26 Terabytes per day when populating the data warehousewith 185 million documents (emails, attachments and other unstructured documents.)It reached loading rates of 2 million emails per hour and 6 million documents perhour while consuming less than 7% of the available CPU power, leaving the other 93%of the SPARC Enterprise M9000 server CPUs available for Sybase IQ to respond toreporting and analytic queries. It demonstrated a substantial reduction in the number of disk drives needed forstorage, translating directly into at least 90% reduction in CO2 emissions over thelifetime of the Sun Data Warehouse Reference Architecture with Solaris 10, Sybase IQand BMMsoft DataFusion.
The results of this benchmark show that Sybase IQ demonstrated its capability tohandle real-world scenarios comparable to the transactions processed across theworldwide financial trading networks over multiple years, said Francois Raab,president, InfoSizing. Sybase IQ has proven its reliability in handling the volumeof multimedia documents representative of the electronic communication between halfa million financial traders.
Breaking these records shows that Sybase IQ is the correct choice for companies whoexpect significant growth in their data warehousing and analytics, particularlythose looking to provide on-demand analytics to a large user community and advancedanalytics applications where more data powers better answers, said Dr. Raj Nathan,chief marketing officer, Sybase. Sybase s vision for an Unwired Enterprise requiresthat companies can remove all the limits. Information should be available anytime,anywhere.
This benchmark is further proof that Sybase IQ is a good choice for analyticsservice providers, said Richard Winter, President, WinterCorp. Sybase IQ providesgood performance and scalability for ad hoc queries and analytics at an attractiveprice.
About Sybase: Sybase is the largest enterprise software company exclusively focusedon managing and mobilizing information from the data center to the point of action.Sybase provides open, cross-platform solutions that securely deliver informationanytime, anywhere, enabling customers to create an information edge. The world smost critical data in commerce, communications, finance, government and healthcareruns on Sybase. With Sybase, customers can optimize and enhance the investmentsthey already own, link together the valuable data resources already in place, andextend the reach of business-critical information to users on the front lines givingthem a financial, agility and productivity edge across all areas of their business.For more information, visit the Sybase Web site: http://www.sybase.ae Sybase is a trademark of Sybase, Inc. indicates registration in the United Statesof America.
Sybase is a registered trademark of Sybase, Inc. All other company and product namesmentioned may be trademarks of the respective companies with which they areassociated.
Sun, Sun Microsystems, Solaris and StorageTek are trademarks or registeredtrademarks of Sun Microsystems, Inc. in the United States and other countries. AllSPARC trademarks are used under license and are trademarks or registered trademarksof SPARC International, Inc. in the United States and other countries. Productsbearing SPARC trademarks are based upon an architecture developed by SunMicrosystems, Inc.
