Feeds

Ingres strikes back at Microsoft and Oracle iron appliances

Software and commodity cores, combined

Top 5 reasons to deploy VMware with Tegile

Two years after Microsoft nicked DataAllegro out from under Ingres, the open-source database vendor has delivered its hardware-loving storage and database response.

Ingres has released VectorWise, a database technology that utilizes the cache on multi-core chips to speed data crunching and analysis in massive data sets.

The VectorWise Project started in 2009 as a database spin-out from mathematics and computer scientific research hothouse Centrum Wiskunde and Informatica (CWI) after Microsoft bought DataAllegro - then working with Ingres. DataAllegro had already devised a test version of a storage engine with Ingres.

DataAllegro is now part of Microsoft's SQL Server 2008 R2 Parallel Data Warehouse built on hardware from Bull, Dell, EMC, HP and IBM. Microsoft's appliance is designed so that each node has dedicated CPU, memory, and storage, along with its own instance of SQL Server, in a parallel shared nothing architecture.

Microsoft is pitching the device as something that, by combining hardware and software, simplifies deployment and management of BI and analytics warehouses. It's the same shtick Oracle's been pushing with Exadata, with the Oracle database and Intel hardware.

Ingres is pushing VectorWise for crunching data on regular servers, without needing to buy specialized hardware optimized to work with a database and tools.

Chief executive Roger Burkhardt said VectorWise unlocks the power of what he called "modern" microprocessors without users having to configure the system themselves to optimize chip cache. He claimed performance gains of between 10 and 70 times over existing database and analytical servers running large, distributed data sets.

Burkhardt said not only does using regular servers mean lower price for customers, it means you don't have to depend on a single company for both hardware and software - something he claimed is alarming ISV customers he's spoken to when it comes to Oracle and Exadata.

"VectorWise is for customers who have a performance problem using Oracle today, have a new requirement, and know enough to know it's going to be extremely complex to solve it with Oracle," Burkhardt said.

Ingres is also pitching VectorWise as working with NoSQL, the data movement building large-scale data processing breaking with traditional SQL norms of storage for size and performance.

VectorWise works with Hadoop via the HadoopDB project, which will parse an SQL statement and make it run over 50 computers but act like it's on a single machine. The idea is you get the scale of Hadoop while retaining the familiarity and performance of working with SQL.

Daniel Abadi, director of Database Research at Yale University, where HadoopDB was invented, said in a statement that VectorWise underpins large-scale HadoopDB applications.

VectorWise is available for download, and priced on a subscription basis according to your number of cores. Two sockets with two cores starts at $24,000 per year, with discounts provided for volume, Burkhardt said. ®

Beginner's guide to SSL certificates

More from The Register

next story
Ellison: Sparc M7 is Oracle's most important silicon EVER
'Acceleration engines' key to performance, security, Larry says
Oracle SHELLSHOCKER - data titan lists unpatchables
Database kingpin lists 32 products that can't be patched (yet) as GNU fixes second vuln
Lenovo to finish $2.1bn IBM x86 server gobble in October
A lighter snack than expected – but what's a few $100m between friends, eh?
Ello? ello? ello?: Facebook challenger in DDoS KNOCKOUT
Gets back up again after half an hour though
Troll hunter Rackspace turns Rotatable's bizarro patent to stone
News of the Weird: Screen-rotating technology declared unpatentable
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.
The next step in data security
With recent increased privacy concerns and computers becoming more powerful, the chance of hackers being able to crack smaller-sized RSA keys increases.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.
A strategic approach to identity relationship management
ForgeRock commissioned Forrester to evaluate companies’ IAM practices and requirements when it comes to customer-facing scenarios versus employee-facing ones.