Ingres slashes database query time

Open source database supplier Ingres has launched a database project which it claims can cut the time taken to answer business queries by up to 70 times.

The...

Open source database supplier Ingres has launched a database project which it claims can cut the time taken to answer business queries by up to 70 times.

The company has made its VectorWise database commercially available and says its partners and customers are hailing it a breakthrough.

Businesses with large amounts of data will be able to run business analytics in a fraction of the time taken on databases such as Oracle's, the company claims.

The company said an insurance firm that has used the system has been able to run a query that normally takes 45 minutes in 11 seconds.

The secret to the database's high speeds are threefold, said Ingres. It can process multiple things at the same time, data goes direct from hard disc to database, rather than via Ram, and it is column-based in the back end.

Business intelligence specialist Datamatics said it saw a massive improvement in performance using VectorWise. "We ported a business application from Oracle to Ingres VectorWise and were astounded by the substantial performance increases, which were up to 70 times faster," said Michael Thuleweit, managing director at the company.

Systems integrator Rational Commerce said the benefits were clear. "The speed is blindingly fast right out of the box and it eliminates layers of work that had to be done in the past," said Roy Hann at Rational Commerce. "Ingres VectorWise uses automated compression and indexing which eliminates the need to spend extra hours tuning and tweaking our data. This means we are now able to cut the time of our business intelligent engagements with our customers by up to 50%."

Ingres CEO Roger Burkhardt said, "This technology breakthrough will enable a CFO to easily analyse hundreds of millions of business transactions in seconds - even on a laptop at 35,000 feet. This ability to extract deep insights from detailed business data at the 'speed of thought' will empower all leaders to make better business decisions, from anywhere at any time."

Ingres is open source so customers only pay for support.

Read more on Database software

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchCIO

SearchSecurity

SearchNetworking

SearchDataCenter

SearchDataManagement

Close