InterBase

InterBase is one of the fastest native databases available, with a small, lightweight footprint. InterBase leverages today's multicore CPUs and multi-CPU systems, combined with a unique versioning approach and advanced disk I/O caching, to retrieve and update your data blazingly fast.

• Small footprint. In its smallest distribution, InterBase is only a few megabytes. The small on-disk footprint and small in-memory requirements make it ideal for any device requiring a commercial-grade embeddable database engine.
• Fast Install. InterBase server installs completely in seconds with an embeddable installer to allow for silent install of server and client drivers. When it comes to InterBase ToGo, no installation is required! Just deploy the InterBase libraries along with your application.
• Faster Data. InterBase’s Change Views improves data speed and scalability by dramatically reducing the amount of data moved, lowering data costs, network traffic, server CPU demand, and disk I/O.
• Write-Ahead Logging. Journaling provides the security of immediately writing changes to disk with the benefits of a full in-memory database system. Enable journaling through a single line of SQL without any changes in your application.

Your app and business runs on data, making database disaster recovery a critical feature. Interbase supports effective disaster recovery planning through live backups, incremental dumps, multithreaded restore, write-ahead logging, and point-in-time recovery. The database can be backed up via command line, through our admin tools, via code using the backup APIs, or via the ODBC driver GUI.

• Live Backups. InterBase’s multi-versioning architecture enables backup snapshots to be taken while users are still connected and changing the database.
• Distinguished Data Dumps. Distinguished data dumps quickly create a read-only copy of your database. In a DR scenario, switching the database to read/write is faster than waiting for a restore. First-time setups create a complete copy of the database, while subsequent runs update the copy with only the changes to the primary database.
• Fast Restores. InterBase restores using multiple threads on multiple processors to ensure the fastest possible recovery of the database and indexes.
• Write-Ahead Logging. InterBase’s journaling provides the security of immediately writing changes to disk, with the benefits of a full in-memory database system. Enable journaling with a single line of SQL.
• Point-in-Time Recovery. Quickly revert the database to any second in time using journal archives. Journal archives can be stored off device to provide a fast way to recover even if the backup hasn’t run.

InterBase’s Change Views feature reduces development time, network costs, and server CPU demand associated with other replication methods that rely on traditional change-tracking methods. As a result, development teams benefit from cost savings, time savings, and improved user experience.

• Log-less replication. InterBase’s Change Views eliminates common scalability issues associated with log tables and time-stamp fields.
• Secure Data Change Subscriptions. Once a device is granted rights and subscribed to specific tables or columns of data, it tracks what is changing at field level for that subscription. This simple model enables access to data changes to be securely managed and easily scaled out with less code to develop, refactor, build, and test.
• The Most Secure Change Tracking Available. Change Views not only makes it easy to identify what has changed, it controls who can track those changes and prevents others from even guessing at data changes.
• Easily Fetch Data Deltas. Change Views provides just the field-level deltas of what has changed, allowing developers to give detailed analysis back to the end user while lowering data-movement costs. Change Views data can be queried via SQL before syncing to ensure you never end up with a surprise data bill.

InterBase is an SQL standards-compliant database. InterBase strictly follows SQL industry standards. It supports unicode and is ideal for any character set globally, and it offers multiple-join unicode, real-time event alerts and our patent-pending Change Views’ SQL-based change tracking.

• Change Views. Change Views speeds up applications and lowers network traffic and costs by identifying and fetching only the changes made to the database. Read the Change Views white paper.
• Multigenerational Architecture. Connects with consistent database snapshots, ensures readers don’t block writers from making changes and increases scalability.
• Event Alerts. InterBase Events enable a real-time alert to connected clients when a change is committed. This saves on CPU intensive database polling and increases database scalability.
• Customizable. Easily customize InterBase with custom field types, stored procedures, custom exceptions and triggers. Customization helps automate database logic, data transformation and easy maintenance.
• Generators. Generators allow you to fetch sequential numbers that are typically used for primary keys. InterBase will not assign duplicate keys. Generators enable InterBase to produce key values centrally in the database.