DB-EnginesextremeDB - solve IoT connectivity disruptionsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > BoltDB vs. OpenSearch vs. SAP HANA vs. SAP SQL Anywhere

System Properties Comparison BoltDB vs. OpenSearch vs. SAP HANA vs. SAP SQL Anywhere

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameBoltDB  Xexclude from comparisonOpenSearch  Xexclude from comparisonSAP HANA  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparison
DescriptionAn embedded key-value store for Go.A distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneIn-memory, column based data store. Available as appliance or cloud serviceRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelKey-value storeSearch engineRelational DBMSRelational DBMS
Secondary database modelsVector DBMSDocument store
Graph DBMS infowith SAP Hana, Enterprise Edition
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.70
Rank#225  Overall
#31  Key-value stores
Score16.31
Rank#36  Overall
#4  Search engines
Score41.32
Rank#23  Overall
#16  Relational DBMS
Score3.50
Rank#81  Overall
#44  Relational DBMS
Websitegithub.com/­boltdb/­boltgithub.com/­opensearch-project
opensearch.org
www.sap.com/­products/­hana.htmlwww.sap.com/­products/­technology-platform/­sql-anywhere.html
Technical documentationopensearch.org/­docs/­latesthelp.sap.com/­hanahelp.sap.com/­docs/­SAP_SQL_Anywhere
DeveloperAmazon Web ServicesSAPSAP infoformerly Sybase
Initial release2013202120101992
Current release2.5.0, January 20232.0 SPS07 (April 4, 2023), April 202317, July 2015
License infoCommercial or Open SourceOpen Source infoMIT LicenseOpen Source infoApache Version 2.0commercialcommercial
Cloud-based only infoOnly available as a cloud servicenonono infoalso available as a cloud based serviceno
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.
Implementation languageGoJava
Server operating systemsBSD
Linux
OS X
Solaris
Windows
All OS with a Java VMAppliance or cloud-serviceAIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemeschema-freeschema-free infoFlexible type definitions. Once a type is defined, it is persistentyesyes
Typing infopredefined data types such as float or datenoyesyesyes
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.nonoyes
Secondary indexesnoyes infoAll search fields are automatically indexedyesyes
SQL infoSupport of SQLnoSQL-like query languageyesyes
APIs and other access methodsJava API
RESTful HTTP/JSON API
JDBC
ODBC
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languagesGoGo
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresnoyesSQLScript, Ryes, in C/C++, Java, .Net or Perl
Triggersnoyes infoby using the 'percolation' featureyesyes
Partitioning methods infoMethods for storing different data on different nodesnoneShardingyesnone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyesyesSource-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayesnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes
User concepts infoAccess controlnoyesfine grained access rights according to SQL-standard
More information provided by the system vendor
BoltDBOpenSearchSAP HANASAP SQL Anywhere infoformerly called Adaptive Server Anywhere
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 partiesCData: 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
BoltDBOpenSearchSAP HANASAP SQL Anywhere infoformerly called Adaptive Server Anywhere
Recent citations in the news

What I learnt from building 3 high traffic web applications on an embedded key value store.
21 February 2018, hackernoon.com

4 Instructive Postmortems on Data Downtime and Loss
1 March 2024, The Hacker News

Roblox’s cloud-native catastrophe: A post mortem
31 January 2022, InfoWorld

How to Put a GUI on Ansible, Using Semaphore
22 April 2023, The New Stack

Grafana Loki: Architecture Summary and Running in Kubernetes
14 March 2023, hackernoon.com

provided by Google News

Achieve cross-Region resilience with Amazon OpenSearch Ingestion
24 September 2024, AWS Blog

AWS brings OpenSearch under the Linux Foundation umbrella
16 September 2024, TechCrunch

AWS hands OpenSearch to Linux Foundation – is this why Elasticsearch was made open source again?
16 September 2024, DevClass

Amazon Donates OpenSearch To Linux Foundation
20 September 2024, iProgrammer

AWS hands OpenSearch to the Linux Foundation
16 September 2024, InfoWorld

provided by Google News

Combine the Power of AI with Business Context Using SAP HANA Cloud Vector Engine
2 April 2024, SAP News

Automating application-consistent Amazon EBS Snapshots for SAP HANA databases
6 February 2024, AWS Blog

SAP HANA and Leonardo Ecosystem Partners – ISG Provider Lens Study 2019 Results
16 September 2024, Capgemini

The best way to modernize your close & consolidation process in an SAP S/4 HANA environment
9 April 2024, Wolters Kluwer

SAP HANA Cloud Vector Engine
18 April 2024, IgniteSAP

provided by Google News

SAP Products & Services Data Portfolio
2 July 2021, Datamation

Securing SAP with AWS Network Firewall: Part 2 – Managed Rules
17 July 2023, AWS Blog

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

MindsDB is now the leading and fastest growing applied ML platform in the world
3 November 2022, PR Newswire

Gartner’s Magic Quadrant for Cloud Database Management Systems
9 December 2020, CRN

provided by Google News



Share this page

Featured Products

SingleStore logo

The data platform to build your intelligent applications.
Try it 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

Milvus logo

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

Neo4j logo

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

RaimaDB logo

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

Present your product here