Ingres Database 9.2
New Features
In today’s world, system downtime can mean the difference between a healthy bottom line and business disaster. When key business systems fail, it can cost a business hundreds of thousands of dollars per hour. Whether the effect is lost productivity to your accounts receivables department, shipping delays to your fleet, or lost business from your web store, downtime when a business critical system fails means significant monetary loss. Ingres Database 9.2 is engineered to keep your Ingres-based solutions up and available around the clock. Ingres Database 9.2 is the only open source database that combines the flexibility of open source with the business class availability and reliability of commercial DBMS platforms.
New features in Ingres Database 9.2 continue to reduce the time, complexity, and database administrators (DBA) requirements by eliminating, simplifying, and automating many tasks traditionally associated with maintaining a business-class database. Upgrading from previous releases of Ingres Database is a simple, highly automated task.
Ingres Database 9.2 is an update focused on providing a flexible, simple, and reliable platform optimized for the Java development of multi-language applications. In addition, new features improve the availability and supportability of Ingres Database 9.2.
Internationalized Applications
Today, more and more organizations expand globally. It has become imperative that business applications support all languages involved in the organization’s business.
Ingres Database 9.2 introduces new features to support today’s global businesses:
- Support for the UTF-8 Character Set
- Support for Unicode upper and lower case
Improved Availability
Business systems have to be up 24 x 7 to serve customers and employees in all time zones. Ingres has many years of experience supporting highly available systems for business critical applications, and with each release, emphasizes this further. With Ingres Database 9.2, new features further improve the robustness of the Ingres server:
- Roll forward re-start
- Logging of backups
- Logging of roll forward
- Logging of database verification
Improved SQL Development
Ingres continues to support the latest standards including Java™ Database Connectivity (JDBC), open database connectivity (ODBC) and .NET Data Provider. This is another example of our commitment to producing standards-based software that works in today's open world.
Ingres Database 9.2 introduces new SQL constructs and concepts to simplify the development of web-based applications:
- Support for scrollable cursors
- New numeric functions
- New string functions
Improved Support for Content Management Systems
- LOB locator support
- Improved performance of string comparisons
Easier to Use, Less Expensive to Support
Shrinking IT budgets translate to fewer resources to support more systems. At Ingres, we understand this. With open source Ingres Database 9.2, we've introduced features to reduce the amount of time needed to keep your systems running smoothly.
- Better defaults for large systems
- Default storage structure for indexed tables
- Improved exception handling and tracing
- New Product demos
More opportunity to take advantage of the power and flexibility of Ingres Database
- World-class support from knowledgeable Ingres experts
- Dedicated consultants available to provide premium services
- Catalogue of training and educational courses
These new technology features, coupled with Ingres world-class services and support, provide customers with the ability to deploy a reliable and powerful open source database solution to protect their mission critical data. The solution is easy-to-deploy, easy-to-use and easy-to-manage, giving enterprise customers a solid low-cost database solution.


