InterBaseとFirebirdの比較

InterBaseとFirebirdの比較情報を探している方は、以下のような観点での回答が得られるでしょう。

• パフォーマンス
• スケーラビリティ
• ビジネス要件への対応
• 主要機能の差
• TCO（総所有コスト：Total Cost of Ownership）

結論としては、InterBaseは、より高速でスケーラブル、よりビジネスクリティカルな要件に対応する機能を提供しています。InterBaseなら、TCOを抑えつつも、商用レベルのサポートも受けられます。以下はその詳細です。

InterBase – 商用グレードのデータベース

InterBase is focused on providing commercial grade database features that supports you deliver cost effective software with industry best practice around change tracking, disaster recovery and data protection. InterBase delivers this power in an admin free, fast, scalability architecture so choosing InterBase means choosing a database that grows with you and meets your demands into the future.

Firebird – InterBaseにツールを持つが異なるデータベース

The Firebird database was developed from an open source copy of the InterBase code back in mid-2000. Firebird is currently community developed, which is co-ordinated by IBPhoenix. While InterBase and Firebird share a number of core features, 15+ years of commercially focused development has enabled InterBase develop a long way from the original open source code.

Below you will discover how InterBase will reduce your costs, save you time, add core business features to your product (especially around business continuity / disaster recovery) and is cheaper than choosing Firebird when it comes to data movement and support.

比較情報

InterBaseとFirebirdの比較 - スケーラビリティとスピード

When it comes to speed and performance many processors make light work! Even mobile phones today carry multi-core processors and InterBase has experience developing for multi-platform devices exploiting SMP since 2002. In contrast Firebird has released in 2016 its first attempts at providing SMP support.

To give a flavor of how much faster and more scalable InterBase is, below are two key metrics from TPC-C performance benchmarking. TPC-C benchmarking provide an industry recognized standard for testing database performance using a fictional warehouse (wh) system that mimics real world usage by mixing read and write activity simultaneously.

Comparing the benchmark test for InterBase XE7 and Firebird 3 on identical hardware show InterBase to be consistently faster than Firebird.

Testing to ensure throughput when data is safely persisted, InterBase out performs Firebird dramatically. Testing a 4wh setup shows InterBase is 30% faster than Firebird. After this point Firebird’s performance drops significantly where as InterBase continues to scale.

Another critical test is against the time you wait for data to return. Based on a complete table scan (the quicker the better!) InterBase is consistently 5 times faster than Firebird, regardless of the data types or number of rows in a table.

One key element to InterBase and Firebird is database transaction handling. Originally InterBase, and thus Firebird, ran with a 32bit Transaction ID. While not a problem for many, the most active systems with large user numbers have in practice needed to backup and restore their database monthly to ensure they don’t run out of transaction IDs. InterBase has moved to a 64bit Transaction ID that mean even the busiest embedded systems today would take closer to 150 years before the system would need to be taken down for maintenance.

In summary; If you are looking for a fast database that will grow with you, InterBase scales further, for longer, and is consistently faster than Firebird.

InterBaseとFirebirdの比較 - データの保護

データセキュリティは今日のビジネスにとって重要課題となっています。データ漏えいは通常、顧客基盤を平均4％縮小させると言います。さらに、数百万ドルにのぼる科料処分を受ける可能性や、顧客対応措置、スタッフの再教育、企業イメージの低下といった悪影響も免れません。何よりも、このような大きな痛手を被らないように、事前に回避措置を講じる必要があります。

Watch the Rising to the Data Security Challenge webinar for best practice advice on how to reduce the risks around Data Protection.

When it comes to data protection, both InterBase and Firebird offer role based authentication to control access to data inside the database however this is just the foundation and encryption at rest is key to safe storage of data and avoiding the bigger fines.

The first encryption capability for Firebird arrived in 2016 allowing for the database in its entirety to be encrypted using external encryption libraries. While useful, the architecture is prone to man-in-the-middle attacks and encrypting everything unnecessarily will slow down the database engine and reduce scalability.

In contrast, a highly flexible encryption model has been built into the InterBase core engine since 2010 offering entire database and focused fast granular column level encryption. Additionally, InterBase allows the creation of multiple encryption keys to protect different types of data, a key requirement to conform to many industry best practices e.g. around PCI.

InterBaseは、データ可視性を定義する責任を一般データベースユーザーから区分し、データセキュリティ責任者（DSO: Data Security Officer）のログインに付与することによって、データセキュリティのベストプラクティスをサポートします。SYSDSOに高精度の暗号化の管理を任せることによって、データ可視性ルールをデータ層に実装、開発ライフサイクルを通じて確実に実行／適用することができます。開発／テストチームによってデータ可視性ルールを管理する必要を取り除くことにより、製品リファクタリングに伴う不慮のデータ漏えいが起こるリスクを劇的に軽減します。また、開発者がアクセス許可のないデータを閲覧するといった、「特権攻撃」のリスクも回避できます。

InterBaseとFirebirdの比較 - 障害復旧

Both InterBase and Firebird are ACID compliant, allowing data to be backed up while the database is live due to a multi-generational architecture.

バックアップ

Firebird has developed incremental backup allowing them to be run regularly appending files for only what has changed.

InterBase also offers incremental backup, but rather than into backup files that have a long restore process, InterBase produces a secondary read only database. This offers two immediate benefits

• High demand data mining queries can be run onto a secondary server without impacting from the production server.
• A copy of the database is available in case of hardware that doesn’t required a lengthy restore process to run first, reducing the costs and risk associated with down time.

ジャーナリングとポイント・イン・タイム リカバリ

InterBase commercial grade features take one giant step on from incremental backups with Journaling and Journal Archives. Journaling allows a database to benefit from in-memory speed with the security of immediate write to disk. Journaling is available to InterBase users and is heavily used in a number of high demand medical data processing facilities due to the speed, performance and data integrity benefits it brings, where the loss of any data can be life or death.

InterBase Journal Archives are the next step on and provide point-in-time recovery, allowing you to take a database back in time to a specific split second to see how the data looked. This allows for the recovery of data, even when a backup hasn’t been run, for ultimate disaster recovery protection. Journaling to a SAN allow for complete data recovery even in the case of hardware failure.

InterBaseとFirebirdの比較 - レプリケーション

IoTアワードを受賞したInterBaseの「変更ビュー」は、コア機能のInterBaseカーネルにレプリケーションAPIを組み込み、開発時間と費用の大幅な節約を実現します。新規設計からスケーラビリティの向上まで、双方向データ移動にも対応する、「変更ビュー」はデータのレプリケーションコストを劇的に低減、常時、適切なブリーフケースデータを反映させます。

Firebird doesn’t have any replication API, instead requires the purchase of IBReplicator licenses from IBPhoenix. IBReplicator is an established Replication Technology available for both InterBase and Firebird and is based on trigger based replication. IBReplicator charges $150 per replication server plus a replication target license of $130 per destination. Because of scalability issues, the largest pack pricing available is for 20 licenses. Bidirectional replication with IBReplicator is complicated to configure (as it requiring unique database users for each database to prevent circular changes) making it very time intensive to setup and complicated to manage (something you don’t need to worry about with Change Views). Firebird replication also requires remote databases to be fixed in their location to enable connectivity, rendering it impractical for mobilization projects where they are constantly on the move.

As Change Views is included in the InterBase license, Firebird replication soon outweighs the cost of InterBase (around 10 seats at list price), has a higher setup and management cost and are less flexible. Even if you found a way to manage Firebird replication to 1000 devices for a distributed project, IBReplicator costs would make InterBase a whopping 93% cheaper than using Firebird!

Read the Change Views white paper to discover how Change Views is different from other replication technologies and simplifies data movement.

InterBaseとFirebirdの比較 - モバイル

With mobile accounting for more connected devices today than traditional desktop and servers, mobile is key to the delivery of modern application architecture. The need for offline data is also essential to deliver the best user experience for end users.

InterBase brings its secure encrypted database format to iOS and Android (through InterBase ToGo) allowing one database to be used everywhere. With the addition of the patent pending Change Views, InterBase provides a scalable offline capability that helps reduce the cost of getting data to mobile.

Currently Firebird doesn’t have released support for mobile and tablet platforms.

Looking to take your work force to mobile? read
Mobilizating Enterprise Data – Top 5 mistakes and how to avoid them

InterBaseとFirebirdの比較 - サポートとチームアクセス

InterBase has cost effective options for global commercial grade support that will help give your customers peace of mind. With established SLA that include installation support to get you going, InterBase on-going support is very low in comparison to Firebird’s charged for extra.

The entry level Firebird support offering is “30 day email only support” for $850, rising to $10,000 (Windows) to $20,000 (Linux) per year.

To put it another way:

• Just 30 day’s support for Firebird costs more than 1 years support for 100 InterBase desktop deployment licenses.
• For 100 desktop deployments, Firebird is 15.4 x more expensive than InterBase for 1 years support.
• If you combined licenses and 1 years support costs for 100 desktop deployments, Firebird is almost 4 times the price of InterBase in year one, and then 15.4 x more expensive for each additional year.

A supported top-end InterBase license (Server with unlimited users) for windows has annual running costs that are $7,891 per year cheaper than Firebird.

Every year you pay for Firebird support, you could have purchased 4¾ years InterBase support. Over 3 years, and including upfront license costs, that is a saving of $16,643.

When it comes to Linux you could have InterBase supported for 9 years (9 x $2109 = $18,981) for less than the price of a single years support for Firebird (1 x $20,000).

When it comes to access to the InterBase product manangement team, this is included for all InterBase ISV / VAR and OEM customers in your general license costs. The same privilege for Firebird with IBPhoenix costs $50,000!

まとめ

It is never an easy conversation to suggest a customer pays for something when they could opt for an Open Source free alternative, however Open Source is not quite like a free beer, it’s more like a free puppy; you have to look after it and care for it and the costs do mount up. While InterBase has a license cost, it delivers more bang for your buck!

InterBase is faster, vastly more scalable, is packed with superior disaster recovery and data protection compliance features that are key to maintaining both you and your customer’s reputations. Additionally, Change Views adds a zero cost and highly scalable replication engine API that reduces significantly both data movement and replication licensing costs for the lowest total cost of ownership.

InterBase continues to offer a faster and more scalable solution than Firebird that will grow with your customer. And as an ISV/OEM/VAR customer your future requirements can always be shared directly with the product management team freely.

If your data is important, Choose InterBase. Choose to Embed, Deploy, Relax!

Reference Source: