Ingres previews "VectorWise" technology
Ingres has announced a technology preview of its VectorWise technology which it originally announced last year. Ingres says that early testing of the technology, which optimises database queries for modern multi-core processors, with "dozens of partners and customers" has already shown results in line with the performance improvements observed in the laboratory. The early tests have, say Ingres, have shown that Vectorwise's ability to perform complex queries with calculations can be performed at a database level and run faster, according to one customer, than in-memory calculations when used for data-mining. The company claims 10x performance gains based on that early testing.
The open source database company is now inviting interested parties to participate in the preview to evaluate how VectorWise performs with their applications by registering with the company and providing information on their database needs.
VectorWise has been developed as a collaborative project between Ingres and a spin off of the database research team at CWI Amsterdam which aims to improve database performance by "orders of magnitude". At the core of Vectorwise is an cange to how data is processed internally; rather than returning indivdual records for processing, the system returns vectors of values which are able to be processed by separate processor cores much more efficiently. This capability is managed automatically, so developers can continue to use SQL as a query language. The development work is eventually planned to become open source once various "commercial and legal issues" have been resolved.