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

Brand Post

Shining a light on creativity

MSI has long pushed the boundaries of invention with its ever-evolving range of laptops but it has now pulled off a world first with the new MSI Creative 17.

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Tom Pope

Dynabook Portégé X30L-G

Ultimately this laptop has achieved everything I would hope for in a laptop for work, while fitting that into a form factor and weight that is remarkable.

Tom Sellers

MSI P65

This smart laptop was enjoyable to use and great to work on – creating content was super simple.

Lolita Wang

MSI GT76

It really doesn’t get more “gaming laptop” than this.

Jack Jeffries

MSI GS75

As the Maserati or BMW of laptops, it would fit perfectly in the hands of a professional needing firepower under the hood, sophistication and class on the surface, and gaming prowess (sports mode if you will) in between.

Taylor Carr

MSI PS63

The MSI PS63 is an amazing laptop and I would definitely consider buying one in the future.

Christopher Low

Brother RJ-4230B

This small mobile printer is exactly what I need for invoicing and other jobs such as sending fellow tradesman details or step-by-step instructions that I can easily print off from my phone or the Web.

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?