To further improve availability, InterBase® SMP 2009 offers new enhancements for protection against failures and increased disaster recovery options through log-based journaling for short-term recovery, and journal archiving for long-term recovery in the occurrence of hardware system failures. In addition, InterBase SMP 2009 introduces Online Dump of database files and Point-in-Time Recovery from archives.

InterBase SMP 2009 Server Edition is certified to run without modification on Windows®, Linux, Solaris™, and Mac OS® X. This enables deployment to a wide variety of platforms without having to rewrite code. The database is fully portable between platforms, and also from InterBase SMP 2009 Desktop Edition to InterBase SMP 2009 Server Edition, allowing for flexible deployment. In addition, InterBase 2009 supports international deployment for international character sets, including the latest Unicode, UTF-8 and UCS2.Framework components as well as other updates and enhanced documentation.

InterBase SMP 2009 is one of the fastest native databases available, and through support for SMP (symmetric multiprocessing) it scales to multiple CPUs, including multi-core CPUs. Performance enhancements and optimizations have been added in a number of areas, such as batch updates, query optimizations, and OLTP improvement via journaling. InterBase implements a multi-generational architecture providing unique versioning capabilities that result in high data availability for transaction processing users and decision support users?simultaneously. Support for multiple simultaneous instances of InterBase on the same machine provides application isolation and load balancing.

InterBase SMP 2009 combines simple installation and automatic crash recovery, with a self-tuning engine that makes it well suited for embedding. It is ideal for ISVs, OEMs, and VARs who require a database that is very compact in memory and disk size without compromising sophisticated features to support high-powered, business-critical applications. And, unlike many other enterprise databases that require expensive ecosystems of support and maintenance, InterBase SMP 2009 is virtually maintenance free.

Developers using Embarcadero RAD Studio, which includes Delphi® and Delphi Prism, and C++Builder®, as well as JBuilder®, 3rdRail and other tools can leverage a wide range of standard database connectivity options through ODBC, JDBC, ADO.NET, and IBX. Transaction monitoring facilities provide developers with granular database controls for viewing, starting, stopping, and rolling back transactions, processes, and queries. InterBase, compliant with SQL92 standards, offers developers everything they can expect from an SQL database: triggers, stored procedures, and views, as well as advanced concepts such as domains and event alerters.