Ingres and Yellowfin team for rapid reporting

Stephen Withers
Tuesday, 05 April 2011 08:00

Database vendor Ingres and business intelligence specialist Yellowfin have teamed up for joint sales of VectorWise and Yellowfin as a complete, fast and easy to use enterprise reporting and analytics system.

Ingres' Melbourne office overlooks the Melbourne Grand Prix circuit in Albert Park, so the company followed the lead of the the Grand Prix's 'ultimate speed comparison' handicap race between a C63 Mercedes, a V8 Supercar and a Formula 1 car.

While the 55 second headstart for the Mercedes and 24 seconds for the V8 saw all three vehicles cross the finishing line in short order, it turned out that the database shootout needed a bigger handicap.

An unspecified commercial database ("we can't actually say what it is because of the contract [which forbids the publication of comparative performance]," said John Ryan, Asia Pacific marketing manager at Ingres Australia) was given a 55 second handicap against Ingres VectorWise running the same query on the same data on identical hardware. VectorWise returned the result in less than one second, whereas 'brand X' took well over three minutes.

The test involved a 12GB database containing 72 million rows, based on the data from the DBT3 benchmark.

Jason Leonidas, vice president, Asia Pacific sales and services, explained that most DBMSes are generic and require a lot of tuning to suit any particular workload, whereas VectorWise is designed for excellent performance on ad hoc queries. It show that "what you should be using [in those situations] is a purpose-built database," ie VectorWise.

VectorWise promises rapid 'slicing and dicing' - see page 2.