Ingres works on hardware-savvy database engine

Ingres' VectorWise engine pushes databases to take advantage of new chip capabilities

Ingres plans to use a new engine that exploits the latest chip hardware for faster execution of database-related tasks, the company said on Wednesday.

The engine, developed with a company called VectorWise, takes advantage of hardware enhancements like faster chips and larger caches to perform more tasks at the same time on a chip, said Roger Burkhardt, CEO of Ingres.

Ingres plans to integrate the new code in its database to take advantage of hardware features found in new chips like Intel's Xeon. The new chips include beefier pipelines and special instruction sets for faster task execution on a single core.

Certain workloads -- like video games and photo editing -- are written to take advantage of the latest chips, but database systems have traditionally not been written for parallel execution, Burkhardt said.

The VectorWise engine asks chips to execute multiple data sets at one time as opposed to in single rows, speeding up simultaneous task execution.

"The net result is at any one point in a single core -- it depends on the circumstances -- you might have a hundred instructions in flight at any one time," Burkhardt said. That is one level of fine-grained parallelism, said Burkhardt.

Another way VectorWise tries to speed up task execution is by simplifying code and reducing data dependencies, Burkhardt said.

Typical databases lose time with complicated routines that could slow down task execution. VectorWise also enables in-cache execution, which allows for efficient execution of code while using memory only as a buffer.

Previously, large servers were needed to execute those kind of tasks, but hardware advancements have brought those capabilities to laptops. The engine could help $US2,000 laptops do what expensive computers were previously needed for, Burkhardt said.

"As an individual businessperson, if you want to analyze tens or hundreds of millions of rows, you can do that and get the results back in a few seconds," Burkhardt said.

The project is being done in partnership with VectorWise, which was spun off from Centrum Wiskunde and Informatica (CWI), a research organization in Amsterdam. CWI is known for inventing programming languages like Python.

Ingres read about performance improvements provided by the engine in a research paper developed by VectorWise and was blown away by the results, Burkhardt said.

"We chose to team up with them to take what they had done and ... bring it to market inside the Ingres database," Burkhardt said.

Company officials couldn't provide an exact date on when the engine could reach the market.

The performance improvements were realized across a range of chips, including Intel's Nehalem chips and Advanced Micro Devices' Opteron server chips.

Performance improvements also showed on Intel's Itanium processors and chips based on the RISC (reduced instruction set computer) architecture.

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags databasesingres

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Agam Shah

IDG News Service
Show Comments

Father’s Day Gift Guide

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Laura Johnston

MSI GS65 Stealth Thin

If you can afford the price tag, it is well worth the money. It out performs any other laptop I have tried for gaming, and the transportable design and incredible display also make it ideal for work.

Andrew Teoh

Brother MFC-L9570CDW Multifunction Printer

Touch screen visibility and operation was great and easy to navigate. Each menu and sub-menu was in an understandable order and category

Louise Coady

Brother MFC-L9570CDW Multifunction Printer

The printer was convenient, produced clear and vibrant images and was very easy to use

Edwina Hargreaves

WD My Cloud Home

I would recommend this device for families and small businesses who want one safe place to store all their important digital content and a way to easily share it with friends, family, business partners, or customers.

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?