Feeds

Ingres' VectorWise rises to answer Microsoft

Open-source stealth project slips out

Security for virtualized datacentres

Ingres is inviting data munchers to take a bite out of its planned software architecture targeting high-performance analytics.

The open-source database company has released alpha code for its VectorWise project, a high-performance storage engine computing-intensive data warehouses running on standard Intel boxes. A first beta of VectorWise is planned for the current quarter.

Ingres claimed VectorWise is between 10 and 15 times faster than rival computational, client products that run on a single, multi-core machine.

VectorWise achieves this by allowing standard SQL applications to access the compute power on multi-core chips while serving up huge blocks of data, Ingres said

The project is designed to bring data warehouse-levels of processing and performance to standard clients. It started after Microsoft purchased specialist DataAllegro, which had been working with Ingres. Features from DataAllergro are now due to appear in the Datacenter Edition of Microsoft's SQL Server 2008 R2, planned for release in May.

That product is being tuned to hardware running up to 256 logical processors and an unlimited number of virtual machines per license.

Ingres has worked on its project with VectorWise, which spun-out from mathematics and computer scientific research hothouse Centrum Wiskunde and Informatica (CWI) and whose brains worked on the MonetDB.

Bill Maimone, Ingres senior vice president of worldwide engineering, told The Reg VectorWise is for machines with hundreds of gigabytes or terabytes of data where the user wants to do complex queries and that involve lots of computation.

The system is designed to simplify the construction of parallel data warehouse systems using SQL, where you've got to design roll up objects or define objects in a cube, where you have to guess what queries will be made. In some cases, people are writing hand-coded programs against flat files.

Not only are such architectures complex to build, servers are bolted on to provide additional performance, further complicating the architecture itself and meaning additional expense and systems management overhead.

To speed the performance in the VectorWise project, Ingres has done a number of things to let the software work with changes in the underlying x86 hardware.

Instead of managing data buffers in random access memory, VectorWise uses the cache on the underlying chip, while all instructions are loaded from cache onto a multi-core chip. Maimone reckoned most business applications only use 10 per cent of the available capacity in the underlying multi-core chip for processing.

VectorWise also transfers a large amount of data to get around the fact that while processors are speeding up, discs can only go so fast: VectorWise will read up to 500kilobytes of data compared to the usual rate of between four and eight kilobytes. ®

Remote control for virtualized desktops

More from The Register

next story
PEAK APPLE: iOS 8 is least popular Cupertino mobile OS in all of HUMAN HISTORY
'Nerd release' finally staggers past 50 per cent adoption
Microsoft to bake Skype into IE, without plugins
Redmond thinks the Object Real-Time Communications API for WebRTC is ready to roll
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
Mozilla: Spidermonkey ATE Apple's JavaScriptCore, THRASHED Google V8
Moz man claims the win on rivals' own benchmarks
Yes, Virginia, there IS a W3C HTML5 standard – as of now, that is
You asked for it! You begged for it! Then you gave up! And now it's HERE!
FTDI yanks chip-bricking driver from Windows Update, vows to fight on
Next driver to battle fake chips with 'non-invasive' methods
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Ubuntu 14.10 tries pulling a Steve Ballmer on cloudy offerings
Oi, Windows, centOS and openSUSE – behave, we're all friends here
prev story

Whitepapers

Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
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.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Top 5 reasons to deploy VMware with Tegile
Data demand and the rise of virtualization is challenging IT teams to deliver storage performance, scalability and capacity that can keep up, while maximizing efficiency.
Mitigating web security risk with SSL certificates
Web-based systems are essential tools for running business processes and delivering services to customers.