
Ingres Database 10
Ingres 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 propriety software purchase and has left them desiring more stable and reliable alternatives. Ingres 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 something stable, from a reliable company. Ingres Database 10.0 not only meets the needs of those looking to migrate from their unpredictable database solution, it meets the needs of those who are seeking something new. 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
Even Easier Migration
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 Ingres 10.
- A community-based Migration Toolkit hosted on Sourceforce can assist customers in migrating to Ingres from Oracle's Enterprise and MySQL databases.
Growth Opportunities for Partners
Ingres Database 10 gives partners an advantage with its inherent security, improved performance enhancements, ease of migration and community innovations. New features enable better integration with more 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 features improves performance of bulk loading by upwards of 50% with the already fast loader too, and enables the same high performance loading via standard JDBC 4.0 driver. Queries on partitioned tables are more efficient, including a unique ability to perform dynamic partition pruning during query processing.
New Security
Ingres Database 10 adds column encryption capabilities that were driven by the Ingres community and completed by Ingres. 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.
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 involvment with column level encryption, the Ingres community delivered other valuable contributions such as new SQL functions by Marty Bowes of the Ingres User Association in the United Kingdom, and implemented and productized by the Ingres 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.



