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 Good Gear Guide newsletter!

Error: Please check your email address.

Tags ingresdatabases

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

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

Essentials

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >

Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Mobile

Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >

Exec

Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards 

Learn more >

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

HD Pan/Tilt Wi-Fi Camera with Night Vision NC450

Learn more >

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Budget

Back To Business Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Michael Hargreaves

Windows 10 for Business / Dell XPS

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Kathy Cassidy

STYLISTIC Q702

First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.

Anthony Grifoni

STYLISTIC Q572

For work use, Microsoft Word and Excel programs pre-installed on the device are adequate for preparing short documents.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?