Home | Products | Ingres

Ingres

Leading Enterprise-Grade Open Source Database

Ingres Database 10

Actian has pulled out all stops with the release of Ingres Database 10 making it even easier to migrate away from Big Software. The recent mergers and acquisition activity in the database market has left customers very concerned about the future of their software purchase and has left them desiring more stable and reliable alternatives. Actian reached out and listened, and as a result, we've come out with a new version of our database software to meet the demands for a suitable alternative, from a reliable company. Ingres Database 10.0 not only meets the needs of those looking to migrate from cost prohibitive database solutions, it meets the needs of those who are seeking a standards based alternative. Ease of migration + performance + economic benefits of open source = Ingres Database 10. There has never been a better time to make the move!

New Features

Ingres Database 10 provides easy migration from MySQL and proprietary databases such as Oracle, SQL Server and Sybase.

  • Multi-Version Concurrency Control provides concurrent access to the database or a "snapshot" version for each user to work with, so that queries never block other users, and updates block only when changing the same row.
  • New SQL types, functions and compatibility features ease migrations of existing applications from other databases to Actian 10.
  • A community-based Migration Toolkit hosted on Sourceforge can assist customers in migrating to Ingres from Oracle's Enterprise and MySQL databases.

Growth Opportunity for Partners

Ingres Database 10 gives partners an advantage with its inherent security, performance enhancements, ease of migration and community innovations. New features enable better integration with off-the-shelf software and improve the performance of applications that rely on complex queries. Today the partner community taking advantage of the power and flexibility of the Ingres Database is hundreds strong.

New Performance Enhancements

Ingres Database 10 improves performance of bulk loading by upwards of 50% and enables the same high performance loading via our standards based JDBC 4.0 driver. Queries on partitioned tables are more efficient, including a unique ability to perform dynamic partition pruning during query processing.

Improved Security

Ingres Database 10 adds column encryption capabilities that were driven by the Actian community and completed by Actian. Column encryption enables database administrators to secure specific fields in a record such as credit card numbers, social security numbers or personal identification (PIN) numbers without having to encrypt the entire table.

Community Contributions

Ingres Database 10 shines a light on innovative community contributions which include new additions to the database engine that were added by its community members. In addition to involvement with column level encryption, the Actian community delivered other valuable contributions such as new SQL functions by Marty Bowes of the Ingres User Association in the United Kingdom, and productized by the Actian Engineering team.

Commitment to Standards

Ingres continues to support the latest standards, and with this release, adds support for JDBC 4.0 which improves Java application access to SQL data stores while still benefiting from the full power of the JDBC API.