Ingres unveils multicore-aware database

Using research funded in part by Intel, Ingres has released a newly re-engineered version of its open-source database management system, called Ingres VectorWise 

 

The company claims that this database engine, when used for analyzing large data sets, can run 10 to 70 times faster than standard SQL relational database systems, based on beta versions run by customers.

 

Amsterdam research institute CWI originally developed the underlying database engine, called VectorWise, spinning off a company of the same name to commercialize the technology. Intel helped fund development of the technology.

 

The performance gains come about thanks to changes in how the query processing works, said Roger Burkhardt, CEO of Ingres. The architecture takes advantage of features in Intel Nehalem-based processors, such as out-of-order execution capabilities, chip multithreading and larger L2/L3 caches.

 

The software also uses novel compression algorithms and data-storing procedures. “VectorWise data decompression can make queries that would otherwise become I/O bound significantly faster. It can even accelerate parallel queries where multi-core CPUs would otherwise become RAM bandwidth starved,” states a white paper on VectorWise.

 

The Vectorwise database works with standard SQL, according to Burkhardt. The software, which runs on Linux, is available for download.

Would you recommend this article?

Share

Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.


Jim Love, Chief Content Officer, IT World Canada

Featured Download

Featured Articles

Cybersecurity in 2024: Priorities and challenges for Canadian organizations 

By Derek Manky As predictions for 2024 point to the continued expansion...

Survey shows generative AI is a top priority for Canadian corporate leaders.

Leaders are devoting significant budget to generative AI for 2024 Canadian corporate...

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now