HOUSTON, December 2 /PRNewswire/ --

- Smash cost performance barriers by extracting, transforming and loading 5.4 terabytes on HP BladeSystem c-Class in less than one hour

Syncsort (http://www.syncsort.com/), a global leader in data integration, data protection and high-speed sorting software, and Vertica, the market innovator for high-performance analytic database management systems, in collaboration with HP have set a new world record for loading data into a relational database for business intelligence applications powered by HP BladeSystem c-Class. This new world record meets the growing need for faster loading speed while empowering enterprises to rapidly integrate data from disparate sources. With data warehouses dramatically increasing in size, this achievement enables companies to accelerate ROI and make better and more timely business decisions.

(Logo: http://www.newscom.com/cgi-bin/prnh/20000922/SYNCSORTLOGO )

This new world record shatters the previous extraction, transformation and load (ETL) performance benchmark. Syncsort's data integration product, DMExpress(TM) (http://www.syncsort.com/products/dmx/home.htm) v4.8 extracted, transformed, cleansed and loaded 5.4 TB of raw data into the Vertica Analytic Database in 57 minutes 21.51 seconds, using highly cost-efficient HP BladeSystem c-Class running the RedHat Linux operating system. The data was generated using the data generation tool of the industry-standard TPC-H benchmark.(*)

Our customers - from industries such as finance, insurance, telecommunications, consumer packaged goods, retail, pharmaceuticals, and e-commerce - are telling us that they need to process and load exponentially growing volumes of data rapidly so that they can make critical decisions, said Harvey Tessler, Syncsort's Senior Vice President of Marketing. Our solution is designed to meet these goals while controlling costs.

The Syncsort/Vertica solution was run on two HP BladeSystem c7000 enclosures using a combination of server blades and storage blades. The efficiency of the software combined with the modularity and manageability of HP BladeSystem c-Class offered an unparalleled level of control, adaptive flexibility, and performance. The density and flexibility of HP BladeSystem enabled the entire 16 node shared-nothing cluster, including all disk storage, to fit in less than a half rack (20U) with excellent energy efficiency.

The breaking of the ETL World Record by Syncsort and Vertica on HP BladeSystem c-Class is also the first to be achieved using a columnar database. Until now, column-oriented databases have been seen as having a disadvantage in data loading speeds, over traditional row-oriented databases, said David Menninger, Vice President of Marketing Product Management of Vertica. Next-generation database technology turned that paradigm on its ear, radically accelerating query performance against terabytes of data, without making data loading the weak link in the chain. We designed the Vertica Analytic Database and partnered with Syncsort to deliver the fastest possible performance across the deployment cycle.

Organizations want cost-effective solutions to help them make more timely business decisions, such as been demonstrated by Syncsort, Vertica and HP, said Steve Gillaspy, group manager for BladeSystem at HP. The combination of these data integration and analytic database technologies and the affordable, high-performance and standards-based HP BladeSystem c-Class creates a compelling solution for many business analytics.

When combined with the Vertica Analytic Database, companies can give their experts faster access to larger volumes of data so they can out-think and out-execute their competitors.

The Vertica Analytic Database has answered queries against terabytes of data 50 to 200 times faster than competing data warehouse technologies using less hardware and disk space at a fraction of the cost of other products.

Benchmark Details

The performance and scalability of DMExpress v4.8 and Vertica v2.5 was tested using 16 two quad-core HP ProLiant BL460c server blades and 16 HP StorageWorks SB40c storage blades. The data generation tool (DBGEN) of industry-standard TPC-H benchmark was used to generate the source data which represents business data that contains a variety of data types.

The benchmark results were independently audited and verified by George Spofford of DSS Labs.

For more details on the Syncsort-Vertica solution, or to download a white paper detailing the record-setting results written by DSS Labs, visit http://www.ETLWorldRecord.com.

Claudia Imhoff of Intelligent Solutions (http://www.intelsols.com/), a noted BI and data warehousing expert and author, will host a webcast explaining the implications of the new benchmark Tuesday, December 16, 2008, 2:00 pm EST. Please visit http://www.vertica.com for details.

About Syncsort Incorporated

Syncsort Incorporated has a 40 year history of developing and marketing high performance, extremely reliable data management and data protection software, supported by world-class technical services. DMExpress, Syncsort's fast and cost-efficient data integration software, is the solution to your data management performance challenges. When it comes to large volumes of data, DMExpress makes ETL, data warehousing, business intelligence and other large volume applications run even faster. Syncsort is headquartered in Woodcliff Lake, NJ. For more information call +1-201-930-9700 (1-877-951-FAST in the US and Canada) or visit www.syncsort.com.

About Vertica

Vertica Systems is the market innovator for high-performance analytic database management systems that run on industry-standard hardware. Co-founded by database pioneer Dr. Michael Stonebraker, Vertica has developed grid-based, column-oriented analytic database technology that lets companies of any size store and query very large databases orders of magnitude faster and more affordably than other solutions. The Vertica Analytic Database's unmatched speed, scalability, flexibility and ease of use helps customers like JP Morgan Chase, Verizon, Mozilla, Comcast, Level 3 Communications and Vonage capitalize on business opportunities in real time. Vertica is headquartered in Billerica, MA. For more information, visit the company's Web site at http://www.vertica.com.

(*)The data generation tool (DBGEN) from industry standard TPC-H benchmark was used for generating the source data. This result does not represent TPC-H benchmark hence can not be compared to any published TPC-H results.

Cassel Kroll, of Horn Group, +1-646-202-9783, ckroll@horngroup.com, for Syncsort; Ed Marshall of Beaupre Co. Public Relations, +1-603-559-5816, emarshall@beaupre.com for Vertica. Photo: http://www.newscom.com/cgi-bin/prnh/20000922/SYNCSORTLOGO