Benefits
Durability to protect data and sustain high availability
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.
The portable, international, cross-platform database allows for growth and flexibility
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.
When performance matters
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.
When security matters
New security and encryption features provide enhanced data protection. Database and Column-level encryption allow encryption of a database and/or individual columns in a database. Over-the-wire (OTW) Encryption encrypts the data as well as any other communications (commands, etc.) between servers and clients. This is important if there are concerns about unauthorized people seeing this communication.
Strong Encryption: AES is the latest strong encryption standard that is being adopted worldwide. AES encryption is optionally available in InterBase SMP 2009. AES is fast in both software and hardware, is relatively easy to implement, and requires little memory. As a new encryption standard, it is currently being deployed on a large scale.
Embed – Deploy – Relax
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 highpowered,
business-critical applications.
The new InterBase To-Go Edition is a small, portable version of the Desktop Edition. The To-Go Edition is perfect for small devices, public kiosks, as well as VAR and OEM applications. InterBase SMP To-Go features a small footprint (less than 2MB) that gives Windows developers the ultimate flexibility to include an embedded, highly reliable SQL compliant, transactional database.And, unlike many other enterprise databases that require expensive ecosystems of support and maintenance, InterBase SMP 2009 is virtually maintenance free.
Built for Developers
Developers using CodeGear RAD Studio, which includes Delphi and C++Builder, as well as JBuilder, 3rdRail, Delphi for PHP 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.