InterBase® SMP 2009 - Frequently Asked Questions
InterBase SMP 2009 FAQs
InterBase SMP 2009 is the only database to combine the performance benefits of a multi-generational architecture with peace of mind of log-based journaling and disaster recovery. It is a high-performance, cross-platform, Unicodeenabled SQL database platform powering millions of applications globally. Combining fast, easy installation and configuration, a small footprint, automatic crash recovery, self-tuning, and near zero maintenance requirements, InterBase SMP 2009 is ideal for embedding within turn-key applications. Out of the box SMP support (Server Edition), SQL 92 compliance, advanced data reliability and recovery, Unicode, numerous connectivity options, and support for Windows®, Linux, SolarisTM, and Macintosh platforms makes InterBase SMP 2009 perfect for high-powered, cost-effective business-critical server applications in small-to-medium enterprises.
Q: What are the Highlights of InterBase SMP 2009?
A: InterBase SMP 2009 is designed to offer additional durability, improved performance and also extended support for international use. The highlights include:
  • Further improving durability and 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 (Server Edition only).
  • InterBase SMP is one of the fastest native databases available, and through supporting 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, and query optimizations.
  • Online Dump, or Incremental Backup, of database files allow backup to be performed easier and with minimal impact on production database operations.
  • Point-in-Time Recovery makes it possible to restore based on timestamps for greater recovery flexibility (Server Edition only).
  • Extended International character support via Unicode UCS-2 and UTF-8
Q: Does InterBase SMP 2009 support multi-processor and multi-core deployment environments?
A: InterBase SMP 2009 is designed for SMP and leverages multi-processor deployment on all supported platforms. The SMP Server license includes built-in support for Dual / Quad-core and additional CPUs � no additional licensing is required (up to 8 CPU / Cores on a single machine).
Q: Which platforms are supported by InterBase SMP 2009?
A: InterBase SMP Server Edition supports deployment on Windows (Microsoft� Windows Server� 2003, Microsoft Windows XP (SP2), Microsoft Windows 2000 (SP4)) , LINUX (Red Hat� Enterprise Linux 3 and 4, SuSE Linux 9 and 10), Solaris (Sun� Solaris 9 and 10), and Mac OS�/X (10.4 and 10.5). InterBase SMP 2009 Desktop Edition supports Windows (Microsoft Windows XP (SP2), Microsoft Windows 2000 (SP4), and Microsoft Windows Server 2003) deployment only.
 
Database Tools | Developer Tools | Channel-E