DB-EnginesDo you need a hard real time database?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > H2GIS vs. Informix vs. Interbase

System Properties Comparison H2GIS vs. Informix vs. Interbase

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameH2GIS  Xexclude from comparisonInformix  Xexclude from comparisonInterbase  Xexclude from comparison
DescriptionSpatial extension of H2A secure embeddable database from IBM, positioned besides IBM Db2 as a relatively low-cost product optimized for OLTP and Internet of Things dataLight-weight proven RDBMS infooriginally from Borland
Primary database modelSpatial DBMSRelational DBMS infoSince Version 12.10 support for JSON/BSON datatypes compatible with MongoDBRelational DBMS
Secondary database modelsRelational DBMSDocument store
Spatial DBMS
Time Series DBMS infowith Informix TimeSeries Extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.07
Rank#327  Overall
#4  Spatial DBMS
Score23.29
Rank#34  Overall
#20  Relational DBMS
Score6.14
Rank#69  Overall
#38  Relational DBMS
Websitewww.h2gis.orgwww.ibm.com/­products/­informixwww.embarcadero.com/­products/­interbase
Technical documentationwww.h2gis.org/­docs/­homeinformix.hcldoc.com
www.ibm.com/­support/­knowledgecenter/­SSGU8G/­welcomeIfxServers.html
docs.embarcadero.com/­products/­interbase
DeveloperCNRSIBM, HCL Technologies infoEffective May 1st, 2017, HCL took on development, technical support, and product management teams, and works jointly with IBM on product strategy, marketing, and sales.Embarcadero
Initial release201319841984
Current release14.10.FC5, November 2020InterBase 2020, December 2019
License infoCommercial or Open SourceOpen Source infoLGPL 3.0commercial infofree developer edition availablecommercial
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC, C++ and JavaC
Server operating systemsAIX
HP-UX
Linux
macOS
Solaris
Windows
Android
iOS
Linux
OS X
Windows
Data schemeyesyesyes
Typing infopredefined data types such as float or dateyesyes infoSince Version 12.10 support for JSON/BSON datatypesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nono infoexport as XML data possible
Secondary indexesyesyesyes
SQL infoSupport of SQLyesyesyes
APIs and other access methodsJDBC
JSON API infoMongoDB compatible
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
Supported programming languagesJava.Net
C
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
.Net
C
C++
Delphi
Java
Object Pascal
PHP
Ruby
Server-side scripts infoStored proceduresyes infobased on H2yesyes infoInterbase procedure and trigger language
Triggersyesyesyes
Partitioning methods infoMethods for storing different data on different nodesnoneShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesyes infobased on H2Multi-source replication
Source-replica replication
Interbase Change Views
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyes infoMultiversion concurreny control
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes
User concepts infoAccess controlyes infobased on H2Users with fine-grained authentication, authorization, and auditing controlsfine grained access rights according to SQL-standard

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
H2GISInformixInterbase
Recent citations in the news

Relational Databases Software Market Size, Scope and Forecast | Microsoft, MySQL, Oracle, SAP, PostgreSQL, Amazon RDS, IBM, MariaDB, Informix, Teradata – Designer Women
5 July 2022, Designer Women

Embedded Database Management Systems Market Size And Forecast | Microsoft, IBM, Oracle, Centura Software, Software AG, Informix, PointBase – Designer Women
5 July 2022, Designer Women

Embedded Database Management Systems Market Size, Scope and Forecast | Microsoft, Oracle, Centura Software, Informix, IBM Corporation, Software AG, PointBase, Boiler Bay, McObject LLC, and others. – Designer Women
4 July 2022, Designer Women

Database Management Software Market Share Development Forecast 2022-2028| IBM, SolarWinds, Oracle, SAP, Microsoft – Designer Women
5 July 2022, Designer Women

HCL Technologies joins the AWS Independent Software Vendor (ISV) Accelerate Program
5 July 2022, India Education Diary

provided by Google News

Top 10 Data Management Platforms and Software to Know in 2022
13 June 2022, Analytics Insight

transcosmos increases workstations at Kuala Lumpur KLCC, its operations base in Malaysia
26 October 2021, PR Web

7 Visual Studio Tools to Improve Your Software Development in 2021
30 September 2021, hackernoon.com

AHQ (Unit) Islamabad wins interbase shooting c'ship
12 February 2020, Pakistan Observer

Best Test Data Generator Tools for 2022
25 March 2022, CIO Insight

provided by Google News

Job opportunities

Warehouse Shipping and Receiving Clerk
Inmar, Remote

Informix Software Engineer (Remote)
Inmar, Winston-Salem, NC

Senior Software Engineer: Informix 4gl
NVR, Inc, Reston, VA

Sr SQL Server DBA
Xtivia Inc, Remote

Customer Support Engineer, Tier 1 (Unix)
Commvault, Remote

Global Technical Support Engineer II
ZEISS Group, Dublin, CA

Database- Repair Center Technician
Carl Zeiss Meditec, Inc., Dublin, CA

Software developer
InterBase Corporation, Yorba Linda, CA

Repair Center Technician II-1
ZEISS Group, Dublin, CA

Senior Technical Support Engineer - Forum
Carl Zeiss Meditec, Inc., Dublin, CA

jobs by Indeed



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here