Articles InterBase ISV Database Comparison by Jon Lennart Aasenden

emailx45

Местный
Регистрация
5 Май 2008
Сообщения
3,571
Реакции
2,438
Credits
573
InterBase ISV Database Comparison
[SHOWTOGROUPS=4,20]
Jon Lennart Aasenden
17/2/2020

When it comes to choosing the right database to support your application it can feel like a daunting task. To make life easier, here are a few topics to consider helping you pick the right database for you and your customers.
TopicNotes
Look at Total Cost of Ownership
  • Up front license cost
  • Ongoing support costs
  • Daily administration costs
  • Development costs
Do the database and pricing both scale to fit the needs of your customers today and into the future?
  • From one to hundreds of end users. Is the price right?
  • Will it work on small customers hardware and still scale to larger customers?
What value will the database add to your product?
  • Data Security
  • Disaster Recovery
  • Data Movement Cost
  • User Security
Will your database help protect you and your customers from the risks around data storage?
  • Can you trust your end user to keep their data safe when using your system?
ISV’s choose InterBase because of its super low total cost of ownership, speed of development, ease to support and commercial grade database features. Below is an overview of InterBase vs a select few databases.
Change Tracking
Core Features
Platforms / FeaturesInterBaseFirebirdMySQLMSSQLSAP SQL AnywhereSQLite
Windows
Linux( ) beta
iOS and Android( ) feature limited
macOS
Solaris
Stored Procedures
Triggers
Data Check Constraints
Database EncryptionExternalDepends on EditionDepends on Edition3rd Party
Column Level EncryptionDepends on Edition
High Concurrency
Fine Grained User Security
Online BackupDepends on Edition
JournalingDepends on EditionDepends on Edition
Point-in-Time recoveryDepends on EditionDepends on Edition
Change Tracking / Sync3rd Party – License Cost Per Server & DestinationDepends on EditionDepends on EditionExtra License Cost


InterBase v FirebirdДля просмотра ссылки Войди или Зарегистрируйся
Summary: 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 vs MySQLДля просмотра ссылки Войди или Зарегистрируйся
Summary: Open-source is not always free. Oracle’s MySQL is a popular open-source database that is free to download, but you’ll need to buy an annual subscription for each deployment. InterBase gives you better value. When it comes to protecting your data and ensuring business continuity, it’s critical that you carefully consider both data backup and data encryption. InterBase supports both online data backups and Transparent Data Encryption (TDE) in all paid editions, while these features are only available for the most expensive MySQL Enterprise edition.
MySQL architecture centers on server-to-server replication, and doesn’t offer a mobile database. InterBase Change Views is built to easily handle data movement between a large variety of remote devices - either locally or distributed - making it ideal for modern scalable replication requirements.
InterBase v MSSQLДля просмотра ссылки Войди или Зарегистрируйся
Summary: MSSQL is a powerful top end database that comes with top end pricing, if you want the business critical features like Transparent Data Encryption (TDE). TDE helps businesses conform with Data Protection laws and best practice and work towards standards like PCI / HIPPA compliance. TDE is in all paid editions of InterBase, a feature that is only available in MSSQL Enterprise.
On disaster recovery server costs; InterBase includes the license for a secondary hot disaster recovery server, for MSSQL you have to pay for an additional server license. To put it another way, an 8 CPU server with TDE and hot disaster recovery is over $107k cheaper with InterBase!
Without the mobile presence, the MSSQL replication technologies focus on server to server rather than enablement of a large number of distributed remote devices that InterBase Change Views also enables.
Для просмотра ссылки Войди или Зарегистрируйся
InterBase v SAP SQL AnywhereДля просмотра ссылки Войди или Зарегистрируйся
Summary: Originally Sybase SQL Anywhere, it was acquired by SAP in 2012. Being a SAP company its agenda is heavily focused on SAP product development and feature requirements. There is also clear indication from SAP that HANA is their platform for the future leaving many wondering what will happen to SQL Anywhere.
Both InterBase and SQL Anywhere provide strong mobile offerings and data change tracking capabilities. While Change Views is built into the InterBase core, MobiLink is a charged extra per device.
InterBase vs SQLiteДля просмотра ссылки Войди или Зарегистрируйся
Summary: InterBase IBLite and SQLite are both free database offerings. SQLite lacks certain features to achieve SQL92 compliance, specifically the lack of Stored Procedures.
For business data on mobile, InterBase ToGo is packed with superior disaster recovery and data protection compliance features that are key to maintaining both you and your customer’s reputations. With protection throughout the development life cycle InterBase massively reduces the risk of fines and regulatory action in the event of lost data.
SQLite is basically a flat file on steroids; SQLite does offer the same level of database support to ensure data integrity and doesn’t for high concurrency. Because of this, it is not really suited for ISV development.
Interested in Using InterBase?
InterBase


ISV / OEMs and VARs can get special pricing by setting up a VAR agreement. Read more about Для просмотра ссылки Войди или Зарегистрируйся or Для просмотра ссылки Войди или Зарегистрируйся for more information

[/SHOWTOGROUPS]
 
Последнее редактирование: