DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Firebird vs. H2GIS vs. OpenSearch vs. Realm

System Properties Comparison Adabas vs. Firebird vs. H2GIS vs. OpenSearch vs. Realm

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonFirebird  Xexclude from comparisonH2GIS  Xexclude from comparisonOpenSearch  Xexclude from comparisonRealm  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformFirebird is an open source RDBMS forked from Borland's InterBaseSpatial extension of H2A distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneA DBMS built for use on mobile devices that’s a fast, easy to use alternative to SQLite and Core Data
Primary database modelMultivalue DBMSRelational DBMSSpatial DBMSSearch engineDocument store
Secondary database modelsRelational DBMSVector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.17
Rank#94  Overall
#1  Multivalue DBMS
Score20.82
Rank#30  Overall
#18  Relational DBMS
Score0.00
Rank#383  Overall
#7  Spatial DBMS
Score16.36
Rank#37  Overall
#4  Search engines
Score7.60
Rank#52  Overall
#9  Document stores
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlwww.firebirdsql.orgwww.h2gis.orggithub.com/­opensearch-project
opensearch.org
realm.io
Technical documentationwww.firebirdsql.org/­en/­reference-manualswww.h2gis.org/­docs/­homeopensearch.org/­docs/­latestrealm.io/­docs
DeveloperSoftware AGFirebird FoundationCNRSAmazon Web ServicesRealm, acquired by MongoDB in May 2019
Initial release19712000 infoAs fork of Borland's InterBase201320212014
Current release5.0.0, January 20242.5.0, January 2023
License infoCommercial or Open SourcecommercialOpen Source infoInitial Developer's Public LicenseOpen Source infoLGPL 3.0Open Source infoApache Version 2.0Open Source
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • STACKIT OpenSearch offers OpenSearch in a managed version in enterprise grade, 100% GDPR-compliant, for a wide range of applications like analytics, website search, offering scalability and fast data access.
  • Aiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
Implementation languageC and C++JavaJava
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
AIX
FreeBSD
HP-UX
Linux
OS X
server-less infoFirebird Embedded Server
Solaris
Unix
Windows
All OS with a Java VMAndroid
Backend: server-less
iOS
Windows
Data schemeyesyesyesschema-free infoFlexible type definitions. Once a type is defined, it is persistentyes
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.nonono
Secondary indexesyesyesyesyes infoAll search fields are automatically indexedyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewayyesyesSQL-like query languageno
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
ADO.NET
C/C++ API
JDBC infoJaybird
ODBC
OLE DB
Java API
RESTful HTTP/JSON API
Supported programming languagesNaturalC
C#
C++
Delphi
Java
JavaScript infoNode.js
Lua
Perl
PHP
Python
Ruby
JavaGo
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
.Net
Java infowith Android only
Objective-C
React Native
Swift
Server-side scripts infoStored proceduresin NaturalPSQLyes infobased on H2yesno inforuns within the applications so server-side scripts are unnecessary
Triggersnoyesyesyes infoby using the 'percolation' featureyes infoChange Listeners
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistanonenoneShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatorSource-replica replicationyes infobased on H2yesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate Consistency
Foreign keys infoReferential integritynoyesyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoFeatures a multi-generational MVCC architecture, readers do not block writersyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes infoIn-Memory realm
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Users with fine-grained authorization conceptyes infobased on H2yes
More information provided by the system vendor
Adabas infodenotes "adaptable data base"FirebirdH2GISOpenSearchRealm
Specific characteristicsOpenSearch is a highly scalable and extensible open-source software suite for search,...
» more
Competitive advantagesDistributed as fully open source under Apache License, Version 2.0 (ALv2), OpenSearch...
» more
Typical application scenariosThe OpenSearch platform is used across a broad range of search , analytics, and observability...
» more
Licensing and pricing modelsThe OpenSearch Project offers open source software licensed under Apache License...
» more

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
3rd partiesAiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
» more

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

More resources
Adabas infodenotes "adaptable data base"FirebirdH2GISOpenSearchRealm
DB-Engines blog posts

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

State agency proves DevOps and mainframes can coexist
12 April 2024, SiliconANGLE News

IBM buys 50-year-old Software AG's enterprise tech units for €2.13B in cash
18 December 2023, The Register

A Second Look at LzLabs' Mainframe Migration
28 June 2017, Virtualization Review

Treehouse Software, Inc. Helps US Foods With Their Mainframe Modernization Initiative
10 April 2023, PerishableNews

Michael E. Jakes Obituary (1941 - 2023)
26 October 2023, Legacy.com

provided by Google News

DoNot Team's New Firebird Backdoor Hits Pakistan and Afghanistan
23 October 2023, The Hacker News

12 Top Open Source Databases to Consider
1 May 2024, TechTarget

FIREBIRD'S HUBBARD TALKS DATA, AI, TIKTOK
14 December 2023, HITS Daily Double

Firebird - Analyst, Digital Marketing (US)
23 February 2024, Music Business Worldwide

Exploring the Firebird Database
9 August 2023, Open Source For You

provided by Google News

Amazon OpenSearch Service now lets you update cluster volume without blue/green
14 February 2024, AWS Blog

Hybrid Search with Amazon OpenSearch Service
19 March 2024, AWS Blog

Amazon OpenSearch H2 2023 in review
15 March 2024, AWS Blog

Amazon OpenSearch Ingestion is now available in 2 additional commercial regions
15 February 2024, AWS Blog

Track Amazon OpenSearch Service configuration changes more easily with new visibility improvements | Amazon Web ...
6 February 2024, AWS Blog

provided by Google News

MongoDB aims to unify developer experience with launch of MongoDB Cloud
9 June 2020, diginomica

Danish CEO explains Silicon Valley learning curve for European entrepreneurs - San Francisco Business Times
6 October 2016, The Business Journals

Is Swift the Future of Server-side Development?
12 September 2017, Solutions Review

Java Synthetic Methods — What are these? | by Vaibhav Singh
27 February 2021, DataDrivenInvestor

Kotlin Programming Language Will Surpass Java On Android Next Year
15 October 2017, Fossbytes

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

Neo4j logo

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

Present your product here