DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Hazelcast vs. OpenSearch vs. Snowflake vs. Sphinx

System Properties Comparison Adabas vs. Hazelcast vs. OpenSearch vs. Snowflake vs. Sphinx

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonHazelcast  Xexclude from comparisonOpenSearch  Xexclude from comparisonSnowflake  Xexclude from comparisonSphinx  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformA widely adopted in-memory data gridA distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneCloud-based data warehousing service for structured and semi-structured dataOpen source search engine for searching in data from different sources, e.g. relational databases
Primary database modelMultivalue DBMSKey-value storeSearch engineRelational DBMSSearch engine
Secondary database modelsDocument store infoJSON support with IMDG 3.12Vector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.17
Rank#94  Overall
#1  Multivalue DBMS
Score5.97
Rank#57  Overall
#6  Key-value stores
Score16.36
Rank#37  Overall
#4  Search engines
Score121.33
Rank#9  Overall
#6  Relational DBMS
Score5.98
Rank#56  Overall
#5  Search engines
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlhazelcast.comgithub.com/­opensearch-project
opensearch.org
www.snowflake.comsphinxsearch.com
Technical documentationhazelcast.org/­imdg/­docsopensearch.org/­docs/­latestdocs.snowflake.net/­manuals/­index.htmlsphinxsearch.com/­docs
DeveloperSoftware AGHazelcastAmazon Web ServicesSnowflake Computing Inc.Sphinx Technologies Inc.
Initial release19712008202120142001
Current release5.3.6, November 20232.5.0, January 20233.5.1, February 2023
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2; commercial licenses availableOpen Source infoApache Version 2.0commercialOpen Source infoGPL version 2, commercial licence available
Cloud-based only infoOnly available as a cloud servicenononoyesno
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 languageJavaJavaC++
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
All OS with a Java VMAll OS with a Java VMhostedFreeBSD
Linux
NetBSD
OS X
Solaris
Windows
Data schemeyesschema-freeschema-free infoFlexible type definitions. Once a type is defined, it is persistentyes infosupport of semi-structured data formats (JSON, XML, Avro)yes
Typing infopredefined data types such as float or dateyesyesyesyesno
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.noyes infothe object must implement a serialization strategyyes
Secondary indexesyesyesyes infoAll search fields are automatically indexedyes infofull-text index on all search fields
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewaySQL-like query languageSQL-like query languageyesSQL-like query language (SphinxQL)
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
JCache
JPA
Memcached protocol
RESTful HTTP API
Java API
RESTful HTTP/JSON API
CLI Client
JDBC
ODBC
Proprietary protocol
Supported programming languagesNatural.Net
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
Python
Scala
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
JavaScript (Node.js)
Python
C++ infounofficial client library
Java
Perl infounofficial client library
PHP
Python
Ruby infounofficial client library
Server-side scripts infoStored proceduresin Naturalyes infoEvent Listeners, Executor Servicesyesuser defined functionsno
Triggersnoyes infoEventsyes infoby using the 'percolation' featureno infosimilar concept for controling cloud resourcesno
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistaShardingShardingyesSharding infoPartitioning is done manually, search queries against distributed index is supported
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event Replicatoryes infoReplicated Mapyesyesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency selectable by user infoRaft Consensus AlgorithmEventual 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 integritynononoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDone or two-phase-commit; repeatable reads; read commitednoACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes infoThe original contents of fields are not stored in the Sphinx index.
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesno
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Role-based access controlUsers with fine-grained authorization concept, user roles and pluggable authenticationno
More information provided by the system vendor
Adabas infodenotes "adaptable data base"HazelcastOpenSearchSnowflakeSphinx
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
CData: Connect to Big Data & NoSQL through standard Drivers.
» 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"HazelcastOpenSearchSnowflakeSphinx
DB-Engines blog posts

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

The DB-Engines ranking includes now search engines
4 February 2013, Paul Andlinger

show all

Recent citations in the news

Re-evaluating legacy: Should you leave Adabas (and Natural) behind?
30 May 2024, ITWeb

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

Real-Time Mainframe Data Replication to AWS with tcVISION from Treehouse Software | Amazon Web Services
22 March 2019, AWS Blog

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

provided by Google News

Hazelcast Showcases Real-Time Data Platform at 2024 Gartner Summit
15 May 2024, Datanami

Hazelcast Weaves Wider Logic Threads Through The Data Fabric
7 March 2024, Forbes

Hazelcast 5.4 real time data processing platform boosts AI and consistency
17 April 2024, VentureBeat

Hazelcast Versus Redis: A Practical Comparison
4 January 2024, Database Trends and Applications

Hazelcast to Demonstrate Power of Unified Platform for Real-Time and AI Applications at the ...
13 May 2024, WDRB

provided by Google News

Amazon OpenSearch Service now supports OpenSearch version 2.13
21 May 2024, AWS Blog

OCI Search with OpenSearch 2.11 delivers easy access to latest AI innovations
13 March 2024, Oracle

Amazon OpenSearch Service zero-ETL integration with Amazon S3 now available
22 May 2024, AWS Blog

Behind the Scenes: Upgrading OpenSearch efficiency with OCI flexible vertical scaling
13 February 2024, Oracle

AWS announces Amazon DocumentDB zero-ETL integration with Amazon OpenSearch Service
16 May 2024, AWS Blog

provided by Google News

How Open Will Snowflake Go at Data Cloud Summit?
29 May 2024, Datanami

evolv Announces Partnership and Revolutionary AI Solution at Snowflake's Data Cloud Summit 2024
24 May 2024, PR Newswire

Notice of Security Incident
27 May 2024, The New Yorker

No Code, No Problem: Hex's New Tools Help Data and Business Teams Explore Data Together Plus New Snowflake ...
29 May 2024, Newswire

Redox, Snowflake Partner to Streamline Healthcare Data Exchange for AI and Machine Learning
24 May 2024, HIT Consultant

provided by Google News

Manticore is a Faster Alternative to Elasticsearch in C++
25 July 2022, hackernoon.com

Perplexity AI: From Its Use To Operation, Everything You Need To Know About Googles Newest Challenger
11 January 2024, Free Press Journal

The Pirate Bay was recently down for over a week due to a DDoS attack
29 October 2019, The Hacker News

Beyond the Concert Hall: 5 Organizations Making a Difference in Classical Music in 2018 | WQXR Editorial
22 December 2018, WQXR Radio

How to Build 600+ Links in One Month
4 September 2020, Search Engine Journal

provided by Google News



Share this page

Featured Products

RaimaDB logo

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

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

Neo4j logo

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

Milvus logo

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here